OSDN Git Service

add amulet search only by seed2
[amulettoolsmh4/main.git] / amulettool.py
index bde94d2..23ec9b9 100644 (file)
@@ -1,3 +1,4 @@
+#!/usr/bin/python
 # -*- coding: utf-8 -*-
 
 # お守りスキルのSeed特定ツールのコントロールクラス
@@ -14,9 +15,11 @@ import wx
 
 import view
 import model
+import convertcoding
 
 SETTING_FILE = u"settings"
 SETTING_THRESHOLD1 = u"threshold1"
+SETTING_THRESHOLD2 = u"threshold2"
 SETTING_SKILLS = u"skills"
 
 def _get_base_dir():
@@ -26,14 +29,16 @@ def _get_base_dir():
         basedir = sys._MEIPASS
     else:
         # we are running in a normal Python environment
-        basedir = os.path.dirname(__file__)
-    return basedir
+        #1basedir = os.path.dirname(__file__)
+        basedir = os.path.dirname(os.path.abspath(__file__))
+    return convertcoding.convert_unicode(basedir)
+
 
 class AmuletToolController(wx.App):
     u""" アプリケーションの制御クラス """
     def OnInit(self):
         self._read_settings()
-        self.frame_view = view.MainFrameView(os.path.join(_get_base_dir(), "view", view.XRC_MAIN_FRAME))
+        self.frame_view = view.MainFrameView(os.path.join(_get_base_dir(), u"view", view.XRC_MAIN_FRAME))
 
         self._init_events()
 
@@ -42,7 +47,13 @@ class AmuletToolController(wx.App):
         self.frame_view.DisableNoteBook()
 
         self._init_database()
-        self._set_views()
+        self._init_notebook_seed1()
+        self._init_notebook_seed2()
+        self._init_notebook_skill1()
+        self._init_notebook_skill2()
+        self._init_notebook_setting()
+        self._init_notebook_simulator()
+        self._init_notebook_amulet()
 
         self.frame_view.EnableNoteBook()
         return True
@@ -54,28 +65,10 @@ class AmuletToolController(wx.App):
         # menu event
         frame.Bind(wx.EVT_MENU, self.OnClose, id=self.frame_view.ID_MENU_ITEM_EXIT)
         frame.Bind(wx.EVT_MENU, self.OnAboutBox, id=self.frame_view.ID_MENU_ITEM_ABOUT)
+        frame.Bind(wx.EVT_MENU, self.OnMemoBox, id=self.frame_view.ID_MENU_MEMO)
         frame.Bind(wx.EVT_CLOSE, self.CloseHandler)
 
         # button event
-        frame.Bind(wx.EVT_BUTTON, self.OnClickSeedSearch, id=self.frame_view.ID_BUTTON_SEED_SEARCH)
-        frame.Bind(wx.EVT_BUTTON, self.OnClickSeedClear, id=self.frame_view.ID_BUTTON_SEED_CLEAR)
-        frame.Bind(wx.EVT_BUTTON, self.OnClickSkillSearchFromSeed, id=self.frame_view.ID_BUTTON_SKILL_FROM_SEED_SEARCH)
-        frame.Bind(wx.EVT_BUTTON, self.OnClickSkillSearch, id=self.frame_view.ID_BUTTON_SKILL_SEARCH)
-        frame.Bind(wx.EVT_BUTTON, self.OnClickSkillClear, id=self.frame_view.ID_BUTTON_SKILL_CLEAR)
-        frame.Bind(wx.EVT_BUTTON, self.OnClickAmuletSearch, id=self.frame_view.ID_BUTTON_AMULET_SEARCH_SEARCH)
-        frame.Bind(wx.EVT_BUTTON, self.OnClickAmuletClear, id=self.frame_view.ID_BUTTON_AMULET_SEARCH_CLEAR)
-        frame.Bind(wx.EVT_BUTTON, self.OnClickSkillSearchFromAmulet, id=self.frame_view.ID_BUTTON_AMULET_SEARCH_SKILL)
-        frame.Bind(wx.EVT_BUTTON, self.OnClickSettingOK, id=self.frame_view.ID_BUTTON_SETTING_OK)
-        frame.Bind(wx.EVT_BUTTON, self.OnClickSettingClear, id=self.frame_view.ID_BUTTON_SETTING_CLEAR)
-
-        # radio button event
-        frame.Bind(wx.EVT_RADIOBUTTON, self.OnClickAmuletRadio, id=self.frame_view.ID_RADIO_BUTTON_AMULET1)
-        frame.Bind(wx.EVT_RADIOBUTTON, self.OnClickAmuletRadio, id=self.frame_view.ID_RADIO_BUTTON_AMULET2)
-        frame.Bind(wx.EVT_RADIOBUTTON, self.OnClickAmuletRadio, id=self.frame_view.ID_RADIO_BUTTON_AMULET3)
-
-        # combo box event
-        frame.Bind(wx.EVT_COMBOBOX, self.OnClickAmuletCombo, id=self.frame_view.ID_COMBO_BOX_AMULET_SEARCH_SKILL1)
-        frame.Bind(wx.EVT_COMBOBOX, self.OnClickAmuletCombo, id=self.frame_view.ID_COMBO_BOX_AMULET_SEARCH_SKILL2)
 
     def _init_database(self):
         u""" DBの初期設定 """
@@ -87,7 +80,7 @@ class AmuletToolController(wx.App):
                 generator = model.DataBaseGenerator(model.DB_FILE_NAME)
                 #generator = model.DataBaseGenerator()
 
-                dlg_view = view.GaugeDialogView(os.path.join(_get_base_dir(), "view", view.XRC_GAUGE_DIALOG))
+                dlg_view = view.GaugeDialogView(os.path.join(_get_base_dir(), u"view", view.XRC_GAUGE_DIALOG))
                 def _loop():
                     while t1.is_alive():
                         dlg_view.gauge.Pulse()
@@ -112,298 +105,304 @@ class AmuletToolController(wx.App):
         except sqlite3.Error as e:
             self._show_error_dialog(u"データベースが壊れています")
 
-        # get dictionaries
-        (self._skill_id2name_dict, 
-            self._skill_name2id_dict,
-            self._amulet_id2name_dict, 
-            self._amulet_name2id_dict,
-            self._amulet_id2skill1_id_dict,
-            self._amulet_id2skill2_id_dict) = self.db_accessor.get_dicts()
-
-
-    def _set_views(self):
-        u""" GUIにDBの各種値をセットする """
-        self._set_combo_views()
-        self._set_spin_views()
-        self._set_check_list_views()
-
-    def _set_combo_views(self):
-        u""" ComboBoxの値をセットする """
-        combo_dict = self.frame_view.combo_box_skill_dict
+        self._minmax_dict = self.db_accessor.get_minmax_dict()
+        self._amulet_names = self.db_accessor.get_id_sorted_amulet_names()
+        self._skill_names = self.db_accessor.get_id_sorted_skill_names()
+
+    def _init_notebook_seed1(self):
+        u""" Seed1特定タブのviewの初期化 """
+        self.notebook_seed1_view = self.frame_view.notebook_seed1_view
+        self.notebook_seed1_view.bind_button_search(self.OnClickSeed1Search)
+        self.notebook_seed1_view.bind_button_clear(self.OnClickSeed1Clear)
+        self.notebook_seed1_view.bind_button_skill1(self.OnClickSkill1SearchFromSeed1)
+        self.notebook_seed1_view.set_skill1_button_enable(False)
+
+        u" 各種お守りの第1スキル選択のセット "
+        name2skill1s = {}
+        for name in self._amulet_names:
+            name2skill1s[name] = tuple([x for x in self._skill_names if x in self._minmax_dict[name][0]])
+        self.notebook_seed1_view.set_amuletname_skillnames_dict(self._amulet_names, name2skill1s)
+
+    def _init_notebook_seed2(self):
+        u""" Seed2特定タブのviewの初期化 """
+        self.notebook_seed2_view = self.frame_view.notebook_seed2_view
+        self.notebook_seed2_view.bind_button_search(self.OnClickSeed2Search)
+        self.notebook_seed2_view.bind_button_clear(self.OnClickSeed2Clear)
+        self.notebook_seed2_view.bind_button_skill2(self.OnClickSkill2SearchFromSeed2)
 
         u" 各種お守りの第2スキル選択 "
-        for amu_key, amu_name in zip([view.KEY_AMULET1, view.KEY_AMULET2, view.KEY_AMULET3], 
+        for amu_key, amu_name in zip([view.KEY_AMULET1, view.KEY_AMULET2, view.KEY_AMULET3],
                 [view.NAME_AMULET1, view.NAME_AMULET2, view.NAME_AMULET3]):
-            amu_id = self._amulet_name2id_dict[amu_name]
-            skill_ids = self._amulet_id2skill2_id_dict[amu_id]
-            skill_names = [view.VAL_NO_SKILL] + [self._skill_id2name_dict[x] for x in skill_ids]
-            for combo in combo_dict[amu_key]:
-               combo.SetItems(skill_names)
-               combo.SetSelection(0)
-
-        # amulet search
-        amu_id = self._amulet_name2id_dict[view.NAME_AMULET1]
-        self._set_skill_list_from_amulet(amu_id)
-        self.frame_view.amulet2radio_button_dict[view.NAME_AMULET1].SetValue(True)
-
-    def _set_skill_list_from_amulet(self, amulet_id):
-        u""" お守り種類の選択が変わった時の動作 """
-
-        for i, (combo, skill_dict) in enumerate(zip(
-                [self.frame_view.combo_box_amulet_search_skill1, 
-                    self.frame_view.combo_box_amulet_search_skill2], 
-                [self._amulet_id2skill1_id_dict, self._amulet_id2skill2_id_dict]
-                )):
-            skill_ids = skill_dict[amulet_id]
-            skill_names = [self._skill_id2name_dict[_id] for _id in skill_ids]
-            if i == 0:
-                combo.SetItems(skill_names)
-                skill1_selected = skill_ids[0]
-            elif i == 1:
-                combo.SetItems([view.VAL_NO_SKILL] + skill_names)
-            else:
-                raise NotImplementedError(u"this iteration must be conducted only twice!")
-            combo.SetSelection(0)   # combo1 = skill1, combo2 = No Skill
-        self._set_spin_range(amulet_id, skill1_selected, None)
-
-    def _set_spin_views(self):
-        u""" Spin Ctrlの最大最小をセット"""
-        min1, max1, min2, max2 = self.db_accessor.get_skill_minmax()
-        self.frame_view.spin_ctrl_amulet_search_slot_num.SetRange(view.SLOT_MIN, view.SLOT_MAX)
-        self.frame_view.spin_ctrl_highlight.SetRange(view.THRESHOLD1_MIN, view.THRESHOLD1_MAX)
-        self.frame_view.spin_ctrl_highlight.SetValue(self._highlight_threshold1)
-
-    def _set_check_list_views(self):
-        u""" CheckListBoxの値のセット """
-        checklist = self.frame_view.check_list_box_highlight_skill
-        checklist.SetItems(self._skill_name2id_dict.keys())
-        checklist.SetCheckedStrings([self._skill_id2name_dict[x] for x in self._highlight_skills])
-
-    def _set_spin_range(self, amulet_id, skill1_id, skill2_id):
-        u""" スキルに応じてSpinCtrlの最大最小をセットする """
-        if skill2_id is None:
-            minmax_dict = self.db_accessor.select_minmax_from_skill_ids(amulet_id, [skill1_id])
-            min1, max1 = minmax_dict[skill1_id][0], minmax_dict[skill1_id][1]
-            min2, max2 = 0, 0
+            skill_names = [view.VAL_NO_SKILL] + [x for x in self._skill_names 
+                    if x in self._minmax_dict[amu_name][1]]
+            self.notebook_seed2_view.set_skill_names(amu_key, skill_names)
+        self.notebook_seed2_view.set_skill_selected_idx(0)
+
+    def _init_notebook_skill2(self):
+        u""" Seed2によるSkill2一覧タブのviewの初期化 """
+        self.notebook_skill2_view = self.frame_view.notebook_skill2_view
+        self.notebook_skill2_view.bind_button_search(self.OnClickSkill2Search)
+        self.notebook_skill2_view.bind_button_clear(self.OnClickSkill2Clear)
+
+    def _init_notebook_skill1(self):
+        u""" Seed1によるSkill1一覧タブのviewの初期化 """
+        self.notebook_skill1_view = self.frame_view.notebook_skill1_view
+        self.notebook_skill1_view.bind_button_search(self.OnClickSkill1Search)
+        self.notebook_skill1_view.bind_button_clear(self.OnClickSkill1Clear)
+
+    def _init_notebook_simulator(self):
+        u""" Seed1,Seed2による錬金シミュレータータブのviewの初期化 """
+        self.notebook_simulator_view = self.frame_view.notebook_simulator_view
+        self.notebook_simulator_view.bind_button_search(self.OnClickSimulatorSearch)
+        self.notebook_simulator_view.bind_button_clear(self.OnClickSimulatorClear)
+
+    def _update_notebook_amulet_seed2s(self):
+        u"""お守り検索タブのSeed2リストを更新する"""
+        pass
+
+    def _init_notebook_amulet(self):
+        u""" お守り検索タブの初期設定 """
+        self.notebook_amulet_view = self.frame_view.notebook_amulet_view
+        self.notebook_amulet_view.set_skillminmax_dict(self._skill_names, self._amulet_names, self._minmax_dict)
+        self.notebook_amulet_view.bind_button_search(self.OnClickAmuletSearch)
+        self.notebook_amulet_view.bind_button_clear(self.OnClickAmuletClear)
+        self.notebook_amulet_view.bind_button_skill2(self.OnClickSkill2SearchFromAmulet)
+
+        self.notebook_amulet_view.set_selected_amulet(True, view.NAME_AMULET1)
+
+    def _init_notebook_setting(self):
+        u""" 設定タブの初期設定 """
+        self.notebook_setting_view = self.frame_view.notebook_setting_view
+        self.notebook_setting_view.bind_button_ok(self.OnClickSettingOK)
+        self.notebook_setting_view.bind_button_clear(self.OnClickSettingClear)
+        self.notebook_setting_view.set_skill_strings(self._skill_names)
+        self._update_notebook_setting()
+
+    def _update_notebook_setting(self):
+        u"""設定タブの値更新"""
+        self.notebook_setting_view.set_threshold(self._highlight_threshold1,
+                self._highlight_threshold2)
+        self.notebook_setting_view.set_checked_strings(self._highlight_skills)
+
+    def _update_highlight(self):
+        u""" update highlight cells """
+        self.notebook_skill2_view.set_skill2_highlight(
+                self._highlight_skills, self._highlight_threshold1, self._highlight_threshold2)
+        self.notebook_skill1_view.update_highlight(self._highlight_skills)
+
+    u""" Seed1 view's event"""
+    def OnClickSeed1Search(self, evt):
+        u""" search seed1s from selected skill1s """
+        alchemy_type = self.notebook_seed1_view.get_tenun_radio_key()
+        amu_skill_name_list = self.notebook_seed1_view.get_selected_amulets_and_names()
+        if alchemy_type == view.KEY_TENUN555:
+            alchemy_type = model.KEY_TENUN555
+        elif alchemy_type == view.KEY_TENUN888:
+            alchemy_type = model.KEY_TENUN888
         else:
-            minmax_dict = self.db_accessor.select_minmax_from_skill_ids(amulet_id, [skill1_id, skill2_id])
-            min1, max1 = minmax_dict[skill1_id][0], minmax_dict[skill1_id][1]
-            min2, max2 = minmax_dict[skill2_id][2], minmax_dict[skill2_id][3]
-        self.frame_view.spin_ctrl_amulet_search_skill1_val.SetRange(min1, max1)
-        self.frame_view.spin_ctrl_amulet_search_skill2_val.SetRange(min2, max2)
-
-    def OnClickSeedSearch(self, evt):
-        u""" search seeds from selected skills """
-        amu_id2skill_id_list_dict = {}
+            raise KeyError(u"key '{0}' not found in alchemy type".format(alchemy_type))
+        seed1s = self.db_accessor.select_seed1s(amu_skill_name_list, alchemy_type)
+        if len(seed1s) == 0:
+            self.notebook_seed1_view.set_text_result(u"条件に一致するSeed1は見つかりません")
+            self.notebook_seed1_view.set_skill1_button_enable(False)
+        elif len(seed1s) == 1:
+            seed1 = [x for x in seed1s][0]
+            no, table_no, result_num = self.db_accessor.select_table_nos_from_seed1(seed1, alchemy_type)
+            self.notebook_seed1_view.set_text_result_by_seed1(seed1, table_no, no)
+            self.notebook_seed1_view.set_skill1_button_enable(True)
+        else:
+            self.notebook_seed1_view.set_text_result(
+                    u"Seed1は{0}件あります。条件を絞ってください".format(len(seed1s)))
+            self.notebook_seed1_view.set_skill1_button_enable(False)
+
+    def OnClickSeed1Clear(self, evt):
+        u""" clear seed1s from selected skill1s """
+        self.notebook_seed1_view.clear_combobox()
+        self.notebook_seed1_view.clear_text_result()
+
+    def OnClickSkill1SearchFromSeed1(self, evt):
+        u""" change page to skill1 search from seed1"""
+        seed1 = self.notebook_seed1_view.get_result_seed1()
+        alchemy_type = self.notebook_seed1_view.get_tenun_radio_key()
+        if seed1 is not None:
+            self.notebook_skill1_view.set_seed1_value(seed1)
+            self.notebook_skill1_view.set_tenun_radio_key(alchemy_type)
+            self.frame_view.note_book.SetSelection(view.SKILL1_SEARCH_PAGE)
+            self.OnClickSkill1Search(evt)
+
+    u""" Seed2 view's event """
+    def OnClickSeed2Search(self, evt):
+        u""" search seed2s from selected skill2s """
+        amu2skills_dict = {}
         for amu_key, amu_name in zip([view.KEY_AMULET1, view.KEY_AMULET2, view.KEY_AMULET3], 
                 [view.NAME_AMULET1, view.NAME_AMULET2, view.NAME_AMULET3]):
-            amu_id = self._amulet_name2id_dict[amu_name]
-            ls = []
-            for combo in self.frame_view.combo_box_skill_dict[amu_key]:
-                name = combo.GetStringSelection()
-                if name not in self._skill_name2id_dict:
-                    ls.append(None)
-                else:
-                    ls.append(self._skill_name2id_dict[name])
-            amu_id2skill_id_list_dict[amu_id] = ls
-        seed_sets = self.db_accessor.select_seeds(amu_id2skill_id_list_dict)
-        self.frame_view.text_ctrl_seed_result.SetValue(u"""Seedの候補は{0}個です。""".format(len(seed_sets)))
+            names = self.notebook_seed2_view.get_selected_skill_names(amu_key)
+            amu2skills_dict[amu_name] = [name if name in self._skill_names else None for name in names]
+        seed_sets = self.db_accessor.select_seed2s(amu2skills_dict)
+        self.notebook_seed2_view.set_result_text(u"""Seedの候補は{0}個です。""".format(len(seed_sets)))
 
         if len(seed_sets) > 0:
-            self.frame_view.list_box_seed.SetItems([u"{0}".format(seed) for seed in seed_sets])
-            self.frame_view.list_box_seed.SetSelection(0)
-            self.frame_view.button_skill_from_seed_search.Enable()
+            self.notebook_seed2_view.set_seed_lists([u"{0}".format(seed) for seed in sorted(seed_sets)])
+            self.notebook_seed2_view.set_skill2_button_enable(True)
         else:
-            self.frame_view.list_box_seed.Clear()
-
-
-    def OnClickSeedClear(self, evt):
-        u""" reset seed search settings of combo box"""
-        combo_dict = self.frame_view.combo_box_skill_dict
-        for amu_key in [view.KEY_AMULET1, view.KEY_AMULET2, view.KEY_AMULET3]:
-            for combo in combo_dict[amu_key]:
-                combo.SetSelection(0)
-        self.frame_view.button_skill_from_seed_search.Disable()
-        self.frame_view.list_box_seed.Clear()
-
-    def OnClickSkillSearchFromSeed(self, evt):
-        u""" change page to skill search from seed"""
-        seed = self.frame_view.list_box_seed.GetStringSelection()
-        if seed.isdigit():
-            self.frame_view.text_ctrl_seed_select.SetValue(seed)
-            self.frame_view.note_book.SetSelection(view.SKILL_SEARCH_PAGE)
-            self.OnClickSkillSearch(evt)
-
-    def OnClickSkillSearch(self, evt):
-        u""" skill search from seed"""
-        seed = self.frame_view.text_ctrl_seed_select.GetValue()
-        if seed.isdigit():
-            seed = int(seed)
-            skill_dict, threshold1_dict = self.db_accessor.select_skills_from_seeds([seed])
+            self.notebook_seed2_view.clear_seed_list()
+            self.notebook_seed2_view.set_skill2_button_enable(False)
+
+    def OnClickSeed2Clear(self, evt):
+        u""" reset seed2 search settings of combo box"""
+        self.notebook_seed2_view.set_skill_selected_idx(0)
+        self.notebook_seed2_view.clear_seed_list()
+        self.notebook_seed2_view.set_result_text(u"")
+        self.notebook_seed2_view.set_skill2_button_enable(False)
+
+    def OnClickSkill2SearchFromSeed2(self, evt):
+        u""" change page to skill2 search from seed2"""
+        seed2 = self.notebook_seed2_view.get_selected_seed2()
+        if seed2 is not None:
+            self.notebook_skill2_view.set_seed2_value(seed2)
+            self.frame_view.note_book.SetSelection(view.SKILL2_SEARCH_PAGE)
+            self.OnClickSkill2Search(evt)
+
+    u""" Skill1 search from Seed1's event """
+    def OnClickSkill1Search(self, evt):
+        u""" skill1 search from seed1"""
+        seed1 = self.notebook_skill1_view.get_seed1_value()
+        alchemy_type = self.notebook_skill1_view.get_tenun_radio_key()
+        if seed1 is not None:
+            try:
+                no, table_no, result_num = self.db_accessor.select_table_nos_from_seed1(seed1, alchemy_type)
+                self.notebook_skill1_view.set_text_result_by_seed1(seed1, table_no, no)
+                # list of (no, seed1)
+                near_num = view.NEAR_SEED1_NUMBERS
+                no_seed1_dict = self.db_accessor.select_near_seed1s_from_table_no(
+                        no, table_no, near_num, near_num, alchemy_type)
+
+                # no -> (seed1, result_num, amu_names, skill_names)
+                self.notebook_skill1_view.set_no2seed1s_dict(no_seed1_dict, no)
+                self.notebook_skill1_view.update_highlight(self._highlight_skills)
+            except KeyError, e:
+                self._show_message_dialog(message=u"指定されたSeed値は存在しません")
+        else:
+            self._show_message_dialog(message=u"Seed値には数字を入力してください")
 
+    def OnClickSkill1Clear(self, evt):
+        u""" clear skills from seed """
+        self.notebook_skill1_view.clear_skill1_grid()
+        self.notebook_skill1_view.clear_highlight()
+        self.notebook_skill1_view.clear_result_text()
+
+    u""" Skill2 search from Seed2's event """
+    def OnClickSkill2Search(self, evt):
+        u""" skill search from seed2"""
+        seed2 = self.notebook_skill2_view.get_seed2_value()
+        if seed2 is not None:
+            table_no, no, skill_dict, th1s, th2s = self.db_accessor.select_names_from_seed2(seed2)
             try:
-                text_ctrl_dict = self.frame_view.text_ctrl_seed_skill_dict
                 for amu_key, amu_name in zip([view.KEY_AMULET1, view.KEY_AMULET2, view.KEY_AMULET3], 
-                    [view.NAME_AMULET1, view.NAME_AMULET2, view.NAME_AMULET3]):
-                    amu_id = self._amulet_name2id_dict[amu_name]
-                    for txt_ctr, skill_id in zip(text_ctrl_dict[amu_key], skill_dict[amu_id][seed]):
-                        txt_ctr.SetValue(self._skill_id2name_dict[skill_id])
-                for txt_ctr, threshold1 in zip(text_ctrl_dict[view.KEY_THRESHOLD1], threshold1_dict[seed]):
-                    txt_ctr.SetValue(u"{0}".format(threshold1))
-                self._update_highlight()
-
+                        [view.NAME_AMULET1, view.NAME_AMULET2, view.NAME_AMULET3]):
+                    skill_names = skill_dict[amu_name]
+                    self.notebook_skill2_view.set_skill2_by_col_key(amu_key, skill_names)
+                th_vals = [u"{0}".format(x) for x in th1s]
+                self.notebook_skill2_view.set_skill2_by_col_key(view.KEY_THRESHOLD1, th_vals)
+                th_vals = [u"{0}".format(x) for x in th2s]
+                self.notebook_skill2_view.set_skill2_by_col_key(view.KEY_THRESHOLD2, th_vals)
+                #inishie
+                skill_name, th1, th2 = self.db_accessor.select_inishie_skill2_from_seed2(seed2)
+                self.notebook_skill2_view.set_inishie(skill_name, th1, th2)
+                # explanation
+                self.notebook_skill2_view.set_result_text(
+                        u"SEED2: {2}, 通し番号: {1}, テーブルNo: {0}".format(table_no, no, seed2))
             except KeyError, e:
                 self._show_message_dialog(message=u"指定されたSeed値は存在しません")
+            finally:
+                self._update_highlight()
+
         else:
             self._show_message_dialog(message=u"Seed値には数字を入力してください")
 
-    def OnClickSkillClear(self, evt):
+    def OnClickSkill2Clear(self, evt):
         u""" clear skills from seed """
-        text_ctrl_dict = self.frame_view.text_ctrl_seed_skill_dict
-        for amu_key, amu_name in zip([view.KEY_AMULET1, view.KEY_AMULET2, view.KEY_AMULET3], 
-            [view.NAME_AMULET1, view.NAME_AMULET2, view.NAME_AMULET3]):
-            amu_id = self._amulet_name2id_dict[amu_name]
-            for txt_ctr in text_ctrl_dict[amu_key]:
-                txt_ctr.Clear()
-        for txt_ctr in text_ctrl_dict[view.KEY_THRESHOLD1]:
-            txt_ctr.Clear()
-        self.frame_view.list_box_seed_skill_amulet_prospect.Clear() 
-
-    def OnClickAmuletRadio(self, evt):
-        u""" switch skill lists by amulet id """
-        btn_id = evt.GetId()
-        if btn_id == self.frame_view.ID_RADIO_BUTTON_AMULET1:
-            amu_id = self._amulet_name2id_dict[view.NAME_AMULET1]
-        elif btn_id == self.frame_view.ID_RADIO_BUTTON_AMULET2:
-            amu_id = self._amulet_name2id_dict[view.NAME_AMULET2]
-        elif btn_id == self.frame_view.ID_RADIO_BUTTON_AMULET3:
-            amu_id = self._amulet_name2id_dict[view.NAME_AMULET3]
-        else:
-            return
-        self._set_skill_list_from_amulet(amu_id)
-
-    def OnClickAmuletCombo(self, evt):
-        u""" switch skill minmax by amulet id and skill_id"""
-        skill1_name = self.frame_view.combo_box_amulet_search_skill1.GetStringSelection()
-        skill2_name = self.frame_view.combo_box_amulet_search_skill2.GetStringSelection()
-        skill1_id = self._skill_name2id_dict[skill1_name]
-        if skill2_name in self._skill_name2id_dict:
-            skill2_id = self._skill_name2id_dict[skill2_name]
+        self.notebook_skill2_view.clear_skill2_grid()
+        self.notebook_skill2_view.clear_skill2_highlight()
+        self.notebook_skill2_view.clear_result_text()
+        self.notebook_skill2_view.clear_inishie()
+
+    u""" Alchemy Simulator's event """
+    def OnClickSimulatorSearch(self, evt):
+        u""" alchemy simulation from seed1, seed2"""
+        seeds = self.notebook_simulator_view.get_seed_values()
+        alchemy_type = self.notebook_simulator_view.get_tenun_radio_key()
+        if seeds is not None:
+            seed1, seed2 = seeds
+            #try:
+            result = self.db_accessor.simulate_nazo(seed1, seed2)
+            self.notebook_simulator_view.set_values(view.KEY_NAZO, *result)
+            result = self.db_accessor.simulate_komyou(seed1, seed2)
+            self.notebook_simulator_view.set_values(view.KEY_KOMYOU, *result)
+            result = self.db_accessor.simulate_inishie(seed1, seed2)
+            self.notebook_simulator_view.set_values(view.KEY_INISHIE, *result)
+            result = self.db_accessor.simulate_tenun(seed1, seed2, alchemy_type)
+            self.notebook_simulator_view.set_tenun_values(result)
+            #except KeyError, e:
+            #   self._show_message_dialog(message=u"指定されたSeed値は存在しません")
+            #finally:
+            self.notebook_simulator_view.update_highlight(self._highlight_skills)
         else:
-            skill2_id = None
-        if self.frame_view.amulet2radio_button_dict[view.NAME_AMULET1].GetValue():
-            amu_id = self._amulet_name2id_dict[view.NAME_AMULET1]
-        elif self.frame_view.amulet2radio_button_dict[view.NAME_AMULET2].GetValue():
-            amu_id = self._amulet_name2id_dict[view.NAME_AMULET2]
-        elif self.frame_view.amulet2radio_button_dict[view.NAME_AMULET3].GetValue():
-            amu_id = self._amulet_name2id_dict[view.NAME_AMULET3]
-        else:
-            raise IndexError(u"amulet id is unknown")
-        self._set_spin_range(amu_id, skill1_id, skill2_id)
+            self._show_message_dialog(message=u"Seed値には数字を入力してください")
 
+    def OnClickSimulatorClear(self, evt):
+        u""" clear simulator form """
+        self.notebook_simulator_view.clear_seed_values()
+        self.notebook_simulator_view.clear_grid()
+        self.notebook_simulator_view.clear_highlight()
+
+    u""" amulet search event """
     def OnClickAmuletSearch(self, evt):
         u""" search seeds from amulet condition """
-        skill1_name = self.frame_view.combo_box_amulet_search_skill1.GetStringSelection()
-        skill2_name = self.frame_view.combo_box_amulet_search_skill2.GetStringSelection()
-        skill1_val = self.frame_view.spin_ctrl_amulet_search_skill1_val.GetValue()
-        skill2_val = self.frame_view.spin_ctrl_amulet_search_skill2_val.GetValue()
-        slot_val = self.frame_view.spin_ctrl_amulet_search_slot_num.GetValue()
-        if self.frame_view.amulet2radio_button_dict[view.NAME_AMULET1].GetValue():
-            amu_id = self._amulet_name2id_dict[view.NAME_AMULET1]
-        elif self.frame_view.amulet2radio_button_dict[view.NAME_AMULET2].GetValue():
-            amu_id = self._amulet_name2id_dict[view.NAME_AMULET2]
-        elif self.frame_view.amulet2radio_button_dict[view.NAME_AMULET3].GetValue():
-            amu_id = self._amulet_name2id_dict[view.NAME_AMULET3]
-        else:
-            raise IndexError(u"amulet id is unknown")
-
-        list_box = self.frame_view.list_box_amulet_search_seeds
-        if skill1_name == skill2_name:
-            self._show_message_dialog(message=u"異なるスキルを選択してください")
-        elif skill1_val == 0:
-            self._show_message_dialog(message=u"第1スキルの値には0以外を指定してください")
-        else:
-            skill1_id = self._skill_name2id_dict[skill1_name]
-            if skill2_name in self._skill_name2id_dict:
-                skill2_id = self._skill_name2id_dict[skill2_name]
-            else:
-                skill2_id = None # for skill2 is 0
-            suff_dict = {}
-            tup = self.db_accessor.get_sufficient_value(
-                amu_id, skill1_id, skill2_id, skill1_val, skill2_val)
-            if tup is not None:
-                suff_val = tup[0]
-                seeds_set = self.db_accessor.select_seeds_from_sufficient_val(amu_id, suff_val, slot_val, skill2_id)
-                if len(seeds_set) > 0:
-                    self.frame_view.text_ctrl_amulet_search_result.SetValue(
-                        u"{0}個のSeedで出現するお守りです".format(len(seeds_set)))
-                    list_box.SetItems([u"{0}".format(seed) for seed in seeds_set])
-                    list_box.SetSelection(0)
-                    self.frame_view.button_amulet_search_skill.Enable()
-                else:
-                    self.frame_view.text_ctrl_amulet_search_result.SetValue(
-                        u"指定されたお守りは見つかりませんでした")
-                    self.frame_view.button_amulet_search_skill.Disable()
-                    list_box.Clear()
-            else:
-                self.frame_view.text_ctrl_amulet_search_result.SetValue(
-                    u"エラー。充足値が計算できません")
-                self.frame_view.button_amulet_search_skill.Disable()
-                list_box.Clear()
+        search_type = self.notebook_amulet_view.get_selected_search_type()
+        if search_type == view.SEARCH_TYPE_SEED2:
+            skill1_name, skill2_name = self.notebook_amulet_view.get_skill_names()
+            skill1_val, skill2_val = self.notebook_amulet_view.get_skill_values()
+            slot_num = self.notebook_amulet_view.get_slot_value()
+            amulet_name = self.notebook_amulet_view.get_selected_amulet()
+            suff_val, threshold, th1_seed2s, th2_seed2s = self.db_accessor.simple_select_seed2s_from_names(
+                    amulet_name, skill1_name, skill1_val, skill2_name, skill2_val, slot_num)
+            self.notebook_amulet_view.set_result_only_seed2(suff_val, threshold, th1_seed2s, th2_seed2s)
+        elif search_type == view.SEARCH_TYPE_SEED1_SEED2:
+            pass
+        elif search_type == view.SEARCH_TYPE_FIXED_SEED2:
+            pass
 
     def OnClickAmuletClear(self, evt):
         u""" clear amulet conditions """
-        amu_id = self._amulet_name2id_dict[view.NAME_AMULET1]
-        self._set_skill_list_from_amulet(amu_id)
-        self.frame_view.amulet2radio_button_dict[view.NAME_AMULET1].SetValue(True)
-        self.frame_view.button_amulet_search_skill.Disable()
-        self.frame_view.text_ctrl_amulet_search_result.SetValue(u"")
-        self.frame_view.list_box_amulet_search_seeds.Clear()
-
-    def OnClickSkillSearchFromAmulet(self, evt):
+        self.notebook_amulet_view.clear_grid()
+        self.notebook_amulet_view.clear_input_values()
+
+    def OnClickSkill2SearchFromAmulet(self, evt):
         u""" change page to skill search from amulet"""
-        seed = self.frame_view.list_box_amulet_search_seeds.GetStringSelection()
-        if seed.isdigit():
-            self.frame_view.text_ctrl_seed_select.SetValue(seed)
+        seed = self.notebook_amulet_view.get_grid_selected_seed2()
+        if seed is not None:
+            self.notebook_skill2_view.set_seed2_value(seed)
             self.frame_view.note_book.SetSelection(view.SKILL_SEARCH_PAGE)
             self.OnClickSkillSearch(evt)
 
+    u""" settings' event """
     def OnClickSettingOK(self, evt):
         u""" get settings of setting tab """
-        self._highlight_threshold1 = self.frame_view.spin_ctrl_highlight.GetValue()
-        self._highlight_skills = set([self._skill_name2id_dict[x] for x in 
-                self.frame_view.check_list_box_highlight_skill.GetCheckedStrings()
-                if x in self._skill_name2id_dict])
+        (self._highlight_threshold1, 
+                self._highlight_threshold2) = self.frame_view.notebook_setting_view.get_threshold()
+        self._highlight_skills = set([x for x in self.frame_view.notebook_setting_view.get_checked_strings()
+                if x in self._skill_names])
         self._update_highlight()
 
     def OnClickSettingClear(self, evt):
         u""" reset settings of setting tab """
         self._highlight_threshold1 = view.HIGHLIGHT_THRESHOLD1
-        self.frame_view.spin_ctrl_highlight.SetValue(view.HIGHLIGHT_THRESHOLD1)
+        self._highlight_threshold2 = view.HIGHLIGHT_THRESHOLD2
         self._highlight_skills = set()
-        for idx in self.frame_view.check_list_box_highlight_skill.GetChecked():
-            self.frame_view.check_list_box_highlight_skill.Check(idx, False)
+        self._update_notebook_setting()
         self._update_highlight()
 
-    def _update_highlight(self):
-        u""" update highlight cells """
-        text_dict = self.frame_view.text_ctrl_seed_skill_dict
-        for key in [view.KEY_AMULET1, view.KEY_AMULET2, view.KEY_AMULET3]:
-            for text_ctrl in text_dict[key]:
-                val = text_ctrl.GetValue()
-                if (val in self._skill_name2id_dict and
-                        self._skill_name2id_dict[val] in self._highlight_skills):
-                    text_ctrl.SetBackgroundColour("Yellow")
-                else:
-                    text_ctrl.SetBackgroundColour(wx.NullColor)
-        for text_ctrl in text_dict[view.KEY_THRESHOLD1]:
-            val = text_ctrl.GetValue()
-            if val.isdigit() and int(val) >= self._highlight_threshold1:
-                text_ctrl.SetBackgroundColour("Yellow")
-            else:
-                text_ctrl.SetBackgroundColour(wx.NullColor)
-
-
     def _show_error_dialog(self, message=u"予期せぬエラーが発生しました", caption=u"エラー"):
         u""" エラーダイアログを表示し、
         OKボタンが押されたらアプリケーションを終了する
@@ -414,7 +413,7 @@ class AmuletToolController(wx.App):
         dlg.ShowModal()
         dlg.Destroy()
         wx.Exit()
-    
+
     def _show_message_dialog(self, message, caption=u"メッセージ"):
         u""" メッセージダイアログを表示する
         """
@@ -442,9 +441,14 @@ class AmuletToolController(wx.App):
         info = self.frame_view.GetAboutInfo()
         wx.AboutBox(info)
 
+    def OnMemoBox(self, evt):
+        dlg_view = view.MemoDialogView(os.path.join(_get_base_dir(), u"view", view.XRC_MEMO_DIALOG))
+        dlg_view.Show()
+
     def _write_settings(self):
         with open(SETTING_FILE, mode="w") as f:
             data = {SETTING_THRESHOLD1:self._highlight_threshold1, 
+                    SETTING_THRESHOLD2:self._highlight_threshold2, 
                     SETTING_SKILLS:self._highlight_skills}
             pickle.dump(data, f)
 
@@ -454,12 +458,15 @@ class AmuletToolController(wx.App):
                 try:
                     data = pickle.load(f)
                     self._highlight_threshold1 = data[SETTING_THRESHOLD1] 
+                    self._highlight_threshold2 = data[SETTING_THRESHOLD2] 
                     self._highlight_skills = data[SETTING_SKILLS]
                 except EOFError, e:
                     self._highlight_threshold1 = view.HIGHLIGHT_THRESHOLD1
+                    self._highlight_threshold2 = view.HIGHLIGHT_THRESHOLD2
                     self._highlight_skills = set()
         else:
             self._highlight_threshold1 = view.HIGHLIGHT_THRESHOLD1
+            self._highlight_threshold2 = view.HIGHLIGHT_THRESHOLD2
             self._highlight_skills = set()
 
 if __name__ == "__main__":