";print_r($dnc);die;
    
    try
    {
      $dnc_list = $dnc->data;
      $record_count = $dnc->record_count;
      if (!empty($dnc_list)) {
        return view('cdr_report.ivr_logs', compact('dnc_list','lower_limit', 'page', 'record_count', 'show','searchTerm'))->withErrors($errors);
    } else {
        if (!empty($searchTerm)) {
            // Search term is not found in the table
            return redirect('ivr-log')->with('error', 'Search term not found');
        } else {
            // Table is empty
            return view('cdr_report.ivr_logs',compact('dnc_list','extension_list','lower_limit','page','record_count','show','searchTerm'))->withErrors($errors);
          }
    }
 
    }
  
    catch (BadResponseException $e)
    {
      return back()->with('message',"Error code - (dnc): Oops something went wrong :( Please contact your administrator.)");
    }
  
    catch (RequestException $ex)
    {
      return back()->with('message',"Error code - (dnc): Oops something went wrong :( Please contact your administrator.)");
    }
  }

     function getExtensionList() {
        $url = env('API_URL') . 'extension-group-list';
        $body = array(
            'id' => Session::get('id'),
            'token' => Session::get('tokenId'),
            'level' => Session::get('level')
        );
        try {
            $extension = Helper::PostApi($url, $body);
            return $extension;
        } catch (BadResponseException $e) {
            return back()->with('message', "Error code - (getExtensionList): Oops something went wrong :( Please contact your administrator.)");
        } catch (RequestException $ex) {
            $message = "Page Not Found";
            return redirect('/');
        }
    }


     function getReport(Request $request) {


        $dtmf_list = [];
        $errors = new MessageBag();
       /* $url = env('API_URL') . "dtmf-list";

        try {
            $response = Helper::GetApi($url);
            if ($response->success) {
                $dtmf_list = $response->data;
            } else {
                foreach ($response->errors as $key => $message) {
                    $errors->add($key, $message);
                }
            }
        } catch (RequestException $ex) {
            $errors->add("error", $ex->getMessage());
            return view("cdr_report.press1-campaign", ["errors" => $errors]);
        }
*/
        //echo "
";print_r($dtmf_list);die;
       // $arrDtmf = $dtmf_list;//[0 => 0,1 => 1,2 => 2,3 => 3,4 => 4,5 => 5,6 => 6,7 => 7,8 => 8,9 => 9,'*' => '*', 'TO' => 'TO'];

        $arrDtmf =[0 => 0,1 => 1,2 => 2,3 => 3,4 => 4,5 => 5,6 => 6,7 => 7,8 => 8,9 => 9,'*' => '*', 'TO' => 'TO'];

        ini_set('max_execution_time', 3000);
        $inherit_list = new InheritApiController;
        $disposition_list = $inherit_list->getDisposition();
        if (!is_array($disposition_list)) {
            $disposition_list = array();
        }

        $campaign_list = [];
        $errors = new MessageBag();
        $url = env('API_URL') . "campaigns";
        try {
            $response = Helper::GetApi($url);
            if ($response->success) {
                $campaign_list = $response->data;
            } else {
                foreach ( $response->errors as $key => $message ) {
                    $errors->add($key, $message);
                }
            }
        } catch (RequestException $ex) {
            $errors->add("error", $ex->getMessage());
            return view("cdr_report.press1-campaign", compact("errors", $errors));
        }

        /*$campaign_list = $inherit_list->getCampaign();
        if (!is_array($campaign_list))
        {
            $campaign_list = array();
        }*/

        $did_list = $inherit_list->getDidList();
        if (!is_array($did_list)) {
            $did_list = array(); // checking empty record
        }

        //areacode list
        $url = env('API_URL') . "area-code-list";
        $area_code = Helper::GetApi($url);
        $area_codes = $area_code->data;

        //timezone list
        $url = env('API_URL') . "get-timezone-list";
        $timezone_list = Helper::GetApi($url);
        $timezone_lists = $timezone_list->data;
        
        $extension_list = $this->getExtensionList();
        //var_dump($extension_list);
        
        if ($request->isMethod('get')) {
            $number = str_replace(array('(',')', '_', '-',' '), array(''), $request->number); 
            
            $show = $request->input('show', 10);
            $urlpage = $request->page;
            if (!empty($urlpage)) {
                $page=0;
                $upper_limit=10;
                if ($show == 25 || $show == 50 || $show == 100) {
                $upper_limit = $show;
                 $urlpage = $urlpage - 1;
                    $lower_limit = $urlpage * $show;

                }
  
                else
                    if (!empty($urlpage) && $urlpage > 1)
                {
                    $urlpage = $urlpage - 1;
                    $lower_limit = $urlpage * 10;
                }
                else
                {
                    $lower_limit = 0;
                }

                if ($request->isMethod('post')) {
                $lower_limit = 0;
                $page=1;
                }
   
                $url = env('API_URL') . 'report-press1-campaign';
                $body = array(
                    'level' => Session::get('level'),
                    'number' => $number,
                    'type' => $request->type,
                    'extension' => $request->extension,
                    'did_numbers'=>$request->did_numbers,
                    'dtmf'=>$request->dtmf,
                    'timezone_value'=>$request->timezone_value,
                    'campaign' => $request->campaign,
                    'disposition' => $request->disposition,
                    'start_date' => $request->start_date,
                    'end_date' => $request->end_date,
                    'lower_limit' => $lower_limit,
                    'upper_limit' => $upper_limit,
                );

                      if(!empty($request->dtmf))
                {
                $dtmf_value = $request->dtmf;

                }
                else
                {
                $dtmf_value = 0;

                }


                try {
                    //echo "s";die;
                    $cdr_report = Helper::PostApi($url, $body);
                   // echo "
";print_r($cdr_report);die;
                    if ($cdr_report->success == 'true') {
                        $record_count = $cdr_report->record_count;
                        $report = $cdr_report->data;
                        return view('cdr_report.press1-campaign', compact('disposition_list','show', 'upper_limit','extension_list', 'report', 'campaign_list', 'record_count', 'lower_limit','did_list','area_codes','timezone_lists','page','arrDtmf','dtmf_value'));
                    }
                    if ($cdr_report->success == 'false') {
                        return view('cdr_report.press1-campaign', compact('disposition_list','show', 'upper_limit','extension_list', 'report', 'campaign_list', 'record_count', 'lower_limit','did_list','area_codes','timezone_lists','page','arrDtmf','dtmf_value'));
                    }
                } catch (BadResponseException $e) {
                    return back()->with('message', "Error code - (press1-campaign): Oops something went wrong :( Please contact your administrator.)");
                } catch (RequestException $ex) {
                    return back()->with('message', "Error code - (press1-campaign): Oops something went wrong :( Please contact your administrator.)");
                }
            } else {
                if (empty(Session::get('tokenId'))) {
                    return redirect('/');
                }
                return view('cdr_report.press1-campaign', compact('campaign_list', 'extension_list', 'disposition_list','did_list','area_codes','timezone_lists','show','arrDtmf'));
            }
        } elseif ($request->isMethod('post')) {
            if ($request->submit_download == '1') {
                $inherit_list = new InheritApiController;
                $headerUserDetails = $inherit_list->headerUserDetails();
                $lower_limit = 0;
            $number = str_replace(array('(',')', '_', '-',' '), array(''), $request->number); 

                $url = env('API_URL') . 'report-press1-campaign';
                $body = array(
                    'level' => Session::get('level'),
                    'number' => $number,
                    'type' => $request->type,
                    'extension' => $request->extension,
                    'did_numbers'=>$request->did_numbers,
                    'dtmf'=>$request->dtmf,
                    'timezone_value'=>$request->timezone_value,
                    'campaign' => $request->campaign,
                    'disposition' => $request->disposition,
                    'start_date' => $request->start_date,
                    'end_date' => $request->end_date,
                    'lower_limit' => $lower_limit,
                    //'upper_limit' => $upper_limit,
                    'route' => $request->route,

                );
                try {
                    $number = $number;
                    $type = $request->type;
                    $extension = $request->extension;
                    $campaign = $request->campaign;
                    $route = $request->route;
                    $start_date = $request->start_date;
                    $end_date = $request->end_date;
                    $disposition = $request->disposition;
                    $cdr_report = Helper::PostApi($url, $body);

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






                    if ($cdr_report->success == 'true') {
                        $record_count = $cdr_report->record_count;
                        $report = $cdr_report->data;
                        $logo = $headerUserDetails->data->logo;
                        $company_name = $headerUserDetails->data->company_name;
                        $mobile = $headerUserDetails->data->mobile;
                        $email = $headerUserDetails->data->email;
                        $pdf = PDF::loadView('cdr_report.press1-campaign_pdf', compact('report', 'record_count', 'campaign_list', 'disposition_list', 'lower_limit', 'extension_list', 'number', 'type', 'extension', 'campaign', 'route', 'start_date', 'end_date', 'disposition', 'logo', 'company_name', 'mobile', 'email','arrDtmf'))->setPaper('a4', 'landscape');
                        return $pdf->download('press1-campaign.pdf');
                    }
                    if ($cdr_report->success == 'false') {
                        return redirect('/');
                    }
                } catch (BadResponseException $e) {
                    return back()->with('message', "Error code - (press1-campaign): Oops something went wrong :( Please contact your administrator.)");
                } catch (RequestException $ex) {
                    $message = "Page Not Found";
                    return redirect('/');
                }
            } else if ($request->submit_download == '2') {

                $inherit_list = new InheritApiController;
                $headerUserDetails = $inherit_list->headerUserDetails();
                $timezone = $headerUserDetails->data->timezone;
                $lower_limit = 0;
            $number = str_replace(array('(',')', '_', '-',' '), array(''), $request->number); 

                $url = env('API_URL') . 'report-press1-campaign';
                $body = array(
                    'id' => Session::get('id'),
                    'token' => Session::get('tokenId'),
                    'level' => Session::get('level'),
                    'did_numbers'=>$request->did_numbers,
                    'dtmf'=>$request->dtmf,
                    'timezone_value'=>$request->timezone_value,
                    'number' => $number,
                    'type' => $request->type,
                    'extension' => $request->extension,
                    'campaign' => $request->campaign,
                    'route' => $request->route,
                    'disposition' => $request->disposition,
                    'start_date' => $request->start_date,
                    'end_date' => $request->end_date,
                    'lower_limit' => $lower_limit,
                );

                try {
                    $user_array = array('route', "type");
                    $users = Helper::PostApi($url, $body);
                    foreach ($users->data as $user) {
                        $user_array[] = array(
                            'route' => $user->route,
                            'type' => $user->type,
                        );
                    }

                    $filename_excel = 'CDR_REPORT_'.date('Y-m-d').".csv";

                    header("Content-type: text/csv");
                    header("Content-Disposition: attachment; filename=".$filename_excel);
                    header("Pragma: no-cache");
                    header("Expires: 0");
                    $reviews = $user_array;
                    $columns = array('Extension', 'Campaign', 'CLI', 'Route', 'Type', 'Number', 'Disposition', 'Duration' , 'State / City' ,'Start Time', 'End Time', 'Recording');
                    $file = fopen('php://output', 'w');
                    fputcsv($file, $columns);
                    if (!empty($users->data)) {

                        $excel_data = array();
                        foreach ($users->data as $key => $val) {

                         $state_city= '-';
                           if(!empty($val->area_code))
                           {
                            foreach($area_codes as $key => $area)
                        {
                            if($area->areacode == $val->area_code)
                            {
                                 $state_city = $area->state_name.' / '.$area->city_name;
                            } 
                        }
                           }
                           else
                           {
                            $state_city= '-';
                           }

                        

                        //extension

                        foreach($extension_list as $key => $extension)
                        {
                            if($extension->extension == $val->extension)
                            {
                                $extension_name = $extension->first_name.' '.$extension->last_name.'-'.$val->extension;
                            }
                            else
                            if($extension->alt_extension == $val->extension)
                            {
                                $extension_name = $extension->first_name.' '.$extension->last_name.'-'.$val->extension;
                            }
                            else
                            if($val->extension == NULL)
                            {
                                $extension_name = '-';
                            }
                            else
                            {
                                $num = $val->extension;
                                $numlength = strlen((string)$num);
                                if($numlength > 9)
                                {
                                    $extension_name = $val->extension;
                                }
                            }
                        }

                        $excel_data[$key]['extension_name'] = $extension_name;

                        //campaign

                        if (!empty($val->campaign_id))
                        {
                            foreach ($campaign_list as $key => $campaign)
                            {
                                if ($campaign->id == $val->campaign_id)
                                {
                                    if (!empty($campaign->title))
                                    {
                                        $campaign_name = $campaign->title;
                                    }                                
                                }
                            }
                        }
                        else
                        {
                            $campaign_name = '-';
                        }

                        //cli

                        if(!empty($val->cli))
                        {
                            $cli = $val->cli;
                        }
                        else
                        {
                            $cli ='-';
                        }

                        //route

                        if(!empty($val->route))
                        {
                            $route = $val->route;
                        }
                        else
                        {
                            $route ='-';
                        }

                        //type

                        if(!empty($val->type))
                        {
                            if($val->type == 'manual')
                                $type = 'Manual';
                            else
                            if($val->type == 'dialer')
                                $type = 'Dialer';
                            else
                            if($val->type == 'predictive_dial')
                                $type = 'Predictive';
                            else
                                $type='-';
                        }
                        else
                        {
                            $type ='-';
                        }

                        //number

                        if(!empty($val->number))
                        {
                            $number = $val->number;
                        }
                        else
                        {
                            $number ='-';
                        }

                        //disposition

                        $disposition_name ='-';//$val->disposition_id;

                        if (!empty($val->disposition_id)) 
                        {
                            foreach ($disposition_list as $key => $dispo) 
                            {
                                if ($dispo->id == $val->disposition_id) 
                                {
                                    $disposition_name = $dispo->title;
                                }
                                else
                                if($val->disposition_id == '101')
                                {
                                    $disposition_name = "No Agent Available";
                                    break;
                                }
                                else
                                if($val->disposition_id == '102')
                                {
                                    $disposition_name = "AMD Hangup";
                                    break;
                                }
                                else
                                if($val->disposition_id == '103')
                                {
                                    $disposition_name = "Voice Drop";
                                    break;
                                }
                                else
                                if($val->disposition_id == '104')
                                {
                                    $disposition_name = "Cancelled By User";
                                    break;
                                }
                                else
                                if($val->disposition_id == '105')
                                {
                                    $disposition_name = "Channel Unavailable";
                                    break;
                                }
                                else
                                if($val->disposition_id == '106')
                                {
                                    $disposition_name = "Congestion";
                                    break;
                                }
                                else
                                if($val->disposition_id == '107')
                                {
                                    $disposition_name = "Line Busy";
                                    break;
                                }

                                else
                                if($val->disposition_id == '108')
                                {
                                    $disposition_name = "CRM CALL";
                                    break;
                                }
                            }
                        }
                        else
                        {
                            $disposition_name = '-';
                        }


                       

                        //recording
                        if(!empty($val->call_recording))
                        {
                            $recording = $val->call_recording;
                        }
                        else
                        {
                            $recording = '-';
                        }


                        //time

                        if(!empty($timezone))
                        {
                            if(!empty($val->start_time))
                            {
                                $utc_start_time = $val->start_time;
                                $dt_start_time = new DateTime($utc_start_time);
                                $tz = new DateTimeZone($timezone); // or whatever zone you're after
                                $dt_start_time->setTimezone($tz);
                                $start_time = $dt_start_time->format('Y-m-d H:i:s');

                            }
                            else
                            {
                                $start_time='-';
                            }

                            if(!empty($val->end_time))
                            {
                                $utc_end_time = $val->end_time;
                                $dt_end_time = new DateTime($utc_end_time);
                                $tz = new DateTimeZone($timezone); // or whatever zone you're after
                                $dt_end_time->setTimezone($tz);    
                                $end_time = $dt_end_time->format('Y-m-d H:i:s');
                            }

                            else
                            {
                                $end_time='-';
                            }
                        }

                        else
                        {
                            if(!empty($val->start_time))
                            {
                                $start_time = $val->start_time;
                            }
                            else
                            {
                                $start_time='-';
                            }

                            if(!empty($val->end_time))
                            {
                                $end_time = $val->end_time;
                            }
                            else
                            {
                                $end_time='-';
                            }
                        }

                        fputcsv($file, array($extension_name,$campaign_name,$cli,$route, $type, $number, $disposition_name, $val->duration, $state_city, $start_time, $end_time,$recording));


                      
                        }
                    }

                    

                    exit();

                    if ($cdr_report->success == 'true') {
                        $record_count = $cdr_report->record_count;
                        $report = $cdr_report->data;
                        return view('cdr_report.press1-campaign', compact('report', 'record_count', 'campaign_list', 'disposition_list', 'lower_limit', 'extension_list','arrDtmf'));
                    }
                    if ($cdr_report->success == 'false') {
                        return redirect('/');
                    }
                } catch (BadResponseException $e) {
                    return back()->with('message', "Error code - (press1-campaign): Oops something went wrong :( Please contact your administrator.)");
                } catch (RequestException $ex) {
                    $message = "Page Not Found";
                    return redirect('/');
                }
            } else {

        
        $urlpage = $request->page;
        $show = $request->input('show', 10);
        $page=0;
        $upper_limit=10;
        if ($show == 25 || $show == 50 || $show == 100) {
            $upper_limit = $show;
        }

        if (!empty($urlpage) && $urlpage > 1)
        {
            $urlpage = $urlpage - 1;
            $lower_limit = $urlpage * 10;
        }
        else
        {
            $lower_limit = 0;
        }

        if ($request->isMethod('post')) {
           $lower_limit = 0;
           $page=1;
        }

            $number = str_replace(array('(',')', '_', '-',' '), array(''), $request->number); 
                
                $url = env('API_URL') . 'report-press1-campaign';
                $body = array(
                    'id' => Session::get('id'),
                    'level' => Session::get('level'),
                    'token' => Session::get('tokenId'),
                    'number' => $number,
                    'did_numbers'=>$request->did_numbers,
                    'dtmf'=>$request->dtmf,
                    'timezone_value'=>$request->timezone_value,
                    'type' => $request->type,
                    'extension' => $request->extension,
                    'campaign' => $request->campaign,
                    'route' => $request->route,
                    'disposition' => $request->disposition,
                    'start_date' => $request->start_date,
                    'end_date' => $request->end_date,
                    'lower_limit' => $lower_limit,
                    'upper_limit' => $upper_limit,
                );

                if(!empty($request->dtmf))
                {
                $dtmf_value = $request->dtmf;

                }
                else
                {
                $dtmf_value = 0;

                }


                    //echo'
';print_r($body); exit;

                try {

                    $cdr_report = Helper::PostApi($url, $body);
                    //echo'
';print_r($cdr_report); exit;
                    if ($cdr_report->success == 'true') {
                        $record_count = $cdr_report->record_count;
                        $report = $cdr_report->data;
                        session()->flash("success", $cdr_report->message);
                        return view('cdr_report.press1-campaign', compact('report', 'record_count','show', 'campaign_list', 'disposition_list', 'lower_limit', 'extension_list','did_list','area_codes','timezone_lists','page','arrDtmf','dtmf_value'));
                    }
                    if ($cdr_report->success == 'false') {
                        return redirect('/');
                    }
                } catch (BadResponseException $e) {
                    return back()->with('message', "Error code - (press1-campaign): Oops something went wrong :( Please contact your administrator.)");
                } catch (RequestException $ex) {
                    $message = "Page Not Found";
                    return redirect('/');
                }
            }
        }
    }


  

    public function findAllDtmf($value = "")
    {
        $body = array('campaign_id' => $value);
        $url = env('API_URL') . 'all-dtmf';
        $response = Helper::PostApi($url, $body);
       // echo "
";print_r($response);die;
        if ($response->success)
        {
            session()->flash("success", $response->message);
            echo json_encode(array('status' => $response->data,  'message' =>  $response->message));
        }
        else
        {
            session()->flash("message", $response->message);
            echo json_encode(array('status' => "false", 'message' =>  $response->message));
        }
    }
}