HYTOS

        @brief      get special item types from database

        @author     humkyung

        @date       2019.08.10

    '''

    def get_special_item_types(self):

        try:

            # Creates or opens a file called mydb with a SQLite3 DB

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), AppDocData.DATABASE)

            conn = sqlite3.connect(dbPath)

            conn.row_factory = sqlite3.Row

            with conn:

                # Get a cursor object

                cursor = conn.cursor()

                sql = 'select UID, Code, Type, Allowables from SpecialItemTypes order by Code DESC'

                cursor.execute(sql)

                return cursor.fetchall()

            # Catch the exception

        except Exception as ex:

            from App import App 

            # Roll back any change if something goes wrong

            conn.rollback()

            message = 'error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno)

            App.mainWnd().addMessage.emit(MessageType.Error, message)

    '''

        @brief      save special item types

        @author     humkyung

        @date       2019.08.10

    '''

    def save_special_item_types(self, datas):

        import uuid

        try:

            # Creates or opens a file called mydb with a SQLite3 DB

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), AppDocData.DATABASE)

            conn = sqlite3.connect(dbPath)

            with conn:

                # Get a cursor object

                cursor = conn.cursor()

                for data in datas:

                    uid,code,_type,allowables = data[0],data[1],data[2],data[3]

                    if not uid:

                        sql = 'insert or replace into SpecialItemTypes(UID, Code, Type, Allowables) values(?, ?, ?, ?)'

                        param = (str(uuid.uuid4()), data[1], data[2], data[3])

                    elif uid == '-1':

                        sql = 'delete from SpecialItemTypes where uid=?' 

                        param = (data[-1],)

                    else:

                        sql = 'update SpecialItemTypes SET Code=?, Type=?, Allowables=? WHERE UID = ?'

                        param = (data[1], data[2], data[3], data[0])

                    cursor.execute(sql, param)

                conn.commit()

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            conn.rollback()

            print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))

    '''

        self.actionSpecialItemTypes.triggered.connect(self.on_show_special_item_types)  ### show special item types dialog

        @brief  show special item types dialog 

        @author humkyung

        @date   2019.08.10

    '''

    def on_show_special_item_types(self):

        from SpecialItemTypesDialog import QSpecialItemTypesDialog

        dlg = QSpecialItemTypesDialog(self)

        dlg.exec_()

    '''

# Form implementation generated from reading ui file '.\UI\MainWindow.ui'

        self.actionSpecialItemTypes = QtWidgets.QAction(MainWindow)

        self.actionSpecialItemTypes.setObjectName("actionSpecialItemTypes")

        self.menu_2.addAction(self.actionSpecialItemTypes)

        self.actionSpecialItemTypes.setText(_translate("MainWindow", "Special Item Types"))

        self.actionSpecialItemTypes.setToolTip(_translate("MainWindow", "Special Item Types"))

CREATE TABLE IF NOT EXISTS SpecialItemTypes (

    UID         TEXT CONSTRAINT SpecialItemTypes_PK PRIMARY KEY

                     NOT NULL,

    Code        TEXT NOT NULL

                     UNIQUE,

    Type TEXT,

    Allowables  TEXT

);

# coding: utf-8

""" This is Special Item Types dialog module """

import os

import sys

from PyQt5.QtCore import *

from PyQt5.QtGui import *

from PyQt5.QtWidgets import *

from AppDocData import AppDocData, MessageType

sys.path.insert(0, os.path.dirname(os.path.realpath(__file__)) + '\\UI')

import SpecialItemTypes_UI

class QSpecialItemTypesDialog(QDialog):

    """ This Special Item Types dialog class """

    CODE_TABLES = ('Special Item Types')

    def __init__(self, parent):

        QDialog.__init__(self, parent)

        self.ui = SpecialItemTypes_UI.Ui_SpecialItemTypesDialog()

        self.ui.setupUi(self)

        self.ui.tableWidgetSpecialItemTypes.setSortingEnabled(True)

        #DB Table명 기준으로 작성

        for table in QSpecialItemTypesDialog.CODE_TABLES:

            self.load_data(table)

    '''

        @brief      Setting Table

        @author     humkyung 

        @date       2019.08.10

    '''

    def load_data(self, table_name):

        try:

            app_doc_data = AppDocData.instance()

            self.ui.tableWidgetSpecialItemTypes.horizontalHeader().setStretchLastSection(True)

            self.ui.tableWidgetSpecialItemTypes.setColumnCount(4)

            self.ui.tableWidgetSpecialItemTypes.setHorizontalHeaderLabels(['UID', 'Code', 'Type', 'Allowables'])

            self.ui.tableWidgetSpecialItemTypes.hideColumn(0)

            self.fill_data()

            self.add_new_row()

            self.ui.tableWidgetSpecialItemTypes.horizontalHeaderItem(1).setSizeHint(QSize(30, 30))

            self.ui.tableWidgetSpecialItemTypes.cellChanged.connect(self.cellValueChanged)

        except Exception as ex:

            from App import App

            message = 'error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno)

            App.mainWnd().addMessage.emit(MessageType.Error, message)

    '''

        @brief      fill tablewidget with data of database

        @author     humkyung

        @date       2019.08.10

    '''

    def fill_data(self):

        try:

            app_doc_data = AppDocData.instance()

            special_item_types = app_doc_data.get_special_item_types()

            self.ui.tableWidgetSpecialItemTypes.setRowCount(len(special_item_types))

            row = 0

            for special_item_type in special_item_types:

                uid_item = QTableWidgetItem(special_item_type[0])

                uid_item.tag = special_item_type[0]

                self.ui.tableWidgetSpecialItemTypes.setItem(row, 0, uid_item)   # UID

                code_item = QTableWidgetItem(special_item_type[1])

                code_item.tag = special_item_type[1]

                self.ui.tableWidgetSpecialItemTypes.setItem(row, 1, code_item)   # Code 

                type_combobox = QComboBox()

                type_combobox.addItem('String')

                type_combobox.addItem('Symbol')

                index = type_combobox.findText(special_item_type[2]) # Type

                type_combobox.setCurrentIndex(index) if index != -1 else type_combobox.setCurrentIndex(0)

                self.ui.tableWidgetSpecialItemTypes.setCellWidget(row, 2, type_combobox)

                allowables_item = QTableWidgetItem(special_item_type[3])

                allowables_item.tag = special_item_type[3]

                self.ui.tableWidgetSpecialItemTypes.setItem(row, 3, allowables_item)   # Allowables

                row += 1

        except Exception as ex:

            from App import App

            message = 'error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno)

            App.mainWnd().addMessage.emit(MessageType.Error, message)

    '''

        @brief      delete selected row

        @author     humkyung

        @date       2019.08.10

    '''

    def keyPressEvent(self, e):

        try:

            if e.key() == Qt.Key_Delete:

                selectedIndexes = self.ui.tableWidgetSpecialItemTypes.selectedIndexes()

                selectedRows = [item.row() for item in selectedIndexes]

                #중복 제거

                rowsIndex = list(set(selectedRows))

                rowsIndex.reverse()

                for row in rowsIndex:

                    self.ui.tableWidgetSpecialItemTypes.hideRow(row)

                self.add_new_row()

        except Exception as ex:

            from App import App

            message = 'error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno)

            App.mainWnd().addMessage.emit(MessageType.Error, message)

    '''

        @brief      add new row 

        @author     humkyung

        @date       2019.08.10

    '''

    def add_new_row(self):

        try:

            rowCount = self.ui.tableWidgetSpecialItemTypes.rowCount()

            for row in range(rowCount):

                if self.ui.tableWidgetSpecialItemTypes.isRowHidden(row): continue

                code = self.ui.tableWidgetSpecialItemTypes.item(row, 1).text()

                if not code: return

            if self.ui.tableWidgetSpecialItemTypes.receivers(self.ui.tableWidgetSpecialItemTypes.cellChanged) > 0:

                self.ui.tableWidgetSpecialItemTypes.cellChanged.disconnect(self.cellValueChanged)

            self.ui.tableWidgetSpecialItemTypes.setRowCount(rowCount + 1)

            self.ui.tableWidgetSpecialItemTypes.setItem(rowCount, 0, QTableWidgetItem(''))

            self.ui.tableWidgetSpecialItemTypes.setItem(rowCount, 1, QTableWidgetItem(''))

            type_combobox = QComboBox()

            type_combobox.addItem('String')

            type_combobox.addItem('Symbol')

            self.ui.tableWidgetSpecialItemTypes.setCellWidget(rowCount, 2, type_combobox)

            self.ui.tableWidgetSpecialItemTypes.setItem(rowCount, 3, QTableWidgetItem(''))

            self.ui.tableWidgetSpecialItemTypes.cellChanged.connect(self.cellValueChanged)

        except Exception as ex:

            from App import App

            message = 'error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno)

            App.mainWnd().addMessage.emit(MessageType.Error, message)

    '''

        @brief      cellValueChange event

        @author     kyouho

        @date       2018.07.10

    '''

    def cellValueChanged(self, row, column):

        try:

            tab_index = self.ui.tabWidget.currentIndex()

            if column == 1:

                code = self.ui.tableWidgetSpecialItemTypes.item(row, column).text()

                exists = self.exists_code(code)

                if not exists:

                    item = self.ui.tableWidgetSpecialItemTypes.item(row, column)

                    item.tag = code # set tag value with given code

                    self.add_new_row()

                else:

                    QMessageBox.warning(self, self.tr('Notice'), self.tr('The same code already exists in the table.'))

                    item = self.ui.tableWidgetSpecialItemTypes.item(row, column)

                    item.setText(item.tag if hasattr(item, 'tag') else '')

            elif column == 2:

                self.ui.tableWidgetSpecialItemTypes.resizeColumnToContents(2)

            else:

                self.ui.tableWidgetSpecialItemTypes.resizeColumnToContents(3)

        except Exception as ex:

            from App import App

            message = 'error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno)

            App.mainWnd().addMessage.emit(MessageType.Error, message)

    '''

        @brief      Check Duplicated Code 

        @author     humkyung

        @date       2019.08.10

    '''

    def exists_code(self, code):

        try:

            if not code: return False

            rowCount = self.ui.tableWidgetSpecialItemTypes.rowCount()

            codes = []

            for row in range(rowCount):

                if self.ui.tableWidgetSpecialItemTypes.isRowHidden(row): continue

                code = self.ui.tableWidgetSpecialItemTypes.item(row, 1).text()

                codes.append(code)

            return True if codes.count(code) >= 2 else False 

        except Exception as ex:

            from App import App

            message = 'error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno)

            App.mainWnd().addMessage.emit(MessageType.Error, message)

    '''

        @brief      save codes and exits dialog

        @author     humkyung

        @date       2019.08.12

    '''

    def accept(self):

        try:

            self.save_data()

            QDialog.accept(self)

        except Exception as ex:

            from App import App

            message = 'error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno)

            App.mainWnd().addMessage.emit(MessageType.Error, message)

    '''

        @brief      save speical item types

        @author     humkyung

        @date       2019.08.10

    '''

    def save_data(self):

        datas = []

        rowCount = self.ui.tableWidgetSpecialItemTypes.rowCount()

        for row in range(rowCount):

            if self.ui.tableWidgetSpecialItemTypes.isRowHidden(row):    # deleted row

                # set allowables with UID

                uid, code, _type, allowables = '-1',self.ui.tableWidgetSpecialItemTypes.item(row, 1).text(),'',self.ui.tableWidgetSpecialItemTypes.item(row, 0).text()

            else:

                uid = self.ui.tableWidgetSpecialItemTypes.item(row, 0).text()

                code = self.ui.tableWidgetSpecialItemTypes.item(row, 1).text()

                _type = self.ui.tableWidgetSpecialItemTypes.cellWidget(row, 2).currentText()

                allowables = self.ui.tableWidgetSpecialItemTypes.item(row, 3).text() if self.ui.tableWidgetSpecialItemTypes.item(row, 3) is not None else ''

            if code: datas.append((uid, code, _type, allowables))

        app_doc_data = AppDocData.instance()

        app_doc_data.save_special_item_types(datas)

    <addaction name="actionSpecialItemTypes"/>

  <action name="actionSpecialItemTypes">

   <property name="text">

    <string>Special Item Types</string>

   </property>

   <property name="toolTip">

    <string>Special Item Types</string>

   </property>

  </action>

<?xml version="1.0" encoding="UTF-8"?>

<ui version="4.0">

 <class>SpecialItemTypesDialog</class>

 <widget class="QDialog" name="SpecialItemTypesDialog">

  <property name="geometry">

   <rect>

    <x>0</x>

    <y>0</y>

    <width>910</width>

    <height>589</height>

   </rect>

  </property>

  <property name="font">

   <font>

    <family>맑은 고딕</family>

   </font>

  </property>

  <property name="windowTitle">

   <string>Special Item Types</string>

  </property>

  <property name="modal">

   <bool>true</bool>

  </property>

  <layout class="QGridLayout" name="gridLayout">

   <item row="0" column="0">

    <widget class="QTabWidget" name="tabWidget">

     <property name="focusPolicy">

      <enum>Qt::NoFocus</enum>

     </property>

     <property name="currentIndex">

      <number>0</number>

     </property>

     <widget class="QWidget" name="tabSpecialItemTypes">

      <attribute name="title">

       <string>Special Item Types</string>

      </attribute>

      <layout class="QGridLayout" name="gridLayout_3">

       <item row="0" column="0">

        <layout class="QGridLayout" name="gridLayout_2">

         <item row="0" column="0">

          <widget class="QGroupBox" name="groupBox_2">

           <property name="title">

            <string>Special Item Types</string>

           </property>

           <layout class="QGridLayout" name="gridLayout_14">

            <item row="0" column="0">

             <widget class="QTableWidget" name="tableWidgetSpecialItemTypes">

              <property name="columnCount">

               <number>3</number>

              </property>

              <attribute name="verticalHeaderVisible">

               <bool>false</bool>

              </attribute>

              <column/>

              <column/>

              <column/>

             </widget>

            </item>

           </layout>

          </widget>

         </item>

        </layout>

       </item>

      </layout>

     </widget>

    </widget>

   </item>

   <item row="1" column="0">

    <widget class="QDialogButtonBox" name="buttonBox">

     <property name="focusPolicy">

      <enum>Qt::TabFocus</enum>

     </property>

     <property name="orientation">

      <enum>Qt::Horizontal</enum>

     </property>

     <property name="standardButtons">

      <set>QDialogButtonBox::Cancel|QDialogButtonBox::Ok</set>

     </property>

    </widget>

   </item>

  </layout>

 </widget>

 <tabstops>

  <tabstop>tabWidget</tabstop>

 </tabstops>

 <resources/>

 <connections>

  <connection>

   <sender>buttonBox</sender>

   <signal>accepted()</signal>

   <receiver>SpecialItemTypesDialog</receiver>

   <slot>accept()</slot>

   <hints>

    <hint type="sourcelabel">

     <x>257</x>

     <y>454</y>

    </hint>

    <hint type="destinationlabel">

     <x>157</x>

     <y>274</y>

    </hint>

   </hints>

  </connection>

  <connection>

   <sender>buttonBox</sender>

   <signal>rejected()</signal>

   <receiver>SpecialItemTypesDialog</receiver>

   <slot>reject()</slot>

   <hints>

    <hint type="sourcelabel">

     <x>325</x>

     <y>454</y>

    </hint>

    <hint type="destinationlabel">

     <x>286</x>

     <y>274</y>

    </hint>

   </hints>

  </connection>

 </connections>

</ui>

# -*- coding: utf-8 -*-

# Form implementation generated from reading ui file '.\UI\SpecialItemTypes.ui'

#

# Created by: PyQt5 UI code generator 5.11.3

#

# WARNING! All changes made in this file will be lost!

from PyQt5 import QtCore, QtGui, QtWidgets

class Ui_SpecialItemTypesDialog(object):

    def setupUi(self, SpecialItemTypesDialog):

        SpecialItemTypesDialog.setObjectName("SpecialItemTypesDialog")

        SpecialItemTypesDialog.resize(910, 589)

        font = QtGui.QFont()

        font.setFamily("맑은 고딕")

        SpecialItemTypesDialog.setFont(font)

        SpecialItemTypesDialog.setModal(True)

        self.gridLayout = QtWidgets.QGridLayout(SpecialItemTypesDialog)

        self.gridLayout.setObjectName("gridLayout")

        self.tabWidget = QtWidgets.QTabWidget(SpecialItemTypesDialog)

        self.tabWidget.setFocusPolicy(QtCore.Qt.NoFocus)

        self.tabWidget.setObjectName("tabWidget")

        self.tabSpecialItemTypes = QtWidgets.QWidget()

        self.tabSpecialItemTypes.setObjectName("tabSpecialItemTypes")

        self.gridLayout_3 = QtWidgets.QGridLayout(self.tabSpecialItemTypes)

        self.gridLayout_3.setObjectName("gridLayout_3")

        self.gridLayout_2 = QtWidgets.QGridLayout()

        self.gridLayout_2.setObjectName("gridLayout_2")

        self.groupBox_2 = QtWidgets.QGroupBox(self.tabSpecialItemTypes)

        self.groupBox_2.setObjectName("groupBox_2")

        self.gridLayout_14 = QtWidgets.QGridLayout(self.groupBox_2)

        self.gridLayout_14.setObjectName("gridLayout_14")

        self.tableWidgetSpecialItemTypes = QtWidgets.QTableWidget(self.groupBox_2)

        self.tableWidgetSpecialItemTypes.setColumnCount(3)

        self.tableWidgetSpecialItemTypes.setObjectName("tableWidgetSpecialItemTypes")

        self.tableWidgetSpecialItemTypes.setRowCount(0)

        self.tableWidgetSpecialItemTypes.verticalHeader().setVisible(False)

        self.gridLayout_14.addWidget(self.tableWidgetSpecialItemTypes, 0, 0, 1, 1)

        self.gridLayout_2.addWidget(self.groupBox_2, 0, 0, 1, 1)

        self.gridLayout_3.addLayout(self.gridLayout_2, 0, 0, 1, 1)

        self.tabWidget.addTab(self.tabSpecialItemTypes, "")

        self.gridLayout.addWidget(self.tabWidget, 0, 0, 1, 1)

        self.buttonBox = QtWidgets.QDialogButtonBox(SpecialItemTypesDialog)

        self.buttonBox.setFocusPolicy(QtCore.Qt.TabFocus)

        self.buttonBox.setOrientation(QtCore.Qt.Horizontal)

        self.buttonBox.setStandardButtons(QtWidgets.QDialogButtonBox.Cancel|QtWidgets.QDialogButtonBox.Ok)

        self.buttonBox.setObjectName("buttonBox")

        self.gridLayout.addWidget(self.buttonBox, 1, 0, 1, 1)

        self.retranslateUi(SpecialItemTypesDialog)

        self.tabWidget.setCurrentIndex(0)

        self.buttonBox.accepted.connect(SpecialItemTypesDialog.accept)

        self.buttonBox.rejected.connect(SpecialItemTypesDialog.reject)

        QtCore.QMetaObject.connectSlotsByName(SpecialItemTypesDialog)

    def retranslateUi(self, SpecialItemTypesDialog):

        _translate = QtCore.QCoreApplication.translate

        SpecialItemTypesDialog.setWindowTitle(_translate("SpecialItemTypesDialog", "Special Item Types"))

        self.groupBox_2.setTitle(_translate("SpecialItemTypesDialog", "Special Item Types"))

        self.tabWidget.setTabText(self.tabWidget.indexOf(self.tabSpecialItemTypes), _translate("SpecialItemTypesDialog", "Special Item Types"))

<mxfile modified="2019-08-09T22:08:42.413Z" host="" agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) draw.io/11.1.4 Chrome/76.0.3809.88 Electron/6.0.0 Safari/537.36" etag="aiTXJGKOv1sL_9v-4c3-" version="11.1.4" type="device"><diagram id="3IPM_YcNxiEY_o1IJA5j" name="Page-1">7Vpbc5s4FP41PCbDxfjyGDtJs7PdNlNn2pl92RFIXCYCsUKu7f31eyQEGAu7zTQUP9jODPDpSOfo0yeJo9jyVtnuA0dF8hfDhFqujXeWd2+5rjNxXUv+2XhfIXN3UgExT7E2aoF1+h/RoK3RTYpJ2TEUjFGRFl0wZHlOQtHBEOds2zWLGO16LVBMDGAdImqi31IskroXsxZ/Immc1J6d6aIqyVBtrHtSJgiz7QHkPVjeijMmqrtstyJUklfzUtV7PFHaBMZJLn6mAhWB95UG6y/29J9Z+YTvVn8nN7qV74hudIfXBQlTJCv+IUgGl5d9AQNQdUHsa15KwdlrQ4ljecumfzY8YFQmBOsHRNM4h/sQIiUcgERktK1VyCazXSwFdJux8HVT3MJwCpTmhJe32zRX7TbNUBJBh5ffCRcpDNSdhgUrZHsFCtM8/qhs7ucSUZGuGGXcVbF7tj0Po6hb5FVF4UR+oSiCAFRBhU/VR+IppQd4pD6AZxDtC9mpkahqay07M3imKCB0icLXmLNNjusGcpaDyVKPAfSH7E4OrtNIBuYaYRkRfA8musJEi2zffdy2kvV9jSUHcvXqaYb0NImbllslwY0W0xuE5RrCstwpleMmUAAicu2AcUwqGqf/buQsWDrtbSf4ptyGcP2OUQixFAhjGPOO6aRj1Qq3BnXjd1BYt2pXtjU/PUVVyDchoxQVJalsmqcDh9NYX6seBwyWv2OQ98YVNCKRbqRKpA9QGpqFi4nbhNIt1DLsxqm7UOykI0ZhuJTtYh5ErnMm2kTqQU+q1kzNuvOcgnzFja6pmKnmu+HpE8pI7Q3EJR3+7hDgijK5XuRBWVSNHUNy3TPNjOcxe/FVza6zMeBfcnBHKduiPJQbQOsFH3uRIP9Zgf+SNhvXa8oKcjYoEwmMGH9Qcf3x8/PDME7eRNmpNYGgyMXeO037JsRHTuT6fM9hSxua4eF9jaDNTwxqPMOLDBFD8ze4qwvW6ZLkcP/4QAN4PXTtLwinm/Pr1DsQ/rsqnuT9VPvPaRzLl6CBuzGomzd3+mWr9J+gcvC9YHBXb+78E0FYbdqD9ntIL71dlmDfC7PEq9Shxo9SUqHSr05y2eZ3Or2z5dc6ncYxyMIiqtJYaQKIWs+aVPYdUjW/m6o5Tk+u5vXkas5iqFzN68nVTHpbIiS12yQVZA3JtizdQureZf5deOoSNTd58mYmTe5QLE0Mlm7G52jiXRRHvsHR5z9HJ2ni+h2SvJ4ZN/N7DkeGYmlqsLSSORYdnSnfvjCmZubx5D4LmMnUwMeREeNZeRsy8L1ku76dZaE+5s6CMSFqZzk6vWzM9JkkQhifOEjsPYY8OGB0reNjT+995GBsVZ5vyGHRs1MNtrzMTTkIrt5Gr3IYQQ7+fFw5LK5yuCQ5zJ1x5VBvVlc9XIQeXHvk3cLp+efmVQ/j6cFdjKwH96qHS9KD742sB/Pc46qHEfUwmw2lB3hsf2ejyg5+reQ9/A8=</diagram></mxfile>