";print($record->friendlyName);
        }
*/


            foreach ($local as $list) {
                $temp = [
                    "",
                    $list->phoneNumber,
                    $list->region,
                    "Metered"
                ];
                $result[] = $temp;
            }
            Log::info('result reached', ['result' => $result]);
        } catch (\Twilio\Exceptions\RestException $e) {
            Log::error('Twilio REST Exception', ['message' => $e->getMessage()]);
            throw new Exception('Error fetching phone numbers from Twilio: ' . $e->getMessage());
            // return response()->json(['message' => 'Error fetching phone numbers from Twilio: ' . $e->getMessage()], 500);
        } catch (Exception $e) {
            Log::error('General Exception', ['message' => $e->getMessage()]);
            throw new Exception('Error: ' . $e->getMessage());
        }

        return $result;
    }


    public function buySaveDidPlivo()
    {
        $response = $this->model->buySaveDidPlivo($this->request);
        return response()->json($response);
    }

    public function buySaveDidTelnyx()
    {
        $response = $this->model->buySaveDidTelnyx($this->request);
        return response()->json($response);
    }


    public function buySaveDidTwilio()
    {
        $response = $this->model->buySaveDidTwilio($this->request);
        return response()->json($response);
    }



    /**
     * buy and save Did
     * @return type
     */
    public function buySaveDid()
    {
        $response = $this->model->buySaveDid($this->request);
        return response()->json($response);
    }

    /**
     * @OA\Post(
     *     path="/upload-did",
     *     tags={"DID"},
     *     summary="Upload a DID Excel file",
     *     description="Uploads a DID Excel file (.xlsx or .xls), processes CLI records, checks for duplicates, and inserts into both master and client-specific databases.",
     *     operationId="uploadDid",
     *     security={{"Bearer":{}}},
     *     @OA\RequestBody(
     *         required=true,
     *         @OA\MediaType(
     *             mediaType="multipart/form-data",
     *             @OA\Schema(
     *                 required={"file", "upload_title"},
     *                 @OA\Property(
     *                     property="file",
     *                     type="string",
     *                    
     *                     description="The Excel file (.xlsx or .xls) containing DID CLIs"
     *                 ),
     *                 @OA\Property(
     *                     property="upload_title",
     *                     type="string",
     *                     example="Weekly Upload",
     *                     description="Title to describe this upload batch"
     *                 )
     *             )
     *         )
     *     ),
     *     @OA\Response(
     *         response=200,
     *         description="DID file processed successfully",
     *         @OA\JsonContent(
     *             @OA\Property(property="success", type="string", example="true"),
     *             @OA\Property(property="message", type="string", example="Did added successfully")
     *         )
     *     ),
     *     @OA\Response(
     *         response=400,
     *         description="Missing file or invalid input",
     *         @OA\JsonContent(
     *             @OA\Property(property="success", type="string", example="false"),
     *             @OA\Property(property="message", type="string", example="The did file field is required.")
     *         )
     *     ),
     *     @OA\Response(
     *         response=409,
     *         description="Duplicate CLI found in file or database",
     *         @OA\JsonContent(
     *             @OA\Property(property="success", type="string", example="false"),
     *             @OA\Property(property="message", type="string", example="Duplicate CLIs found in the file.")
     *         )
     *     ),
     *     @OA\Response(
     *         response=422,
     *         description="Excel file could not be read or is malformed",
     *         @OA\JsonContent(
     *             @OA\Property(property="success", type="string", example="false"),
     *             @OA\Property(property="message", type="string", example="Unable to read excel. No ReaderType or WriterType could be detected.")
     *         )
     *     ),
     *     @OA\Response(
     *         response=500,
     *         description="Server error during file processing",
     *         @OA\JsonContent(
     *             @OA\Property(property="success", type="string", example="false"),
     *             @OA\Property(property="message", type="string", example="Did not added successfully, File is empty")
     *         )
     *     )
     * )
     */


    public function uploadDid(Request $request)
    {
        if (!$request->has('file')) {
            return response()->json([
                'success' => false,
                'message' => 'The did file field is required.',
            ], 400);
        }
        if ($request->has('file')) {
            //path of uploaded file
            $filename = $this->request->input('file');
            $filePath = env('FILE_UPLOAD_PATH') . '/' . $filename;

            Log::info('reached filepath', ['filePath' => $filePath]);
            //  $filePath = base_path()."/uploads/".$this->request->input('file');
            //$filePath = base_path()."\public\api/".$this->request->input('file');
            // $filePath= ('C:/xampp/htdocs/uploads/'.$this->request->input('file'));


            try {
                if (!empty($filePath)) {
                    $database = "mysql_" . $request->auth->parent_id;

                    try {
                        // switch to dynamic connection
                        $connection = DB::connection($database);
                        $reader = Excel::toArray(new Excel(), $filePath);
                        Log::info('reached reader', ['reader' => $reader]);
                    } catch (\Exception $e) {
                        return array(
                            'success' => 'false',
                            'message' => 'Unable to read excel' . $e->getMessage()
                        );
                    }

                    $cliArray = array(); // Create an empty array to store unique CLIs
                    $did = null; // Initialize the variable
                    $masterDid = null;
                    if (!empty($reader)) {
                        $count = 0;

                        foreach ($reader as $row) {
                            $i = 0;
                            $add = 0;
                            foreach ($row as $item => $value) {
                                if ($item != 0) {
                                    // Check if the CLI already exists in the array
                                    if (in_array($value[0], $cliArray)) {
                                        return array(
                                            'success' => 'false',
                                            'message' => 'Duplicate CLIs found in the file.',
                                        );
                                    }

                                    // Add the CLI to the array
                                    $cliArray[] = $value[0];
                                    // Check if the CLI already exists in the database
                                    $existingCli = $connection->table('did')
                                        ->where('cli', $value[0])
                                        ->first();
                                    Log::info('reached cliArray', ['cliArray' => $cliArray]);

                                    if ($existingCli) {
                                        // CLI already exists in the database, skip insertion
                                        continue;
                                        return array(
                                            'success' => 'false',
                                            'message' => 'Duplicate CLI found in the database.',
                                        );
                                    }

                                    // Insert the CLI into the database client_3
                                    $did = new \App\Model\Client\Did([
                                        'cli' => $value[0],
                                        'area_code' => substr($value[0], 1, 3),
                                        'sms' => 0,
                                        'voip_provider' => $value[1]
                                    ]);
                                    Log::info('reached did', ['did' => $did]);

                                    $connection->table('did')->insert($did->toArray());

                                    // Insert the CLI into the master database
                                    $data1 = [
                                        'parent_id' => $request->auth->parent_id,
                                        'cli' => $value[0],
                                        'user_id' => $request->auth->id,
                                        'area_code' => substr($value[0], 1, 3),
                                        'country_code' => '+1',
                                        'provider' => 1,
                                        'voip_provider' => $value[1]

                                    ];
                                    Log::info('reached data1', ['data1' => $data1]);

                                    $masterDid = \App\Model\Master\Did::create($data1);
                                    Log::info('reached masterDid', ['masterDid' => $masterDid]);
                                }
                            }
                        }
                        $fileName = $request->input('file');
                        // Insert the CLI into the upload_history_did table
                        $currentUrl = URL::current();
                        $uploadTitle = $request->input('upload_title');

                        $uploadHistoryDid = new \App\Model\Client\UploadHistoryDid([
                            'user_id' => $request->auth->id,
                            'file_name' => $fileName,
                            'upload_url' => $currentUrl,
                            'url_title' => $uploadTitle

                        ]);
                        Log::info('reached uploadHistoryDid', ['uploadHistoryDid' => $uploadHistoryDid]);

                        $connection->table('upload_history_did')->insert($uploadHistoryDid->toArray());
                        if ($did && $masterDid) {
                            return array(
                                'success' => 'true',
                                'message' => 'Did added successfully',
                            );
                        }
                    } else {
                        return array(
                            'success' => 'false',
                            'message' => 'Did not added successfully, File is empty',
                        );
                    }
                }
            } catch (Exception $e) {
                Log::error($e->getMessage()); // Corrected line
            } catch (InvalidArgumentException $e) {
                Log::error($e->getMessage()); // Corrected line
            }
        }
    }


    //     public function uploadDid(Request $request)
    // {   
    //     if (!$request->has('file')) 
    //     {

    //         return response()->json([
    //             'success' => false,
    //             'message' => 'The did file field is required.',
    //         ], 400);
    //     }
    //     if($this->request->has('file'))
    //     {
    //         //path of uploaded file
    //         $filePath = base_path()."\public\api/".$this->request->input('file');
    //         try
    //         {
    //             if (!empty($filePath))
    //             {
    //                 //$database = "client_" . $request->auth->parent_id;

    //                 try
    //                 {
    //                     $reader = Excel::toArray(new Excel(), $filePath);
    //                 }
    //                 catch (\Exception $e)
    //                 {
    //                     return array(
    //                         'success'=> 'false',
    //                         'message'=> 'Unable to read excel'. $e->getMessage()
    //                     );
    //                 }

    //                 $cliArray = array(); // Create an empty array to store unique CLIs

    //                 if (!empty($reader))
    //                 {
    //                     $count = 0;

    //                     foreach ($reader as $row)
    //                     {
    //                         $i=0;
    //                         $add = 0; 
    //                         foreach ($row as $item => $value)
    //                         {
    //                             if ($item != 0)
    //                             {
    //                                 // Check if the CLI already exists in the array
    //                                 if (in_array($value[0], $cliArray))
    //                                 {
    //                                     return array(
    //                                         'success'=> 'false',
    //                                         'message'=> 'Duplicate CLIs found in the file.',
    //                                     );
    //                                 }

    //                                 // Add the CLI to the array
    //                                 $cliArray[] = $value[0];

    //                                 // Insert the CLI into the database client_3
    //                                 $did = new Did([
    //                                     'cli' => $value[0],
    //                                     'area_code' => substr($value[0], 1, 3),
    //                                 ]);
    //                                 $did=new \App\Model\Client\Did($data);
    //                                 $did->save();

    //                                 // Insert the CLI into the master database
    //                                 $data1 = [
    //                                     'parent_id' => $request->auth->parent_id,
    //                                     'cli' => $value[0],
    //                                     'user_id' => $request->auth->id,
    //                                     'area_code' => substr($value[0], 1, 3),
    //                                     'country_code' => +1,
    //                                     'provider' => 1,
    //                                 ];
    //                                 $masterDid = new \App\Model\Master\Did($data1);
    //                                 $masterDid->save();

    //                             }
    //                         }
    //                     }

    //                     if ($did && $masterDid)
    //                     {
    //                         return array(
    //                             'success'=> 'true',
    //                             'message'=> 'Did added successfully.'
    //                         );
    //                     }
    //                 }
    //                 else
    //                 {
    //                     return array(
    //                         'success'=> 'false',
    //                         'message'=> 'Did not added successfully, File is empty',
    //                     );
    //                 }
    //             }
    //         }
    //         catch (Exception $e)
    //         {
    //             Log::log($e->getMessage());
    //         }
    //         catch (InvalidArgumentException $e)
    //         {
    //             Log::log($e->getMessage());
    //         }



    //  }

    // }

    function setAppExtension(Request $request)
    {
        $users = User::where('base_parent_id', '2')->where('is_deleted', '0')->get()->all();
        foreach ($users as $list_user) {
            $app_extension = $list_user->app_extension;
            $first_name = $list_user->first_name;
            $last_name = $list_user->last_name;
            $alt_extension = $list_user->extension;

            //for password

            $user_data_alt_extension = UserExtension::where('username', "=", $alt_extension)->first();

            if (!empty($user_data_alt_extension)) {

                $secret = $user_data_alt_extension->secret;
                $user_data_extension = UserExtension::where('username', "=", $app_extension)->first();

                if (!empty($user_data_extension)) {
                    $dt['name'] = $app_extension;
                    $dt['context'] = 'user-extensions-phones';
                    $dt['username'] = $app_extension;
                    $dt['fullname'] = $first_name . ' ' . $last_name;
                    $insertData = "UPDATE user_extensions SET name= :name , fullname= :fullname, context= :context WHERE username= :username ";
                    $record_ustext = DB::connection('master')->select($insertData, $dt);

                    //echo "
";print_r($dt);die;
                    //echo "yes-".$app_extension.'
';
                } else {
                    $dt['name'] = $app_extension;
                    $dt['username'] = $app_extension;
                    $dt['secret'] = $secret;
                    $dt['context'] = 'user-extensions-phones'; //'default';
                    $dt['host'] = 'dynamic';
                    $dt['nat'] = 'force_rport,comedia';
                    $dt['qualify'] = 'no';
                    $dt['type'] = 'friend';
                    $dt['fullname'] = $first_name . ' ' . $last_name;
                    $dt['rtptimeout'] = '7200';
                    $dt['rtpholdtimeout'] = '7200';
                    $dt['sendrpid'] = 'yes';
                    $dt['subscribemwi'] = 'yes';
                    $dt['t38pt_udptl'] = 'no';
                    $dt['transport'] = 'TLS,WS,WSS,TCP,UDP';
                    $dt['trustrpid'] = 'no';
                    $dt['useclientcode'] = 'no';
                    $dt['usereqphone'] = 'no';
                    $dt['videosupport'] = 'yes';
                    $dt['icesupport'] = 'yes';
                    $dt['force_avp'] = 'no';
                    $dt['dtlsenable'] = 'yes';
                    $dt['dtlsverify'] = 'fingerprint';
                    $dt['dtlscertfile'] = '/etc/asterisk/asterisk.pem';
                    $dt['dtlssetup'] = 'actpass';
                    $dt['rtcp_mux'] = 'no';
                    $dt['avpf'] = 'no';
                    $dt['webrtc'] = 'no';

                    $insertData = "INSERT INTO user_extensions SET fullname= :fullname, context= :context, name= :name, type= :type , qualify= :qualify , nat= :nat , host= :host, secret= :secret,username= :username, rtptimeout= :rtptimeout, rtpholdtimeout= :rtpholdtimeout,sendrpid= :sendrpid,subscribemwi= :subscribemwi,t38pt_udptl= :t38pt_udptl,transport= :transport,trustrpid= :trustrpid,useclientcode= :useclientcode,usereqphone= :usereqphone,videosupport= :videosupport,icesupport= :icesupport,force_avp =:force_avp,dtlsenable=:dtlsenable,dtlsverify=:dtlsverify,dtlscertfile= :dtlscertfile,dtlssetup= :dtlssetup,rtcp_mux= :rtcp_mux,avpf= :avpf,
                webrtc= :webrtc";

                    $record_ustextSav = DB::connection('master')->select($insertData, $dt);
                    //echo "no-".$app_extension.'
';
                }
            }
        }
    }
}

//select app_extension,secret,context from users inner join  user_extensions on user_extensions.username=users.app_extension where users.base_parent_id=3