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

                if (!empty($updateString) && !empty($data)) {
                    $query = "UPDATE mailbox set " . implode(" , ", $updateString) . " WHERE id = :id";
                    $save = DB::connection('mysql_' . $request->auth->parent_id)->update($query, $data);
                    if ($save == 1) {
                        return array(
                            'success' => 'true',
                            'message' => 'mailbox updated successfully.'
                        );
                    } else {
                        return array(
                            'success' => 'false',
                            'message' => 'mailbox are not updated successfully.'
                        );
                    }
                }
            }
            return array(
                'success' => 'false',
                'message' => 'mailbox doesn\'t exist.'
            );
        } catch (Exception $e) {
            Log::log($e->getMessage());
        } catch (InvalidArgumentException $e) {
            Log::log($e->getMessage());
        }
    }

    /*
     * Fetch Live calls from user id
     * @param integer $id
     * @return array
     */


    /*
     * Fetch Call transfer Detail
     * @param integer $id
     * @return array
     */

    public function getUnreadMailBox($request) {
        try {
            $id = $request->input('id');
            if (!empty($id) && is_numeric($id)) {
                $search = array();
                $searchString = array();
                $limitString = '';


                /* if($request->auth->role == 2)
                  {
                  $search['extension'] = $request->auth->extension;
                  array_push($searchString, 'extension = :extension');
                  }
                  else */
                //if($request->auth->role == 2)
                //{
                /* $search['extension'] = $request->auth->extension;
                  array_push($searchString, 'extension = :extension'); */
                //}
                //else
                if ($request->has('extension') && !empty($request->input('extension'))) {
                    $search['extension'] = $request->input('extension');
                    array_push($searchString, 'extension = :extension');

                    $search['status'] = '1';
                    array_push($searchString, 'status = :status');
                }

                // return $search;


                $sql = "SELECT count(1) as rowCountMailbox FROM mailbox where status='1' and extension ='" . $request->input('extension') . "' ";
                // $record =  DB::connection('master')->selectOne($sql, $data);
                $record = DB::connection('mysql_' . $request->auth->parent_id)->select($sql);

                $response = (array) $record;

                foreach ($response as $res) {
                    $dataMailbox['record_count'] = $res->rowCountMailbox;
                }
                if (!empty($response)) {
                    $data = (array) $record;
                    return array(
                        'success' => 'true',
                        'message' => 'MailBox Report.',
                        'data' => $dataMailbox,
                    );
                } else {
                    return array(
                        'success' => 'true',
                        'message' => 'No MailBox Report found.',
                        'record_count' => 0,
                        'data' => array()
                    );
                }
            }
            return array(
                'success' => 'false',
                'message' => 'MailBox Report doesn\'t exist.'
            );
        } catch (Exception $e) {
            Log::log($e->getMessage());
        } catch (InvalidArgumentException $e) {
            Log::log($e->getMessage());
        }
    }

    public function deleteMailbox($request) {
        try {
            if ($request->has('mailbox_id')) {
                $data['id'] = $request->input('mailbox_id');
                $query = "DELETE FROM mailbox WHERE id IN (".$data['id'].")";
                $save = DB::connection('mysql_' . $request->auth->parent_id)->update($query);
                if ($save == 1) {
                    return array(
                        'success' => 'true',
                        'message' => 'Mailbox deleted successfully.'
                    );
                } else {
                    return array(
                        'success' => 'false',
                        'message' => 'Mailbox are not deleted successfully.'
                    );
                }
            }
            return array(
                'success' => 'false',
                'message' => 'Mailbox doesn\'t exist.'
            );
        } catch (Exception $e) {
            Log::log($e->getMessage());
        } catch (InvalidArgumentException $e) {
            Log::log($e->getMessage());
        }
    }

}