subMinutes(30); $startDate = '2025-10-01 00:00:00'; $apiTokens = ['bc6c'];//, 'c2b9b3a0','09eabc80-qbna-8027-wwrp-5b5f92fa7412','37ea9be4-azet-6087-avlg-32bb430f3929' //master_slave $rvm_cdr_log = RvmCdrLog::whereIn('api_token', $apiTokens) ->where('timezone_status', '1') ->whereNull('status') ->where('tries', '<', 1) ->where('created_at', '>=', $startDate) ->where('created_at', '<', $date) ->orderBy('id', 'desc') ->limit(50) ->get(); //$rvm_cdr_log = RvmCdrLog::where('api_token', 'bc6c')->where('timezone_status','1')->whereNull('status')->where('tries', '<=', 1)->where('created_at', '<',$date)->orderBy('id', 'desc')->limit(250)->get()->all(); //echo "
";print_r($rvm_cdr_log);die;


        if($rvm_cdr_log)
        {
            foreach($rvm_cdr_log as $rvm_cdr)
            {
                $rvm_queue_list = RvmQueueList::where('rvm_cdr_log_id',$rvm_cdr->id)->get()->first();
               // $rvm_queue_list = RvmQueueList::on('master_slave')->where('rvm_cdr_log_id',$rvm_cdr->id)->get()->first();
                
                //echo "
";print_r($rvm_queue_list);die;

                if($rvm_queue_list)
                {
                    continue;
                }

                else
                if(empty($rvm_cdr->json_data))
                {

                    /*$rvm_cdr_log_update = RvmCdrLog::where('id',$rvm_cdr->id)->get()->first();
                    $rvm_cdr_log_update['status'] ='Not Valid JSON';
                    $rvm_cdr_log_update->save();*/

                    $rvm_cdr->status = 'Not Valid JSON';
                    $rvm_cdr->save();
                    continue;
                }

                $rvm_data = json_decode($rvm_cdr->json_data);
                $this->info("UnsentYesterdayRVMCall ({$rvm_cdr->api_token},{$rvm_cdr->id})");


                $rvm_data = json_decode($rvm_cdr->json_data);
                $rvm_data->id = $rvm_cdr->id;


                $number = preg_replace('/[^0-9]/', '', $rvm_cdr->phone);
                $last10Digit = substr($number, -10);
                $return = ["dialable" => 0,"areacodeTimeZone" => 0,"dialingTime" => 0];
                $numberAreacode = substr(trim($last10Digit), 0, 3);
                $timeZone = $this->getTimezone($numberAreacode);

                if (empty($timeZone)) 
                {
                    $return["dialable"] = 1;
                    $return["dialingTime"] = 1;
                }
                else 
                {
                    if (!empty($timeZone['timezone']))
                    {
                        $return["areacodeTimeZone"] = 1;
                        $time = new DateTime();
                        $time->setTimeZone(new DateTimeZone(timezone_name_from_abbr($timeZone['timezone'])));
                        $currentTime = $time->format('H:i:s');

                        if (strtotime($startTime) < strtotime($currentTime) && strtotime($endTime) > strtotime($currentTime)) 
                        {
                            $return["dialingTime"] = 1;
                            $return["dialable"] = 1;
                        }
                    }
                }

                $rvm_data->status_code = 'rvm_unsent_schedule_job';


                //echo "
";print_r($return);die;

                if($return['dialable'] == 0)
                {
                    $rvm_cdr_log_update = RvmCdrLog::where('id',$rvm_cdr->id)->get()->first();
                    $rvm_cdr_log_update['timezone_status'] ='0';
                    $rvm_cdr_log_update->save();
                }

                //sleep(5);

                if($return["dialable"] == 1)
                {

                    sleep(2);
                    dispatch((new SendRvmJob($rvm_data))->delay(Carbon::now()->addSeconds(5))->onConnection("rvm_unsent_schedule_job"));
                    $this->info("UnsentYesterdayRVMCall rvm_unsent_schedule_job timezone is matched rvm_cdr_log table id ({$rvm_cdr->api_token},{$rvm_cdr->id})");

                }
                else
                {
                    $this->info("UnsentYesterdayRVMCall rvm_unsent_schedule_job timezone is not matched rvm_cdr_log table id ({$rvm_cdr->api_token},{$rvm_cdr->id})");
                }
            }

        }
        else
        {
            $this->info("UnsentYesterdayRVMCall rvm_unsent_schedule_job no data found ");
        }

        
    }

    public function getTimezone($numberAreacode)
    {
        $timeZone = DB::connection('master')->selectOne("SELECT timezone FROM timezone WHERE areacode = :areacode", array('areacode' => $numberAreacode));
        $timeZone = (array)$timeZone;
        return $timeZone;
    }
}