@forelse($survey_questions as $survey_questions) @if($survey_questions->type == 2) @php($questionsAnswers_2 = App\Models\Tenant\SurveyAnswer::where('survey_question_id',$survey_questions->id)->get()) @for($i = 1; $i <= $questionsAnswers_2->count() ; $i++) @php($answer[$i] = 0) @endfor @foreach($survey_submit as $survey_submit_2) @php($answers_2 = json_decode($survey_submit_2->answers)) @php($survey_questions_id_2 = $survey_questions->id) @if(isset($answers_2->$survey_questions_id_2)) @php( $result_2= $answers_2->$survey_questions_id_2) @forelse( $questionsAnswers_2 as $questionsAnswer) @if(in_array ($questionsAnswer->id , $result_2 )) @php($answer[$loop->index + 1] += 1) @endif @empty @endforelse @endif @endforeach @forelse( $questionsAnswers_2 as $questionsAnswer) @empty @endforelse @elseif($survey_questions->type == 3) @php($questionsAnswers = App\Models\Tenant\SurveyAnswer::where('survey_question_id',$survey_questions->id)->get()) @for($i = 1; $i <= $questionsAnswers->count() ; $i++) @php($answer[$i] = 0) @endfor @foreach($survey_submit as $survey_submit_3) @php($answers_3 = json_decode($survey_submit_3->answers)) @php($survey_questions_id_3 = $survey_questions->id) @if(isset($answers_3->$survey_questions_id_3)) @php( $result_3= $answers_3->$survey_questions_id_3) @forelse( $questionsAnswers as $questionsAnswer) @if( $result_3 == $questionsAnswer->id) @php($answer[$loop->index + 1] += 1) @endif @empty @endforelse @endif @endforeach @forelse( $questionsAnswers as $questionsAnswer) @empty @endforelse @elseif($survey_questions->type == 4) @php($sumStar1 = 0) @php($sumStar2 = 0) @php($sumStar3 = 0) @php($sumStar4 = 0) @php($sumStar5 = 0) @foreach($survey_submit as $survey_submit_4) @php($answers_4 = json_decode($survey_submit_4->answers)) @php($survey_questions_id_4 = $survey_questions->id) @if(isset($answers_4->$survey_questions_id_4)) @php( $result_4= $answers_4->$survey_questions_id_4) @if( $result_4 == 1) @php($sumStar1 += 1) @elseif($result_4 == 2) @php($sumStar2 += 1) @elseif($result_4 == 3) @php($sumStar3 += 1) @elseif($result_4 == 4) @php($sumStar4 += 1) @elseif($result_4 == 5) @php($sumStar5 += 1) @endif @endif @endforeach @elseif($survey_questions->type == 5 ) @php($sumresult5_1 = 0) @php($sumresult5_2 = 0) @php($sumresult5_3 = 0) @php($sumresult5_4 = 0) @php($sumresult5_5 = 0) @foreach($survey_submit as $survey_submit_5) @php($answers_5 = json_decode($survey_submit_5->answers)) @php($survey_questions_id_5 = $survey_questions->id) @if(isset($answers_5->$survey_questions_id_5)) @php( $result_5= $answers_5->$survey_questions_id_5) @if( $result_5 == 0) @php($sumresult5_1 += 1) @elseif($result_5 == 1) @php($sumresult5_2 += 1) @elseif($result_5 == 2) @php($sumresult5_3 += 1) @elseif($result_5 == 3) @php($sumresult5_4 += 1) @elseif($result_5 == 4) @php($sumresult5_5 += 1) @endif @endif @endforeach @elseif($survey_questions->type == 6 ) @php($sumYes_6 = 0) @php($sumNo_6 = 0) @foreach($survey_submit as $survey_submit_6) @php($answers_6 = json_decode($survey_submit_6->answers)) @php($survey_questions_id_6 = $survey_questions->id) @if(isset($answers_6->$survey_questions_id_6)) @php( $result_6= $answers_6->$survey_questions_id_6) @if( $result_6 == 1) @php($sumYes_6 += 1) @elseif($result_6 == 0) @php($sumNo_6 += 1) @endif @endif @endforeach @elseif($survey_questions->type == 7 ) @php($sumAgree = 0) @php($sumUndecided = 0) @php($sumDisagree = 0) @foreach($survey_submit as $survey_submit_7) @php($answers_7 = json_decode($survey_submit_7->answers)) @php($survey_questions_id_7 = $survey_questions->id) @if(isset($answers_7->$survey_questions_id_7)) @php( $result_7= $answers_7->$survey_questions_id_7) @if( $result_7 == 2) @php($sumAgree += 1) @elseif($result_7 == 1) @php($sumUndecided += 1) @elseif($result_7 == 0) @php($sumDisagree += 1) @endif @endif @endforeach @elseif($survey_questions->type == 8 ) @php($sumPoor = 0) @php($sumBad = 0) @php($sumNeutral = 0) @php($sumGood = 0) @php($sumVeryGood = 0) @foreach($survey_submit as $survey_submit_8) @php($answers_8 = json_decode($survey_submit_8->answers)) @php($survey_questions_id_8 = $survey_questions->id) @if(isset($answers_8->$survey_questions_id_8)) @php( $result_8= $answers_8->$survey_questions_id_8) @if( $result_8 == 0) @php($sumPoor += 1) @elseif($result_8 == 1) @php($sumBad += 1) @elseif($result_8 == 2) @php($sumNeutral += 1) @elseif($result_8 == 3) @php($sumGood += 1) @elseif($result_8 == 4) @php($sumVeryGood += 1) @endif @endif @endforeach @elseif($survey_questions->type == 9 ) @php($sumVeryPoor_9 = 0) @php($sumPoor_9 = 0) @php($sumBad_9 = 0) @php($sumNeutral_9 = 0) @php($sumGood_9 = 0) @php($sumVeryGood_9 = 0) @php($sumExceptional_9 = 0) @foreach($survey_submit as $survey_submit_9) @php($answers_9 = json_decode($survey_submit_9->answers)) @php($survey_questions_id_9 = $survey_questions->id) @if(isset($answers_9->$survey_questions_id_9)) @php( $result_9= $answers_9->$survey_questions_id_9) @if( $result_9 == 0) @php($sumVeryPoor_9 += 1) @elseif($result_9 == 1) @php($sumPoor_9 += 1) @elseif($result_9 == 2) @php($sumBad_9 += 1) @elseif($result_9 == 3) @php($sumNeutral_9 += 1) @elseif($result_9 == 4) @php($sumGood_9 += 1) @elseif($result_9 == 5) @php($sumVeryGood_9 += 1) @elseif($result_9 == 6) @php($sumExceptional_9 += 1) @endif @endif @endforeach @elseif($survey_questions->type == 10 ) @php($sumExtremelyPoor_10 = 0) @php($sumVeryPoor_10 = 0) @php($sumPoor_10 = 0) @php($sumBad_10 = 0) @php($sumNeutral_10 = 0) @php($sumGood_10 = 0) @php($sumVeryGood_10 = 0) @php($sumExceptional_10 = 0) @php($sumExtraordinarily_10 = 0) @foreach($survey_submit as $survey_submit_10) @php($answers_10 = json_decode($survey_submit_10->answers)) @php($survey_questions_id_10 = $survey_questions->id) @if(isset($answers_10->$survey_questions_id_10)) @php( $result_10= $answers_9->$survey_questions_id_10) @if( $result_10 == 0) @php($sumExtremelyPoor_10 += 1) @elseif($result_10 == 1) @php($sumVeryPoor_10 += 1) @elseif($result_10 == 2) @php($sumPoor_10 += 1) @elseif($result_10 == 3) @php($sumBad_10 += 1) @elseif($result_10 == 4) @php($sumNeutral_10 += 1) @elseif($result_10 == 5) @php($sumGood_10 += 1) @elseif($result_10 == 6) @php($sumVeryGood_10 += 1) @elseif($result_10 == 7) @php($sumExceptional_10 += 1) @elseif($result_10 == 9) @php($sumExtraordinarily += 1) @endif @endif @endforeach @endif @empty @endforelse

Question	answers	Number Of submited
{{$survey_questions->title}}	{{ $questionsAnswer->title}}	{{$answer[$loop->index + 1]}}
{{$survey_questions->title}}	{{ $questionsAnswer->title}}	{{$answer[$loop->index + 1]}}
{{$survey_questions->title}}	1 star	{{$sumStar1}}
	2 star	{{$sumStar2}}
	3 star	{{$sumStar3}}
	4 star	{{$sumStar4}}
	5 star	{{$sumStar5}}
{{$survey_questions->title}}	😀	{{$sumresult5_1}}
	😄	{{$sumresult5_2}}
	😐	{{$sumresult5_3}}
	😠	{{$sumresult5_4}}
	😡	{{$sumresult5_5}}
{{$survey_questions->title}}	Yes	{{$sumYes_6}}
	No	{{$sumNo_6}}
{{$survey_questions->title}}	Agree	{{$sumAgree}}
	Undecided	{{$sumUndecided}}
	Disagree	{{$sumDisagree}}
{{$survey_questions->title}}	Poor	{{$sumPoor}}
	Bad	{{$sumBad}}
	Neutral	{{$sumNeutral}}
	Good	{{$sumGood}}
	Very Good	{{$sumVeryGood}}
{{$survey_questions->title}}	Very Poor	{{$sumVeryPoor_9}}
	Poor	{{$sumPoor_9}}
	Bad	{{$sumBad_9}}
	Neutral	{{$sumNeutral_9}}
	Good	{{$sumGood_9}}
	Very Good	{{$sumVeryGood_9}}
	Exceptional Good	{{$sumExceptional_9}}
{{$survey_questions->title}}	Extremely Poor	{{$sumExtremelyPoor_10}}
	Very Poor	{{$sumVeryPoor_10}}
	Poor	{{$sumPoor_9}}
	Bad	{{$sumBad_10}}
	Neutral	{{$sumNeutral_9}}
	Good	{{$sumGood_9}}
	Very Good	{{$sumVeryGood_10}}
	Exceptional Good	{{$sumExceptional_10}}
	Extraordinarily Magnificent	{{$sumExtraordinarily_10}}
There is no data found

@forelse($survey_submit as $survey_submit) @forelse($survey_questions as $survey_question ) @empty @endforelse @empty @endforelse

Customer Name	Question	Answers
{{$survey_submit->name}}	{{$survey_question->title}}	@php($customerAnswers = json_decode($survey_submit->answers)) @php($customer_survey_questions_id = $survey_question->id) @if(isset($customerAnswers->$customer_survey_questions_id)) @php( $customerResult = $customerAnswers->$customer_survey_questions_id) @if($survey_question->type == 1) {{$customerResult}} @elseif($survey_question->type == 2) @foreach($customerResult as $customerResult) @php($customerAnswers_3 = App\Models\Tenant\SurveyAnswer::where('id',$customerResult)->get()) {{$customerAnswers_3[0]->title}} @endforeach @elseif($survey_question->type == 3) @php($customerAnswers_3 = App\Models\Tenant\SurveyAnswer::where('id',$customerResult)->get()) {{$customerAnswers_3[0]->title}} @elseif($survey_question->type == 4) @if($customerResult == 1) @elseif($customerResult == 2) @elseif($customerResult == 3) @elseif($customerResult == 4) @elseif($customerResult == 5) @endif @elseif($survey_question->type == 5) @if($customerResult == 0) 😡 @elseif($customerResult == 1) 😠 @elseif($customerResult == 2) 😐 @elseif($customerResult == 3) 😄 @elseif($customerResult == 4) 😀 @endif @elseif($survey_question->type == 6) @if($customerResult == 0) No @else Yes @endif @elseif($survey_question->type == 7) @if($customerResult == 0) Disagree @elseif($customerResult == 1) Undecided @elseif($customerResult == 2) Agree @endif @elseif($survey_question->type == 8) @if($customerResult == 0) Poor @elseif($customerResult == 1) Bad @elseif($customerResult == 2) Neutral @elseif($customerResult == 3) Good @elseif($customerResult == 4) Very Good @endif @elseif($survey_question->type == 9) @if($customerResult == 0) Very Poor @elseif($customerResult == 1) Poor @elseif($customerResult == 2) Bad @elseif($customerResult == 3) Neutral @elseif($customerResult == 4) Good @elseif($customerResult == 5) Very Good @elseif($customerResult == 6) Exceptional @endif @elseif($survey_question->type == 10) @if($customerResult == 0) Extremely Poor @elseif($customerResult == 1) Very Poor @elseif($customerResult == 2) Poor @elseif($customerResult == 3) Bad @elseif($customerResult == 4) Neutral @elseif($customerResult == 5) Good @elseif($customerResult == 6) Very Good @elseif($customerResult == 7) Exceptional @elseif($customerResult == 9) Extraordinarily Magnificent @endif @endif @else - @endif
-
There is no data found