class FileExplorer(wx.Frame):
    def __init__(self):
        # ...初始化代碼...
        
        # 關(guān)鍵數(shù)據(jù)結(jié)構(gòu)
        self.listbox_panels = []  # 存儲每層的面板和listbox信息
        self.root_folder = ""     # 根文件夾路徑
        self.left_sizer = wx.BoxSizer(wx.HORIZONTAL)  # 水平布局管理器

def create_listbox_for_folder(self, folder_path, level):
    """為指定文件夾創(chuàng)建一個listbox"""
    try:
        # 清理后續(xù)層級 - 關(guān)鍵的層級管理邏輯
        while len(self.listbox_panels) > level:
            panel_info = self.listbox_panels.pop()
            panel_info['panel'].Destroy()
        
        # 創(chuàng)建新面板
        panel = wx.Panel(self.left_scroll)
        panel_sizer = wx.BoxSizer(wx.VERTICAL)
        
        # 創(chuàng)建標(biāo)題
        folder_name = os.path.basename(folder_path) or folder_path
        title_text = f"?? 根目錄" if level == 0 else f"?? {folder_name}"
        
        title = wx.StaticText(panel, label=title_text)
        title.SetFont(wx.Font(9, wx.FONTFAMILY_DEFAULT, wx.FONTSTYLE_NORMAL, wx.FONTWEIGHT_BOLD))
        
        # 創(chuàng)建listbox并綁定事件
        listbox = wx.ListBox(panel, style=wx.LB_SINGLE, size=(200, -1))
        listbox.Bind(wx.EVT_LISTBOX, lambda evt: self.on_listbox_selection(evt, folder_path, level))
        
        # 組裝界面
        panel_sizer.Add(title, 0, wx.ALL | wx.EXPAND, 3)
        panel_sizer.Add(listbox, 1, wx.EXPAND | wx.ALL, 3)
        panel.SetSizer(panel_sizer)
        
        # 填充內(nèi)容
        self.populate_listbox(listbox, folder_path)
        
        # 添加到布局
        self.left_sizer.Add(panel, 0, wx.EXPAND | wx.ALL, 2)
        
        # 存儲組件信息
        panel_info = {
            'panel': panel,
            'listbox': listbox,
            'folder_path': folder_path,
            'level': level
        }
        self.listbox_panels.append(panel_info)
        
        # 更新布局并滾動到最新位置
        self.left_scroll.Layout()
        self.left_scroll.FitInside()
        self.scroll_to_right()

while len(self.listbox_panels) > level:
    panel_info = self.listbox_panels.pop()
    panel_info['panel'].Destroy()

listbox.Bind(wx.EVT_LISTBOX, lambda evt: self.on_listbox_selection(evt, folder_path, level))

def scroll_to_right(self):
    """滾動到最右側(cè)顯示最新的listbox"""
    self.left_scroll.Layout()
    virtual_size = self.left_scroll.GetVirtualSize()
    client_size = self.left_scroll.GetClientSize()
    
    if virtual_size.width > client_size.width:
        max_scroll_x = virtual_size.width - client_size.width
        scroll_unit = self.left_scroll.GetScrollPixelsPerUnit()[0]
        if scroll_unit > 0:
            scroll_x = max_scroll_x // scroll_unit
            self.left_scroll.Scroll(scroll_x, -1)

def populate_listbox(self, listbox, folder_path):
    """填充listbox內(nèi)容"""
    try:
        items = []
        for item in os.listdir(folder_path):
            item_path = os.path.join(folder_path, item)
            if os.path.isdir(item_path):
                items.append(("?? " + item, item_path, "folder"))
            else:
                if item.lower().endswith(('.xlsx', '.xls', '.docx', '.doc', '.txt', '.pdf')):
                    items.append(("?? " + item, item_path, "file"))
        
        # 按類型和名稱排序（文件夾在前）
        items.sort(key=lambda x: (x[2] == "file", x[0].lower()))
        
        # 添加到listbox
        for display_name, full_path, item_type in items:
            index = listbox.Append(display_name)
            listbox.SetClientData(index, (full_path, item_type))
            
    except PermissionError:
        listbox.Append("? 無法訪問（權(quán)限不足）")
    except Exception as e:
        listbox.Append(f"? 錯誤: {str(e)}")

def show_file_preview(self, file_path):
    """在右側(cè)顯示文件預(yù)覽"""
    # ...清理界面代碼...
    
    file_ext = os.path.splitext(file_name)[1].lower()
    
    try:
        if file_ext in ['.xlsx', '.xls']:
            content = self.preview_excel(file_path)
        elif file_ext in ['.docx', '.doc']:
            content = self.preview_word(file_path)
        elif file_ext == '.txt':
            content = self.preview_text(file_path)
        else:
            content = f"不支持預(yù)覽此文件類型: {file_ext}"

def preview_excel(self, file_path):
    """預(yù)覽Excel文件"""
    try:
        df = pd.read_excel(file_path, sheet_name=0, nrows=100)
        
        content = f"Excel文件預(yù)覽 (前100行):\n"
        content += f"工作表形狀: {df.shape}\n"
        content += f"列名: {list(df.columns)}\n\n"
        content += df.to_string(max_rows=100, max_cols=15, width=100)
        
        return content
    except Exception as e:
        return f"無法預(yù)覽Excel文件: {str(e)}"

panel_info = {
    'panel': panel,           # 容器組件
    'listbox': listbox,       # 列表組件
    'folder_path': folder_path, # 數(shù)據(jù)
    'level': level            # 元數(shù)據(jù)
}

listbox.Bind(wx.EVT_LISTBOX, lambda evt: self.on_listbox_selection(evt, folder_path, level))

preview_strategies = {
    '.xlsx': self.preview_excel,
    '.docx': self.preview_word,
    '.txt': self.preview_text
}

# 及時清理不需要的組件
while len(self.listbox_panels) > level:
    panel_info = self.listbox_panels.pop()
    panel_info['panel'].Destroy()