";print_r($data);die;



                    $data['update_duration']='no';

                    if($camp->duration != $data['duration'])
                    {
                        if($camp->duration > $data['duration'])
                        {
                            $percentage = '-down';
                            $data['percentage_label'] = 'a decrease';
                        }
                        else
                        {
                            $percentage ='-up';
                            $data['percentage_label'] = 'an increase';

                        }
                        $data['percentage_inc_dec'] =  $data['duration'].$percentage;

                        $data['update_duration']='yes';

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

                        $sql = "UPDATE campaign set duration = :duration,percentage_inc_dec=:percentage_inc_dec WHERE id = :id";
                        DB::connection($connection)->update($sql, array('id' => $camp->id,'duration'=>$data['duration'],'percentage_inc_dec'=>$data['percentage_inc_dec']));

                        $role = array('1','3');
                        $emails = User::whereIn('role', $role)->where('parent_id',$clientId)->where('is_deleted','0')->select('email','mobile','country_code','role')->get()->all();

                        #send sms for predictive drop calls
                        $setting = config("otp.sms");
                        $smsService = new SmsService($setting["url"], $setting["key"], $setting["token"]);

                        foreach($emails as $key=> $value)
                        {
                            $to = str_replace('-','',$value->country_code.$value->mobile);
                            $message = "Predictive Drop Call Total Calls: ".$data['cdr_total_call'].", Drop Calls: ".$data['cdr_total_drop_call'].", Change Duration: ".$data['duration']."";

                            $response = $smsService->sendMessage($setting["from_number"],$to,$message);
                            Log::debug("PredictiveDialCallDropJobSMS.sendMessage.response", [$response]);

                            $email_send[] = $value->email;
                        }



                        Log::info("PredictiveDialCallDropJob.handle", ["clientId" => $clientId,"predictive calls" => $data]);

                        $smtpSetting = SmtpSetting::on("mysql_3")->where("sender_type", "=", 'system')->first();
                        if(!empty($smtpSetting))
                        {
                            $from = [
                                "address" => empty($smtpSetting->from_email) ? env('DEFAULT_EMAIL') : $smtpSetting->from_email,
                                "name" => empty($smtpSetting->from_name) ? env('DEFAULT_NAME') : $smtpSetting->from_name,
                            ];
                        }
                        else
                        {
                            $smtpSetting = new SmtpSetting;
                            $smtpSetting->mail_driver = "SMTP";
                            $smtpSetting->mail_host = env("PORTAL_MAIL_HOST");
                            $smtpSetting->mail_port = env("PORTAL_MAIL_PORT");
                            $smtpSetting->mail_username = env("PORTAL_MAIL_USERNAME");
                            $smtpSetting->mail_password = env("PORTAL_MAIL_PASSWORD");
                            $smtpSetting->from_name = env("PORTAL_MAIL_SENDER_NAME");
                            $smtpSetting->from_email = env("PORTAL_MAIL_SENDER_EMAIL");
                            $smtpSetting->mail_encryption = env("PORTAL_MAIL_ENCRYPTION");
                            $from = [
                                "address" => empty($smtpSetting->from_email) ? env('DEFAULT_EMAIL') : $smtpSetting->from_email,
                                "name" => empty($smtpSetting->from_name) ? env('DEFAULT_NAME') : $smtpSetting->from_name,
                            ];
                        }

                        $view = "emails.predictiveDropCall";
                        $email = $email_send;
                        //$email = array('mailme@rohitwanchoo.com','abhi2112mca@gmail.com');
                        
                        $super_admin = env('SYSTEM_ADMIN_EMAIL');
                        $admin = explode(',',$super_admin);
                        $sender_super_admin = $admin;

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

                        $bcc = array();
                        $cc = array();

                        Log::info("PredictiveDialCallDropJobSMTP.handle", ["clientId" => $clientId,"predictive calls" => $smtpSetting]);

                        try
                        {
                            $subject = "Drop Ratio Updated For Campaign: ".$camp->title;
                            $mailable = new SystemNotificationMail($from, $view,$subject, $data);
                            $MailServiceToBccCC = new MailServiceToBccCC($clientId, $mailable, $smtpSetting);
                            $MailServiceToBccCC->sendEmail($email,$bcc,$cc);

                            Log::info("PredictiveDialCallDropJobEmail.handle", ["clientId" => $clientId,"MailServiceToBccCC calls" => $mailable]);

                            //
                            $view = "emails.predictiveDropCallSuperAdmin";
                            $mailable_super_admin = new SystemNotificationMail($from, $view,$subject, $data);
                            $MailServiceToBccCC_super_admin = new MailServiceToBccCC($clientId, $mailable_super_admin, $smtpSetting);
                            $MailServiceToBccCC_super_admin->sendEmail($sender_super_admin,$bcc,$cc);
                            Log::info("PredictiveDialCallDropJobEmail.handle", ["clientId" => $clientId,"MailServiceToBccCCSUperAdmin calls" => $mailable]);

                        } 
                        catch (\Throwable $throwable)
                        {
                            $context = buildContext($throwable, [
                                "clientId" => $clientId,
                                "email" => $email
                            ]);

                            Log::error("PredictiveDialCallDropJobError.email.error($email)", $context);
                        }
                    }
                }
                else
                {
                    $data['percentage']=0;
                    $data['duration']=0;

                     Log::info("PredictiveDialCallDropJob.handle", ["clientId" => $clientId,'message'=>"No Cdr Data" ]);
                }
            }
        }
        else
        {
            Log::info("PredictiveDialCallDropJobCampaign.handle", ["clientId" => $clientId,'message'=>'no campaign are automated_duration or predictive dial' ]);
        }
    }
}