HYTOS

        @brief  get symbol name

        @brief  get symbol name list

    '''

    def getSymbolListByQuery(self, fieldName=None, param=None):

        ret = []

        try:

            dbPath = self.getCurrentProject().getPath() + "/db/ITI_PID.db"

            conn = sqlite3.connect(dbPath)

            cursor = conn.cursor()

            if fieldName is not None and param is not None:

                sql = 'SELECT * FROM Symbol WHERE ' + fieldName + ' = "' + param + '"'

            else:

                sql = 'SELECT * FROM Symbol'

            try:

                cursor.execute(sql)

                rows = cursor.fetchall()

                if rows is not None and len(rows) > 0:

                    for symbolTuple in rows:

                        sym = symbol.SymbolBase(symbolTuple[1], symbolTuple[2], symbolTuple[3], symbolTuple[4]

                                                , symbolTuple[5], symbolTuple[6], symbolTuple[7], symbolTuple[8], symbolTuple[9]

                                                , symbolTuple[10], symbolTuple[11], symbolTuple[12], symbolTuple[13], symbolTuple[0]) ## uid is last item

                        ret.append(sym)

            except Exception as ex:

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

        finally:

            conn.close()

        return ret

    '''

        @date       18.04.20

    def getSymbolTypeList(self):

        return symbolTypeList

    '''

        @brief      Return Symbol Type Items with "None"

        @author     Jeongwoo

        @date       18.04.06

        @history    Seperate SymbolTypeList and "None"

    '''

    def getSymbolTypeComboBoxItems(self):

        symbolTypeList = self.getSymbolTypeList()

        symbolTypeList.insert(0, "None")

    TREE_DATA_ROLE = Qt.ToolTipRole

    '''

        @brief      Load Symbol Info and add TreeItem with DB

        @author     Jeongwoo

        @date       18.04.20

    '''

        SVG_PATH_ROOT = AppDocData.instance().getCurrentProject().getSvgFilePath()

        symbolTypeList = AppDocData.instance().getSymbolTypeList()

        for symbolType in symbolTypeList:

            parent = QTreeWidgetItem(self, [symbolType])

            symbolList = AppDocData.instance().getSymbolListByQuery('type', symbolType)

            #symbolNameList = AppDocData.instance().getSymbolNameListByType(symbolType)

            for symbol in symbolList:

                symbolItem = QTreeWidgetItem(parent, [symbol.getName()])

                symbolItem.setData(0, self.TREE_DATA_ROLE, symbol) ## ADD DATA

                svgPath = SVG_PATH_ROOT + "/" + symbolType + "/" + symbol.getName() + ".svg"

                icon = QIcon(svgPath)

                symbolItem.setIcon(0, icon)

                symbolItem.svgFilePath = svgPath # save svg file path

    #def loadDirectoryInfo(self, startPath, tree):

    #    for element in os.listdir(startPath):

    #        pathInfo = os.path.join(startPath, element)

    #        parentItem = QTreeWidgetItem(tree, [os.path.basename(element)])

    #        if pathInfo.endswith(".png"):

    #            icon = QIcon(pathInfo)

    #            parentItem.setIcon(0, icon)

    #            parentItem.svgFilePath = pathInfo  # save svg file path

    #        if os.path.isdir(pathInfo):

    #            self.loadDirectoryInfo(pathInfo, parentItem)

    '''

        @brief      Get Symbol data by symbol name

        @author     Jeongwoo

        @date       18.04.20

    '''

        #if itemName.lower().endswith(".png"):

        #path = itemName

        #while tmpItem.parent() is not None:

        #    path = tmpItem.parent().text(columnNo) + "/" + path

        #    tmpItem = tmpItem.parent()

        #fullPath = AppDocData.instance().getCurrentProject().getImageFilePath() + "/" + path # path includes ".png"

        #name = itemName.replace(".png", "")

        name = itemName

        sym = AppDocData.instance().getSymbolByQuery("name", name)

        return sym

        #else:

        #    return None

        @history    18.04.20    Jeongwoo    Change Path in QPixmap

            symData = items[0].data(0, self.TREE_DATA_ROLE)

            pixmap = QPixmap(AppDocData.instance().getCurrentProject().getSvgFilePath() + '/'+symData.getType()+'/' +symData.getName()+ '.svg')