000

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class VoiceSearchController extends Controller

{

public function __construct(){

\DB::statement("SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));");

}

public function speech(){

return view('admin.dashboard.voice');

}

public function getTotalMembers($voice_text) {

$data = array();

$voiceTextArr[1] = 'total member';

$voiceTextArr[2] = 'total members';

$voiceTextArr[3] = 'all members';

$voiceTextArr[4] = 'all member';

$voiceTextArr[4] = 'mcc wise total member';

$voiceTextArr[4] = 'mcc wise total members';

$is_found = 0;

foreach($voiceTextArr as $key=>$text) {

if($text && str_contains(strtolower($voice_text), $text)){

$is_found = 1;

break;

}

if ($is_found) {

$count = \DB::table('membership_details')->where('is_active', 1)->count();

if($count > 0) {

$data['total_member_count'] = $count;

$data['total_member_text'] = 'Total Member';

} else {

$data['total_member_count'] = 0;

$data['total_member_text'] = 'Total member';

}

} elseif($total_member && str_contains($voice_text, $total_member)) {

$count = \DB::table('membership_details')->where('is_active', 1)->count();

if($count > 0) {

$data['total_member_count'] = $count;

$data['total_member_text'] = 'Total member';

} else {

$data['total_member_count'] = 0;

$data['total_member_text'] = 'Total member';

}

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

}

public function getTotalMembersMccWise(Request $request) {

$voice_text = $request->voice_text;

$data = array();

$voiceTextArr[1] = 'mcc wise';

$voiceTextArr[2] = 'mcc wise members';

$voiceTextArr[3] = 'mcc wise member';

$voiceTextArr[4] = 'total mcc member';

$voiceTextArr[5] = 'total mcc members';

$is_found = 0;

foreach($voiceTextArr as $key=>$text) {

if($text && str_contains(strtolower($voice_text), $text)){

$is_found = 1;

break;

}

if($is_found) {

$mccwise_count = \DB::table('membership_details')->select(\DB::raw('count(mcc_code) as member_count'), 'mcc_name', 'mcc_code')->groupBy('mcc_code')->get();

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

foreach($mccwise_count as $key=>$value) {

$data[$key]['mcc_name'] = $value->mcc_name;

$data[$key]['mcc_code'] = $value->mcc_code;

$data[$key]['member_count'] = $value->member_count;

}

$response['status'] = 1;

$response['mcc_wise_count'] = $data;

} else {

$response['status'] = 0;

$response['mcc_wise_count'] = 'No member.';

}

} else {

$response['status'] = 2;

$response['mcc_wise_count'] = 'No member.';

}

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

}