<?php

namespace App\Http\Controllers;
use App\Annexure_Three;
use Illuminate\Http\Request;
use App\Annexure_Status;

class AnnexureThreeController extends Controller
{
  public function store(Request $request){
  $check = Annexure_Three::query()->where('userid',$request->userid)->count();
  if ($check==1) {
    $atwo =  Annexure_Three::query()->where('userid',$request->userid)->first();
    $declarable_interest = $request->input('declarable_interest');
    $personal_financial_interests = $request->input('personal_financial_interests');
    $value_personal_financial_interests = $request->input('value_personal_financial_interests');
    $professional_duties = $request->input('professional_duties');
    $mtn_business_activities = $request->input('mtn_business_activities');
    $personal_financial_interests_conflict = $request->input('personal_financial_interests_conflict');
    $additional_information_3 = $request->input('additional_information_3');
    $userid = $request->input('userid');
    $username = $request->input('name');


    $atwo->declarable_interest=$declarable_interest;
    $atwo->personal_financial_interests=$personal_financial_interests;
    $atwo->value_personal_financial_interests=$value_personal_financial_interests;
    $atwo->professional_duties=$professional_duties;
    $atwo->mtn_business_activities=$mtn_business_activities;
    $atwo->personal_financial_interests_conflict=$personal_financial_interests_conflict;
    $atwo->additional_information_3=$additional_information_3;
    $atwo->save();
  $data=[
  'userid'=>$userid,
  'name'=>$username,
  ];
  session(['anexthree' => $userid]);
  $jj = Annexure_Status::where('userid',$userid)->first();
  if ($jj !==null && $jj->status !=='Completed' && $jj->status !=='Updated') {
    $status = Annexure_Status::updateOrCreate(['userid' => $userid], [
        'status' => 'Pending'
    ]);
  }else {
    // return 'hi';
    $status = Annexure_Status::updateOrCreate(['userid' => $userid], [
        'status' => 'Updated'
    ]);
    // return route('complete.edit',$userid);
    return redirect()->route('complete.edit',$userid);
  }
  return view('annexures.annexures',$data);
  }else {

  $declarable_interest = $request->input('declarable_interest');
  $personal_financial_interests = $request->input('personal_financial_interests');
  $value_personal_financial_interests = $request->input('value_personal_financial_interests');
  $professional_duties = $request->input('professional_duties');
  $mtn_business_activities = $request->input('mtn_business_activities');
  $personal_financial_interests_conflict = $request->input('personal_financial_interests_conflict');
  $additional_information_3 = $request->input('additional_information_3');
  $userid = $request->input('userid');
  $username = $request->input('name');

  $atwo = new Annexure_Three();

  $atwo->userid=$userid;
  $atwo->declarable_interest=$declarable_interest;
  $atwo->personal_financial_interests=$personal_financial_interests;
  $atwo->value_personal_financial_interests=$value_personal_financial_interests;
  $atwo->professional_duties=$professional_duties;
  $atwo->mtn_business_activities=$mtn_business_activities;
  $atwo->personal_financial_interests_conflict=$personal_financial_interests_conflict;
  $atwo->additional_information_3=$additional_information_3;
  $atwo->save();

  $data=[
  'userid'=>$userid,
  'name'=>$username,
  ];
session(['anexthree' => $userid]);
$status = Annexure_Status::updateOrCreate(['userid' => $userid], [
    'status' => 'Pending'
]);
  return view('annexures.annexures',$data);
  }
  }
}