";
    // print_r($request);
    // exit;
        $return_data=[];
     //   return $request;
        // $request->validate([
        //     'g-recaptcha-response' => function($attribute,$value,$fail){
        //         $secret_key = env('GOOGLE_RECAPTCHA_SECRET');
        //         $response = $value;
        //         $userIP = $_SERVER['REMOTE_ADDR'];
        //         $url = "https://www.google.com/recaptcha/api/siteverify?secret=$secret_key&response=$response&remoteIp=$userIP";
        //         $response = \file_get_contents($url);
        //         $response = json_decode($response);
        //         if(!$response->success){
        //             Session::flash('g-recaptcha-response','Please Check reCaptcha ');
        //             Session::flash('alert-class','alert-danger');
        //             $fail($attribute.' google reCaptcha failed');
        //         }
        //     }
        // ]);

        //$request->validate(['startup_launch_title'=>'required','startup_launch_date_range'=>'required','startup_category'=>'required','banners'=>'required','banners.*'=>'image']); 

        $request->validate(['pitch_deck_file'=>'required | mimes:jpg,png,jpeg,pptx,ppt,pdf,docx,doc','name'=>'required','email'=>'required|email','contact_no'=>'required |digits:10 ','founder_profile'=>'required | url','company_name'=>'required','company_website'=>'required | url','legal_entity'=>'required','year_incorporation'=>'required','sub_sector'=>'required','company_location'=>'required','revenue'=>'required','session_master_id'=>'required','startup_status'=>'required','message'=>'required','expectations'=>'required','is_thrive'=>'required','startup_type_tran_id'=>'required']); 

        if($request->legal_entity=="Other")
        {
            $request->validate(['legal_entity_other'=>'required']); 
        }

        if($request->referral=="Other")
        {
            $request->validate(['referral_other'=>'required']); 
        }
        if($request->is_thrive=='Y')
        {
            $request->validate(['startup_belong_to'=>'required']); 
        }
        try{
            $input = $request->all();
            $image_name = null;
            $image_name_1 = null;
            if ($request->hasFile('pitch_deck_file'))
            {
              $image = $input['pitch_deck_file'];
              $image_name = uniqid().rand(1234567890, 6).'.'.$image->getClientOriginalExtension();
              $fileObj = $request->file('pitch_deck_file');
              $fileObj->move(public_path($this->supplychain_img_path).'/', $image_name);
            }
            if ($request->hasFile('page_pitch_file'))
            {
              $image1 = $input['page_pitch_file'];
              $image_name_1 = uniqid().rand(1234567890, 6).'.'.$image1->getClientOriginalExtension();
              $fileObj = $request->file('page_pitch_file');
              $fileObj->move(public_path($this->supplychain_img_path).'/', $image_name_1);
            }
            $StartUpObj = new StartUps();
            $StartUpObj->field['name'] = $input['name'];
            $StartUpObj->field['email'] = $input['email'];
            $StartUpObj->field['contact_no'] = $input['contact_no'];
            $StartUpObj->field['founder_profile'] = $input['founder_profile'];
            $StartUpObj->field['company_name'] = $input['company_name'];
            $StartUpObj->field['company_website'] = $input['company_website'];
            $StartUpObj->field['legal_entity'] = @$input['legal_entity']=="Other" ? @$input['legal_entity_other'] : @$input['legal_entity'];
            $StartUpObj->field['year_of_incorporation'] = $input['year_incorporation'];
            if($input['is_thrive']=='Y')
                $StartUpObj->field['startup_belong_to'] = $input['startup_belong_to'];
            else
                $StartUpObj->field['startup_belong_to']='0';
            
            $StartUpObj->field['sub_sector'] = $input['sub_sector'];
            $StartUpObj->field['city_call_home'] = $input['company_location'];
            $StartUpObj->field['revenue'] = $input['revenue'];
            $StartUpObj->field['revenue_master_id'] = $input['revenue'];
            $StartUpObj->field['session_master_id'] = $input['session_master_id'];
            $StartUpObj->field['startup_status'] = $input['startup_status'];
            $StartUpObj->field['message'] = $input['message'];
            $StartUpObj->field['expectations'] = $input['expectations'];
            $StartUpObj->field['pitch_deck_file'] = $image_name;
            $StartUpObj->field['page_pitch_file'] = $image_name_1;
            $StartUpObj->field['is_thrive']=$input['is_thrive'];            

            if($input['is_thrive']=='N')
            $StartUpObj->field['startup_type_tran_id'] = $input['startup_type_tran_id'];
            else
            $StartUpObj->field['startup_type_tran_id'] = $input['startup_belong_to'];

            $StartUpObj->field['referral'] = @$input['referral']=="Other" ? @$input['referral_other'] : @$input['referral'];

            $return_data = $StartUpObj->saveStartupData();

            $type_trans_array = TypeTrans::pluck('id', 'name');
            //startup id insert into CategoryMapping start
            $category_mapping=new CategoryMapping;
            $category_mapping->startups_id=$return_data['id'];
            $category_mapping->startup_type_tran_id=$return_data['startup_type_tran_id'];
            $category_mapping->category_mapping_trans_id=$return_data['startup_type_tran_id'];
            $category_mapping->save();
            //startup id insert into CategoryMapping end

            //startup id insert into StartupSubStatusTrans start
            $startup_sub_status_trans=new StartupSubStatusTrans;
            $startup_sub_status_trans->startup_id=$return_data['id'];
            $startup_sub_status_trans->startup_status=$return_data['startup_status'];
            $startup_sub_status_trans->type_trans_id=$type_trans_array['Active'];
            $startup_sub_status_trans->user_id=1;
            $startup_sub_status_trans->save();
            //startup id insert into StartupSubStatusTrans end
             

            $return_arr['status'] = false;
            $return_arr['message'] = "Unable to send email, try again later.";
            $return_arr['status'] = true;
            $return_arr['message'] = 'Your query has been sent successfully. One of our executive will contact you soon.';

            if(@$input['name'] && $input['contact_no'] && $input['email']){
                $email = $input['email'];
                Mail::send('email.suppychaintech', [
                    'name' => $request->get('name'),
                    'email' => $request->get('email'),
                    'contact_no' => $request->get('contact_no'),
                    'founder_profile' => $request->get('founder_profile'),
                    'company_name' => $request->get('company_name'),
                    'company_website' => $request->get('company_website'),
                    'legal_entity' => $request->get('legal_entity'),
                    'year_incorporation' => $request->get('year_incorporation'),
                    'startup_belong_to' => $request->get('startup_belong_to'),
                    'sub_sector' => $request->get('sub_sector'),
                    'city_call_home' =>$request->get('company_location'),
                    'company_location' => $request->get('company_location'),
                    'revenue' => $request->get('revenue'),
                    'message_1' => $request->get('message')],
                    function ($message) {
                        $message->from(env('MAIL_USERNAME'));
                        $message->to([env('MAIL_TO'),'sushil@marwaricatalysts.com','thrive@marwaricatalysts.com'], ['APP_NAME','Sushil Sharma','thrive marwari catalysts'])
                        ->subject('Enquiry: new application received for thrive on website');
                });

                if(!empty($email)){
                    //old welcome mail start
                    /*
                    Mail::send('email.suppychaintech_user',[] ,
                        function ($message) use($email) {
                            $message->from(env('MAIL_USERNAME'));
                            $message->to($email, 'APP_NAME')
                            ->subject('Congratulations! We have received your Startup Application | Marwari Catalysts ');
                    });
                    */
                    //old welcome mail end


                    //new welcome mail start
                    $startup_id=$request->startup_id;
                    $type_trans_array = TypeTrans::pluck('name', 'id');       
                    $mail_configuration=MailConfiguration::where('id',6)->first();
                    $replaceble_tags=array('{startup_name}','{cohort_name}','{user_name}');
                    $replaceble_tags_with_value['{startup_name}']=$input['company_name'];
                    $replaceble_tags_with_value['{user_name}']=$input['name'];
                    if($input['is_thrive']=='N')
                    {
                        $replaceble_tags_with_value['{cohort_name}']=$type_trans_array[$input['startup_type_tran_id']];
                    }
                    else
                    {
                        $replaceble_tags_with_value['{cohort_name}']=$type_trans_array[$input['startup_belong_to']];
                    }
                    
                    foreach($replaceble_tags as $_replaceble_tags)
                    {
                        $mail_configuration['content']=str_replace($_replaceble_tags,$replaceble_tags_with_value[$_replaceble_tags],$mail_configuration['content']);
                        $mail_configuration['subject']=str_replace($_replaceble_tags,$replaceble_tags_with_value[$_replaceble_tags],$mail_configuration['subject']);
                    }
                    $mail_configuration_content=$mail_configuration['content'];
                    $mail_configuration_subject=$mail_configuration['subject'];
                    $to_email = $input['email'];
                    //return view('email.shortlist',['mail_configuration_content'=> $mail_configuration_content]);
                    Mail::send('email.congratulation', [
                        'mail_configuration_content'=>$mail_configuration_content,
                    ],
                    function ($message) use($to_email,$mail_configuration_subject) {
                        $message->from(env('MAIL_USERNAME'));
                        $message->to($to_email, 'APP_NAME')
                        ->subject($mail_configuration_subject);
                    });
                    //new welcome mail end
                }
            }else{
                $return_arr['status'] = false;
                $return_arr['message'] = 'Please porvide all mendatory fields';
            }
        } catch(\Exception $e){
            $e->getMessage();
        }
        return response()->json($return_data, 200);
    }

    public function masterform(Request $request)
    {
       // return $request;
        //is master form already filled start
        $startup_id=$request->startup_id;
        $startups_obj=Startups::find($startup_id);
        $master_form_saved = $startups_obj->master_form_saved;
        $master_form_saved_level=$startups_obj->master_form_saved_level;
       // dd($master_form_saved,!Auth::guard('admin')->check());
        if($master_form_saved == 'Y' && !Auth::guard('admin')->check())
        {
            $redirect_url = tokenize_url(route('web.masterFormAlreadySubmitted'),['startup_id' => $startup_id]);
            return redirect($redirect_url);
        }
        //is master form already filled end
        $startup_id = $request['startup_id'];

        $current_step = $request['current_step'];
        $page_title = 'Master Form for Cleantech with Marwari Catalysts';
        $page_description = 'Master Form for Cleantech with Marwari Catalysts';
        if(@$startup_id){
            $general_questions = [];
            $business_questions = [];
            $startup_detail = [];
            $general_questions_answer = [];
            $return_startup = StartUps::getStartupDetail($startup_id);
            if($return_startup['status']){
                $startup_detail = $return_startup['data'];
            }
            $return_general_questions_answer = StartupGeneralQuestionAnswer::getAllAnswers(['startup_id'=>$startup_detail->id]);

            if($return_general_questions_answer['status']){
               $QuestionsAnswerArr =  $return_general_questions_answer['data'];
               foreach($QuestionsAnswerArr as $SubQuestionsAnswerArr){
                $general_questions_answer[$SubQuestionsAnswerArr->question_id] = $SubQuestionsAnswerArr->answer;
               }
            }
            $return_general_questions = StartUpGeneralQuestion::getAllQuestions(['question_cat' => 'G']);

            //MT Start
            //current step1 start
            $indian_cities=DB::table('countries')->join('states','countries.id','=','states.country_id')->join('cities','cities.state_id','=','states.id')->select('cities.id','cities.name as city_name','states.name as city_state')->where('countries.id','101')->get();
            $view_data['indian_cities']= $indian_cities;
            //current step1 end
            $current_step=@$current_step ?? 1;
            if($current_step==1)
            {
                $return_CINFO_questions = StartUpGeneralQuestion::getAllQuestions(['question_cat' => 'CINFO']);
                if($return_CINFO_questions['status']){
                    $CINFO_questions = $return_CINFO_questions['data']['records'];
                }
                $CINFO_questions_answer=StartupGeneralQuestionAnswer::where('startup_id',$startup_id)
                    ->get()->keyBy('question_id');
                $view_data['Dynamic_questions_answer']=$CINFO_questions_answer;
                $view_data['Dynamic_questions']=$CINFO_questions;
            }
            else if($current_step==4)
            {
                $return_PTF_questions = StartUpGeneralQuestion::getAllQuestions(['question_cat' => 'PTF']);
                if($return_PTF_questions['status']){
                    $PTF_questions = $return_PTF_questions['data']['records'];
                    $PTF_questions_option=StartupQuestionOption::where('removed','N')->orderBy('sort_order','ASC')->get();
                }
                $PTF_questions_answer=StartupGeneralQuestionAnswer::where('startup_id',$startup_id)
                    ->get()->keyBy('question_id')->toArray();
                $PTF_questions_option_answer=StartupQuestionOptionAnswer::where('startup_id',$startup_id)
                    ->get()->keyBy('question_option_id')->toArray();
                $view_data['Dynamic_answers']=$PTF_questions_answer;
                $view_data['Dynamic_option_answers']=$PTF_questions_option_answer;
                $view_data['Dynamic_questions']=$PTF_questions;
                $view_data['Dynamic_questions_option']=$PTF_questions_option;
            }
            else if($current_step==5)
            {
                $return_FIR_questions = StartUpGeneralQuestion::getAllQuestions(['question_cat' => 'FIR']);
                if($return_FIR_questions['status']){
                    $FIR_questions = $return_FIR_questions['data']['records'];
                    $FIR_questions_option=StartupQuestionOption::where('removed','N')->orderBy('sort_order','ASC')->get();
                }
                $FIR_questions_answer=StartupGeneralQuestionAnswer::where('startup_id',$startup_id)
                    ->get()->keyBy('question_id')->toArray();
                $FIR_questions_option_answer=StartupQuestionOptionAnswer::where('startup_id',$startup_id)
                    ->get()->keyBy('question_option_id')->toArray();
                $view_data['Dynamic_answers']=$FIR_questions_answer;
                $view_data['Dynamic_option_answers']=$FIR_questions_option_answer;
                $view_data['Dynamic_questions']=$FIR_questions;
                $view_data['Dynamic_questions_option']=$FIR_questions_option;
            }
            else if($current_step==6)
            {
                $return_IDE_questions = StartUpGeneralQuestion::getAllQuestions(['question_cat' => 'IDE']);
                if($return_IDE_questions['status']){
                    $IDE_questions = $return_IDE_questions['data']['records'];
                    $IDE_questions_option=StartupQuestionOption::where('removed','N')->orderBy('sort_order','ASC')->get();
                }
                $IDE_questions_answer=StartupGeneralQuestionAnswer::where('startup_id',$startup_id)
                    ->get()->keyBy('question_id')->toArray();
                $IDE_questions_option_answer=StartupQuestionOptionAnswer::where('startup_id',$startup_id)
                    ->get()->keyBy('question_option_id')->toArray();
                // return $IDE_questions_option_answer;
                $view_data['Dynamic_answers']=$IDE_questions_answer;
                $view_data['Dynamic_option_answers']=$IDE_questions_option_answer;
                $view_data['Dynamic_questions']=$IDE_questions;
                $view_data['Dynamic_questions_option']=$IDE_questions_option;
            }
            //MT end

            
            if($return_general_questions['status']){
                $general_questions = $return_general_questions['data']['records'];
            }

            $designation_arr = [];
            $return_typetrans = TypeTrans::getAllTypeTrans(['type_master_id'=>2]);
            if($return_typetrans['status']){
                foreach($return_typetrans['data']['records'] as $subArr){
                    $designation_arr[$subArr->id] = $subArr->name;
                }
            }

            $return_busniess_questions = StartUpGeneralQuestion::getAllQuestions(['question_cat' => 'B']);
            if($return_busniess_questions['status']){
                $business_questions = $return_busniess_questions['data']['records'];
            }

            $team_detail = [];

            if($current_step==2){
                $return_team = StartUpTeamDetails::getAllTeamMemberDetails(['startup_id' => $startup_id]);
                if($return_team['status']){
                    $team_detail = $return_team['data']['records'];
                }
            }
            $page_keywords = $page_title;
            $view_data['page_title'] =  $page_title;
            $view_data['page_keywords'] =  $page_keywords;
            $view_data['page_description'] =  $page_description;
            $view_data['team_details']              =  $team_detail;
            $view_data['general_questions']         =  $general_questions;
            $view_data['business_questions']        =  $business_questions;
            $view_data['startup_detail']            =  $startup_detail;
            $view_data['designation_arr']           =  $designation_arr;
            $view_data['general_questions_answer']  =  $general_questions_answer;
            $view_data['current_step']  =  @$current_step ?? 1;
            $view_data['startup_id']    =  @$startup_id ?? 1;
            $view_data['type_trans_array']=TypeTrans::where('type_master_id',1)->select('id','name')->get()->pluck('name','id');
            $category_title_obj=$view_data['category_title']=Startups::select('type_trans.name as category_title')->join('type_trans','type_trans.id','=','startups.startup_type_tran_id')->where('startups.id',$startup_id)->first();

            if($category_title_obj)
            {
                $view_data['category_title']=$category_title_obj->category_title;                
            }
            else
            {
                $view_data['category_title']="";                
            }
            
            return view('pages.masterform',$view_data);
        }else{
            return view('pages.error');
        }
    }

    public function masterformNew()
    {
        $page_title = 'Master Form for Cleantech with Marwari Catalysts';
        $page_description = 'Master Form for Cleantech with Marwari Catalysts';

        $general_questions = [];
        $business_questions = [];

        $return_general_questions = StartUpGeneralQuestion::getAllQuestions(['question_cat' => 'G']);

        if($return_general_questions['status']){
            $general_questions = $return_general_questions['data']['records'];
        }

        $return_busniess_questions = StartUpGeneralQuestion::getAllQuestions(['question_cat' => 'B']);

        if($return_busniess_questions['status']){
            $business_questions = $return_busniess_questions['data']['records'];
        }
        

        $page_keywords = $page_title;
        $view_data['page_title'] =  $page_title;
        $view_data['page_keywords'] =  $page_keywords;
        $view_data['page_description'] =  $page_description;


        $view_data['general_questions'] =  $general_questions;
        $view_data['business_questions'] =  $business_questions;
        return view('pages.masterformNew',$view_data);
    }

    public function saveMasterForm(Request $request){
        $input = $request->all();
        $current_step = $request['current_step'];
        $startup_id   = $request['startup_id'];
        $StartupsObj = new Startups();
        if($current_step==1){
            $request->validate(['company_logo'=>'file|max:2048']); 
            if($request->hasFile('company_logo'))
            {
                $company_logo = $request->file('company_logo');
                $company_logo_name = uniqid().rand(1234567890, 6).'.'.$company_logo->getClientOriginalExtension();
                $company_logo->move(public_path($this->company_logo).'/', $company_logo_name);
                $StartupsObj->field['company_logo'] = $company_logo_name;
            }
            $StartupsObj->field['name'] = $input['name'];
            $StartupsObj->field['email'] = $input['email'];
            $StartupsObj->field['contact_no'] = $input['contact_no'];
            $StartupsObj->field['company_name'] = $input['company_name'];
            $StartupsObj->field['legal_entity'] = $input['type_of_organization'];
            $StartupsObj->field['year_of_incorporation'] =$input['year_of_incorporation'];
            $StartupsObj->field['company_address'] = $input['company_address'];
            $StartupsObj->field['no_of_founders'] = $input['no_of_founders'];
            $StartupsObj->field['city_call_home'] = $input['company_location'];
            $StartupsObj->field['sub_sector'] = $input['sub_sector'];
            $StartupsObj->field['master_form_partial_saved'] = 'Y';
            $StartupsObj->field['master_form_saved_level'] = 1;
            $return_data = $StartupsObj->updateStartup($startup_id);
            //dynamic question start
            $dynamic_question_SELECT=$request['dynamic_question_SELECT'];
            $dynamic_question_CHK=$request['dynamic_question_CHK'];
            if($dynamic_question_SELECT)
            {
                foreach($dynamic_question_SELECT as $_dynamic_q_info)
                {
                    $_dynamic_q_info_arr=explode("_",$_dynamic_q_info);
                    $qid=$_dynamic_q_info_arr[1];
                    $input_value=$input[$_dynamic_q_info];
                    // $startup_gen_q_ans=new StartupGeneralQuestionAnswer;
                    // $startup_gen_q_ans->startup_id=$startup_id;
                    // $startup_gen_q_ans->question_id=$qid;
                    // $startup_gen_q_ans->answer=$input_value;
                    // $isSucess=$startup_gen_q_ans->save();
                    //
                    $StartupAnswer = new StartupGeneralQuestionAnswer();
                    $StartupAnswer->field['question_id'] = $qid;
                    $StartupAnswer->field['answer'] = $input_value;
                    $StartupAnswer->field['startup_id'] = $startup_id;
                    $StartupAnswer->updateOrSaveAnswer(['startup_id' => $startup_id, 'question_id' =>$qid]);
                    //
                }
            }
            if($dynamic_question_CHK)
            {
                foreach($dynamic_question_CHK as $_dynamic_q_info)
                {
                    $_dynamic_q_info_arr=explode("_",$_dynamic_q_info);
                    $qid=$_dynamic_q_info_arr[1];
                    $input_value=$input[$_dynamic_q_info];
                    $StartupAnswer = new StartupGeneralQuestionAnswer();
                    $StartupAnswer->field['question_id'] = $qid;
                    $StartupAnswer->field['answer'] = implode(",",$input_value);
                    $StartupAnswer->field['startup_id'] = $startup_id;
                    $StartupAnswer->updateOrSaveAnswer(['startup_id' => $startup_id, 'question_id' =>$qid]);
                }
            }
            //dynamic question end
        }
        else if($current_step==2){
            //file size validate start
            $request->validate(['team_member_photo.*'=>'file|max:2048']); 
            //file size validate end

            //update startup level start
            $StartupsObj = new Startups();
            $StartupsObj->field['master_form_saved_level'] = 2;
            $StartupsObj->updateStartup($startup_id);
            //update startup level end
            StartUpTeamDetails::where('startup_id',$startup_id)->delete();
            $team_member_name_arr = $request['team_member_name'];
 
            if(count($team_member_name_arr)){
                foreach($team_member_name_arr as $key => $name){
                    $StartUpTeamDetails = new StartUpTeamDetails();

                    $StartUpTeamDetails->field['name'] = $name;
                    $StartUpTeamDetails->field['email'] = $request['team_member_email'][$key];
                    $StartUpTeamDetails->field['contact_no'] = $request['team_member_contact_no'][$key];
                    $StartUpTeamDetails->field['linked_in_profile'] = $request['team_member_linkedin_profile'][$key];
                    $StartUpTeamDetails->field['educational_qualification'] = $request['team_member_edu_qualification'][$key];
                    $StartUpTeamDetails->field['designation'] = @implode(",",@$request['team_member_type'][$key]);
                    $StartUpTeamDetails->field['field_of_exp'] = $request['team_member_field_of_exp'][$key];
                    $StartUpTeamDetails->field['age'] = $request['team_member_age'][$key];
                    $StartUpTeamDetails->field['work_as'] = $request['team_member_work_as'][$key];
                    $StartUpTeamDetails->field['startup_id'] = $startup_id;
                    $files_arr = $request->file();
                    if(count($files_arr)){
                        if(@$files_arr['team_member_photo'][$key] != null){   
                            $fileObj = $files_arr['team_member_photo'][$key];
                            $photo_name = uniqid().rand(1234567890, 6).'.'.$fileObj->getClientOriginalExtension();
                            $fileObj->move(public_path($this->core_team_member_photo).'/', $photo_name);
                            $StartUpTeamDetails->field['photo'] = $photo_name;
                        }
                        else{
                            $StartUpTeamDetails->field['photo'] = $request['photo_arr'][$key];
                        }
                    }else{
                        $StartUpTeamDetails->field['photo'] = $request['photo_arr'][$key];
                    }

                    //dd($StartUpTeamDetails->field);
                    $return_data = $StartUpTeamDetails->saveStartupTeamDetails();
                }
            }
        }
        else if($current_step==3){

            //file size validate start
            $request->validate(['core_team_member_photo'=>'file|max:2048']); 
            //file size validate end

            if($request->hasFile('core_team_member_photo'))
            {
                $core_team_member_photo = $request->file('core_team_member_photo');
                $core_team_member_photo_name = uniqid().rand(1234567890, 6).'.'.$core_team_member_photo->getClientOriginalExtension();
                $core_team_member_photo->move(public_path($this->core_team_member_photo).'/', $core_team_member_photo_name);
                $StartupsObj->field['core_team_member_photo'] = $core_team_member_photo_name;
            }

            //Core Info
            $StartupsObj->field['core_team_member_name'] = $input['core_team_member_name'];
            $StartupsObj->field['core_team_member_email'] = $input['core_team_member_email'];
            $StartupsObj->field['core_team_member_no'] = $input['core_team_member_no'];
            $StartupsObj->field['core_team_member_lprofile'] = $input['core_team_member_lprofile'];
            $StartupsObj->field['is_tech_team'] = $input['is_tech_team'];
            if($input['is_tech_team']=="Y")
            {
                $StartupsObj->field['product_development_process'] ="";
            }
            else if($input['is_tech_team']=="N")
            {
                $StartupsObj->field['product_development_process'] = $input['product_development_process'];
            }
            $StartupsObj->field['product_demo_url'] = $input['product_demo_url'];
            $StartupsObj->field['current_team_size'] = $input['current_team_size'];
            $StartupsObj->field['master_form_partial_saved'] = 'Y';
            $StartupsObj->field['master_form_saved_level'] = 3;

            $return_data = $StartupsObj->updateStartup($startup_id);
        }
        else if($current_step==4){
            $startup_id=$request->startup_id;
            $ptf_question_id=StartUpGeneralQuestion::select('id')->where('question_cat','PTF')->get()->pluck('id');
            StartupGeneralQuestionAnswer::where('startup_id',$startup_id)
                                         ->wherein('question_id',$ptf_question_id)
                                         ->delete(); 
            StartupQuestionOptionAnswer::where('startup_id',$startup_id)
                                         ->wherein('question_id',$ptf_question_id)
                                         ->delete();                          
            $allInputKeys=collect($request->all())->keys();
            foreach($allInputKeys as $input_key)
            {
                $input_info=(explode("_",$input_key));
                if(count($input_info)==2)
                {
                    $q_type=$input_info[0];
                    $q_id=$input_info[1];
                    if($q_type=="TEXT")
                    {
                        $input_value=$request[$input_key];
                        $startup_general_question_answer=new StartupGeneralQuestionAnswer();
                        $startup_general_question_answer->question_id=$q_id;
                        $startup_general_question_answer->answer=$input_value;
                        $startup_general_question_answer->startup_id=$startup_id;
                        $startup_general_question_answer->save();
                    }
                    else if($q_type=="TEXTAREA")
                    {
                        $input_value=$request[$input_key];
                        $startup_general_question_answer=new StartupGeneralQuestionAnswer();
                        $startup_general_question_answer->question_id=$q_id;
                        $startup_general_question_answer->answer=$input_value;
                        $startup_general_question_answer->startup_id=$startup_id;
                        $startup_general_question_answer->save();
                    }
                    else if($q_type=="RD")
                    {
                        $input_value=$request[$input_key];
                        $startup_general_question_answer=new StartupGeneralQuestionAnswer();
                        $startup_general_question_answer->question_id=$q_id;
                        $startup_general_question_answer->answer=$input_value;
                        $startup_general_question_answer->startup_id=$startup_id;
                        $startup_general_question_answer->save();
                    }
                    else if($q_type=="SELECT")
                    {
                        $input_value=$request[$input_key];
                        $startup_general_question_answer=new StartupGeneralQuestionAnswer();
                        $startup_general_question_answer->question_id=$q_id;
                        $startup_general_question_answer->answer=$input_value;
                        $startup_general_question_answer->startup_id=$startup_id;
                        $startup_general_question_answer->save();
                    }
                    else if($q_type=="CHK")
                    {
                        $input_value=$request[$input_key];
                        $startup_general_question_answer=new StartupGeneralQuestionAnswer();
                        $startup_general_question_answer->question_id=$q_id;
                        $startup_general_question_answer->answer=implode(",",$input_value);
                        $startup_general_question_answer->startup_id=$startup_id;
                        $startup_general_question_answer->save();
                    }
                    else if($q_type=="FILE")
                    {
                        //
                    }
                }
                else if(count($input_info)==3)
                {
                    $q_type=$input_info[0];
                    $q_id=$input_info[1];
                    $q_op_id=$input_info[2];
                    if($q_type=="TEXT")
                    {
                        $input_value=$request[$input_key];
                        $startup_question_option_answer=new StartupQuestionOptionAnswer();
                        $startup_question_option_answer->question_id=$q_id;
                        $startup_question_option_answer->question_option_id=$q_op_id;
                        $startup_question_option_answer->answer=$input_value;
                        $startup_question_option_answer->startup_id=$startup_id;
                        $startup_question_option_answer->save();
                    }
                    else if($q_type=="TEXTAREA")
                    {
                        $input_value=$request[$input_key];
                        $startup_question_option_answer=new StartupQuestionOptionAnswer();
                        $startup_question_option_answer->question_id=$q_id;
                        $startup_question_option_answer->question_option_id=$q_op_id;
                        $startup_question_option_answer->answer=$input_value;
                        $startup_question_option_answer->startup_id=$startup_id;
                        $startup_question_option_answer->save();
                    }
                    else if($q_type=="RD")
                    {
                        $input_value=$request[$input_key];
                        $startup_question_option_answer=new StartupQuestionOptionAnswer();
                        $startup_question_option_answer->question_id=$q_id;
                        $startup_question_option_answer->question_option_id=$q_op_id;
                        $startup_question_option_answer->answer=$input_value;
                        $startup_question_option_answer->startup_id=$startup_id;
                        $startup_question_option_answer->save();
                    }
                    else if($q_type=="SELECT")
                    {
                        $input_value=$request[$input_key];
                        $startup_question_option_answer=new StartupQuestionOptionAnswer();
                        $startup_question_option_answer->question_id=$q_id;
                        $startup_question_option_answer->answer=$input_value;
                        $startup_question_option_answer->startup_id=$startup_id;
                        $startup_question_option_answer->save();
                    }
                    else if($q_type=="CHK")//not used
                    {
                        $input_value=$request[$input_key];
                        $startup_question_option_answer=new StartupQuestionOptionAnswer();
                        $startup_question_option_answer->question_id=$q_id;
                        $startup_question_option_answer->question_option_id=$q_op_id;
                        $startup_question_option_answer->answer=$input_value;
                        $startup_question_option_answer->startup_id=$startup_id;
                        $startup_question_option_answer->save();
                    }
                }
            }
            $StartupsObj->field['master_form_partial_saved'] = 'Y';
            $StartupsObj->field['master_form_saved_level'] = 4;
            $return_data = $StartupsObj->updateStartup($startup_id);
        }
        else if($current_step==5){
            $startup_id=$request->startup_id;
            $fir_question_id=StartUpGeneralQuestion::select('id')->where('question_cat','FIR')->get()->pluck('id');
            StartupGeneralQuestionAnswer::where('startup_id',$startup_id)
                                         ->wherein('question_id',$fir_question_id)
                                         ->delete(); 
            StartupQuestionOptionAnswer::where('startup_id',$startup_id)
                                         ->wherein('question_id',$fir_question_id)
                                         ->delete();                          
            $allInputKeys=collect($request->all())->keys();
            foreach($allInputKeys as $input_key)
            {
                $input_info=(explode("_",$input_key));
                if(count($input_info)==2)
                {
                    $q_type=$input_info[0];
                    $q_id=$input_info[1];
                    if($q_type=="TEXT")
                    {
                        $input_value=$request[$input_key];
                        $startup_general_question_answer=new StartupGeneralQuestionAnswer();
                        $startup_general_question_answer->question_id=$q_id;
                        $startup_general_question_answer->answer=$input_value;
                        $startup_general_question_answer->startup_id=$startup_id;
                        $startup_general_question_answer->save();
                    }
                    else if($q_type=="TEXTAREA")
                    {
                        $input_value=$request[$input_key];
                        $startup_general_question_answer=new StartupGeneralQuestionAnswer();
                        $startup_general_question_answer->question_id=$q_id;
                        $startup_general_question_answer->answer=$input_value;
                        $startup_general_question_answer->startup_id=$startup_id;
                        $startup_general_question_answer->save();
                    }
                    else if($q_type=="RD")
                    {
                        $input_value=$request[$input_key];
                        $startup_general_question_answer=new StartupGeneralQuestionAnswer();
                        $startup_general_question_answer->question_id=$q_id;
                        $startup_general_question_answer->answer=$input_value;
                        $startup_general_question_answer->startup_id=$startup_id;
                        $startup_general_question_answer->save();
                    }
                    else if($q_type=="SELECT")
                    {
                        $input_value=$request[$input_key];
                        $startup_general_question_answer=new StartupGeneralQuestionAnswer();
                        $startup_general_question_answer->question_id=$q_id;
                        $startup_general_question_answer->answer=$input_value;
                        $startup_general_question_answer->startup_id=$startup_id;
                        $startup_general_question_answer->save();
                    }
                    else if($q_type=="CHK")
                    {
                        $input_value=$request[$input_key];
                        $startup_general_question_answer=new StartupGeneralQuestionAnswer();
                        $startup_general_question_answer->question_id=$q_id;
                        $startup_general_question_answer->answer=implode(",",$input_value);
                        $startup_general_question_answer->startup_id=$startup_id;
                        $startup_general_question_answer->save();
                    }
                    else if($q_type=="FILE")
                    {
                        //
                    }
                }
                else if(count($input_info)==3)
                {
                    $q_type=$input_info[0];
                    $q_id=$input_info[1];
                    $q_op_id=$input_info[2];
                    if($q_type=="TEXT")
                    {
                        $input_value=$request[$input_key];
                        $startup_question_option_answer=new StartupQuestionOptionAnswer();
                        $startup_question_option_answer->question_id=$q_id;
                        $startup_question_option_answer->question_option_id=$q_op_id;
                        $startup_question_option_answer->answer=$input_value;
                        $startup_question_option_answer->startup_id=$startup_id;
                        $startup_question_option_answer->save();
                    }
                    else if($q_type=="TEXTAREA")
                    {
                        $input_value=$request[$input_key];
                        $startup_question_option_answer=new StartupQuestionOptionAnswer();
                        $startup_question_option_answer->question_id=$q_id;
                        $startup_question_option_answer->question_option_id=$q_op_id;
                        $startup_question_option_answer->answer=$input_value;
                        $startup_question_option_answer->startup_id=$startup_id;
                        $startup_question_option_answer->save();
                    }
                    else if($q_type=="RD")
                    {
                        $input_value=$request[$input_key];
                        $startup_question_option_answer=new StartupQuestionOptionAnswer();
                        $startup_question_option_answer->question_id=$q_id;
                        $startup_question_option_answer->question_option_id=$q_op_id;
                        $startup_question_option_answer->answer=$input_value;
                        $startup_question_option_answer->startup_id=$startup_id;
                        $startup_question_option_answer->save();
                    }
                    else if($q_type=="SELECT")
                    {
                        $input_value=$request[$input_key];
                        $startup_question_option_answer=new StartupQuestionOptionAnswer();
                        $startup_question_option_answer->question_id=$q_id;
                        $startup_question_option_answer->answer=$input_value;
                        $startup_question_option_answer->startup_id=$startup_id;
                        $startup_question_option_answer->save();
                    }
                    else if($q_type=="CHK")//not used
                    {
                        $input_value=$request[$input_key];
                        $startup_question_option_answer=new StartupQuestionOptionAnswer();
                        $startup_question_option_answer->question_id=$q_id;
                        $startup_question_option_answer->question_option_id=$q_op_id;
                        $startup_question_option_answer->answer=$input_value;
                        $startup_question_option_answer->startup_id=$startup_id;
                        $startup_question_option_answer->save();
                    }
                }
            }
            $StartupsObj->field['master_form_saved'] = 'N';
            $StartupsObj->field['master_form_partial_saved'] = 'Y';
            $StartupsObj->field['master_form_saved_level'] = 5;
            $return_data = $StartupsObj->updateStartup($startup_id);
        }else if($current_step==6){
            $startup_id=$request->startup_id;
            $ide_question_id=StartUpGeneralQuestion::select('id')->where('question_cat','IDE')->get()->pluck('id');
            StartupGeneralQuestionAnswer::where('startup_id',$startup_id)
                                         ->wherein('question_id',$ide_question_id)
                                         ->delete(); 
            StartupQuestionOptionAnswer::where('startup_id',$startup_id)
                                         ->wherein('question_id',$ide_question_id)
                                         ->delete();                          
            $allInputKeys=collect($request->all())->keys();
            foreach($allInputKeys as $input_key)
            {
                $input_info=(explode("_",$input_key));
                if(count($input_info)==2)
                {
                    $q_type=$input_info[0];
                    $q_id=$input_info[1];
                    if($q_type=="TEXT")
                    {
                        $input_value=$request[$input_key];
                        $startup_general_question_answer=new StartupGeneralQuestionAnswer();
                        $startup_general_question_answer->question_id=$q_id;
                        $startup_general_question_answer->answer=$input_value;
                        $startup_general_question_answer->startup_id=$startup_id;
                        $startup_general_question_answer->save();
                    }
                    else if($q_type=="TEXTAREA")
                    {
                        $input_value=$request[$input_key];
                        $startup_general_question_answer=new StartupGeneralQuestionAnswer();
                        $startup_general_question_answer->question_id=$q_id;
                        $startup_general_question_answer->answer=$input_value;
                        $startup_general_question_answer->startup_id=$startup_id;
                        $startup_general_question_answer->save();
                    }
                    else if($q_type=="RD")
                    {
                        $input_value=$request[$input_key];
                        $startup_general_question_answer=new StartupGeneralQuestionAnswer();
                        $startup_general_question_answer->question_id=$q_id;
                        $startup_general_question_answer->answer=$input_value;
                        $startup_general_question_answer->startup_id=$startup_id;
                        $startup_general_question_answer->save();
                    }
                    else if($q_type=="SELECT")
                    {
                        $input_value=$request[$input_key];
                        $startup_general_question_answer=new StartupGeneralQuestionAnswer();
                        $startup_general_question_answer->question_id=$q_id;
                        $startup_general_question_answer->answer=$input_value;
                        $startup_general_question_answer->startup_id=$startup_id;
                        $startup_general_question_answer->save();
                    }
                    else if($q_type=="CHK")
                    {
                        $input_value=$request[$input_key];
                        $startup_general_question_answer=new StartupGeneralQuestionAnswer();
                        $startup_general_question_answer->question_id=$q_id;
                        $startup_general_question_answer->answer=implode(",",$input_value);
                        $startup_general_question_answer->startup_id=$startup_id;
                        $startup_general_question_answer->save();
                    }
                    else if($q_type=="FILE")
                    {
                        //
                    }
                }
                else if(count($input_info)==3)
                {
                    $q_type=$input_info[0];
                    $q_id=$input_info[1];
                    $q_op_id=$input_info[2];
                    if($q_type=="TEXT")
                    {
                        $input_value=$request[$input_key];
                        $startup_question_option_answer=new StartupQuestionOptionAnswer();
                        $startup_question_option_answer->question_id=$q_id;
                        $startup_question_option_answer->question_option_id=$q_op_id;
                        $startup_question_option_answer->answer=$input_value;
                        $startup_question_option_answer->startup_id=$startup_id;
                        $startup_question_option_answer->save();
                    }
                    else if($q_type=="TEXTAREA")
                    {
                        $input_value=$request[$input_key];
                        $startup_question_option_answer=new StartupQuestionOptionAnswer();
                        $startup_question_option_answer->question_id=$q_id;
                        $startup_question_option_answer->question_option_id=$q_op_id;
                        $startup_question_option_answer->answer=$input_value;
                        $startup_question_option_answer->startup_id=$startup_id;
                        $startup_question_option_answer->save();
                    }
                    else if($q_type=="RD")
                    {
                        $input_value=$request[$input_key];
                        $startup_question_option_answer=new StartupQuestionOptionAnswer();
                        $startup_question_option_answer->question_id=$q_id;
                        $startup_question_option_answer->question_option_id=$q_op_id;
                        $startup_question_option_answer->answer=$input_value;
                        $startup_question_option_answer->startup_id=$startup_id;
                        $startup_question_option_answer->save();
                    }
                    else if($q_type=="SELECT")
                    {
                        $input_value=$request[$input_key];
                        $startup_question_option_answer=new StartupQuestionOptionAnswer();
                        $startup_question_option_answer->question_id=$q_id;
                        $startup_question_option_answer->answer=$input_value;
                        $startup_question_option_answer->startup_id=$startup_id;
                        $startup_question_option_answer->save();
                    }
                    else if($q_type=="CHK")//not used
                    {
                        $input_value=$request[$input_key];
                        $startup_question_option_answer=new StartupQuestionOptionAnswer();
                        $startup_question_option_answer->question_id=$q_id;
                        $startup_question_option_answer->question_option_id=$q_op_id;
                        $startup_question_option_answer->answer=$input_value;
                        $startup_question_option_answer->startup_id=$startup_id;
                        $startup_question_option_answer->save();
                    }
                }
            }
            $StartupsObj->field['master_form_saved'] = 'Y';
            $StartupsObj->field['master_form_partial_saved'] = 'N';
            $StartupsObj->field['master_form_saved_level'] = 6;
            $return_data = $StartupsObj->updateStartup($startup_id);
        }

        if($current_step==6){
            $redirect_url = tokenize_url(route('web.masterFormConfirmation'),['startup_id' => $startup_id]);
            $message = 'Master Form saved successfully';
        }else{
            $redirect_url = tokenize_url(route('web.masterform'),['startup_id' => $startup_id,'current_step' => ($current_step+1)]);
            $message = 'Form Step '.$current_step.' saved successfully';
        }


        // Set redirect parameters
        $redirect['url']     = $redirect_url;
        $redirect['message'] = ['message' => $message, 'type' => 'success'];
        //------------------------

        return redirect($redirect['url'])->with(['message' => $redirect['message']]);
        
    }

    public function masterFormConfirmation(Request $request){
        $startup_id = $request['startup_id'];
        $startups_rec = Startups::select('type_trans.name as category_title')
            ->join('type_trans','type_trans.id','=','startups.startup_type_tran_id')
            ->where('startups.id',$startup_id)
            ->first();
        $return_startup = StartUps::getStartupDetail($startup_id);

        $startup_detail = $return_startup['data'];

        $view_data['startup_detail'] = $startup_detail;
        $view_data['category_title'] = @$startups_rec->category_title ?? "";
        return view('pages.form_confirmation',$view_data);
    }

    public function masterFormAlreadySubmitted(Request $request)
    {
        $startup_id = $request['startup_id'];
        $startups_rec = Startups::select('type_trans.name as category_title')
            ->join('type_trans','type_trans.id','=','startups.startup_type_tran_id')
            ->where('startups.id',$startup_id)
            ->first();
        $view_data['category_title'] = @$startups_rec->category_title ?? "";
        return view('pages.master_form_already_submitted',$view_data);
    }

    public function careholders()
    {
       $page_title = "Careholders Trust, Commitment to Excellence | Marwari Catalysts";
        $page_description = "Learn about the trusted shareholders of Marwari Catalysts, dedicated to excellence and committed to driving growth and innovation within our ecosystem.";

        $page_keywords = $page_title;
        $view_data['page_title'] =  $page_title;
        $view_data['page_keywords'] =  $page_keywords;
        $view_data['page_description'] =  $page_description;

        return view('pages.careholders',$view_data);
    }

     public function mentor_form()
    {
        $page_title = 'Thrive - Mentors with Marwari Catalysts';
        $page_description = 'Thrive - Mentors with Marwari Catalysts';

        $page_keywords = $page_title;
        $view_data['page_title'] =  $page_title;
        $view_data['page_keywords'] =  $page_keywords;
        $view_data['page_description'] =  $page_description;

        return view('pages.mentorForm',$view_data);
    }

    public function saveMentor(Request $request){


        $request->validate([
            'g-recaptcha-response' => function($attribute,$value,$fail){
                $secret_key = env('GOOGLE_RECAPTCHA_SECRET');
                $response = $value;
                $userIP = $_SERVER['REMOTE_ADDR'];
                $url = "https://www.google.com/recaptcha/api/siteverify?secret=$secret_key&response=$response&remoteIp=$userIP";
                $response = \file_get_contents($url);
                $response = json_decode($response);
                if(!$response->success){
                    Session::flash('g-recaptcha-response','Please Check reCaptcha ');
                    Session::flash('alert-class','alert-danger');
                    $fail($attribute.' google reCaptcha failed');
                }
            }
        ]);

        try{

            $input = $request->all();  
            
            $image_name = null;
            
            if ($request->hasFile('photo'))
            {
              $image = $input['photo'];
              $image_name = uniqid().rand(1234567890, 6).'.'.$image->getClientOriginalExtension();
              $fileObj = $request->file('photo');
              $fileObj->move(public_path($this->mentor_img_path).'/', $image_name);
            }

            $MentorObj = new Mentor();
            $MentorObj->field['name'] = $input['name'];
            $MentorObj->field['email'] = $input['email'];
            $MentorObj->field['contact_no'] = $input['contact_no'];
            $MentorObj->field['linkedin_profile'] = $input['linkedin_profile'];
            $MentorObj->field['address'] = $input['address'];
            $MentorObj->field['job_title'] = $input['job_title'];
            $MentorObj->field['organization'] = $input['organization'];
            $MentorObj->field['intro_achievement'] = $input['intro_achievement'];
            $MentorObj->field['area_of_interest'] = $input['area_of_interest'];
            $MentorObj->field['session_preffer'] = $input['session_preffer'];
            $MentorObj->field['photo'] = $image_name;
            $return_data = $MentorObj->saveMentor();

            $return_arr['status'] = false;
            $return_arr['message'] = "Unable to send email, try again later.";
            
        } catch(\Exception $e){
            dd($e->getMessage());    
        }
        return response()->json($return_data, 200);
    }

    public function getallStartupsEmails()
    {
        $all_startups_emails=StartUps::where('removed','=','N')->select('email')->get();
        return $all_startups_emails;
    }

    public function getStartupSubQuestion(Request $req)
    {
        $qid=$req->qid;
        $value=$req->value;
        $startup_id=$req->startup_id;
        $startup_general_question_ob=json_decode(StartUpGeneralQuestion::select('sub_question')->where('id',$qid)->first(),1);
        $startup_sub_question_ids=json_decode($startup_general_question_ob['sub_question'],1);
        $startup_sub_question_ids_array=[];
        if(array_key_exists($value,$startup_sub_question_ids))
        {
            $startup_sub_question_ids_array=$startup_sub_question_ids[$value];
        }
        $startup_general_question = StartUpGeneralQuestion::select('startup_general_questions.*')
                    ->whereIn('startup_general_questions.id',$startup_sub_question_ids_array)
                    ->where('startup_general_questions.removed','N')
                    ->orderBy('startup_general_questions.sort_order','ASC')
                    ->get();
        $startup_question_option=StartupQuestionOption::
                    whereIn('startup_question_option.startup_general_questions_id',$startup_sub_question_ids_array)
                    ->where('startup_question_option.removed','N')
                    ->orderBy('startup_question_option.sort_order','ASC')
                    ->get();

        $startup_questions_answer=StartupGeneralQuestionAnswer::
                    whereIn('question_id',$startup_sub_question_ids_array)
                    ->where('startup_id',$startup_id)
                    ->get()->keyBy('question_id')->toArray();
        $startup_questions_option_answer=StartupQuestionOptionAnswer::
                    whereIn('question_id',$startup_sub_question_ids_array)
                    ->where('startup_id',$startup_id)
                    ->get()->keyBy('question_option_id')->toArray();

        $data['value']=$value;
        $data['startup_general_question']=$startup_general_question;
        $data['startup_question_option']=$startup_question_option;
        $data['startup_questions_answer']=$startup_questions_answer;
        $data['startup_questions_option_answer']=$startup_questions_option_answer;
        return $data;     
    }

    //Begin:UserRegistrationForm methods Mtak
    public function UserRegistrationForm(Request $request)
    {
        $user_registration_link_id = $request->user_registration_link_id;
        $page_title = 'User Registration';
        $page_description = 'User Registration Form';
        $user_registration_link = UserRegistrationLink::select('id','title','user_type','details','is_expiry','expiry_range','expiry_message',DB::raw('IF(is_expiry = "Y",IF(REPLACE(LEFT(expiry_range,10),"/","-") <= CURDATE() AND REPLACE(RIGHT(expiry_range,10),"/","-") >= CURDATE(),"N","Y"),"N") AS is_link_expired'))
            ->where('id',$user_registration_link_id)
            ->first();

        $view_data['page_title'] =  $page_title;
        $view_data['page_description'] =  $page_description;
        $view_data['user_registration_link'] = $user_registration_link;
        return view('pages.user_registration',$view_data);
    }

    public function saveUserRegistrationForm(Request $request)
    {
        $request->validate([
            'first_name' => 'required', 
            'last_name' => 'required', 
            'email' => 'email|required',
            'user_name' => 'required',
            'linked_in' => 'required|url',
            'profile_pic' => 'required|image|max:2048',
            'mobile' => 'nullable|digits:10',
            'instagram_profile' => 'nullable|url'
        ]);

        $form_status = false;

        $user_registration_obj = new UserRegistration();
        $user_registration_obj->field['first_name'] = $request->first_name;
        $user_registration_obj->field['last_name'] = $request->last_name;
        $user_registration_obj->field['email'] = $request->email;
        $user_registration_obj->field['user_name'] = $request->user_name;
        $user_registration_obj->field['mobile'] = $request->mobile;
        $user_registration_obj->field['linked_in'] = $request->linked_in;
        $user_registration_obj->field['user_type'] = $request->user_type;
        $user_registration_obj->field['instagram_profile'] = $request->instagram_profile;
        $user_registration_obj->field['detail'] = $request->detail;
        $user_registration_obj->field['user_registration_link_id'] = $request->user_registration_link_id;

        //file upload
        if($request->has('profile_pic'))
        {
          $file_name_extension = $request->file('profile_pic')->extension(); 
          $file_name = "user_profile_".uniqid().".".$file_name_extension;
          $request->file('profile_pic')->move('uploads/users_profile_pic', $file_name);
          $user_registration_obj->field['profile_pic'] = $file_name;
        }
        //file upload
        $return = $user_registration_obj->saveUserRegistration();

        if($return['status'])
        {
            $form_status = true;
        }
        $view_data['page_title'] =  'User Registration';
        $view_data['form_status'] = $form_status;
        return view('pages.user_registration_form_success',$view_data);
    }

    public function duplicateEmailCheckUserRegForm(Request $request)
    {
        $email = $request->email;
        $isExsits = User::where('email', '=', $email)->exists();
        
        return $isExsits ? 'false' : 'true';
    }

    public function duplicateUserNameCheckUserRegForm(Request $request)
    {
        $user_name = $request->user_name;
        $isExsits = User::where('user_name', '=', $user_name)->exists();
        return $isExsits ? 'false' : 'true';
    }
    //End:UserRegistrationForm methods Mtak


     public function turbo_pap()
    {
        $page_title = 'Turbo Pap';
        $page_description = '';
        $page_keywords = '';

        $view_data['page_title'] =  $page_title;
        $view_data['page_keywords'] =  $page_keywords;
        $view_data['page_description'] =  $page_description;

        return view('pages.turbo-pap',$view_data);
    }

    public function duplicateEmailValidation(Request $request)
    {
        $email = $request->email;
        $email_exist = DB::table('startups')->where('email',$email)->exists();
        return $email_exist ? 'false' : 'true';
    }

    public function uploadRequestedDocumentView(Request $request)
    {
        $strtps_doc_req_records = [];
        $startups_id = $request->startups_id;
        $return = StartupsDocumentsRequest::getPendingRequestsByStartupsId($startups_id);
        
        if($return['status'])
        {
            $strtps_doc_req_records = $return['records'];
        }

        $view_data['page_title'] = "Upload Document";
        $view_data['strtps_doc_req_records'] = $strtps_doc_req_records;
        return view('pages.document_request.index',$view_data);
    }

    public function storeRequestedDocument(Request $request)
    {
        // 
        $strtp_doc_req_record = [];
        $response = [];
        $request->validate([
          "file_name"=>[
            'required',
            'file',
            'max:5120',
            'mimes:pdf,txt,docx,doc,xlsx,xls,docx,doc,pptx,ppt,jpg,png'
          ]
        ]);

        $strtps_doc_req_id = $request->strtps_doc_req_id;
        $logged_in_usr_id = 0;
        $return = StartupsDocumentsRequest::getStartupsDocumentsRequestById($strtps_doc_req_id);
        
        DB::beginTransaction();
        try
        {
            if($return['status'])
            {
                $strtp_doc_req_record = $return['record'];
                $file_name = $request->file_name;
                $startups_id = $strtp_doc_req_record->startups_id;
                //upload StartupDocument
                if($request->has('file_name'))
                {
                    $file_name = $request->file_name;
                    $extension = $file_name->extension();          
                    $disc_file_name = uniqid("strtp_doc_")."_".@$startups_id.".".$extension;
                    $file_name->move('uploads/startups_docs',$disc_file_name);
                }
                $data['startups_id'] = $strtp_doc_req_record->startups_id;
                $data['document_type_id'] = $strtp_doc_req_record->document_type_id;
                $data['name'] = $strtp_doc_req_record->title;
                $data['file_name'] = $disc_file_name ?? "";
                $data['action_by_users_id'] = $logged_in_usr_id;
                $data['startups_documents_requests_id'] = $strtp_doc_req_record->id;
                $startupDocumentObj = new StartupDocument();
                $startupDocumentObj->field = $data;
                $startupDocumentObj->createStartupDocument();
                //---
                //StartupsDocumentsRequest update
                $strtpDocReqObj = new StartupsDocumentsRequest();
                $strtpDocReqObj->field['is_responded'] = 'Y';
                $strtpDocReqObj->updateStartupsDocumentsRequest($strtp_doc_req_record->id);
                //---
                DB::commit();
                // session()->put('doc_req_frm_upld_success',true);
                $response['type'] = "success";
                $response['message'] = "document uploaded sucessfully";
            }
            else
            {
                $response['type'] = "error";
                $response['message'] = "unable to upload , try again later";
            }
        }
        catch(\Exception $e)
        {
            DB::rollback();
            $response['type'] = "error";
            $response['message'] = "unable to upload , try again later";
        }
        return $response;
        // 
    }

    public function investorRegistration(Request $request,$aif_partner_slug = "")
    {
       // return $aif_partner_slug;
        $view_data = [];
        $aif_partner_id = $request->aif_partner_id;
        $view_data['aif_partner_slug'] = $aif_partner_slug;

        $aif_partner_rec = DB::table('aif_partner')
            ->where('id',$aif_partner_id)
            ->where('removed','N')
            ->first();
        
        $view_data['aif_partner_rec'] = $aif_partner_rec;

        if(session('aif_invstr_reg_id'))
        {
            $aif_invstr_reg_id = $request->aif_invstr_reg_id;

            $aif_inv_reg_rec = AifInvestorRegistration::where('id',$aif_invstr_reg_id)->first();
            
            $aif_partner_id_2 = @$aif_inv_reg_rec->aif_partner_id;

            if(@$aif_partner_id_2 && @$aif_partner_id_2 != $aif_partner_id)
            {
                $aif_partner_rec_2 = DB::table('aif_partner')
                    ->where('id',$aif_partner_id_2)
                    ->where('removed','N')
                    ->first();
        
               // return $aif_partner_rec->slug;
                $correct_url = route('web.investor_registration.login_page',['aif_partner_slug' => $aif_partner_rec_2->slug]);
                $view_data['page_title'] = "No Access";
                $view_data['correct_url'] = $correct_url;
                $view_data['partner_name'] = $aif_partner_rec_2->name;
                return view('pages.investor_registration.no_access',$view_data);
            }

            if(!$aif_invstr_reg_id)
            {
                $aif_invstr_reg_id = session('aif_invstr_reg_id');
            }
            $aif_invester_frm_rec = [];

            $countries_record = [];
            $states_record = [];
            $cities_record = [];
            $current_step = $request->current_step ?? 1;

            if($current_step == 2)
            {   
                $countries_record = DB::table('countries')->where('aif_active',1)->whereNull('deleted_at')->pluck('name','id')->toArray();
            } 
            
            $return = AifInvesterForm::getDataByAifInvestorRegId($aif_invstr_reg_id);

            if($return['status'])
            {
                $aif_invester_frm_rec = $return['record'];
                $country_id = $aif_invester_frm_rec->country_id ?? 0;
                $state_id = $aif_invester_frm_rec->state_id ?? 0;

                $states_record = DB::table('states')->where('aif_active',1)->where('country_id',$country_id)->whereNull('deleted_at')->pluck('name','id')->toArray();
                $cities_record = DB::table('cities')->where('aif_active',1)->where('state_id',$state_id)->whereNull('deleted_at')->pluck('name','id')->toArray();
            }

            $view_data['current_step'] = $current_step;
            $view_data['page_title'] = "Investor Registration";
            $view_data['countries_record'] = $countries_record;
            $view_data['aif_invester_frm_rec'] = $aif_invester_frm_rec;
            $view_data['aif_invstr_reg_id'] = $aif_invstr_reg_id;
            $view_data['states_record'] = $states_record;
            $view_data['cities_record'] = $cities_record;
            //accredited_cbreturn $aif_invester_frm_rec;
            return view('pages.investor_registration.index',$view_data);
        }
        else
        {
            $request->session()->flash('response', ['message'=>'You have been logged out!','type'=>'error']);
            return redirect()->route('web.investor_registration.login_page',['aif_partner_slug' => @$aif_partner_slug]);
        }
    }

    public function investorRegistrationStore(Request $request,$aif_partner_slug = "")
    {
        $aif_partner_id = @$request->aif_partner_id ?? 0;
        //return $aif_partner_id;
        $view_data['aif_partner_slug'] = $aif_partner_slug;
        $mail_enable = true;
        $aif_invester_reg_rec  = [];
        $mail_smtp_configuration = [];
        $message = [];
        $aif_invstr_reg_id = $request->aif_invstr_reg_id;
        $aif_invester_frm_rec = [];
        $return = AifInvesterForm::getDataByAifInvestorRegId($aif_invstr_reg_id);
        $aif_partner_record = AifPartner::where('id',$aif_partner_id)->first();

        // return [
        //     @$aif_partner_record->demat_account_field_active,
        //     @$aif_partner_record->cancelled_cheque_field_active ]
        // ;

        if($return['status'])
        {
            $aif_invester_frm_rec = $return['record'];
        }

        if(!session('aif_invstr_reg_id'))
        {
            $request->session()->flash('response', ['message'=>'You have been logged out!','type'=>'error']);
            return redirect()->route('web.investor_registration.login_page',['aif_partner_slug' => @$aif_partner_slug]);
        }
        else if(@$request->re_submit == 'Y')
        {
            //return $request;
            $data = [];
            $colNameArr = [];
            $aifInvstrFrmRecArr = @json_decode(@$aif_invester_frm_rec->aif_invester_form_col_names_arr) ?? [];

            $aif_invester_form_id = $aif_invester_frm_rec->id;

            if(@in_array('avatar',$aifInvstrFrmRecArr))
            {
                $validArrRules['avatar'][1] = 'mimes:jpg,png,jpeg';
            }

            if(@in_array('aadhaar_card',$aifInvstrFrmRecArr))
            {
                $validArrRules['aadhaar_card'][0] = 'required';
                $validArrRules['aadhaar_card'][1] = 'mimes:jpg,png,jpeg,pdf';
            }

            if(@in_array('pan_card_doc',$aifInvstrFrmRecArr))
            {
                $validArrRules['pan_card_doc'][0] = 'required';
                $validArrRules['pan_card_doc'][1] = 'mimes:jpg,png,jpeg,pdf';
            }

            if( @in_array('demat_doc',$aifInvstrFrmRecArr) && @$aif_partner_record->demat_account_field_active == "Y" )
            {
                $validArrRules['demat_doc'][0] = 'required';
                $validArrRules['demat_doc'][1] = 'mimes:jpg,png,jpeg,pdf';
            }

            if( @in_array('cancelled_cheque',$aifInvstrFrmRecArr) && @$aif_partner_record->cancelled_cheque_field_active == "Y" )
            {
                $validArrRules['cancelled_cheque'][0] = 'required';
                $validArrRules['cancelled_cheque'][1] = 'mimes:jpg,png,jpeg,pdf';
            }
            
            $request->validate($validArrRules);

            if($request->has('avatar'))
            {
                $file_name = $request->avatar;
                $extension = $file_name->extension();          
                $disc_file_name = uniqid("aif_avtr_")."_".@$aif_invstr_reg_id.".".$extension;
                $file_name->move('uploads/aif_invester_reg_docs',$disc_file_name);
                $data['avatar'] = $disc_file_name;
                array_push($colNameArr,'avatar');
            }

            if($request->has('aadhaar_card'))
            {
                $file_name = $request->aadhaar_card;
                $extension = $file_name->extension();          
                $disc_file_name = uniqid("aadhaar_card_")."_".@$aif_invstr_reg_id.".".$extension;
                $file_name->move('uploads/aif_invester_reg_docs',$disc_file_name);
                $data['aadhaar_card'] = $disc_file_name;
                array_push($colNameArr,'aadhaar_card');
            }

            if($request->has('pan_card_doc'))
            {
                $file_name = $request->pan_card_doc;
                $extension = $file_name->extension();          
                $disc_file_name = uniqid("pan_card_doc_")."_".@$aif_invstr_reg_id.".".$extension;
                $file_name->move('uploads/aif_invester_reg_docs',$disc_file_name);
                $data['pan_card_doc'] = $disc_file_name;
                array_push($colNameArr,'pan_card_doc');
            }

            if($request->has('demat_doc'))
            {
                $file_name = $request->demat_doc;
                $extension = $file_name->extension();          
                $disc_file_name = uniqid("demat_doc_")."_".@$aif_invstr_reg_id.".".$extension;
                $file_name->move('uploads/aif_invester_reg_docs',$disc_file_name);
                $data['demat_doc'] = $disc_file_name;
                array_push($colNameArr,'demat_doc');
            }

            if($request->has('cancelled_cheque'))
            {
                $file_name = $request->cancelled_cheque;
                $extension = $file_name->extension();          
                $disc_file_name = uniqid("cancelled_cheque_")."_".@$aif_invstr_reg_id.".".$extension;
                $file_name->move('uploads/aif_invester_reg_docs',$disc_file_name);
                $data['cancelled_cheque'] = $disc_file_name;
                array_push($colNameArr,'cancelled_cheque');
            }

            $data['status'] = "P";
            $data['remark'] = null;
            $data['sub_status'] = null;
            $data['re_submit'] = 'Y';

            $aifInvesterFormObj = new AifInvesterForm();
            $aifInvesterFormObj->field['matched_fileds'] = ['aif_investor_registration_id' => $aif_invstr_reg_id];
            $aifInvesterFormObj->field['inserted_fileds'] = $data;
            $return = $aifInvesterFormObj->updateOrCreateAifInvesterForm();
            // 
            AifInvestorRorQuestion::where('aif_invester_form_id',$aif_invester_form_id)
                ->where('removed','N')
                ->wherein('aif_invester_form_col_name',$colNameArr)
                ->update([
                  'removed' => 'Y',
                  're_upload' => 'Y'
                ]);
            // 

            $message = ['message'=>'Form Submitted Successfully','type'=>'success'];
            $redirect_url = tokenize_url(route('web.investor_registration.index',['aif_partner_slug'=>@$aif_partner_slug]),['aif_invstr_reg_id' => $aif_invstr_reg_id]);

            $request->session()->flash('response', $message);
            return redirect($redirect_url);
        }
        else if($aif_invester_frm_rec && @$aif_invester_frm_rec->saved_level == 4)
        {
            $redirect_url = tokenize_url(route('web.investor_registration.index',['aif_partner_slug'=>@$aif_partner_slug]),['current_step' =>  1,'aif_invstr_reg_id' => $aif_invstr_reg_id]);

            $request->session()->flash('response', ['message'=>'Your account is under review','type'=>'success']);
            return redirect($redirect_url);
        }
        else
        {
            $validArrRules = [];
            $current_step = $request->current_step;
           
            if($current_step == 1)
            {
                $validArrRules['bio'] = [
                    'required'
                ];

                $validArrRules['phone_number'] = [
                    'required'
                ];

                /*
                $validArrRules['phone_number'] = [
                     'required','digits:10'
                ];
                */

                $validArrRules['linked_in_url'] = [
                   // 'required','url'
                ];

                // if(!$request->has('avatar_file_saved'))
                // {
                //     $validArrRules['avatar'][0] = 'required';
                // }
                
                $validArrRules['avatar'][1] = 'mimes:jpg,png,jpeg';
                
                $validArrRules['entity_type'] = [
                    'required'
                ];

                $validArrRules['legal_entity_name'] = [
                    'required'
                ];
            }
            else if($current_step == 2)
            {
                $validArrRules['pan'] = [
                    'required','regex:/^([a-zA-Z]{5})([0-9]{4})([a-zA-Z]{1})?$/'
                ];

                $validArrRules['dob'] = [
                    'required'
                ];
                
                $validArrRules['country_id'] = [
                    'required'
                ];
                
                $validArrRules['state_id'] = [
                    'required'
                ];
                
                $validArrRules['city_id'] = [
                    'required'
                ];

                $validArrRules['address'] = [
                    'required'
                ];

                $validArrRules['pincode'] = [
                    'required','regex:/^\d{6}$/i'
                ];

                if(!$request->has('aadhaar_card_file_saved'))
                {
                    $validArrRules['aadhaar_card'][0] = 'required';
                }
                $validArrRules['aadhaar_card'][1] = 'mimes:jpg,png,jpeg,pdf';

                if(!$request->has('pan_card_doc_file_saved'))
                {
                    $validArrRules['pan_card_doc'][0] = 'required';
                }
                $validArrRules['pan_card_doc'][1] = 'mimes:jpg,png,jpeg,pdf';


                if(@$aif_partner_record->demat_account_field_active == "Y")
                {
                    if(!$request->has('demat_doc_file_saved'))
                    {
                        $validArrRules['demat_doc'][0] = 'required';
                    }
                    $validArrRules['demat_doc'][1] = 'mimes:jpg,png,jpeg,pdf';
                }   
                
                if(@$aif_partner_record->cancelled_cheque_field_active == "Y")
                {
                    if(!$request->has('cancelled_cheque_file_saved'))
                    {
                        $validArrRules['cancelled_cheque'][0] = 'required';
                    }
                    $validArrRules['cancelled_cheque'][1] = 'mimes:jpg,png,jpeg,pdf';
                }
            }
            else if($current_step == 3)
            {
                $validArrRules['accredited'] = [
                    'required'
                ];  

                $validArrRules['capital_plan_to_invest'] = [
                    'required'
                ];  

                $validArrRules['investment_amount'] = [
                    'required',
                    'numeric',
                    'max:10000000000000000000'
                ];  

                $validArrRules['experience_investing_in_venture'] = [
                    'required'
                ];     

                /*
                if(!$request->has('eligibility_proof_doc_file_saved'))
                {
                    $validArrRules['eligibility_proof_doc'][0] = 'required';
                }
                $validArrRules['eligibility_proof_doc'][1] = 'mimes:jpg,png,jpeg,pdf';
                */
            }
            else if($current_step == 4)
            {
                $validArrRules['i_confirm'] = [
                    'required'
                ];    

                $validArrRules['agree_term_cond'] = [
                    'required'
                ]; 
            }

            //validation begin
            $request->validate($validArrRules);
            //validation end
            // $data['aif_partner_id'] = $aif_partner_id;
            //insert begin
            if($current_step == 1)
            {
                $data['bio'] = $request->bio;
                $data['phone_number'] = $request->phone_number;
                $data['linked_in_url'] = $request->linked_in_url;
                $data['saved_level'] = $current_step;
                $data['status'] = "P";
                
                if($request->has('avatar'))
                {
                    $file_name = $request->avatar;
                    $extension = $file_name->extension();          
                    $disc_file_name = uniqid("aif_avtr_")."_".@$aif_invstr_reg_id.".".$extension;
                    $file_name->move('uploads/aif_invester_reg_docs',$disc_file_name);
                    $data['avatar'] = $disc_file_name;
                }

                $data['entity_type'] = $request->entity_type;
                $data['legal_entity_name'] = $request->legal_entity_name;
                $data['saved_level'] = $current_step;
                $data['status'] = "P";
            }
            else if($current_step == 2)
            {
                $data['pan'] = $request->pan;
                $data['dob'] = @date_format(@date_create($request->dob),"Y/m/d");
                $data['country_id'] = $request->country_id;
                $data['state_id'] = $request->state_id;
                $data['city_id'] = $request->city_id;
                $data['address'] = $request->address;
                $data['pincode'] = $request->pincode;

                if($request->has('aadhaar_card'))
                {
                    $file_name = $request->aadhaar_card;
                    $extension = $file_name->extension();          
                    $disc_file_name = uniqid("aadhaar_card_")."_".@$aif_invstr_reg_id.".".$extension;
                    $file_name->move('uploads/aif_invester_reg_docs',$disc_file_name);
                    $data['aadhaar_card'] = $disc_file_name;
                }

                if($request->has('pan_card_doc'))
                {
                    $file_name = $request->pan_card_doc;
                    $extension = $file_name->extension();          
                    $disc_file_name = uniqid("pan_card_doc_")."_".@$aif_invstr_reg_id.".".$extension;
                    $file_name->move('uploads/aif_invester_reg_docs',$disc_file_name);
                    $data['pan_card_doc'] = $disc_file_name;
                }

                if($request->has('demat_doc'))
                {
                    $file_name = $request->demat_doc;
                    $extension = $file_name->extension();          
                    $disc_file_name = uniqid("demat_doc_")."_".@$aif_invstr_reg_id.".".$extension;
                    $file_name->move('uploads/aif_invester_reg_docs',$disc_file_name);
                    $data['demat_doc'] = $disc_file_name;
                }

                if($request->has('cancelled_cheque'))
                {
                    $file_name = $request->cancelled_cheque;
                    $extension = $file_name->extension();          
                    $disc_file_name = uniqid("cancelled_cheque_")."_".@$aif_invstr_reg_id.".".$extension;
                    $file_name->move('uploads/aif_invester_reg_docs',$disc_file_name);
                    $data['cancelled_cheque'] = $disc_file_name;
                }
        
                $data['saved_level'] = $current_step;
                $data['status'] = "P";
            }
            else if($current_step == 3)
            {
                $data['accredited'] = $request->accredited;
                $data['capital_plan_to_invest'] = $request->capital_plan_to_invest;
                $data['investment_amount'] = $request->investment_amount;
                $data['experience_investing_in_venture'] = $request->experience_investing_in_venture;
                $data['accredited_cb'] = $request->accredited_cb;

                /*
                if($request->has('eligibility_proof_doc'))
                {
                    $file_name = $request->eligibility_proof_doc;
                    $extension = $file_name->extension();          
                    $disc_file_name = uniqid("elig_proof_doc_")."_".@$aif_invstr_reg_id.".".$extension;
                    $file_name->move('uploads/aif_invester_reg_docs',$disc_file_name);
                    $data['eligibility_proof_doc'] = $disc_file_name;
                }
                */

                $data['saved_level'] = $current_step;
                $data['status'] = "P";
            }
            else if($current_step == 4)
            {
                $data['i_confirm'] = "Y";
                $data['agree_term_cond'] = "Y";
                $data['saved_level'] = $current_step;
                $data['status'] = "P";
            }

            $aifInvesterFormObj = new AifInvesterForm();
            $aifInvesterFormObj->field['matched_fileds'] = ['aif_investor_registration_id' => $aif_invstr_reg_id];
            $aifInvesterFormObj->field['inserted_fileds'] = $data;
            $return = $aifInvesterFormObj->updateOrCreateAifInvesterForm();
            //insert end

            //mail begin
            if($current_step == 4)
            {
                //get mail smtp config begin
                $return = AifInvestorRegistration::getAifInvestorRegistrationById($aif_invstr_reg_id);
                if($return['status'])
                {
                    $aif_invester_reg_rec = $return['record'];
                }

                $mail_smtp_config_rec = MailSMTPConfiguration::where('removed','N')->where('for_aif','Y')->first();
                $mail_smtp_configuration_id = @$mail_smtp_config_rec->id ?? 0;
                
                $return_1 = MailSMTPConfiguration::getMailSMTPConfigurationById($mail_smtp_configuration_id);
                
                if($return_1['status'])
                {
                    $mail_smtp_configuration = $return_1['data']['record'];
                }

                //get mail smtp config end
                if(@$mail_smtp_configuration && @$aif_invester_reg_rec && $mail_enable)
                { 
                    Config::set('mail',getMailConfig($mail_smtp_configuration));
                    //dd(Config('mail'));
                    
                    //set mail content begin
                    $mail_config = MailConfiguration::select('*')
                        ->where('removed','N')
                        ->where('type_trans_id',_AIF_ONBOARD_FINAL_SUBMIT_)
                        ->first();
                    
                    if($mail_config)
                    {
                        $from_email = $mail_smtp_configuration->mail_from_address;
                        $to_email = @$aif_invester_reg_rec->email;
                        
                        //set mail content begin
                        $content = $mail_config->content;
                        $subject = $mail_config->subject;
                        
                        $replaceble_tags = array('{entity_name}');
                        $replaceble_tags_with_value['{entity_name}'] = @$aif_invester_reg_rec->legal_entity_name;

                        foreach($replaceble_tags as $_replaceble_tags)
                        {
                            $content = str_replace($_replaceble_tags, @$replaceble_tags_with_value[$_replaceble_tags], $content);
                            $subject = str_replace($_replaceble_tags, @$replaceble_tags_with_value[$_replaceble_tags], $subject);
                        }
                        $mail_data['content'] = $content;
                        //set mail content end

                        try
                        {
                            Mail::send('email.investor_fund.aif_onboard_final_submit', $mail_data,
                            function($message) use($from_email,$to_email,$subject) 
                            {
                                $message->from($from_email);
                                $message->to($to_email, 'APP_NAME')->subject($subject);
                            });
                        }
                        catch(\Exception $e)
                        {
                            //return $e;
                        }
                    }
                }
            }
            //mail end
            
            if($current_step == 4)
            {
                $current_step = 0;
                $message = ['message'=>'Form Submitted Successfully','type'=>'success'];
            }
            else
            {
               $message = ['message'=>'Data Saved Successfully','type'=>'success'];
            }

            $redirect_url = tokenize_url(route('web.investor_registration.index',['aif_partner_slug'=>@$aif_partner_slug]),['current_step' => $current_step + 1,'aif_invstr_reg_id' => $aif_invstr_reg_id]);

            $request->session()->flash('response', $message);
            return redirect($redirect_url);
        }
    }

    public function getStates(Request $request,$aif_partner_slug = "")
    {

        $view_data['aif_partner_slug'] = $aif_partner_slug;
        $country_id = $request->country_id;

        $options_html = "";
        $states_record = DB::table('states')->where('aif_active',1)->where('country_id',$country_id)->whereNull('deleted_at')->pluck('name','id')->toArray();

        if($states_record)
        {
            foreach($states_record as $state_id => $state_name)
            {
                $options_html = $options_html.'
                    '.$state_name.'
                ';
            }
        }
        return $options_html;
    }   

    public function getStatesG(Request $request)
    {

        $country_id = $request->country_id;
        
        $options_html = "";
        $states_record = DB::table('states')->where('is_active',1)->where('country_id',$country_id)->whereNull('deleted_at')->pluck('name','id')->toArray();

        if($states_record)
        {
            foreach($states_record as $state_id => $state_name)
            {
                $options_html = $options_html.'
                    '.$state_name.'
                ';
            }
        }
        return $options_html;
    }   

    public function getCities(Request $request,$aif_partner_slug = "")
    {
        $view_data['aif_partner_slug'] = $aif_partner_slug;
        $state_id = $request->state_id;
        $options_html = "";
        $cities_record = DB::table('cities')->where('aif_active',1)->where('state_id',$state_id)->whereNull('deleted_at')->pluck('name','id')->toArray();

        if($cities_record)
        {
            foreach($cities_record as $city_id => $city_name)
            {
                $options_html = $options_html.'
                    '.$city_name.'
                ';
            }
        }
        return $options_html;
    }

    public function getCitiesG(Request $request)
    {
        
        $state_id = $request->state_id;
        $options_html = "";
        $cities_record = DB::table('cities')->where('is_active',1)->where('state_id',$state_id)->whereNull('deleted_at')->pluck('name','id')->toArray();

        if($cities_record)
        {
            foreach($cities_record as $city_id => $city_name)
            {
                $options_html = $options_html.'
                    '.$city_name.'
                ';
            }
        }
        return $options_html;
    }

    public function investorRegistrationLoginPage(Request $request,$aif_partner_slug = "")
    {   
        if(session('aif_invstr_reg_id'))
        {
            $aif_invstr_reg_id = session('aif_invstr_reg_id');
            $redirect_url = tokenize_url(route('web.investor_registration.index',['aif_partner_slug'=>@$aif_partner_slug]),['current_step' => 1,'aif_invstr_reg_id' => $aif_invstr_reg_id]);

            return redirect($redirect_url);
        }
        else
        {
            $view_data = [];
            $aif_partner_id = $request->aif_partner_id;
            $view_data['aif_partner_slug'] = $aif_partner_slug;
            $aif_partner_rec = DB::table('aif_partner')
                ->where('id',$aif_partner_id)
                ->where('removed','N')
                ->first();
            $view_data['aif_partner_rec'] = $aif_partner_rec;
            $view_data['page_title'] = "Login";
            return view('pages.investor_registration.login',$view_data);
        }
    }

    public function investorRegistrationSignupPage(Request $request,$aif_partner_slug = "")
    {
        $view_data = [];
        $aif_partner_id = $request->aif_partner_id;
        $view_data['aif_partner_slug'] = $aif_partner_slug;
        $aif_partner_rec = DB::table('aif_partner')
            ->where('id',$aif_partner_id)
            ->where('removed','N')
            ->first();
        $view_data['aif_partner_rec'] = $aif_partner_rec;
        $view_data['page_title'] = "Signup";
        return view('pages.investor_registration.sign_up',$view_data);
    }

    public function investorRegistrationSignupStore(Request $request,$aif_partner_slug = "")
    {
        $aif_partner_id = @$request->aif_partner_id ?? 0;
        $view_data['aif_partner_slug'] = $aif_partner_slug;
        $request->validate([
            'email' => 'required',
            'full_name' => 'required'
        ]);

        $data['email'] = @trim($request->email);
        $data['full_name'] = @trim($request->full_name);
        $data['aif_partner_id'] = $aif_partner_id;

        $is_email_exist = AifInvestorRegistration::where('removed','N')->where('email',@$data['email'])->exists();

        if(!$is_email_exist)
        {
            $aifInvestorRegistrationObj = new AifInvestorRegistration();
            $aifInvestorRegistrationObj->field = $data;
            $return = $aifInvestorRegistrationObj->createAifInvestorRegistration();
            
            if($return['status'])
            {
                $message = ['message'=>'Registration Successfully','type'=>'success'];
                $redirect_url = route('web.investor_registration.login_page',['aif_partner_slug'=>@$aif_partner_slug]);
            }
            else
            {
                $message = ['message'=>'Registration Faild','type'=>'error'];
                $redirect_url = route('web.investor_registration.signup_page',['aif_partner_slug'=>@$aif_partner_slug]);
            }
        }
        else
        {
            $message = ['message'=>'Email already Exist','type'=>'error'];
            $redirect_url = route('web.investor_registration.signup_page',['aif_partner_slug'=>@$aif_partner_slug]);
        }

        $request->session()->flash('response', @$message);
        return redirect(@$redirect_url);
    }

    public function investorRegistrationLogin(Request $request,$aif_partner_slug = "")
    {
       // return $aif_partner_slug;
        $view_data['aif_partner_slug'] = $aif_partner_slug;
        $mail_enable = true;
        $request->validate([
            'email' => 'required'
        ]);

        $mail_smtp_configuration = [];
        $email = @trim($request->email);
        
        $record = AifInvestorRegistration::where('removed','N')->where('email',$email)->first();
        
        $aif_invstr_reg_id = @$record->id;

        if($aif_invstr_reg_id)
        {
            //
            $current_time_stamp = date('Y-m-d H:i:s');
            $minutes_to_add = 15;
            $time = new \DateTime($current_time_stamp);
            $time->add(new \DateInterval('PT' . $minutes_to_add . 'M'));
            $valid_till = $time->format('Y-m-d H:i:s');
            //
            $data['otp'] = mt_rand(100000,999999);
            $data['aif_investor_registration_id'] = $aif_invstr_reg_id;
            $data['valid_till'] = $valid_till;

            $aifInvestorOtpTransObj = new AifInvestorOtpTrans();
            $aifInvestorOtpTransObj->field = $data;
            $return = $aifInvestorOtpTransObj->createAifInvestorRegistration();
           
            //return view("email.aif_investor_otp_email",['otp'=>@$data['otp'] ]);
           
            if($return['status'])
            {
                $message = ['message'=>'Please check your email for a one-time password','type'=>'success'];
                $redirect_url = tokenize_url(route('web.investor_registration.authenticate.otp_view',['aif_partner_slug'=>@$aif_partner_slug]),['aif_invstr_reg_id'=>$aif_invstr_reg_id]);

              //  return $redirect_url;
                $mail_smtp_config_rec = MailSMTPConfiguration::where('removed','N')->where('for_aif','Y')->first();

                $mail_smtp_configuration_id = @$mail_smtp_config_rec->id ?? 0;
                
                $return_1 = MailSMTPConfiguration::getMailSMTPConfigurationById($mail_smtp_configuration_id);
                
                if($return_1['status'])
                {
                    $mail_smtp_configuration = $return_1['data']['record'];
                }

                if(@$mail_smtp_configuration && @$mail_enable)
                { 
                    $from_email = $mail_smtp_configuration->mail_from_address;
                    $to_email = $email;
                    $mail_subject = "Your OTP for login";
                    $mail_data = [ 'otp'=>@$data['otp'] ];
                    Config::set('mail',getMailConfig($mail_smtp_configuration));
                  
                    //dd(Config('mail'));
                    try
                    {
                        Mail::send('email.investor_fund.aif_investor_otp_email',$mail_data,
                        function($message) use($from_email,$to_email,$mail_subject) 
                        {
                            $message->from($from_email);
                            $message->to($to_email, 'APP_NAME')->subject($mail_subject);
                        });
                    }
                    catch(\Exception $e)
                    {
                        //return $e;
                        $message = ['message'=>'Unable to send otp,try again later','type'=>'error'];
                        // $redirect_url = route('web.investor_registration.login_page');
                    }
                }

            }
            else
            {
                $message = ['message'=>'Unable to send otp,try again later','type'=>'error'];
                $redirect_url = route('web.investor_registration.login_page',['aif_partner_slug'=>@$aif_partner_slug]);
            }
        }
        else
        {
            $message = ['message'=>'User Not Found','type'=>'error'];
            $redirect_url = route('web.investor_registration.login_page',['aif_partner_slug'=>@$aif_partner_slug]);
        }
        $request->session()->flash('response', @$message);
        return redirect(@$redirect_url);
    }

    public function investorAuthenticateOtpView(Request $request,$aif_partner_slug = "")
    {
        $view_data = [];
        $aif_partner_id = $request->aif_partner_id;
        $view_data['aif_partner_slug'] = $aif_partner_slug;
        $aif_invstr_reg_id = $request->aif_invstr_reg_id;
        $aif_partner_rec = DB::table('aif_partner')
            ->where('id',$aif_partner_id)
            ->where('removed','N')
            ->first();
        $view_data['aif_partner_rec'] = $aif_partner_rec;

        $view_data['page_title'] = "Authenticate";
        $view_data['aif_invstr_reg_id'] = $aif_invstr_reg_id;
        return view('pages.investor_registration.authenticate_otp_view',$view_data);
    }

    public function investorAuthenticateOtpVerify(Request $request,$aif_partner_slug = "")
    {
       // return $aif_partner_slug;
        $view_data['aif_partner_slug'] = $aif_partner_slug;
        $aif_invstr_reg_id = $request->aif_invstr_reg_id;
        $otp = $request->otp;
        $request->validate([
            'otp' => 'required|digits:6'
        ]);

        $aifInvestorOtpTransRec = AifInvestorOtpTrans::select('aif_investor_otp_trans.*',DB::RAW('IF(CURRENT_TIMESTAMP() <= valid_till AND is_used = "N","Y","N") as is_valid_otp'))
            ->where('removed','N')
            ->where('aif_investor_registration_id',$aif_invstr_reg_id)
            ->orderBy('id','desc')
            ->first();

        if(@$aifInvestorOtpTransRec && @$aifInvestorOtpTransRec->is_valid_otp == 'Y' && @$aifInvestorOtpTransRec->otp == $otp )
        {
            session()->put('aif_invstr_reg_id',$aif_invstr_reg_id);
            AifInvestorOtpTrans::where('id',@$aifInvestorOtpTransRec->id)
                ->update(['is_used' => 'Y']);

            $message = ['message'=>'Login Successful','type'=>'success'];
            $request->session()->flash('response', @$message);

            $redirect_url = tokenize_url(route('web.investor_registration.index',['aif_partner_slug'=>@$aif_partner_slug]),['aif_invstr_reg_id'=>$aif_invstr_reg_id]);
            //return $redirect_url;
        }
        else
        {
            $message = ['message'=>'Invalid OTP','type'=>'error'];
            $redirect_url = tokenize_url(route('web.investor_registration.authenticate.otp_view',['aif_partner_slug'=>@$aif_partner_slug]),['aif_invstr_reg_id'=>$aif_invstr_reg_id]);
        }

        $request->session()->flash('response', @$message);
        return redirect(@$redirect_url);
    }

    public function investorRegistrationLogout(Request $request,$aif_partner_slug = "")
    { 
        $view_data['aif_partner_slug'] = $aif_partner_slug;
       // dd(session('aif_invstr_reg_id'));
        session()->forget('aif_invstr_reg_id');
        $message = ['message'=>'Logout Successful','type'=>'success'];
        $request->session()->flash('response', @$message);
        return redirect()->route('web.investor_registration.login_page',['aif_partner_slug'=>@$aif_partner_slug]);
    }

    public function contributionAgreementView(Request $request,$aif_partner_slug = "")
    {
        $view_data = [];
        $view_data['aif_partner_slug'] = $aif_partner_slug;
        $aif_invester_form_id = $request->aif_invester_form_id;
        $aif_investor_registration_id =  $request->aif_investor_registration_id;
        $aif_invester_reg_rec  = [];
        $return = AifInvestorRegistration::getAifInvestorRegistrationById($aif_investor_registration_id);
        if($return['status'])
        {
            $aif_invester_reg_rec = $return['record'];
        }
        //return $aif_invester_reg_rec;
        $view_data['aif_invester_reg_rec'] = $aif_invester_reg_rec;
        $view_data['page_title'] = "Contribution Agreement";
        return view('pages.investor_registration.contribution_agreement',$view_data);
    }   

    public function noAccess(Request $request,$aif_partner_slug = "")
    {
        $view_data['page_title'] = "No Access";
        return view('pages.investor_registration.no_access',$view_data);
    }

    public function rising_rajasthan()
    {
        $page_title = 'Rising Rajasthan 2024!';
        $page_description = '';
        $page_keywords = '';

        $view_data['page_title'] =  $page_title;
        $view_data['page_keywords'] =  $page_keywords;
        $view_data['page_description'] =  $page_description;

        return view('pages.rising-rajasthan',$view_data);
    }
    public function saveRising(Request $request)
    {
        $input = $request->all();

        $RisingObj = new RisingRajasthan();
        $RisingObj->field['fname'] = $input['fname'];
        $RisingObj->field['lname'] = $input['lname'];
        $RisingObj->field['email'] = $input['email'];
        $RisingObj->field['phone_no'] = $input['phone'];
        $RisingObj->field['linkedin'] = $input['linkedin'];
        $RisingObj->field['profile'] = $input['profile'];
        $return_data = $RisingObj->saveRising();

      return redirect('/rising-rajasthan')->with("success", "Data added successfully");  
    }

    public function rising_response()
    {
        $risingData = DB::table("rising_rajasthans")
                    ->get();   

        return view('pages.rising-rajasthan-response', compact("risingData"));
    }

    public function aim_congress()
    {
        $page_title = 'AIM Congress 2025!';
        $page_description = '';
        $page_keywords = '';

        $view_data['page_title'] =  $page_title;
        $view_data['page_keywords'] =  $page_keywords;
        $view_data['page_description'] =  $page_description;

        return view('pages.aim-congress',$view_data);
    }
    public function saveAim(Request $request)
    {
        $input = $request->all();
        if($input['investment_range'] == 'Other')
            $investment_range = $input['investment_other'];
        else
            $investment_range = $input['investment_range'];

        $AimObj = new AimCongress();
        $AimObj->field['name'] = $input['name'];
        $AimObj->field['email'] = $input['email'];
        $AimObj->field['phone_no'] = $input['phone'];
        $AimObj->field['linkedin'] = $input['linkedin'];
        $AimObj->field['location'] = $input['location'];
        $AimObj->field['role'] = $input['role'];
        $AimObj->field['investment_range'] = $investment_range;
        $AimObj->field['metting_time'] = $input['metting_time'];
        $return_data = $AimObj->saveAim();

      return redirect('/aim-congress')->with("success", "Data added successfully");  
    }

    public function aim_congress_response()
    {
        $AimData = DB::table("aim_congress")
                    ->get();   

        return view('pages.aim-congress-response', compact("AimData"));
    }

}