000

<?php

namespace App\Http\Controllers;

use Faker;

use Auth;
use Illuminate\Support\Str;
use Illuminate\Http\Request;

use Illuminate\Support\Facades\DB;

use Illuminate\Support\Facades\Session;

class ApiController extends Controller

{

public function checkApiAuth($data)

{

if ($data->api_token) {

$user = \App\User::where("api_token", $data->api_token)->first();

if (!is_null($user)) {

return true;

} else {

return false;

}

} else {

return false;

}

public function parseErrorResponse($errors)

{

$response = [];

foreach ($errors->toArray() as $key => $value) {

$obj = new \stdClass();

$obj->message = $value[0];

array_push($response, $obj);

}

return $response;

}

// public function checkApiAuth($data)

// {

//     if ($data->firebase_token) {

//         $user = \App\User::where('firebase_token', $data->firebase_token)->first();

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

//             return true;

//         } else {

//             return false;

//         }

//     } else {

//         return false;

//     }

// }

public function login(Request $request)

{

$response = [];

$internals = Faker\Factory::create("en_US");

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

"email" => "required",

"password" => "required",

"device_id" => "required",

]);

if ($validator->fails()) {

$response["status"] = 0;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

// if($request->app_version>='1.4.3') {

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

if ($request->app_version >= $user->app_version) {

$creds = [

"email" => $request->email,

"password" => $request->password,

];

if (Auth::attempt($creds)) {

$user = \App\User::where("email", $request->email)->first();

if (!is_null($user) && $user->is_active == 1 && ($user->role_id == 3 || $user->role_id == 4)) {

$auth_user = \App\User::find(Auth::user()->id);

// if(is_null($auth_user->imei_no) || ($auth_user->imei_no == $request->device_id) ) {

$auth_user->api_token = bcrypt($internals->uuid);

if ($request->api_token) {

$auth_user->api_token = $request->api_token;

}

if (isset($request->app_version)) {

$auth_user->app_version = $request->app_version;

}

if (isset($request->device_details)) {

$auth_user->device_details =

$request->device_details;

}

$auth_user->imei_no = $request->device_id;

$auth_user->save();

$response["flag"] = true;

$response["user"] = $auth_user;

// } else {

//     \Auth::logout();

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

//     $response['message'] = 'Invalid Device, Please Contact Admin.';

// }

} else {

\Auth::logout();

$response["flag"] = false;

$response["message"] =

"User Id Deactivated , Please Contact Admin.";

}

} else {

$response["flag"] = false;

$response["message"] = "Invalid credentials.";

}

} else {

\Auth::logout();

$response["flag"] = false;

$response["message"] = "Please Update Latest Version.";

}

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

// $response['message'] = "Service Unavailable.";

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

}

public function getMasterData(Request $request)

{

$response = [];

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

"api_token" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$all_master = \DB::table("master")

->where("is_active", 1)

->get();

$finalArr = [];

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

$i = 0;

foreach ($all_master as $key => $master) {

$finalArr[$i]["id"] = $master->id;

$finalArr[$i]["district_name"] = $master->district_name;

$finalArr[$i]["district_code"] = $master->district_code;

$finalArr[$i]["village_name"] = $master->village_name;

$finalArr[$i]["village_code"] = $master->village_code;

$finalArr[$i]["hamlet_name"] = $master->hamlet_name;

$finalArr[$i]["hamlet_code"] = $master->hamlet_code;

$finalArr[$i]["mcc_name"] = $master->mcc_name;

$finalArr[$i]["mcc_code"] = $master->mcc_code;

$finalArr[$i]["mpp_name"] = $master->mpp_name;

$finalArr[$i]["mpp_code"] = $master->mpp_code;

$finalArr[$i]["state_name"] = $master->state_name;

$finalArr[$i]["state_code"] = $master->state_code;

$finalArr[$i]["tehsil_name"] = $master->tehsil_name;

$finalArr[$i]["tehsil_code"] = $master->tehsil_code;

$i++;

}

$response["data"] = $finalArr;

$response["status"] = 1;

} else {

$response["status"] = 0;

$response["message"] = "Master is empty.";

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

// $response['status'] = 0;

// $response['message'] = "Service Unavailable.";

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

}

public function getBankMasterData(Request $request)

{

$response = [];

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

"api_token" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$all_master = \DB::table("bank_masters")

->where("is_active", 1)

->get();

$finalArr = [];

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

$i = 0;

foreach ($all_master as $key => $master) {

$finalArr[$i]["id"] = $master->id;

$finalArr[$i]["bank_name"] = $master->bank_name;

$finalArr[$i]["ifsc"] = $master->ifsc_code;

$finalArr[$i]["branch_name"] = $master->branch;

$i++;

}

$response["data"] = $finalArr;

$response["status"] = 1;

} else {

$response["status"] = 0;

$response["message"] = "Bank Master is empty.";

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

// $response['status'] = 0;

// $response['message'] = "Service Unavailable.";

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

}
    
    public function getTotalAnimalPaayasmilkForm(Request $request){
            if($request->isMethod('post')){
            $from = $request->from_date;
            $to = $request->to_date;
            
            $totalAnimalMembers = \App\AnimalDetail::whereBetween(DB::raw('date(created_at)'), [$from, $to])->whereNotNull('virtual_tag_number')->where('is_active',1)->distinct('member_aadhar')->count('member_aadhar');
            $totalAnimals = \App\AnimalDetail::whereBetween(DB::raw('date(created_at)'),[$from,$to])->whereNotNull('virtual_tag_number')->where('is_active',1)->count();
        }else{
            $totalAnimalMembers = \App\AnimalDetail::whereNotNull('virtual_tag_number')->where('is_active',1)->distinct('member_aadhar')->count('member_aadhar');
            $totalAnimals = \App\AnimalDetail::whereNotNull('virtual_tag_number')->where('is_active',1)->count();            
        }
            $response['status'] = 1;
            $response['totalAnimalMembers'] = $totalAnimalMembers;
            $response['totalAnimals'] = $totalAnimals;

return response()->json($response);
            
    }
    
    public function getTotalMembersPaayasmilk(Request $request){
            
            $totalAnimals = \App\AnimalDetail::where('is_active', 1)
                ->get()
                ->groupBy('member_aadhar')  // Group by member_aadhar
                ->map(function ($group) {
                    return $group->first();  // Take the first record in each group
                });
            $response = [
                'status' => 1,
                'members' => []
            ];

foreach ($totalAnimals as $animal) {
                if ($animal->is_old_member == 0) {
                    // Check in MembershipDetail
                    $member = \App\MembershipDetail::where('aadhar_card', $animal->member_aadhar)
                        ->where('is_active', 1)
                        ->select('aadhar_card as aadhar_no', 'applicant_name')
                        ->first();
                } else {
                    // Check in legacy_data
                    $member = DB::table('legacy_data')
                        ->where('aadhar_no', $animal->member_aadhar)
                        ->where('is_active', 1)
                        ->select('aadhar_no', 'applicant_name')
                        ->first();
                }

// Add the member information to the response
                $response['members'][] = [
                    'aadhar_no' => $animal->member_aadhar,
                    'applicant_name' => $member->applicant_name ?? 'Not Found',
                    // 'found_in' => $member ? ($animal->is_old_member == 0 ? 'MembershipDetail' : 'LegacyData') : 'None',
                ];
            }

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

public function getAnimalTaggedDetailPaayasmilk(Request $request)
    {
        $memberAadhar = $request->member_aadhar;

// Fetch active animal details for the given member Aadhar
        $animalDetails = \App\AnimalDetail::where('member_aadhar', $memberAadhar)
            ->where('is_active', 1)
            ->get();

// Check if any animal details are found
        if ($animalDetails->isEmpty()) {
            return response()->json([
                'status' => 0,
                'message' => 'No animal details found for the given member Aadhar.'
            ]);
        }

// Map breed and type names into the response
        $animalDetails = $animalDetails->map(function ($animal) {
            // Fetch breed name
            $breed = \App\AnimalBreed::where('id', $animal->animal_breed)
                ->where('is_active', 1)
                ->select('breed_name')
                ->first();

// Fetch animal type name
            $type = \App\AnimalType::where('id', $animal->animal_type)
                ->where('is_active', 1)
                ->select('animal_type')
                ->first();

// Append breed and type names to the original details
            $animal->animal_breed = $breed ? $breed->breed_name : null;
            $animal->animal_type = $type ? $type->animal_type : null;

return $animal;
        });

// Response with animal details
        return response()->json([
            'status' => 1,
            'animalDetails' => $animalDetails
        ]);
    }

public function getAnimalBreed(Request $request)

{

$response = [];

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

"api_token" => "required",

"animal_type" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$all_master = \DB::table("animal_breeds")

->where("animal_type_id", $request->animal_type)

->where("is_active", 1)

->get();

$finalArr = [];

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

$i = 0;

foreach ($all_master as $key => $master) {

$finalArr[$i]["id"] = $master->id;

$finalArr[$i]["breed_name"] = $master->breed_name;

$i++;

}

$response["data"] = $finalArr;

$response["status"] = 1;

} else {

$response["status"] = 0;

$response["message"] = "Animal Breed is empty.";

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

// $response['status'] = 0;

// $response['message'] = "Service Unavailable.";

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

}

public function getAnimalType(Request $request)

{

$response = [];

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

"api_token" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$all_master = \DB::table("animal_types")

->where("is_active", 1)

->get();

$finalArr = [];

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

$i = 0;

foreach ($all_master as $key => $master) {

$finalArr[$i]["id"] = $master->id;

$finalArr[$i]["animal_type"] = $master->animal_type;

$i++;

}

$response["data"] = $finalArr;

$response["status"] = 1;

} else {

$response["status"] = 0;

$response["message"] = "Animal Type is Empty.";

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

// $response['status'] = 0;

// $response['message'] = "Service Unavailable.";

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

}

public function getAnimalByTag(Request $request)
    {
        $response = [];
        $validator = \Validator::make($request->all(), [
            "api_token" => "required",
            "strTagNo" => "required",
        ]);
        if ($validator->fails()) {
            $response["flag"] = false;
            $response["errors"] = $this->parseErrorResponse(
                $validator->getMessageBag()
            );
        } else {
            if ($this->checkApiAuth($request)) {
                $all_master = \DB::table("animal_details")
                    ->where("animal_tag_no", $request->strTagNo)
                    ->where("is_active", 1)
                    ->get();

$finalArr = [];
                if (!$all_master->isEmpty()) {
                    $i = 0;
                    foreach ($all_master as $key => $master) {
                        $finalArr[$i]["id"] = $master->id;
                        $finalArr[$i]["animal_tag_no"] = $master->animal_tag_no;
                        $finalArr[$i]["member_aadhar"] = $master->member_aadhar;

$memberData = \DB::table("membership_details")
                            ->where("aadhar_card", $master->member_aadhar)
                            ->where("is_active", 1)
                            ->first();
                        
                        $finalArr[$i]["member_name"] = $memberData->applicant_name ?? "";
                        $finalArr[$i]["animal_registration_date"] = $master->animal_registration_date;
                        $finalArr[$i]["animal_type"] = $master->animal_type;
                        $finalArr[$i]["animal_breed"] = $master->animal_breed;
                        $finalArr[$i]["age"] = $master->age;
                        $finalArr[$i]["animal_category"] = $master->animal_category;
                        $finalArr[$i]["milk_production"] = $master->milk_production;
                        $finalArr[$i]["lactation_count"] = $master->lactation_count;
                        $finalArr[$i]["is_pregnant"] = $master->is_pregnant;
                        $finalArr[$i]["month_of_pregnancy"] = $master->month_of_pregnancy;

$i++;
                    }

$response["data"] = $finalArr;
                    $response["status"] = 1;
                    $response["message"] = "This tag number already exist.";
                } else {
                    $response["status"] = 0;
                    $response["message"] = "This tag number does not exist.";
                }
            } else {
                $response["status"] = 0;
                $response["message"] = " Session Expired";
                $response["is_token_expired"] = 1;
            }
        }
        // $response['status'] = 0;
        // $response['message'] = "Service Unavailable.";
        return response()->json($response);
    }

public function getMppMaster(Request $request)

{

$response = [];

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

"api_token" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$user = \App\User::where(

"api_token",

$request->api_token

)->first();

$all_mcc = \DB::table("assign_users")

->where("user_id", $user->id)

->where("is_active", 1)

->get();

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

$i = 0;

$finalArr = [];

foreach ($all_mcc as $key => $mcc) {

$mppCode = explode(",", $mcc->mpp_code);

$all_mpp = \DB::table("mpp")

->where("mcc_code", $mcc->mcc_code)

->whereIn("code", $mppCode)

->where("is_active", 1)

->get();

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

foreach ($all_mpp as $key => $mpp) {

$finalArr[$i]["id"] = $mpp->id;

$finalArr[$i]["mcc_code"] = $mpp->mcc_code;

$finalArr[$i]["mpp_name"] = $mpp->name;

$finalArr[$i]["mpp_code"] = $mpp->code;

$i++;

}

$response["status"] = 1;

$response["data"] = $finalArr;

} else {

$response["status"] = 0;

$response["message"] = "MPP not Allotted.";

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

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

// $response['status'] = 0;

// $response['message'] = "Service Unavailable.";

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

}

public function getMccMaster(Request $request)

{

$response = [];

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

"api_token" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$user = \App\User::where(

"api_token",

$request->api_token

)->first();

$all_mcc = \DB::table("mcc")

->select(

"mcc.name as name",

"mcc.id as id",

"mcc.code as code"

)

->leftjoin(

"assign_users",

"assign_users.mcc_code",

"mcc.code"

)

->leftjoin("users", "users.id", "assign_users.user_id")

->where("assign_users.user_id", $user->id)

->where("mcc.is_active", 1)

->groupBy("id")

->get();

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

$i = 0;

$finalArr = [];

foreach ($all_mcc as $key => $mcc) {

$finalArr[$i]["id"] = $mcc->id;

$finalArr[$i]["mcc_code"] = $mcc->code;

$finalArr[$i]["mcc_name"] = $mcc->name;

$i++;

}

$response["status"] = 1;

$response["data"] = $finalArr;

} else {

$response["status"] = 0;

$response["message"] = "MCC Master is empty.";

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

// $response['status'] = 0;

// $response['message'] = "Service Unavailable.";

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

}

public function getRejectedForm(Request $request)

{

$response = [];

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

"api_token" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$user = \App\User::where(

"api_token",

$request->api_token

)->first();

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

if (

!is_null($user) &&

$user->app_version >= $user1->app_version

) {

// if (!is_null($user) && $user->app_version>='1.4.3') {

$rejectedForm = \App\MembershipDetail::select(

"id",

"form_no"

)

->where("created_by_id", $user->id)

->where("is_active", 1)

->where("final_approval_status", "Rejected")

->get();

$rejectedFormCount = \App\MembershipDetail::where(

"created_by_id",

$user->id

)

->where("is_active", 1)

->where("final_approval_status", "Rejected")

->count();

$approvedFormCount = \App\MembershipDetail::where(

"created_by_id",

$user->id

)

->where("is_active", 1)

->where("final_approval_status", "Approved")

->count();

$pendingFormCount = \App\MembershipDetail::where(function (

$query

) {

$query

->whereNull("final_approval_status")

->orwhere("final_approval_status", "Requested");

})

->where("created_by_id", $user->id)

->where("is_active", 1)

->count();

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

$response["status"] = 1;

$response["rejectedForm"] = $rejectedForm;

$response["rejectedFormCount"] = $rejectedFormCount;

$response["approvedFormCount"] = $approvedFormCount;

$response["pendingFormCount"] = $pendingFormCount;

} else {

$response["status"] = 0;

$response["rejectedFormCount"] = $rejectedFormCount;

$response["approvedFormCount"] = $approvedFormCount;

$response["pendingFormCount"] = $pendingFormCount;

$response["message"] = "No rejected form found!";

}

} else {

$response["status"] = 2;

$response["message"] =

"Please Update Latest Apk Version On Play Store";

$response["url"] =

"https://play.google.com/store/apps/details?id=com.vaikomtech.paayas";

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

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

}

public function getApprovedForm(Request $request)

{

$response = [];

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

"api_token" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$user = \App\User::where(

"api_token",

$request->api_token

)->first();

$approvedForm = \App\MembershipDetail::where(

"created_by_id",

$user->id

)

->where("is_active", 1)

->where("final_approval_status", "Approved")

->get();

$approvedFormCount = \App\MembershipDetail::where(

"created_by_id",

$user->id

)

->where("is_active", 1)

->where("final_approval_status", "Approved")

->count();

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

$response["status"] = 1;

$response["approvedForm"] = $approvedForm;

$response["approvedFormCount"] = $approvedFormCount;

} else {

$response["status"] = 0;

$response["approvedFormCount"] = $approvedFormCount;

$response["message"] = "No approved form found!";

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

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

}

public function getCountOfForm(Request $request)

{

$response = [];

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

"api_token" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$user = \App\User::where(

"api_token",

$request->api_token

)->first();

$totalApprovedForm = \App\MembershipDetail::where(

"created_by_id",

$user->id

)

->where("is_active", 1)

->whereNotNull("final_approval_status")

->where("final_approval_status", "Approved")

->count();

$totalRejectedForm = \App\MembershipDetail::where(

"created_by_id",

$user->id

)

->where("is_active", 1)

->whereNotNull("final_approval_status")

->where("final_approval_status", "Rejected")

->count();

$totalFinalRequestedForm = \App\MembershipDetail::where(

"created_by_id",

$user->id

)

->where("is_active", 1)

->whereNotNull("final_approval_status")

->where("final_approval_status", "Requested")

->count();

// $totalPendingForm = \App\MembershipDetail::where('created_by_id', $user->id)->where('is_active', 1)->where('ao_approval_status', 'Pending')->count();

$totalPendingForm1 = \App\MembershipDetail::where(

"created_by_id",

$user->id

)

->where("is_active", 1)

->where("final_approval_status", null)

->count();

$totalPendingForm =

$totalFinalRequestedForm + $totalPendingForm1;

// \DB::enableQueryLog();

// $totalProcessingForm = \App\MembershipDetail::where('created_by_id', $user->id)->where('is_active', 1)->where('ao_approval_status', 'Processing')->orWhere('ao_approval_status', 'Approved')->count();

// $totalProcessingForm = \App\MembershipDetail::where('created_by_id', $user->id)->where('is_active', 1)->where(function($query){

//     $query->where('ao_approval_status', 'Processing')->orWhere('ao_approval_status', 'Approved');

// })->count();

$totalProcessingForm = \App\MembershipDetail::where(

"created_by_id",

$user->id

)

->where("is_active", 1)

->count();

// dd(\DB::getQueryLog($totalProcessingForm));

$response["status"] = 1;

$response["user_id"] = $user->id;

$response["totalApprovedForm"] = $totalApprovedForm;

$response["totalRejectedForm"] = $totalRejectedForm;

$response["totalFinalRequestedForm"] = $totalFinalRequestedForm;

$response["totalPendingForm"] = $totalPendingForm;

$response["totalProcessingForm"] = $totalProcessingForm;

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

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

}

public function getMcc(Request $request)

{

$response = [];

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

"api_token" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$user = \App\User::where(

"api_token",

$request->api_token

)->first();

$getmcc = \DB::table("mcc")

->select(

"mcc.name as name",

"mcc.id as id",

"mcc.code as code"

)

->join("assign_users", "assign_users.mcc_code", "mcc.code")

->join("users", "users.id", "assign_users.user_id")

->where("assign_users.user_id", $user->id)

->where("mcc.is_active", 1)

->groupBy("id")

->get();

if (!empty($getmcc)) {

if (count($getmcc) > 0) {

$response["status"] = 1;

$response["data"] = $getmcc;

} else {

$response["status"] = 0;

$response["message"] = "No Data Found";

}

} else {

$response["status"] = 0;

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

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

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

}

public function getMpp(Request $request)

{

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

"api_token" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$user = \App\User::where(

"api_token",

$request->api_token

)->first();

$getMppCode = \DB::table("assign_users")

->where("mcc_code", $request->mcc_code)

->where("user_id", $user->id)

->where("is_active", 1)

->first();

if (!is_null($getMppCode)) {

$mppCode = explode(",", $getMppCode->mpp_code);

$getmpp = \DB::table("mpp")

->where("mcc_code", $request->mcc_code)

->whereIn("code", $mppCode)

->where("is_active", 1)

->get();

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

$response["status"] = 1;

$response["data"] = $getmpp;

} else {

$response["status"] = 0;

$response["message"] = "No MPP Found";

}

} else {

$response["status"] = 0;

$response["message"] = "Please Assign MPP Fisrt!";

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

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

}

public function getMppOld(Request $request)

{

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

"api_token" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$user = \App\User::where(

"api_token",

$request->api_token

)->first();

$getmpp = \DB::table("mpp")

->where("")

->where("mcc_code", $request->mcc_code)

->where("is_active", 1)

->get();

if (!empty($getmpp)) {

if (count($getmpp) > 0) {

$response["status"] = 1;

$response["data"] = $getmpp;

} else {

$response["status"] = 0;

$response["message"] = "No Data Found";

}

} else {

$response["status"] = 0;

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

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

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

}

public function getAll(Request $request)

{

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

"api_token" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$getmpp = \DB::table("master")

->where("mcc_code", $request->mcc_code)

->where("mpp_code", $request->mpp_code)

->where("is_active", 1)

->first();

if (!is_null($getmpp)) {

// if(count($getmpp)>0){

$response["status"] = 1;

$response["data"] = $getmpp;

// }else{

//   $response['status'] = 0;

//   $response['message'] = 'No Data Found';

// }

} else {

$response["status"] = 0;

$response["message"] = "No Data Found";

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

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

}

public function AddMember(Request $request)

{     
        logger($request->all());

$response = [];

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

"api_token" => "required",
            
            "strReceiptNo" => "required|unique:membership_details,fee_receipt_no",

"farmer_aadhar_front_file" => "required",

"farmer_aadhar_back_file" => "required",

"nominee_aadhar_front_file" => "required",

"nominee_aadhar_back_file" => "required",

// "farmer_Pancard" => "required",

"farmer_passbook_file" => "required",

"farmer_pic_file" => "required",

"farmer_Signature" => "required",

"strApplicantName" => "required",

"strfather_husbandName" => "required",

"strGender" => "required",

"differenceyear" => "required",

"strCast" => "required",

"strEducation" => "required",

"strAadharNo" => "required",

// "strpancardNo" => "required",

// "pan_status" => "required",

"strPinCode" => "required",

"strBMCName" => "required",

"strmcc_code" => "required",

"strMPPName" => "required",

"strmpp_code" => "required",

"strRevenueVillName" => "required",

"strRevenueVillCode" => "required",

"strVtehsil" => "required",

"strVdistrict" => "required",

"strMobileNo" => "required",

// "email" => "required",

"strMilkProductdate" => "required",

"desiCow" => "required",

"crossBred" => "required",

"buffalo" => "required",

"total" => "required",

"MilkProduction" => "required",

"HouseHoldConsumption" => "required",

"account_holder_name" => "required",

"s_account_number" => "required",

"ifsc_code" => "required",

"bank_name" => "required",

"branch_name" => "required",

"self_declare" => "required",

"strRelation1" => "required",

"lat" => "required",

"longit" => "required",

//  "strSHGMember" => "required",

"strNomineeName" => "required",

"strApplicant" => "required",

"strAge" => "required",

"AnnualMilkCommitment" => "required",

]);

if ($validator->fails()) {

$response["status"] = 0;

$response["message"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$aadhar_data = \App\MembershipDetail::where(

"aadhar_card",

$request->strAadharNo

)

->where("is_active", 1)

->first();

$account_number = \App\MembershipDetail::where("s_account_number",$request->s_account_number)->where("is_active", 1)->first();
                     $old_adhar_card = \DB::table("legacy_data")
                    ->where("aadhar_no", $request->strAadharNo)
                    ->where("is_active", 1)
                    ->first();

if (is_null($aadhar_data) && is_null($account_number) && is_null($old_adhar_card)) {

$my_array = explode(",", $request->total);

if ($my_array[2] > 0) {

try {

\DB::beginTransaction();

$user = \App\User::where(

"api_token",

$request->api_token

)

->where("is_active", 1)

->first();

$memberShip = new \App\MembershipDetail();

//Member Detail

$memberShip->created_by_id = $user->id;

$memberShip->applicant_name =

$request->strApplicantName;

$my_array1 = explode(

",",

$request->strfather_husbandName

);

$memberShip->husband_or_father = strtoupper(

$my_array1[0]

);

$memberShip->husband_or_father_name =

$my_array1[1];

$memberShip->gender = $request->strGender;

$memberShip->applicant_age =

$request->differenceyear;

$memberShip->cast = $request->strCast;

$memberShip->education = $request->strEducation;

$memberShip->aadhar_card =

$request->strAadharNo;

$memberShip->pancard_no =

$request->strpancardNo;

$memberShip->pan_status =

$request->pan_status;

$memberShip->old_code = $request->old_code;
                                $memberShip->email = $request->email;

//Address And Contact Detail

$memberShip->house_no = $request->strHouseNo;

$memberShip->helmet = $request->strHemlet;

$memberShip->village = $request->strVillage;

$memberShip->post_office =

$request->strPostOffice;

$memberShip->tehsil = $request->strTeshsil;

$memberShip->district = $request->strDistrict;

$memberShip->state = $request->strState;

$memberShip->pincode = $request->strPinCode;

$memberShip->mobile_no = $request->strMobileNo;

$memberShip->landline = $request->strLandlineNo;
                                if($request->AnnualMilkCommitment == "0" || $request->AnnualMilkCommitment == " " || $request->AnnualMilkCommitment == "Null"){
                                     $memberShip->AnnualMilkCommitment = "500";
                                }elseif($request->AnnualMilkCommitment < '500'){
                                    $memberShip->AnnualMilkCommitment = "500";
                                }else{
                                    $memberShip->AnnualMilkCommitment = $request->AnnualMilkCommitment;
                                }

//Saving Bank Account Details

$memberShip->account_holder_name =

$request->account_holder_name;

$memberShip->s_account_number =

$request->s_account_number;

$memberShip->ifsc_code = $request->ifsc_code;

$memberShip->bank_name = $request->bank_name;

$memberShip->branch_name =

$request->branch_name;

$memberShip->self_declare =

$request->self_declare;

//Nominee Declaration

$memberShip->nominee_name =

$request->strNomineeName;

$memberShip->relation_with_application =

$request->strApplicant;

$memberShip->address =

$request->strVillage . ', ' . $request->strTeshsil . ', ' . $request->strDistrict . ', ' . $request->strState . ', ' . $request->strPinCode;

$memberShip->guardian_name =

$request->strGuardianName;

$memberShip->age = $request->strAge;

$memberShip->dob = $request->strDOB;

//Village Details

$memberShip->milk_producer_name =

$request->strMilProducerName;

$memberShip->mcc_name = $request->strBMCName;

$memberShip->mcc_code = $request->strmcc_code;

$memberShip->mpp_name = $request->strMPPName;

$memberShip->mpp_code = $request->strmpp_code;

$memberShip->revanue_vill_name =

$request->strRevenueVillName;

$memberShip->revanue_vill_code =

$request->strRevenueVillCode;

$memberShip->tehsil_name = $request->strVtehsil;

$memberShip->district_name =

$request->strVdistrict;

$memberShip->pooling_point_code =

$request->strPoolPointCode;

//Member Fee Details

$memberShip->admission_fee =

$request->strAdmissionFee;

$memberShip->share_quantity =

$request->strShareQuantity;

$memberShip->received_amount =

$request->strReceivedAmount;

$memberShip->cash_dd = $request->strCash_DD;

$memberShip->fee_bank_name =

$request->strFBankName;

$memberShip->fee_ifsc = $request->fee_ifsc;

$memberShip->fee_branch_name =

$request->strFBranchName;

$memberShip->fee_receipt_no =

$request->strReceiptNo;

$memberShip->fee_receipt_date =

$request->strReceiptDate;

$memberShip->amount = $request->strFAmount;

// $memberShip->shg_member =

//     $request->strSHGMember;

//Milk Production And Consumption Details

$memberShip->milk_product_date =

$request->strMilkProductdate;

$memberShip->desiCow = $request->desiCow;

$memberShip->crossBred = $request->crossBred;

$memberShip->buffalo = $request->buffalo;

$memberShip->total = $request->total;

$memberShip->MilkProduction =

$request->MilkProduction;

$memberShip->HouseHoldConsumption =

$request->HouseHoldConsumption;

$memberShip->MarketableSurplus =

$request->MarketableSurplus;

//Particular Of My House Hold Members Living With Me

$memberShip->relation1 = $request->strRelation1;

$memberShip->relation2 = $request->strRelation2;

$memberShip->relation3 = $request->strRelation3;

$memberShip->relation4 = $request->strRelation4;

$memberShip->relation5 = $request->strRelation5;

$memberShip->relation6 = $request->strRelation6;

//other

$memberShip->lat = $request->lat;

$memberShip->long = $request->longit;

//payment

$memberShip->transaction_id =

$request->transaction_id;

$memberShip->payment_status =

$request->payment_status;

$memberShip->is_active = "1";

// $form_number = $this->generateFormNo($request->strmcc_code);

// $memberShip->form_no = $form_number;

$member_data = \App\MembershipDetail::orderBy(

"id",

"DESC"

)->first();

if (!is_null($member_data)) {

$form_no = trim($member_data->form_no, "A");

$form_no = (int) $form_no + 1;

$form_number = "A" . $form_no;

} else {

$form_number = "A30261";

}

$memberShip->form_no = $form_number;

$memberShip->save();

//document Details

if ($request->farmer_aadhar_front_file) {

$adhar_front =

$form_number .

"_front" .

$memberShip->id .

"." .

$request->farmer_aadhar_front_file->extension();

$request->farmer_aadhar_front_file->move(

public_path("member_image/img_adhar/"),

$adhar_front

);

$memberShip->aadhar_front_file =

"img_adhar/" . $adhar_front;

}

if ($request->farmer_aadhar_back_file) {

$adhar_back =

$form_number .

"_back" .

$memberShip->id .

"." .

$request->farmer_aadhar_back_file->extension();

$request->farmer_aadhar_back_file->move(

public_path("member_image/img_adhar/"),

$adhar_back

);

$memberShip->aadhar_back_file =

"img_adhar/" . $adhar_back;

}

if ($request->nominee_aadhar_front_file) {

$nominee_aadhar1 =

$form_number .

"_front" .

$memberShip->id .

"_" .

time() .

"." .

$request->nominee_aadhar_front_file->extension();

$request->nominee_aadhar_front_file->move(

public_path(

"member_image/img_nominee_aadhar/"

$nominee_aadhar1

);

$memberShip->nominee_aadhar_front_file =

"img_nominee_aadhar/" .

$nominee_aadhar1;

}

if ($request->nominee_aadhar_back_file) {

$nominee_aadhar2 =

$form_number .

"_back" .

$memberShip->id .

"_" .

time() .

"." .

$request->nominee_aadhar_back_file->extension();

$request->nominee_aadhar_back_file->move(

public_path(

"member_image/img_nominee_aadhar/"

$nominee_aadhar2

);

$memberShip->nominee_aadhar_back_file =

"img_nominee_aadhar/" .

$nominee_aadhar2;

}

if ($request->farmer_passbook_file) {

$passbook =

$form_number .

"_passbook" .

$memberShip->id .

"." .

$request->farmer_passbook_file->extension();

$request->farmer_passbook_file->move(

public_path(

"member_image/img_passbook/"

$passbook

);

$memberShip->passbook_file =

"img_passbook/" . $passbook;

}

if ($request->farmer_pic_file) {

$pic =

$form_number .

"_farmer" .

$memberShip->id .

"." .

$request->farmer_pic_file->extension();

$request->farmer_pic_file->move(

public_path("member_image/img_farmer/"),

$pic

);

$memberShip->pic_file =

"img_farmer/" . $pic;

}

if ($request->farmer_Signature) {

$sign =

$form_number .

"_sign" .

$memberShip->id .

"." .

$request->farmer_Signature->extension();

$request->farmer_Signature->move(

public_path("member_image/img_sign/"),

$sign

);

$memberShip->Signature =

"img_sign/" . $sign;

}

if ($request->payment_receipt) {

$payment_receipt =

$form_number .

"_receipt" .

$memberShip->id .

"." .

$request->payment_receipt->extension();

$request->payment_receipt->move(

public_path(

"member_image/payment_receipt/"

$payment_receipt

);

$memberShip->payment_receipt =

"payment_receipt/" . $payment_receipt;

}

if ($request->farmer_Pancard) {

$pancard =

$form_number .

"_pancard" .

$memberShip->id .

"_" .

time() .

"." .

$request->farmer_Pancard->extension();

$request->farmer_Pancard->move(

public_path(

"member_image/img_pancard/"

$pancard

);

$memberShip->pancard =

"img_pancard/" . $pancard;

}

$memberShip->save();

$response["status"] = 1;

$response["message"] =

"Member Register Successfully";

$response["data"] = $memberShip->id;

$response["form_no"] = $memberShip->form_no;

\DB::commit();

$abc = $this->assignFormToAreaOfficer(

$memberShip->id,

$request->strmcc_code

);

} catch (\Exception $exp) {

\DB::rollBack();

$response["status"] = 0;

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

}

} else {

$response["status"] = 0;

$response["message"] =

"In milk animal number can not be 0.";

}

} else {

if (!is_null($aadhar_data)) {

$response["status"] = 0;

$response["message"] = "Aadhar already registered.";

}
                        if (!is_null($old_adhar_card)) {

$response["status"] = 0;

$response["message"] = "Old Member Aadhar already registered.";

}

if (!is_null($account_number)) {

$response["status"] = 0;

$response["message"] =

"Account already registered.";

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

// $response['status'] = 0;

// $response['message'] = "Service Unavailable.";

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

}

// public function generateFormNo($mcc_code) {

//     // 'AKBARPUR 10301'

//     // 'BADLAPUR 10701'

//     // 'BAHRAICH 10401'

//     // 'BALRAMPUR 10501'

//     // 'PRATAPGARH 10601'

//     $member_data = \App\MembershipDetail::where('mcc_code', $mcc_code)->orderBy('id', 'DESC')->first();

//     if($mcc_code == 10301) {

//         $form_no = (!is_null($member_data)) ? (trim($member_data->form_no, "AKB")) : "AKB000";

//         $bmc_code = "AKB";

//     } elseif($mcc_code == 10401) {

//         $form_no = (!is_null($member_data)) ? (trim($member_data->form_no, "BAH")) : "BAH000";

//         $bmc_code = "BAH";

//     } elseif($mcc_code == 10501) {

//         $form_no = (!is_null($member_data)) ? (trim($member_data->form_no, "BLR")) : "BLR000";

//         $bmc_code = "BLR";

//     } elseif($mcc_code == 10601) {

//         $form_no = (!is_null($member_data)) ? (trim($member_data->form_no, "PBH")) : "PBH000";

//         $bmc_code = "PBH";

//     } elseif($mcc_code == 10701) {

//         $form_no = (!is_null($member_data)) ? (trim($member_data->form_no, "BDL")) : "BDL000";

//         $bmc_code = "BDL";

//     }

//     $form_no = (int)$form_no+1;

//     $length = strlen((string)$form_no);

//     if($length == 1) {

//         $form_number = $bmc_code.'00'.$form_no;

//     } else if($length == 2) {

//         $form_number = $bmc_code.'0'.$form_no;

//     } else {

//         $form_number = $bmc_code.$form_no;

//     }

//     return $form_number;

// }

public function assignFormToAreaOfficer($form_id, $mcc_code)

{

$response = [];

$sections_id = \DB::table("form_sections")->pluck("id");

$sections_id = $sections_id->toArray();

if (count($sections_id)) {

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

} else {

$sections_id = "";

}

$users_data = \App\User::select("id", "assigned_mcc")

->where("is_active", 1)

->where("role_type", 1)

->get();

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

$mcc_user_id = "";

foreach ($users_data as $key => $user) {

$mcc = explode(",", $user->assigned_mcc);

if (in_array($mcc_code, $mcc)) {

$mcc_user_id = $user->id;

}

if ($mcc_user_id != "") {

try {

\DB::beginTransaction();

$user_edit = new \App\UserEditPermission();

$user_edit->form_id = $form_id;

$user_edit->module_id = $sections_id;

$user_edit->user_id = $mcc_user_id;

$user_edit->update_status = "Pending";

$user_edit->save();

$member_data = \App\MembershipDetail::where(

"id",

$form_id

)->first();

if (!is_null($member_data)) {

$member_data->ao_approval_status = "Pending";

$member_data->save();

}

\DB::commit();

$response["msg"] = "saved successfully.";

} catch (\Exception $exp) {

\DB::rollback();

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

}

return true;

}

return false;

}

public function memberList(Request $request)

{

$response = [];

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

"api_token" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$user = \App\User::where("api_token", $request->api_token)

->where("is_active", 1)

->first();

if ($user->role_id == 1) {

$data = \App\MembershipDetail::where(

"final_approval_status",

"!=",

"Rejected"

)

->where("is_active", 1)

->orderBy("created_at", "DESC")

->get();

$total = \App\MembershipDetail::whereDate(

"created_at",

"=",

date("Y-m-d")

)

->where("is_active", 1)

->count();

} else {

$data = \App\MembershipDetail::where(function ($query) {

$query

->whereNull("final_approval_status")

->orWhere("final_approval_status", "Requested");

})

->where("created_by_id", $user->id)

->where("is_active", 1)

->get();

$total = \App\MembershipDetail::whereDate(

"created_at",

"=",

date("Y-m-d")

)

->where("created_by_id", $user->id)

->where("is_active", 1)

->count();

}

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

$response["status"] = 1;

$response["data"] = $data;

$response["total"] = $total;

} else {

$response["status"] = 0;

$response["message"] = "No Data Found";

$response["total"] = $total;

}

} else {

$response["status"] = 0;

$response["message"] = "Session Expired";

$response["is_token_expired"] = 1;

}

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

}

public function rejectMemberList(Request $request)

{

$response = [];

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

"api_token" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$user = \App\User::where("api_token", $request->api_token)

->where("is_active", 1)

->first();

if ($user->role_id == 1) {

$data = \App\MembershipDetail::where(

"final_approval_status",

"Rejected"

)

->where("is_active", 1)

->get();

} else {

$data = \App\MembershipDetail::where(

"final_approval_status",

"Rejected"

)

->where("created_by_id", $user->id)

->where("is_active", 1)

->get();

}

if (!empty($data)) {

if (count($data) > 0) {

$response["status"] = 1;

$response["data"] = $data;

} else {

$response["status"] = 0;

$response["message"] = "No Data Found";

}

} else {

$response["status"] = 0;

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

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

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

}

public function memberListById(Request $request)

{

$response = [];

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

"api_token" => "required",

"id" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$data = \App\MembershipDetail::where("id", $request->id)

->where("is_active", 1)

->first();

if (!is_null($data)) {

// if(count($data)>0){

$response["status"] = 1;

$response["data"] = $data;

// }else{

//   $response['status'] = 0;

//   $response['message'] = 'No Data Found';

// }

} else {

$response["status"] = 0;

$response["message"] = "No Data Found!";

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

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

}

public function updateMember(Request $request)

{

$response = [];

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

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

"api_token" => "required",

"form_id" => "required",

]);

if ($validator->fails()) {

$response["status"] = 0;

$response["message"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$aadhar_data = \App\MembershipDetail::where(

"aadhar_card",

$request->strAadharNo

)

->where("id", "!=", $request->form_id)

->where("is_active", 1)

->first();

$account_number = \App\MembershipDetail::where(

"s_account_number",

$request->s_account_number

)

->where("id", "!=", $request->form_id)

->where("is_active", 1)

->first();

if (is_null($aadhar_data) && is_null($account_number)) {

$my_array = explode(",", $request->total);

if ($my_array[2] > 0) {

try {

\DB::beginTransaction();

$user = \App\User::where(

"api_token",

$request->api_token

)

->where("is_active", 1)

->first();

$memberShip = \App\MembershipDetail::where(

"id",

$request->form_id

)

->where("is_active", 1)

->first();

$pre_data = $memberShip->toArray();

if (is_null($memberShip)) {

$response["status"] = 0;

$response["message"] = "No Data found";

} else {

if ($memberShip->resubmit_status == 1) {

$memberShip->resubmit_status = 2;

}

//Member Detail

$memberShip->applicant_name =

$request->strApplicantName;

$my_array1 = explode(

",",

$request->strfather_husbandName

);

$memberShip->husband_or_father = strtoupper(

$my_array1[0]

);

$memberShip->husband_or_father_name =

$my_array1[1];

$memberShip->gender = $request->strGender;

$memberShip->applicant_age =

$request->differenceyear;

$memberShip->cast = $request->strCast;

$memberShip->education = $request->strEducation;

$memberShip->aadhar_card =

$request->strAadharNo;

$memberShip->pancard_no =

$request->strpancardNo;

$memberShip->pan_status =

$request->pan_status;

//Address And Contact Detail

$memberShip->house_no = $request->strHouseNo;

$memberShip->helmet = $request->strHemlet;

$memberShip->village = $request->strVillage;

$memberShip->post_office =

$request->strPostOffice;

$memberShip->tehsil = $request->strTeshsil;

$memberShip->district = $request->strDistrict;

$memberShip->state = $request->strState;

$memberShip->pincode = $request->strPinCode;

$memberShip->mobile_no = $request->strMobileNo;

$memberShip->landline = $request->strLandlineNo;

//Saving Bank Account Details

$memberShip->account_holder_name =

$request->account_holder_name;

$memberShip->s_account_number =

$request->s_account_number;

$memberShip->ifsc_code = $request->ifsc_code;

$memberShip->bank_name = $request->bank_name;

$memberShip->branch_name =

$request->branch_name;

//Nominee Declaration

$memberShip->nominee_name =

$request->strNomineeName;

$memberShip->relation_with_application =

$request->strApplicant;

$memberShip->address =

$request->strVillage . ', ' . $request->strTeshsil . ', ' . $request->strDistrict . ', ' . $request->strState . ', ' . $request->strPinCode;

$memberShip->guardian_name =

$request->strGuardianName;

$memberShip->age = $request->strAge;

$memberShip->dob = $request->strDOB;

//Village Details

$memberShip->milk_producer_name =

$request->strMilProducerName;

$memberShip->mcc_name = $request->strBMCName;

$memberShip->mcc_code = $request->strmcc_code;

$memberShip->mpp_name = $request->strMPPName;

$memberShip->mpp_code = $request->strmpp_code;

$memberShip->revanue_vill_name =

$request->strRevenueVillName;

$memberShip->revanue_vill_code =

$request->strRevenueVillCode;

$memberShip->tehsil_name = $request->strVtehsil;

$memberShip->district_name =

$request->strVdistrict;

$memberShip->pooling_point_code =

$request->strPoolPointCode;

//Member Fee Details

$memberShip->admission_fee =

$request->strAdmissionFee;

$memberShip->share_quantity =

$request->strShareQuantity;

$memberShip->received_amount =

$request->strReceivedAmount;

$memberShip->cash_dd = $request->strCash_DD;

$memberShip->fee_bank_name =

$request->strFBankName;

$memberShip->fee_branch_name =

$request->strFBranchName;

$memberShip->fee_receipt_no =

$request->strReceiptNo;

$memberShip->fee_ifsc = $request->fee_ifsc;

$memberShip->fee_receipt_date =

$request->strReceiptDate;

$memberShip->amount = $request->strFAmount;
                                $memberShip->old_code = $request->old_code;

// $memberShip->shg_member =

//     $request->strSHGMember;

//Milk Production And Consumption Details

$memberShip->milk_product_date =

$request->strMilkProductdate;

$memberShip->desiCow = $request->desiCow;

$memberShip->crossBred = $request->crossBred;

$memberShip->buffalo = $request->buffalo;

$memberShip->total = $request->total;

$memberShip->MilkProduction =

$request->MilkProduction;

$memberShip->HouseHoldConsumption =

$request->HouseHoldConsumption;

$memberShip->MarketableSurplus =

$request->MarketableSurplus;
                                    
                                if($request->AnnualMilkCommitment == "0" || $request->AnnualMilkCommitment == " " || $request->AnnualMilkCommitment == "Null"){
                                     $memberShip->AnnualMilkCommitment = "500";
                                }elseif($request->AnnualMilkCommitment < '500'){
                                    $memberShip->AnnualMilkCommitment = "500";
                                }else{
                                    $memberShip->AnnualMilkCommitment = $request->AnnualMilkCommitment;
                                }

//Particular Of My House Hold Members Living With Me

$memberShip->relation1 = $request->strRelation1;

$memberShip->relation2 = $request->strRelation2;

$memberShip->relation3 = $request->strRelation3;

$memberShip->relation4 = $request->strRelation4;

$memberShip->relation5 = $request->strRelation5;

$memberShip->relation6 = $request->strRelation6;

$memberShip->save();

$form_number = $memberShip->form_no;

//document Details

if ($request->farmer_aadhar_front_file) {

$adhar_front =

$form_number .

"_front" .

$memberShip->id .

"." .

$request->farmer_aadhar_front_file->extension();

$request->farmer_aadhar_front_file->move(

public_path("member_image/img_adhar/"),

$adhar_front

);

$memberShip->aadhar_front_file =

"img_adhar/" . $adhar_front;

}

if ($request->farmer_aadhar_back_file) {

$adhar_back =

$form_number .

"_back" .

$memberShip->id .

"." .

$request->farmer_aadhar_back_file->extension();

$request->farmer_aadhar_back_file->move(

public_path("member_image/img_adhar/"),

$adhar_back

);

$memberShip->aadhar_back_file =

"img_adhar/" . $adhar_back;

}

if ($request->nominee_aadhar_front_file) {

$nominee_aadhar1 =

$form_number .

"_front" .

$memberShip->id .

"_" .

time() .

"." .

$request->nominee_aadhar_front_file->extension();

$request->nominee_aadhar_front_file->move(

public_path(

"member_image/img_nominee_aadhar/"

$nominee_aadhar1

);

$memberShip->nominee_aadhar_front_file =

"img_nominee_aadhar/" .

$nominee_aadhar1;

}

if ($request->nominee_aadhar_back_file) {

$nominee_aadhar2 =

$form_number .

"_back" .

$memberShip->id .

"_" .

time() .

"." .

$request->nominee_aadhar_back_file->extension();

$request->nominee_aadhar_back_file->move(

public_path(

"member_image/img_nominee_aadhar/"

$nominee_aadhar2

);

$memberShip->nominee_aadhar_back_file =

"img_nominee_aadhar/" .

$nominee_aadhar2;

}

if ($request->farmer_passbook_file) {

$passbook =

$form_number .

"_passbook" .

$memberShip->id .

"." .

$request->farmer_passbook_file->extension();

$request->farmer_passbook_file->move(

public_path(

"member_image/img_passbook/"

$passbook

);

$memberShip->passbook_file =

"img_passbook/" . $passbook;

}

if ($request->farmer_pic_file) {

$pic =

$form_number .

"_farmer" .

$memberShip->id .

"." .

$request->farmer_pic_file->extension();

$request->farmer_pic_file->move(

public_path("member_image/img_farmer/"),

$pic

);

$memberShip->pic_file =

"img_farmer/" . $pic;

}

if ($request->farmer_Signature) {

$sign =

$form_number .

"_sign" .

$memberShip->id .

"." .

$request->farmer_Signature->extension();

$request->farmer_Signature->move(

public_path("member_image/img_sign/"),

$sign

);

$memberShip->Signature =

"img_sign/" . $sign;

}

if ($request->payment_receipt) {

$payment_receipt =

$form_number .

"_receipt" .

$memberShip->id .

"." .

$request->payment_receipt->extension();

$request->payment_receipt->move(

public_path(

"member_image/payment_receipt/"

$payment_receipt

);

$memberShip->payment_receipt =

"payment_receipt/" . $payment_receipt;

}

if ($request->farmer_Pancard) {

$pancard =

$form_number .

"_pancard" .

$memberShip->id .

"_" .

time() .

"." .

$request->farmer_Pancard->extension();

$request->farmer_Pancard->move(

public_path(

"member_image/img_pancard/"

$pancard

);

$memberShip->pancard =

"img_pancard/" . $pancard;

}

//payment

$memberShip->transaction_id =

$request->transaction_id;

$memberShip->payment_status =

$request->payment_status;

//other

$memberShip->lat = $request->lat;

$memberShip->long = $request->longit;

$memberShip->remark = null;

$memberShip->is_active = "1";

$memberShip->ao_approval_status = "Pending";

$memberShip->lo_approval_status = null;

$memberShip->fo_approval_status = null;

$memberShip->final_approved_by = null;

$memberShip->final_approval_status = null;

if ($memberShip->save()) {

$arr = [];

$ao_data = \App\UserEditPermission::where(

"form_id",

$request->form_id

)

->get()

->toArray();

$lo_data = \App\LegalEditPermission::where(

"form_id",

$request->form_id

)

->get()

->toArray();

$fo_data = \App\FinanceEditPermission::where(

"form_id",

$request->form_id

)

->get()

->toArray();

if (count($ao_data)) {

\App\UserEditPermission::where(

"form_id",

$request->form_id

)->delete();

$arr["user_edit_permission"] = $ao_data;

}

if (count($lo_data)) {

\App\LegalEditPermission::where(

"form_id",

$request->form_id

)->delete();

$arr[

"legal_edit_permission"

] = $lo_data;

}

if (count($fo_data)) {

\App\FinanceEditPermission::where(

"form_id",

$request->form_id

)->delete();

$arr[

"finance_edit_permission"

] = $fo_data;

}

//LOGS

$form_logs = new \App\EditFormLog();

$form_logs->user_id = $user->id;

$form_logs->form_id = $memberShip->id;

$form_logs->pre_data = json_encode(

$pre_data

);

$form_logs->user_allotment_log = json_encode(

$arr

);

$form_logs->save();

//delete allotment data from user edit permission table

}

\DB::commit();

$abc = $this->assignFormToAreaOfficer(

$memberShip->id,

$request->strmcc_code

);

$response["status"] = 1;

$response["message"] =

"Form Updated Successfully";

$response["data"] = $memberShip->id;

$response["form_no"] = $memberShip->form_no;

}

} catch (\Exception $exp) {

\DB::rollBack();

logger($exp);

$response["flag"] = false;

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

}

} else {

$response["status"] = 0;

$response["message"] =

"In milk animal number can not be 0.";

}

} else {

if (!is_null($aadhar_data)) {

$response["status"] = 0;

$response["message"] = "Aadhar already registered.";

}

if (!is_null($account_number)) {

$response["status"] = 0;

$response["message"] = "Account already registered.";

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

// $response['status'] = 0;

// $response['message'] = "Service Stopped By Admin.";

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

}

public function getDistrict(Request $request)

{

$response = [];

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

"api_token" => "required",

"id" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$getDistrict = \DB::table("districts")

->where("is_active", 1)

->where("state_id", $request->id)

->get();

if (!empty($getDistrict)) {

if (count($getDistrict) > 0) {

$response["status"] = 1;

$response["data"] = $getDistrict;

} else {

$response["status"] = 0;

$response["message"] = "No Data Found";

}

} else {

$response["status"] = 0;

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

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

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

}

public function getState(Request $request)

{

$response = [];

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

"api_token" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$getstate = \DB::table("states")

->where("is_active", 1)

->get();

if (!empty($getstate)) {

if (count($getstate) > 0) {

$response["status"] = 1;

$response["data"] = $getstate;

} else {

$response["status"] = 0;

$response["message"] = "No Data Found";

}

} else {

$response["status"] = 0;

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

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

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

}

public function checkAdhar(Request $request)
    {
        $response = [];
        $validator = \Validator::make($request->all(), [
            "api_token" => "required",
            "strAadharNo" => "required",

]);
        if ($validator->fails()) {
            $response["flag"] = false;
            $response["errors"] = $this->parseErrorResponse(
                $validator->getMessageBag()
            );
        } else {
            if ($this->checkApiAuth($request)) {

$getstate1 = \DB::table("membership_details")
                    ->where("aadhar_card", $request->strAadharNo)
                    ->where("is_active", 1)
                    ->first();
                $getstate2 = \DB::table("legacy_data")
                    ->where("aadhar_no", $request->strAadharNo)
                    ->where("is_active", 1)
                    ->first();
                $getstate3 = \DB::table("old_member_detail")
                    ->where("aadhar_no", $request->strAadharNo)
                    ->first();
                if (!empty($getstate1) || !empty($getstate2) || !empty($getstate3)) {
                    if (!empty($getstate1)) {
                        $response["status"] = 1;
                        $response["data"] = $getstate1;
                        $response["data1"] = $getstate1->form_no;
                        $response["message"] = "MemberShip Details";
                    } elseif (!empty($getstate2)) {
                        $response["status"] = 1;
                        $response["data"] = $getstate2;
                        $response["message"] = "Legacy Data";
                    }elseif (!empty($getstate3)) {
                        $response["status"] = 1;
                        $response["data"] = $getstate3;
                        $response["message"] = "Old Member Details";
                    }else {
                        $response["status"] = 0;
                        $response["message"] = "No Data Found";
                    }
                } else {
                    $response["status"] = 0;
                    $response["message"] = "No Data Found!";
                }
            } else {
                $response["status"] = 0;
                $response["message"] = " Session Expired";
                $response["is_token_expired"] = 1;
            }
        }
        return response()->json($response);
    }

public function checkpassbook(Request $request)

{

$response = [];

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

//'api_token' => 'required',

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$getstate = \DB::table("membership_details")

->where("s_account_number", $request->account_number)

->where("is_active", 1)

->first();

$getstat = \DB::table("old_member_detail")

->where("bank_account_no", $request->account_number)

->first();

if (!empty($getstate) || !empty($getstat)) {

if (!empty($getstate)) {

$response["status"] = 1;

$response["data"] = $getstate;

$response["data1"] = $getstate->form_no;

} elseif (!empty($getstat)) {

$response["status"] = 1;

$response["data"] = $getstat;

} else {

$response["status"] = 0;

$response["message"] = "No Data Found";

}

} else {

$response["status"] = 0;

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

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

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

}

public function image_test(Request $request)

{

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

$response = [];

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

//'api_token' => 'required',

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($request->image) {

$getstate = $request->image;

if (!empty($getstate)) {

if ($getstate) {

$code_base64 = $getstate;

$code_base64 = str_replace(

"data:image/jpeg;base64,",

"",

$code_base64

);

$png_url = "swethdhara-" . time() . ".jpg";

$path = public_path() . "/images/" . $png_url;

$code_binary = base64_decode($code_base64);

$success = file_put_contents($path, $code_binary);

$response["status"] = 1;

$response["data"] = $success;

// $response['data'] = $getstate;

} else {

$response["status"] = 0;

$response["message"] = "No Data Found";

}

} else {

$response["status"] = 0;

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

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

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

}

public function SyncMember(Request $request)

{

$response = [];

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

"api_token" => "required",
            //"email" => "required",

]);

if ($validator->fails()) {

$response["status"] = 0;

$response["message"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

// $aadhar_data = \App\MembershipDetail::where('aadhar_card', $request->strAadharNo)->first();

// $account_number = \App\MembershipDetail::where('s_account_number', $request->s_account_number)->first();

// if(is_null($aadhar_data) && is_null($account_number)) {

try {

\DB::beginTransaction();

$user = \App\User::where("api_token", $request->api_token)

->where("is_active", 1)

->first();

$memberShip = new \App\SyncMember();

//Member Detail

$memberShip->created_by_id = $user->id;

$memberShip->api_token = $request->api_token;

$memberShip->applicant_name = $request->strApplicantName;

$memberShip->husband_or_father =

$request->husband_or_father;

$memberShip->husband_or_father_name =

$request->strfather_husbandName;

$memberShip->gender = $request->strGender;

$memberShip->dob = $request->strDOB;

$memberShip->cast = $request->strCast;

$memberShip->education = $request->strEducation;

$memberShip->house_no = $request->strHouseNo;

// $memberShip->applicant_age = $request->differenceyear;

// $memberShip->aadhar_card = $request->strAadharNo;

// $memberShip->email = $request->email;

//Address And Contact Detail

$memberShip->old_code = $request->old_code;
                    $memberShip->helmet = $request->strHemlet;

$memberShip->village = $request->strVillage;

$memberShip->post_office = $request->strPostOffice;

$memberShip->tehsil = $request->strTeshsil;

$memberShip->district = $request->strDistrict;

$memberShip->state = $request->strState;

$memberShip->pincode = $request->strPinCode;

$memberShip->mobile_no = $request->strMobileNo;

$memberShip->landline = $request->strLandlineNo;

$memberShip->email = $request->email;

//Saving Bank Account Details

$memberShip->account_holder_name =

$request->account_holder_name;

$memberShip->s_account_number = $request->s_account_number;

$memberShip->ifsc_code = $request->ifsc_code;

$memberShip->bank_name = $request->bank_name;

$memberShip->branch_name = $request->branch_name;

// $memberShip->self_declare = $request->self_declare;

//Nominee Declaration

$memberShip->nominee_name = $request->strNomineeName;

$memberShip->relation_with_application =

$request->strApplicant;

$memberShip->address = $request->strVillage . ', ' . $request->strTeshsil . ', ' . $request->strDistrict . ', ' . $request->strState . ', ' . $request->strPinCode;

$memberShip->guardian_name = $request->strGuardianName;

$memberShip->age = $request->strAge;

//Village Details

$memberShip->milk_producer_name =

$request->strMilProducerName;

$memberShip->mcc_name = $request->strBMCName;

$memberShip->mcc_code = $request->strmcc_code;

$memberShip->mpp_name = $request->strMPPName;

$memberShip->mpp_code = $request->strmpp_code;

// $memberShip->revanue_vill_name = $request->strRevenueVillName;

// $memberShip->revanue_vill_code = $request->strRevenueVillCode;

// $memberShip->tehsil_name = $request->strVtehsil;

// $memberShip->district_name = $request->strVdistrict;

$memberShip->pooling_point_code =

$request->strPoolPointCode;

$memberShip->aadhar_card = $request->strAadharNo;

$memberShip->pancard_no = $request->strpancardNo;

$memberShip->pan_status = $request->pan_status;

//Member Fee Details

$memberShip->admission_fee = $request->strAdmissionFee;

$memberShip->share_quantity = $request->strShareQuantity;

$memberShip->received_amount = $request->strReceivedAmount;

$memberShip->cash_dd = $request->strCash_DD;

$memberShip->fee_bank_name = $request->strFBankName;

$memberShip->fee_ifsc = $request->fee_ifsc;

$memberShip->fee_branch_name = $request->strFBranchName;

$memberShip->fee_receipt_no = $request->strReceiptNo;

$memberShip->fee_receipt_date = $request->strReceiptDate;

$memberShip->amount = $request->strFAmount;

//  $memberShip->shg_member = $request->strSHGMember;

//Milk Production And Consumption Details

$memberShip->milk_product_date =

$request->strMilkProductdate;

$memberShip->desiCow = $request->desiCow;

$memberShip->crossBred = $request->crossBred;

$memberShip->buffalo = $request->buffalo;

$memberShip->total = $request->total;

$memberShip->MilkProduction = $request->MilkProduction;

$memberShip->HouseHoldConsumption =

$request->HouseHoldConsumption;

$memberShip->MarketableSurplus =

$request->MarketableSurplus;
                    $memberShip->AnnualMilkCommitment = $request->AnnualMilkCommitment;

//Particular Of My House Hold Members Living With Me

$memberShip->relation1 = $request->strRelation1;

$memberShip->relation2 = $request->strRelation2;

$memberShip->relation3 = $request->strRelation3;

$memberShip->relation4 = $request->strRelation4;

$memberShip->relation5 = $request->strRelation5;

$memberShip->relation6 = $request->strRelation6;

//other

$memberShip->lat = $request->lat;

$memberShip->long = $request->longit;

//payment

$memberShip->transaction_id = $request->transaction_id;

$memberShip->payment_status = $request->payment_status;

$memberShip->is_active = "1";

$memberShip->save();

//document Details

if ($request->farmer_aadhar_front_file) {

$adhar_front =

"front" .

$memberShip->id .

"." .

$request->farmer_aadhar_front_file->extension();

$request->farmer_aadhar_front_file->move(

public_path("sync_member_img/"),

$adhar_front

);

$memberShip->aadhar_front_file =

"sync_member_img/" . $adhar_front;

// $memberShip->aadhar_front_file = $request->farmer_aadhar_front_file;

}

if ($request->farmer_aadhar_back_file) {

$adhar_back =

"back" .

$memberShip->id .

"." .

$request->farmer_aadhar_back_file->extension();

$request->farmer_aadhar_back_file->move(

public_path("sync_member_img/"),

$adhar_back

);

$memberShip->aadhar_back_file =

"sync_member_img/" . $adhar_back;

// $memberShip->aadhar_back_file = $request->farmer_aadhar_back_file;

}

if ($request->nominee_aadhar_front_file) {

$nominee_aadhar1 =

"nominee_front" .

$memberShip->id .

"_" .

$request->nominee_aadhar_front_file->extension();

$request->nominee_aadhar_front_file->move(

public_path("sync_member_img/"),

$nominee_aadhar1

);

$memberShip->nominee_aadhar_front_file =

"sync_member_img/" . $nominee_aadhar1;

}

if ($request->nominee_aadhar_back_file) {

$nominee_aadhar2 =

"nominee_back" .

$memberShip->id .

"_" .

$request->nominee_aadhar_back_file->extension();

$request->nominee_aadhar_back_file->move(

public_path("sync_member_img/"),

$nominee_aadhar2

);

$memberShip->nominee_aadhar_back_file =

"sync_member_img/" . $nominee_aadhar2;

}

if ($request->farmer_passbook_file) {

$passbook =

"passbook" .

$memberShip->id .

"." .

$request->farmer_passbook_file->extension();

$request->farmer_passbook_file->move(

public_path("sync_member_img/"),

$passbook

);

$memberShip->passbook_file =

"sync_member_img/" . $passbook;

// $memberShip->passbook_file = $request->farmer_passbook_file;

}

if ($request->farmer_pic_file) {

$pic =

"farmer" .

$memberShip->id .

"." .

$request->farmer_pic_file->extension();

$request->farmer_pic_file->move(

public_path("sync_member_img/"),

$pic

);

$memberShip->pic_file = "sync_member_img/" . $pic;

// $memberShip->pic_file = $request->farmer_pic_file;

}

if ($request->farmer_Signature) {

$sign =

"sign" .

$memberShip->id .

"." .

$request->farmer_Signature->extension();

$request->farmer_Signature->move(

public_path("sync_member_img/"),

$sign

);

$memberShip->Signature = "sync_member_img/" . $sign;

// $memberShip->Signature = $request->farmer_Signature;

}

if ($request->payment_receipt) {

$payment_receipt = $form_number.'_receipt'.$memberShip->id.'.'.$request->payment_receipt->extension();

$request->payment_receipt->move(public_path('member_image/payment_receipt/'), $payment_receipt);

$memberShip->payment_receipt = 'payment_receipt/'.$payment_receipt;

}

if ($request->farmer_Pancard) {

$pancard =

"pancard" .

$memberShip->id .

"." .

$request->farmer_Pancard->extension();

$request->farmer_Pancard->move(

public_path("sync_member_img/"),

$pancard

);

$memberShip->pancard = "sync_member_img/" . $pancard;

}

$memberShip->save();

$response["status"] = 1;

$response["message"] = "Sync Member Register Successfully";

$response["data"] = $memberShip->id;

\DB::commit();

} catch (\Exception $exp) {

\DB::rollBack();

$response["status"] = 0;

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

}

// } else {

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

//         $response['status'] = 0;

//         $response['message'] = "Aadhar already registered.";

//     }

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

//         $response['status'] = 0;

//         $response['message'] = "Account already registered.";

//     }

// }

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

// $response['status'] = 0;

// $response['message'] = "Service Unavailable.";

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

}

public function syncMemberListById(Request $request)

{

$response = [];

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

"api_token" => "required",

"id" => "required",

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$data = \App\SyncMember::where("created_by_id", $request->id)

->where("status", 0)

->get();

if (!is_null($data)) {

if (count($data) > 0) {

$response["status"] = 1;

$response["data"] = $data;

} else {

$response["status"] = 0;

$response["message"] = "No Data Found";

}

} else {

$response["status"] = 0;

$response["message"] = "No Data Found!";

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

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

}

// public function updateSyncMemberStatus(Request $request)

// {

//     $response=array();

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

//     $validator = \Validator::make(

//         $request->all(),

//         array(

//              'api_token' => 'required',

//              'form_id' => 'required',

//         )

//     );

//     if ($validator->fails()) {

//         $response['status'] = 0;

//         $response['message'] = $this->parseErrorResponse($validator->getMessageBag());

//     } else {

//         if ($this->checkApiAuth($request)) {

//             try{

//                 \DB::beginTransaction();

//                 // $user=\App\User::where('api_token',$request->api_token)->where('is_active', 1)->first();

//                 $memberShip =  \App\SyncMember::where('id',$request->form_id)->where('status',0)->first();

//                 if(is_null($memberShip)){

//     				$response['status'] = 0;

//     				$response['message'] = "No Data found";

//     			}else{

//                     $memberShip->status = 1;

//                     if ($memberShip->save()) {

//                     $response['status'] = 1;

//                     $response['message'] = "Form Updated Successfully";

//                     $response['data'] = $memberShip->id;

//                     }

//                 }

//             } catch(\Exception $exp) {

//                 \DB::rollBack();

//                 logger($exp);

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

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

//             }

//         } else {

//             $response['status'] = 0;

//             $response['message'] = "Session Expired";

//             $response['is_token_expired'] = 1;

//         }

//     }

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

// }

public function AddSyncMember(Request $request)

{
 logger($request->all());
        $response = [];

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

"api_token" => "required",
            
            "strReceiptNo" => "required|unique:membership_details,fee_receipt_no",

"farmer_aadhar_front_file" => "required",

"farmer_aadhar_back_file" => "required",

"nominee_aadhar_front_file" => "required",

"nominee_aadhar_back_file" => "required",

// "farmer_Pancard" => "required",

"farmer_passbook_file" => "required",

"farmer_pic_file" => "required",

"farmer_Signature" => "required",

"strApplicantName" => "required",

"strfather_husbandName" => "required",

"strGender" => "required",

"differenceyear" => "required",

"strCast" => "required",

"strEducation" => "required",

"strAadharNo" => "required",

// "strpancardNo" => "required",

// "pan_status" => "required",

"strPinCode" => "required",

"strBMCName" => "required",

"strmcc_code" => "required",

"strMPPName" => "required",

"strmpp_code" => "required",

"strRevenueVillName" => "required",

"strRevenueVillCode" => "required",

"strVtehsil" => "required",

"strVdistrict" => "required",

"strMobileNo" => "required",

"strMilkProductdate" => "required",

"desiCow" => "required",

"crossBred" => "required",

"buffalo" => "required",

"total" => "required",

"MilkProduction" => "required",

"HouseHoldConsumption" => "required",

"account_holder_name" => "required",

"s_account_number" => "required",

"ifsc_code" => "required",

"bank_name" => "required",

"branch_name" => "required",

"self_declare" => "required",

"strRelation1" => "required",

"lat" => "required",

"longit" => "required",

// "strSHGMember" => "required",

"strNomineeName" => "required",

"strApplicant" => "required",

"strAge" => "required",

"AnnualMilkCommitment" => "required"

]);

if ($validator->fails()) {

$response["status"] = 0;

$response["message"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$aadhar_data = \App\MembershipDetail::where(

"aadhar_card",

$request->strAadharNo

)

->where("is_active", 1)

->first();

$account_number = \App\MembershipDetail::where("s_account_number",$request->s_account_number)->where("is_active", 1)->first();
                $old_adhar_card = \DB::table("legacy_data")
                    ->where("aadhar_no", $request->strAadharNo)
                    ->where("is_active", 1)
                    ->first();

if (is_null($aadhar_data) && is_null($account_number) && is_null($old_adhar_card)) {

$my_array = explode(",", $request->total);

if ($my_array[2] > 0) {

try {

\DB::beginTransaction();

$user = \App\User::where(

"api_token",

$request->api_token

)

->where("is_active", 1)

->first();

$memberShip = new \App\MembershipDetail();

//Member Detail

$memberShip->created_by_id = $user->id;

$memberShip->applicant_name =

$request->strApplicantName;

$my_array1 = explode(

",",

$request->strfather_husbandName

);

$memberShip->husband_or_father = strtoupper(

$my_array1[0]

);

$memberShip->husband_or_father_name = $my_array1[1];

$memberShip->gender = $request->strGender;

$memberShip->applicant_age =

$request->differenceyear;

$memberShip->cast = $request->strCast;

$memberShip->education = $request->strEducation;

$memberShip->aadhar_card = $request->strAadharNo;

$memberShip->pancard_no = $request->strpancardNo;

$memberShip->pan_status = $request->pan_status;

$memberShip->email = $request->email;
                            $memberShip->old_code = $request->old_code;

//Address And Contact Detail

$memberShip->house_no = $request->strHouseNo;

$memberShip->helmet = $request->strHemlet;

$memberShip->village = $request->strVillage;

$memberShip->post_office = $request->strPostOffice;

$memberShip->tehsil = $request->strTeshsil;

$memberShip->district = $request->strDistrict;

$memberShip->state = $request->strState;

$memberShip->pincode = $request->strPinCode;

$memberShip->mobile_no = $request->strMobileNo;

$memberShip->landline = $request->strLandlineNo;

if($request->AnnualMilkCommitment == "0" || $request->AnnualMilkCommitment == " " || $request->AnnualMilkCommitment == "Null"){
                                     $memberShip->AnnualMilkCommitment = "500";
                                }elseif($request->AnnualMilkCommitment < '500'){
                                    $memberShip->AnnualMilkCommitment = "500";
                                }else{
                                    $memberShip->AnnualMilkCommitment = $request->AnnualMilkCommitment;
                                }

//Saving Bank Account Details

$memberShip->account_holder_name =

$request->account_holder_name;

$memberShip->s_account_number =

$request->s_account_number;

$memberShip->ifsc_code = $request->ifsc_code;

$memberShip->bank_name = $request->bank_name;

$memberShip->branch_name = $request->branch_name;

$memberShip->self_declare = $request->self_declare;

//Nominee Declaration

$memberShip->nominee_name =

$request->strNomineeName;

$memberShip->relation_with_application =

$request->strApplicant;

$memberShip->address = $request->strVillage . ', ' . $request->strTeshsil . ', ' . $request->strDistrict . ', ' . $request->strState . ', ' . $request->strPinCode;

$memberShip->guardian_name =

$request->strGuardianName;

$memberShip->age = $request->strAge;

$memberShip->dob = $request->strDOB;
                            $memberShip->old_code = $request->old_code;

//Village Details

$memberShip->milk_producer_name =

$request->strMilProducerName;

$memberShip->mcc_name = $request->strBMCName;

$memberShip->mcc_code = $request->strmcc_code;

$memberShip->mpp_name = $request->strMPPName;

$memberShip->mpp_code = $request->strmpp_code;

$memberShip->revanue_vill_name =

$request->strRevenueVillName;

$memberShip->revanue_vill_code =

$request->strRevenueVillCode;

$memberShip->tehsil_name = $request->strVtehsil;

$memberShip->district_name = $request->strVdistrict;

$memberShip->pooling_point_code =

$request->strPoolPointCode;

//Member Fee Details

$memberShip->admission_fee =

$request->strAdmissionFee;

$memberShip->share_quantity =

$request->strShareQuantity;

$memberShip->received_amount =

$request->strReceivedAmount;

$memberShip->cash_dd = $request->strCash_DD;

$memberShip->fee_bank_name = $request->strFBankName;

$memberShip->fee_ifsc = $request->fee_ifsc;

$memberShip->fee_branch_name =

$request->strFBranchName;

$memberShip->fee_receipt_no =

$request->strReceiptNo;

$memberShip->fee_receipt_date =

$request->strReceiptDate;

$memberShip->amount = $request->strFAmount;

//   $memberShip->shg_member = $request->strSHGMember;

//Milk Production And Consumption Details

$memberShip->milk_product_date =

$request->strMilkProductdate;

$memberShip->desiCow = $request->desiCow;

$memberShip->crossBred = $request->crossBred;

$memberShip->buffalo = $request->buffalo;

$memberShip->total = $request->total;

$memberShip->MilkProduction =

$request->MilkProduction;

$memberShip->HouseHoldConsumption =

$request->HouseHoldConsumption;

$memberShip->MarketableSurplus =

$request->MarketableSurplus;

//Particular Of My House Hold Members Living With Me

$memberShip->relation1 = $request->strRelation1;

$memberShip->relation2 = $request->strRelation2;

$memberShip->relation3 = $request->strRelation3;

$memberShip->relation4 = $request->strRelation4;

$memberShip->relation5 = $request->strRelation5;

$memberShip->relation6 = $request->strRelation6;

//other

$memberShip->lat = $request->lat;

$memberShip->long = $request->longit;

//payment

$memberShip->transaction_id =

$request->transaction_id;

$memberShip->payment_status =

$request->payment_status;

$memberShip->is_active = "1";

// $form_number = $this->generateFormNo($request->strmcc_code);

// $memberShip->form_no = $form_number;

$member_data = \App\MembershipDetail::orderBy(

"id",

"DESC"

)->first();

if (!is_null($member_data)) {

$form_no = trim($member_data->form_no, "A");

$form_no = (int) $form_no + 1;

$form_number = "A" . $form_no;

} else {

$form_number = "A30261";

}

$memberShip->form_no = $form_number;

$memberShip->save();

//document Details

if ($request->farmer_aadhar_front_file) {

$adhar_front =

$form_number .

"_front" .

$memberShip->id .

"." .

$request->farmer_aadhar_front_file->extension();

$request->farmer_aadhar_front_file->move(

public_path("member_image/img_adhar/"),

$adhar_front

);

$memberShip->aadhar_front_file =

"img_adhar/" . $adhar_front;

}

if ($request->farmer_aadhar_back_file) {

$adhar_back =

$form_number .

"_back" .

$memberShip->id .

"." .

$request->farmer_aadhar_back_file->extension();

$request->farmer_aadhar_back_file->move(

public_path("member_image/img_adhar/"),

$adhar_back

);

$memberShip->aadhar_back_file =

"img_adhar/" . $adhar_back;

}

if ($request->nominee_aadhar_front_file) {

$nominee_aadhar1 =

$form_number .

"_front" .

$memberShip->id .

"_" .

time() .

"." .

$request->nominee_aadhar_front_file->extension();

$request->nominee_aadhar_front_file->move(

public_path(

"member_image/img_nominee_aadhar/"

$nominee_aadhar1

);

$memberShip->nominee_aadhar_front_file =

"img_nominee_aadhar/" . $nominee_aadhar1;

}

if ($request->nominee_aadhar_back_file) {

$nominee_aadhar2 =

$form_number .

"_back" .

$memberShip->id .

"_" .

time() .

"." .

$request->nominee_aadhar_back_file->extension();

$request->nominee_aadhar_back_file->move(

public_path(

"member_image/img_nominee_aadhar/"

$nominee_aadhar2

);

$memberShip->nominee_aadhar_back_file =

"img_nominee_aadhar/" . $nominee_aadhar2;

}

if ($request->farmer_passbook_file) {

$passbook =

$form_number .

"_passbook" .

$memberShip->id .

"." .

$request->farmer_passbook_file->extension();

$request->farmer_passbook_file->move(

public_path("member_image/img_passbook/"),

$passbook

);

$memberShip->passbook_file =

"img_passbook/" . $passbook;

}

if ($request->farmer_pic_file) {

$pic =

$form_number .

"_farmer" .

$memberShip->id .

"." .

$request->farmer_pic_file->extension();

$request->farmer_pic_file->move(

public_path("member_image/img_farmer/"),

$pic

);

$memberShip->pic_file = "img_farmer/" . $pic;

}

if ($request->farmer_Signature) {

$sign =

$form_number .

"_sign" .

$memberShip->id .

"." .

$request->farmer_Signature->extension();

$request->farmer_Signature->move(

public_path("member_image/img_sign/"),

$sign

);

$memberShip->Signature = "img_sign/" . $sign;

}

if ($request->payment_receipt) {

$payment_receipt =

$form_number .

"_receipt" .

$memberShip->id .

"." .

$request->payment_receipt->extension();

$request->payment_receipt->move(

public_path(

"member_image/payment_receipt/"

$payment_receipt

);

$memberShip->payment_receipt =

"payment_receipt/" . $payment_receipt;

}

if ($request->farmer_Pancard) {

$pancard =

$form_number .

"_pancard" .

$memberShip->id .

"_" .

time() .

"." .

$request->farmer_Pancard->extension();

$request->farmer_Pancard->move(

public_path("member_image/img_pancard/"),

$pancard

);

$memberShip->pancard =

"img_pancard/" . $pancard;

}

$memberShip->save();

$syncMemberShip = \App\SyncMember::where(

"aadhar_card",

$request->strAadharNo

)

->where("status", 0)

->first();

$syncMemberShip->status = 1;

$syncMemberShip->save();

$response["status"] = 1;

$response["message"] =

"Member Register Successfully";

$response["data"] = $memberShip->id;

$response["form_no"] = $memberShip->form_no;

\DB::commit();

$abc = $this->assignFormToAreaOfficer(

$memberShip->id,

$request->strmcc_code

);

} catch (\Exception $exp) {

\DB::rollBack();

$response["status"] = 0;

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

}

} else {

$response["status"] = 0;

$response["message"] =

"In milk animal number can not be 0.";

}

} else {

if (!is_null($aadhar_data) || !is_null($old_adhar_card)) {

$response["status"] = 0;

$response["message"] = "Aadhar already registered.";

}

if (!is_null($account_number)) {

$response["status"] = 0;

$response["message"] = "Account already registered.";

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

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

}

public function checkUtrNo(Request $request)

{

$response = [];

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

//'api_token' => 'required',

]);

if ($validator->fails()) {

$response["flag"] = false;

$response["errors"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

$getUtr = \DB::table("membership_details")

->where("fee_receipt_no", $request->utr_no)

->where("is_active", 1)

->first();

if (!empty($getUtr)) {

// if(count($getUtr)>0){

$response["status"] = 1;

$response["data"] = $getUtr->form_no;

$response["message"] = "UTR Number Exist";

// }else{

//   $response['status'] = 0;

//   $response['message'] = 'No Data Found';

// }

} else {

$response["status"] = 0;

$response["message"] = "UTR Number Not Exist";

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

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

}

public function getTotalPaayasmilkForm(Request $request)

{

if ($request->isMethod("post")) {

$from = $request->from_date;

$to = $request->to_date;

$totalMembers = \App\MembershipDetail::whereBetween(

DB::raw("date(created_at)"),

[$from, $to]

)->count();

$approvedMembers = \App\MembershipDetail::whereNotNull(

"final_approval_status"

)

->where("final_approval_status", "Approved")

->whereBetween(DB::raw("date(created_at)"), [$from, $to])

->count();

$rejectededMembers = \App\MembershipDetail::whereNotNull(

"final_approval_status"

)

->where("final_approval_status", "Rejected")

->whereBetween(DB::raw("date(created_at)"), [$from, $to])

->count();

$totalFinalRequestedForm = \App\MembershipDetail::whereNotNull(

"final_approval_status"

)

->where("final_approval_status", "Requested")

->whereBetween(DB::raw("date(created_at)"), [$from, $to])

->count();

$totalPendingForm1 = \App\MembershipDetail::where(

"final_approval_status",

null

)

->whereBetween(DB::raw("date(created_at)"), [$from, $to])

->count();

$pendingMembers = $totalFinalRequestedForm + $totalPendingForm1;

} else {

$totalMembers = \App\MembershipDetail::count();

$approvedMembers = \App\MembershipDetail::whereNotNull(

"final_approval_status"

)

->where("final_approval_status", "Approved")

->count();

$rejectededMembers = \App\MembershipDetail::whereNotNull(

"final_approval_status"

)

->where("final_approval_status", "Rejected")

->count();

$totalFinalRequestedForm = \App\MembershipDetail::whereNotNull(

"final_approval_status"

)

->where("final_approval_status", "Requested")

->count();

$totalPendingForm1 = \App\MembershipDetail::where(

"final_approval_status",

null

)->count();

$pendingMembers = $totalFinalRequestedForm + $totalPendingForm1;

}

$response["status"] = 1;

$response["totalMembers"] = $totalMembers;

$response["approvedMembers"] = $approvedMembers;

$response["rejectededMembers"] = $rejectededMembers;

$response["pendingMembers"] = $pendingMembers;

// if($totalMembers>0){

//     $response['status'] = 1;

//     $response['totalMembers'] = $totalMembers;

//     $response['approvedMembers'] = $approvedMembers;

//     $response['rejectededMembers'] = $rejectededMembers;

//     $response['pendingMembers'] = $pendingMembers;

//  }else{

//     $response['status'] = 0;

//     $response['message'] = "No Form";

// }

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

}

public function updateMemberImage(Request $request)

{

$response = [];

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

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

"api_token" => "required",

"form_id" => "required",

]);

if ($validator->fails()) {

$response["status"] = 0;

$response["message"] = $this->parseErrorResponse(

$validator->getMessageBag()

);

} else {

if ($this->checkApiAuth($request)) {

try {

\DB::beginTransaction();

$user = \App\User::where("api_token", $request->api_token)

->where("is_active", 1)

->first();

$memberShip = \App\MembershipDetail::where(

"id",

$request->form_id

)

->where("is_active", 1)

->first();

$pre_data = $memberShip->toArray();

if (is_null($memberShip)) {

$response["status"] = 0;

$response["message"] = "No Data found";

} else {

$form_number = $memberShip->form_no;

//document Details

if ($request->farmer_aadhar_front_file) {

$adhar_front =

$form_number .

"_front" .

$memberShip->id .

"." .

$request->farmer_aadhar_front_file->extension();

$request->farmer_aadhar_front_file->move(

public_path("member_image/img_adhar/"),

$adhar_front

);

$memberShip->aadhar_front_file =

"img_adhar/" . $adhar_front;

}

if ($request->farmer_aadhar_back_file) {

$adhar_back =

$form_number .

"_back" .

$memberShip->id .

"." .

$request->farmer_aadhar_back_file->extension();

$request->farmer_aadhar_back_file->move(

public_path("member_image/img_adhar/"),

$adhar_back

);

$memberShip->aadhar_back_file =

"img_adhar/" . $adhar_back;

}

if ($request->farmer_passbook_file) {

$passbook = $form_number.'_passbook'.$memberShip->id.'.'.$request->farmer_passbook_file->extension();

$request->farmer_passbook_file->move(public_path('member_image/img_passbook/'), $passbook);

$memberShip->passbook_file = 'img_passbook/'.$passbook;

}

if ($request->farmer_pic_file) {

$pic = $form_number.'_farmer'.$memberShip->id.'.'.$request->farmer_pic_file->extension();

$request->farmer_pic_file->move(public_path('member_image/img_farmer/'), $pic);

$memberShip->pic_file = 'img_farmer/'.$pic;

}

if ($request->farmer_Signature) {

$sign = $form_number.'_sign'.$memberShip->id.'.'.$request->farmer_Signature->extension();

$request->farmer_Signature->move(public_path('member_image/img_sign/'), $sign);

$memberShip->Signature = 'img_sign/'.$sign;

}

if ($request->payment_receipt) {

$payment_receipt = $form_number.'_receipt'.$memberShip->id.'.'.$request->payment_receipt->extension();

$request->payment_receipt->move(public_path('member_image/payment_receipt/'), $payment_receipt);

$memberShip->payment_receipt = 'payment_receipt/'.$payment_receipt;

}

if ($memberShip->save()) {

//LOGS

$form_logs = new \App\EditFormLog();

$form_logs->user_id = $user->id;

$form_logs->form_id = $memberShip->id;

$form_logs->pre_data = json_encode($pre_data);

$form_logs->save();

}

\DB::commit();

$response["status"] = 1;

$response["message"] = "Form Updated Successfully";

$response["data"] = $memberShip->id;

$response["form_no"] = $memberShip->form_no;

}

} catch (\Exception $exp) {

\DB::rollBack();

logger($exp);

$response["flag"] = false;

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

}

} else {

$response["status"] = 0;

$response["message"] = " Session Expired";

$response["is_token_expired"] = 1;

}

// $response['status'] = 0;

// $response['message'] = "Service Stopped By Admin.";

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

}

public function AddAnimal(Request $request)
    {
        logger($request->all());
        $response = [];

$validator = \Validator::make($request->all(), [
            "api_token" => "required",
            "code" => "required",
            "animalDataList" => "required",
            "animalTagImageList" => "required",
            "animalImageList" => "required",
        ]);

if ($validator->fails()) {
            $response["status"] = 0;
            $response["message"] = $this->parseErrorResponse($validator->getMessageBag());
        } else {
            if ($this->checkApiAuth($request)) {
                $user = \App\User::where("api_token", $request->api_token)
                    ->where("is_active", 1)
                    ->first();

// Check if member exists in membership or legacy data
                $isAlreadyExistInMembership = \App\MembershipDetail::where("aadhar_card", $request->code)
                    ->where("is_active", 1)
                    ->first();
                $isAlreadyExistInMembership2 = \DB::table('legacy_data')
                    ->where("aadhar_no", $request->code)
                    ->where('is_active', 1)
                    ->first();

if (is_null($isAlreadyExistInMembership) && is_null($isAlreadyExistInMembership2)) {
                    $response["status"] = 0;
                    $response["message"] = "Member Not Found On This Aadhar Card.";
                    return response()->json($response);
                }

// Get form_no from membership or legacy data
                $formNo = $isAlreadyExistInMembership ? $isAlreadyExistInMembership->form_no : $isAlreadyExistInMembership2->form_no;

// Find the highest existing virtual_tag_number for the member
                $lastVirtualTag = \App\AnimalDetail::where("member_aadhar", $request->code)
                    ->where("is_active", 1)
                    ->whereNotNull('virtual_tag_number')
                    ->orderBy('id', 'desc')
                    ->first();

// Start virtual tag number series from last number, or default to 1
                $startIndex = 1;
                if ($lastVirtualTag && $lastVirtualTag->virtual_tag_number) {
                    $lastIndex = intval(explode('-', $lastVirtualTag->virtual_tag_number)[2]);
                    $startIndex = $lastIndex + 1;
                }

// Decode the JSON string in animalDataList
                $animalDataList = json_decode($request->animalDataList, true);

if (is_array($animalDataList)) {
                    foreach ($animalDataList as $index => $animalData) {
                        // Generate virtual tag number using last 4 digits of Aadhar, form_no, and index
                        $lastFourDigits = substr($request->code, -4);
                        $virtualTagNumber = $lastFourDigits . "-" . $formNo . "-" . ($startIndex + $index);

try {
                            \DB::beginTransaction();

// Save animal details
                            $animal = new \App\AnimalDetail();
                            $animal->created_by = $user->id;
                            $animal->member_aadhar = $request->code;
                            $animal->animal_registration_date = $animalData['strRegistrationDate'];
                            $animal->animal_type = $animalData['strAnimalType'];
                            $animal->animal_breed = $animalData['strAnimalBreed'];
                            $animal->age = $animalData['strAge'];
                            $animal->animal_category = $animalData['strAnimalCategory'];
                            $animal->milk_production = $animalData['strMilkProduction'];
                            $animal->lactation_count = $animalData['strLactationCount'];
                            $animal->is_pregnant = $animalData['strPregnant'];
                            $animal->month_of_pregnancy = ($animalData['strPregnant'] === "Yes") ? $animalData['strPregnancyMonth'] : null;
                            $animal->animal_tag_no = $animalData['strAnimalTag'];
                            $animal->virtual_tag_number = $virtualTagNumber;
                            $animal->animal_tag_status = 1;
                            $animal->is_active = 1;
                            if (!is_null($isAlreadyExistInMembership2)) {
                                $animal->is_old_member = 1;
                            }
                            $animal->save();

// Handle image uploads
                            if ($request->hasFile('animalTagImageList')) {
                                $animalTagImage = is_array($request->file('animalTagImageList')) 
                                    ? $request->file('animalTagImageList')[$index] 
                                    : $request->file('animalTagImageList');
                                
                                $animalTagFileName = "animal_tag_" . $animal->id . "_" . time() . "." . $animalTagImage->extension();
                                $animalTagImage->move(public_path("animal_image/img_animal/"), $animalTagFileName);
                                $animal->photo_with_animal_tag = "img_animal/" . $animalTagFileName;
                            }

if ($request->hasFile('animalImageList')) {
                                $animalImage = is_array($request->file('animalImageList')) 
                                    ? $request->file('animalImageList')[$index] 
                                    : $request->file('animalImageList');
                                
                                $animalImageFileName = "animal_image_" . $animal->id . "_" . time() . "." . $animalImage->extension();
                                $animalImage->move(public_path("animal_image/img_animal/"), $animalImageFileName);
                                $animal->photo_of_animal = "img_animal/" . $animalImageFileName;
                            }

$animal->save();

\DB::commit();
                        } catch (\Exception $exp) {
                            \DB::rollBack();
                            $response["status"] = 0;
                            $response["message"] = $exp->getMessage();
                            return response()->json($response);
                        }
                    }

$response["status"] = 1;
                    $response["message"] = "Animals registered successfully.";
                } else {
                    $response["status"] = 0;
                    $response["message"] = "Invalid animal data.";
                }
            } else {
                $response["status"] = 0;
                $response["message"] = "Session Expired";
                $response["is_token_expired"] = 1;
            }
        }

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

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

$validator = \Validator::make($request->all(), [
            "api_token" => "required",
            "strAadharNo" => "required",
        ]);
        if ($validator->fails()) {
            $response["status"] = 0;
            $response["message"] = $this->parseErrorResponse(
                $validator->getMessageBag()
            );
        } else {
            if ($this->checkApiAuth($request)) {
                try {
                    \DB::beginTransaction();

$user = \App\User::where("api_token", $request->api_token)
                        ->where("is_active", 1)
                        ->first();
                    $animal = new \App\AnimalDetail();
                    //Member Detail
                    $animal->created_by = $user->id;
                    $animal->member_aadhar = $request->strAadharNo;

$animal->is_active = "1";

$animal->save();

$response["status"] = 1;
                    $response["message"] = "Animal Register Successfully";
                    $response["data"] = $animal;

\DB::commit();
                } catch (\Exception $exp) {
                    \DB::rollBack();

$response["status"] = 0;
                    $response["message"] = $exp->getMessage();
                }
            } else {
                $response["status"] = 0;
                $response["message"] = " Session Expired";
                $response["is_token_expired"] = 1;
            }
        }
        return response()->json($response);
    }

public function AddAnimalPartialByMember($api_token,$strAadharNo)

{

$response = [];

try {

\DB::beginTransaction();

$user = \App\User::where("api_token",$api_token)

->where("is_active", 1)

->first();

$animal = new \App\AnimalDetail();

//Member Detail

$animal->created_by = $user->id;

$animal->member_aadhar = $strAadharNo;

$animal->is_active = "1";

$animal->save();

$response["status"] = 1;

$response["message"] = "Animal Register Partially";

$response["data"] = $animal;

\DB::commit();

} catch (\Exception $exp) {

\DB::rollBack();

$response["status"] = 0;

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

}

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

}

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

$validator = \Validator::make($request->all(), [
            "api_token" => "required",
            "strAadharNo" => "required",
            "strAnimalTag" => "required",
            "strAnimalTagStatus" => "nullable",
        ]);
        if ($validator->fails()) {
            $response["status"] = 0;
            $response["message"] = $this->parseErrorResponse(
                $validator->getMessageBag()
            );
        } else {
            if ($this->checkApiAuth($request)) {
                $isAlreadyExist = \App\AnimalDetail::where(
                    "member_aadhar",
                    $request->strAadharNo
                )
                    ->where("animal_tag_no", $request->strAnimalTag)
                    ->where("is_active", 1)
                    ->first();

if (!is_null($isAlreadyExist)) {
                    try {
                        \DB::beginTransaction();
                        $user = \App\User::where(
                            "api_token",
                            $request->api_token
                        )
                            ->where("is_active", 1)
                            ->first();

$animal = \App\AnimalDetail::where(
                            "member_aadhar",
                            $request->strAadharNo
                        )
                            ->where("animal_tag_no", $request->strAnimalTag)
                            ->where("is_active", 1)
                            ->first();

$pre_data = $animal->toArray();

if(isset($request->strAnimalTagStatus) && $request->strAnimalTagStatus == 0){
                            $animal->animal_tag_status = $request->strAnimalTagStatus;
                            $animal->is_active = 0;
                            $animal->save();
                        }else{
                            //Member Detail
                            $animal->member_aadhar = $request->strAadharNo;
                            $animal->animal_registration_date = $request->strRegistrationDate ?? $animal->animal_registration_date;
                            $animal->animal_type = $request->strAnimalType ?? $animal->animal_type;
                            $animal->animal_breed = $request->strAnimalBreed ?? $animal->animal_breed;
                            $animal->age = $request->strAge ?? $animal->age;
                            $animal->animal_category = $request->strAnimalCategory ?? $animal->animal_category;
                            $animal->milk_production = $request->strMilkProduction ?? $animal->milk_production;
                            $animal->lactation_count = $request->strLactationCount ?? $animal->lactation_count;
                            $animal->is_pregnant = $request->strPregnant ?? $animal->is_pregnant;

if ($request->strPregnant) {
                                $animal->month_of_pregnancy =
                                    $request->strPregnancyMonth;
                            } else {
                                $animal->month_of_pregnancy = null;
                            }
                            $animal->animal_tag_no = $request->strAnimalTag;
                            // $animal->animal_tag_status = 1;
                            // $animal->is_active = "1";
                            $animal->save();

//document Details
                            //Animal Tag Image
                            if ($request->animalTagFile) {
                                $animalTag1 =
                                    "animal_tag_" . $animal->id . "_" . time() . "." . $request->animalTagFile->extension();
                                $request->animalTagFile->move(
                                    public_path("animal_image/img_animal/"),
                                    $animalTag1
                                );
                                $animal->photo_with_animal_tag =
                                    "img_animal/" . $animalTag1;
                            }
                            // Animal Image
                            if ($request->animalImageFile) {
                                $animalTag =
                                    "animal_image_" . $animal->id . "_" . time() . "." . $request->animalImageFile->extension();
                                $request->animalImageFile->move(
                                    public_path("animal_image/img_animal/"),
                                    $animalTag
                                );
                                $animal->photo_of_animal =
                                    "img_animal/" . $animalTag;
                            }
                            $animal->save();
                        }

//LOGS
                        $form_logs = new \App\AnimalDetailLog();
                        $form_logs->user_id = $user->id;
                        $form_logs->animal_id = $animal->id;
                        $form_logs->pre_data = json_encode($pre_data);
                        $form_logs->user_allotment_log = json_encode($animal);
                        $form_logs->save();

$response["status"] = 1;
                        if(isset($request->strAnimalTagStatus) && $request->strAnimalTagStatus == 0){
                        $response["message"] =
                            "Animal Deactivated Successfully";
                        }else{
                        $response["message"] =
                            "Animal Detail Updated Successfully";
                        }
                        $response["data"] = $animal;

\DB::commit();
                    } catch (\Exception $exp) {
                        \DB::rollBack();

$response["status"] = 0;
                        $response["message"] = $exp->getMessage();
                    }
                } else {
                    $response["status"] = 0;
                    $response["message"] = "Animal Detail Not Found!";
                }
            } else {
                $response["status"] = 0;
                $response["message"] = " Session Expired";
                $response["is_token_expired"] = 1;
            }
        }
        return response()->json($response);
    }

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

$validator = \Validator::make($request->all(), [
        "api_token" => "required",
    ]);
    if ($validator->fails()) {
        $response["status"] = 0;
        $response["message"] = $this->parseErrorResponse(
            $validator->getMessageBag()
        );
    } else {
        if ($this->checkApiAuth($request)) {
            if(!$request->strAadharNo && $request->api_token){
            try {
                \DB::beginTransaction();

$user = \App\User::where("api_token", $request->api_token)->where("is_active", 1)->first();

$mergedAnimals = \App\AnimalDetail::where("created_by", $user->id)->where("is_active", 1)->get();

// Group animals by 'member_aadhar'
                $groupedAnimals = $mergedAnimals->groupBy('member_aadhar');

$data = [];
                foreach ($groupedAnimals as $aadhar => $animals) {
                    $status = 'Pending'; // Default status
                    $created_at = $animals->first()->created_at; 
                    $submittedAnimal = $animals->whereNotNull('virtual_tag_number')->first();
                    if ($submittedAnimal) {
                        $status = 'Submitted';
                    }
                    $data[] = [
                        'member_aadhar' => $aadhar,
                        'status' => $status,
                        'created_at' => $created_at->format('d/m/Y'),
                    ];
                }
                 $response["status"] = 1;
                 $response["data"] = $data;

\DB::commit();
            } catch (\Exception $exp) {
                \DB::rollBack();
                $response["status"] = 0;
                $response["message"] = $exp->getMessage();
            }
        }
        if($request->api_token && $request->strAadharNo){
           try {
                \DB::beginTransaction();

$user = \App\User::where("api_token", $request->api_token)
                    ->where("is_active", 1)
                    ->first();
                $getAllDataByAadhar = \App\AnimalDetail::where(
                    "member_aadhar",
                    $request->strAadharNo
                )
                    ->where("created_by", $user->id)
                    ->where("is_active", 1)
                    ->get();
                
                $response["status"] = 1;
                $response["data"] = $getAllDataByAadhar;

\DB::commit();
            } catch (\Exception $exp) {
                \DB::rollBack();
                $response["status"] = 0;
                $response["message"] = $exp->getMessage();
            } 
        }
        } else {
            $response["status"] = 0;
            $response["message"] = "Session Expired";
            $response["is_token_expired"] = 1;
        }
    }
    return response()->json($response);
}

public function CheckPendingAnimal($data)

{

if ($data->api_token) {

$user = \App\User::where("api_token", $data->api_token)->first();

$animal = \App\AnimalDetail::where("created_by", $user->id)

->whereNull("animal_tag_no")

->where("is_active", 1)

->get();

if (is_null($animal)) {

return true;

} else {

return false;

}

} else {

return false;

}

public function searchMemberByCode(Request $request)
    {
        $response = [];
        $validator = \Validator::make($request->all(), [
            "api_token" => "required",
            "strUniqueNo" => "required",
        ]);

if ($validator->fails()) {
            $response["flag"] = false;
            $response["errors"] = $this->parseErrorResponse(
                $validator->getMessageBag()
            );
        } else {
            if ($this->checkApiAuth($request)) {

// Extract the mpp_code (first 6 digits) and member_code (last 4 digits) from strUniqueNo
                $mpp_code = substr($request->strUniqueNo, 0, -4);
                $member_code_last_four = substr($request->strUniqueNo, -4);

// Search in the membership_details table first
                $getstate1 = \DB::table("membership_details")
                    ->where("mpp_code", $mpp_code)
                    ->whereRaw('RIGHT(member_code, 4) = ?', [$member_code_last_four])
                    ->where("is_active", 1)
                    ->first();

// If not found in membership_details, search in legacy_data
                $getstate2 = null;
                if (empty($getstate1)) {
                    $getstate2 = \DB::table("legacy_data")
                        ->where("mpp_code", $mpp_code)
                        ->whereRaw('RIGHT(member_code, 4) = ?', [$member_code_last_four])
                        ->where("is_active", 1)
                        ->first();
                }

// Return response based on where the data was found
                if (!empty($getstate1)) {
                    $response["status"] = 1;
                    $response["data"] = $getstate1;
                    $response["message"] = "Membership Details";
                } elseif (!empty($getstate2)) {
                    // Map aadhar_no as aadhar_card
                    $getstate2->aadhar_card = $getstate2->aadhar_no;
                    unset($getstate2->aadhar_no); // Optionally remove aadhar_no from the response
                    $response["status"] = 1;
                    $response["data"] = $getstate2;
                    $response["message"] = "Legacy Data";
                } else {
                    $response["status"] = 0;
                    $response["message"] = "No Data Found!";
                }

} else {
                $response["status"] = 0;
                $response["message"] = "Session Expired";
                $response["is_token_expired"] = 1;
            }
        }

return response()->json($response);
    }
    
     public function sendMemberDetailOtpMail(Request $request){

$response = array();

$validator = \Validator::make(

$request->all(),

array(

'api_token' => 'required',

'email' => 'required',

'name' => 'required',

)

);

if ($validator->fails()) {

$response['flag'] = false;

$response['errors'] = $this->parseErrorResponse($validator->getMessageBag());

} else {

if ($this->checkApiAuth($request)) {

//$emailAlready = \App\MembershipDetail::where('email', $request->email)->where('is_active',1)->first();

$resendemail = \App\OtpEmail::where('email',$request->email)->where('is_active', 1)->first();

if($resendemail){

$resendemail->is_active = '0';

$resendemail->save();

}
                    $otp ='123456';
                    //  $otp = rand(100000, 999999);

//         $data["code"] = $otp;

//         $data["name"] = $request->name;

//         $data["title"] = "OTP for Email ID Verification in Paayas Milk Producer Company Limited";

//         $from_mail = "marathvarhadmembership@gmail.com";

// 	    $from_title = 'Marathvarhad Milk Producer Company Limited';

//         $to_emails = $request->email;

// 	    $mail = \Mail::send('email.email', $data, function ($m) use ($from_mail,$from_title,$to_emails){

//             $m->from($from_mail,$from_title);

//             $m->to($to_emails);

//             $m->subject('OTP for Email ID Verification in Marathvarhad Milk Producer Company Limited');

//         });

$data['otp'] = $otp;

$data['email'] = $request->email;

$member = new \App\OtpEmail;

$member->email = $request->email;

$member->otp = $otp;

if($member->save()){

$response['status'] = 1;

$response['mvc'] = $otp;

}else{

$response['status'] = 0;

$response['message'] = "Email Not Found";

}

} else {

$response['status'] = 0;

$response['message'] = " Session Expired";

$response['is_token_expired'] = 1;

}

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

}

public function verifyMemberDetailOtpMail(Request $request){

$response = array();

$validator = \Validator::make(

$request->all(),

array(

// 'api_token' => 'required',

'otp' => 'required',

'email' => 'required',

)

);

if ($validator->fails()) {

$response['flag'] = false;

$response['errors'] = $this->parseErrorResponse($validator->getMessageBag());

} else {

if ($this->checkApiAuth($request)) {

$member = \App\OtpEmail::where('email', $request->email)->where('otp', $request->otp)->where('is_active', 1)->first();

if($member){

$response['status'] = 1;

$response['message'] = "Otp Verified Successfully." ;

}else{

$response['status'] = 0;

$response['message'] = "Wrong OTP! Please Enter Correct OTP.";

}

} else {

$response['status'] = 0;

$response['message'] = " Session Expired";

$response['is_token_expired'] = 1;

}

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

}
    
     public function sendMemberDetailSMS(Request $request)
    {
        
        $response = array();
        $validator = \Validator::make(
            $request->all(),
            array(
                'api_token' => 'required',
                'mobile_no' => 'required',
            )
        );
        if ($validator->fails()) {
            $response['flag'] = false;
            $response['errors'] = $this->parseErrorResponse($validator->getMessageBag());
        } else {
            
                    if($this->checkApiAuth($request)) {
                        $mobile_array = explode(',', '917275894336,919315409352,919450214592,917800966472,917081959351,917081971252,919648949562,919648953381,918574026581,919170539197,917268058186,919305615906,919559992532,918810959182,917706864230,918470804738,919648844859,919235175306,919026130107,918052060233,918303492020,91953847402,919129658633,919794789220,919305387785,916390181695,919935287314,919554861772,919721414341,919839018028,919872688139,918173962712,919696408278,919648690634,919454503810,919628593077,919569514297,918808264195,919339691716,919651508240,918756514255,917880754376,916394505594,919335175886,918808508441,919335785778,918707445689,918736991783,919792796116,916386753999,918187991315,918881108801,918858997181,919679056053,918957780737,919936522478,918528780537,917307452511,917800934339,919151471245,918278648092,917571875580,917388864573,918874275396,919628668761,919695001817,916393862978,919682072845,919565859563,918853523919,917521891019,919628848627,918931078729,919260955957,916392670964,919450621045,919415931201,919125160164,919335165058,918417813607,919695878079,917235085523,917525892442,919453228523,919621745028,919935676524,916392347895,919760811231,919653010369,918467946442,919812667539,919506059172,919554247260,919648296691,919721767955,919670394452,917408626264,918795637063,919559951747,919369289581,919769519037,917388689302,918840525920,918299571001,918960467047,918874408019,919696761176,917388164497,918447340241,918874918633,917754962573,919724218714,917007453579,917238958563,917607957113,919835015304,919519271916,91955593826,917379298653,918318065133,917897801407,916393441352,919721776157,918429932760,918081043240,917398312060,917054900564,916394246986,919798412877,919918635284,918887901810,919151110917,916393441352,916388685922,917457921854,918869934996,917408305557,918810495948,918303761028,918052057124,918858498311,919935564122,919118522090,916392294947,918545027287,919793279073,918004510915,918005075776,918423566978,919580037568,919452084026,919721718515,919695837596,918739874417,919321567327,918960575329,919456509028,918382097800,919598511805,919005514171,918200604520,918853672591,917458858838,919452829358,919628722031,917800413342,918175004351,916393967026,919058645824,916306269255,917307278165,919005654514,917275439500,919721770124,919598980993,918171515134,916387781522,917275903795,919554065807,919370188158,917408874213,919369839802,919454265907,919198259124,918127670629,919648205346,917518574550,917388217885,919621536484,918302005622,917268087094,917380522408,917275908193,919580900662,917269056452,918171917835,917339503426,919918133543,918423141390,917058831517,917753004182,917398153673,916394850233,919811537985,919554195384,917392071368,918009288120,917565934137,918127271042,919559513288,919517518007,918081961674,919621970076,917016396091,917888577357,919935683644,919956057581,919120941634,917617071712,919794971434,919857723699,918187920036,918303762625,918874556000,918601069460,918528800726,916388968685,919793117198,918429478706,917307288584,917521045470,917715937156,918090568774,917388164497,917318018375,917052805503,919518875487,919935729539,917800498832,917754837689,919919463813,919651854646,919535801000,918866992276,919670269520,919598814971,919170532498,919651946070,919930689331,919936836708,917267874086,919118703893,916392696844,919670726974,919453579526,919621818698,919454626922,918400127224,918400603225,919860279524,919820202018,919879590291,919852824885,919670100181,919565508843,91957002785,919558689784,917897754084,919519240203,91930939986,919161148807,916386115496,919961646909,918948732745,919125389283,919076537960,918009288120,919851173157,919945557809,919875600649,917379551746,919794378571,919919487725,918009288120,917567070920,917991769506,917897967937,919565714586,918009337827,916306612840,919935307564,919565403217,918933910356,919026643588,919517441630,919721165715,919721043539,917084543659,918081817778,917897202390,919860193862,919565342653,917887007260,917379703376,918726894813,917068886082,919450210088,918737075894,918874335910,919598695056,918433313101,917068886082,919415353839,916306242661,919740873438,919506002455,919005195542,919024960507,918090142384,919118620865,917388358400,918957340435,916391800821,918467903225,918542030101,918009523580,917380641032,9196498380477,919450767392,917754947277,919415909284,9195554982428,919169497272,919554197318,91919225313');
                        if(in_array($request->mobile_no, $mobile_array)){
                          $response['status'] = 1;
                          $response['mvc'] = '1234';
                          $response['token'] = '';
                          $response['message'] = "otp sent successfully";
                        }else{
                             $mvc = "123456";
                        
        //                 $mvc = mt_rand(100000,999999);
        //                 $curl = curl_init();
        //  //CURLOPT_URL => "http://smsfortius.in/api/mt/SendSMS?user=kmmpclotp&password=kmmpclotp&senderid=KMMPCL&channel=Trans&DCS=0&flashsms=0&number=".$request->mobile_no."&text=".$mvc."%20OTP%20for%20Member%20registration%20in%20Kaushikee%20MMPCL,%20Bihar.&route=02&DLTTemplateId=1707171403877489254",
                       
        //                 curl_setopt_array($curl, array(
        //                     CURLOPT_URL => "http://164.52.195.161/API/SendMsg.aspx?uname=20240265&pass=99TVNCTq&send=KMMPCL&dest=".$request->mobile_no."&msg=".$mvc."%20%20OTP%20for%20Member%20registration%20in%20Kaushikee%20MMPCL,%20Bihar.",
        //                     CURLOPT_RETURNTRANSFER => true,
        //                     CURLOPT_ENCODING => "",
        //                     CURLOPT_TIMEOUT => 30000,
        //                     CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
        //                     CURLOPT_CUSTOMREQUEST => "GET",
        //                     CURLOPT_HTTPHEADER => array(
        //                         // Set Here Your Requesred Headers
        //                         'Content-Type: application/json',
        //                     ),
        //                 ));
        //                 $sms_response = curl_exec($curl);
        //                 $err = curl_error($curl);
        //                 // dd($err);
        //                 curl_close($curl);
                        // if($err) {
                        //     $response['status'] = 0;
                        //     $response['message'] = "could not send otp";
                        //     return response()->json($response);
                        // }else {
                           
                        
                            $user = \App\User::where('api_token', $request->api_token)->first();
        
                            $store_otp = new \App\OtpVerify();
                        
                            $store_otp->user_id = $user->id;
                            $store_otp->mvc = $mvc;
                            // $store_otp->message = $mesid;
                            $store_otp->mobile_no = $request->mobile_no;
                            $store_otp->token = Str::random(50);
                            $store_otp->is_active = 1;
                            if($store_otp->save()){
                                $response['status'] = 1;
                                $response['mvc'] = $mvc;
                                $response['token'] = $store_otp->token;
                                $response['message'] = "otp sent successfully";
                            }else{
                                $response['status'] = 0;
                                $response['message'] = "something went wrong";
                            }
                            
                          }
                        
                    }else{
                        $response['status'] = 0;
                        $response['message'] = " Session Expired";
                        $response['is_token_expired'] = 1;
                    }
                    
        
            
        }
        return response()->json($response);
    }
    public function verifyMemberDetailSMS(Request $request){
        $response = array();
        $validator = \Validator::make(
            $request->all(),
            array(
                'api_token' => 'required',
                'mvc' => 'required',
                // 'verify_token' => 'required',
            )
        );
        if ($validator->fails()) {
            $response['flag'] = false;
            $response['errors'] = $this->parseErrorResponse($validator->getMessageBag());
        } else {
        
            
                        if($this->checkApiAuth($request)) {
            
                            // $otp_verify = \App\OtpVerify::where('mvc',$request->mvc)->where('token',$request->verify_token)->where('is_active',1)->first();
                            $otp_verify = \App\OtpVerify::where('mvc',$request->mvc)->where('is_active',1)->first();
                    
                            if(!is_null($otp_verify)){
                                $otp_verify->is_active = 2 ;
                                if($otp_verify->save()){
                                    $response['status'] = 1;
                                    $response['message'] = "otp verified successfully";
                                }else{
                                    $response['status'] = 0;
                                    $response['message'] = "something went wrong";
                                }
                                
                            }else{
                                $response['status'] = 0;
                                $response['message'] = "invalid or expired otp";
                            }
                           
                        }else{
                            $response['status'] = 0;
                            $response['message'] = " Session Expired";
                            $response['is_token_expired'] = 1;
                        }
         
        }
        return response()->json($response);
    }
}