HYTOS

# coding: utf-8

"""

This is ItemDataExportDialog module

"""

import os

import sys

from PyQt5.QtCore import *

from PyQt5.QtGui import *

from PyQt5.QtWidgets import *

import sqlite3

from AppDocData import AppDocData, Config

from openpyxl import *

from openpyxl.styles import *

import ItemDataExport_UI

class QItemDataExportDialog(QDialog):

    """

    This is QItemDataExportDialog class

    """

    def __init__(self, parent):

        QDialog.__init__(self, parent)

        self.delimiter = '!-!'

        self.sceneLineData = {}

        self.sceneEquipData = {}

        self.scene_valve_data= {}

        self.sceneInstData = {}

        self.sceneNoteData = {}

        self.lineColumnListAll = ['UID', 'LINE_SIZE', 'LINE_SYMBOL', 'LINE_NO', 'LINE_CLASS', 'LINE_ROUTING_FROM', 'LINE_ROUTING_TO', 'SERVICE_FLUID', 'SERVICE_DENSITY', 'SERVICE_STATE', 'OPERATION_CONDITION_TEMP', 'OPERATION_CONDITION_PRESS', 'DESIGN_CONDITION_TEMP', 'DESIGN_CONDITION_PRESS', 'TEST_CONDITION_TEMP', 'TEST_CONDITION_PRESS', 'INSUL_CODE', 'PAINT_CODE', 'NDE_CODE', 'PWHT', 'PNID_NO']

        self.equipColumnListAll = ['UID', 'ITEM_NO', 'SERVICE', 'NO_REQ', 'FLUID', 'DESC_OF_PART', 'OPERATION_CONDITION_TEMP', 'OPERATION_CONDITION_PRESS', 'DESIGN_CONDITION_TEMP', 'DESIGN_CONDITION_PRESS', 'MATERIAL', 'WEIGHT', 'POWER', 'INSULATION', 'PNID_NO', 'REV']

        self.valveColumnListAll = ['UID', 'ITEM_NO', 'PNID_NO']

        self.instColumnListAll = ['UID', 'ITEM_NO', 'SERVICE', 'FLOW_RATE', 'PRESSURE', 'TEMPERATURE', 'TPYE', 'RANGE', 'NOR_LEVEL_MM', 'NOR_LEVEL_PERCENT', 'DEL_PRESS', 'SHUT_OFF', 'LOCATION', 'PNID_NO', 'REV']

        self.noteColumnListAll = ['UID', 'Note No', 'Description', 'P&ID No']

        self.removeUID = [[], [], [], []]

        self.parent = parent

        self.ui = ItemDataExport_UI.Ui_ItemDataExportDialog()

        self.ui.setupUi(self)

        # line no table setting combobox column

        self.nominalDiameterList = []

        self.fluidCodeList = []

        self.insulationPurposeList = []

        self.pipingMaterialClassList = []

        self.initLineNoAttrData()

        self.lineNoTableComboBoxDic = {}

        self.lineNoTableComboBoxDic[1] = self.nominalDiameterList

        self.lineNoTableComboBoxDic[2] = self.fluidCodeList

        self.lineNoTableComboBoxDic[4] = self.pipingMaterialClassList

        self.lineNoTableComboBoxDic[7] = self.fluidCodeList

        self.lineNoTableComboBoxDic[16] = self.insulationPurposeList

        try:

            # save scene data

            self.saveSceneData()

            # setting combobox

            self.initComboBox()

            # setting table

            self.initTableWidget()

        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))

            from App import App

            from AppDocData import MessageType

            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)

            return None

        # evnet connect

        self.ui.pushButtonItemDataFormat.clicked.connect(self.show_item_data_format_dialog)

        self.ui.comboBoxDoc.currentTextChanged.connect(self.docNameChanged)

        self.ui.pushButtonExport.clicked.connect(self.save_excel)

    '''

        @brief      setting commbobox Data

        @author     kyouho

        @date       2018.08.16

    '''

    def initLineNoAttrData(self):

        docData = AppDocData.instance()

        lineProps = docData.getLineProperties()

        for prop in lineProps:

            if prop[3] == 'Code Table':

                tableName = prop[1].upper().replace(' ','')

                if tableName == 'NOMINALDIAMETER':

                    self.nominalDiameterList = docData.getCodeTable(tableName, True)

                elif tableName == 'FLUIDCODE':

                    self.fluidCodeList = docData.getCodeTable(tableName, True)

                elif tableName == 'INSULATIONPURPOSE':

                    self.insulationPurposeList = docData.getCodeTable(tableName, True)

                elif tableName == 'PIPINGMATERIALSCLASS':

                    self.pipingMaterialClassList = docData.getCodeTable(tableName, True)

    '''

        @brief      save excel

        @author     kyouho

        @date       2018.08.16

    '''

    def save_excel(self):

        try:

            options = QFileDialog.Options()

            options |= QFileDialog.DontUseNativeDialog

            fileName = QFileDialog.getSaveFileName(self, "Save xlsx file", os.getcwd(), "xlsx files(*.xlsx)", options=options)

            wb = Workbook()

            wb.active.title = '라인 리스트'

            wb.create_sheet('장치 리스트')

            wb.create_sheet('밸브 리스트')

            wb.create_sheet('계장 리스트')

            wb.create_sheet('노트 리스트')

            lineTable = self.ui.tableWidgetLineDataList

            equipTable = self.ui.tableWidgetEquipmentDataList

            instTable = self.ui.tableWidgetInstrumentDataList

            noteTable = self.ui.tableWidgetNoteDataList

            lineSheet = wb.worksheets[0]

            equipSheet = wb.worksheets[1]

            valve_sheet = wb.worksheets[2]

            instSheet = wb.worksheets[3]

            noteSheet = wb.worksheets[4]

            self.qtable_to_sheet(lineTable, lineSheet)

            self.qtable_to_sheet(equipTable, equipSheet)

            self.qtable_to_sheet(self.ui.tableWidgetValveDataList, valve_sheet)

            self.qtable_to_sheet(instTable, instSheet)

            self.qtable_to_sheet(noteTable, noteSheet)

            fileName, ext = os.path.splitext(fileName[0])

            wb.save(fileName + ext if ext == '.xlsx' else fileName + '.xlsx')

            QMessageBox.about(self, "알림", '성공적으로 저장하였습니다.')

        except Exception as ex:

            from App import App 

            from AppDocData import MessageType

            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 excel

        @author     kyouho

        @date       2018.08.16

    '''

    def qtable_to_sheet(self, table, sheet):

        self.set_sheet_header(table, sheet)

        self.set_sheet_data(table, sheet)

        self.auto_resize_columns(sheet)

    '''

        @brief      save excel

        @author     kyouho

        @date       2018.08.16

    '''

    def set_sheet_header(self, table, sheet):

        thin = Side(border_style='thin', color='000000')

        border = Border(left=thin, right=thin, top=thin, bottom=thin)

        for index in range(table.columnCount()):

            if not index:

                continue

            sheet.cell(1, index, table.horizontalHeaderItem(index).text())

            sheet.cell(row = 1, column = index).alignment = Alignment(horizontal='center', vertical='center', wrapText=True)

            sheet.cell(row = 1, column = index).fill = PatternFill(patternType='solid', fill_type='solid', fgColor=Color('8DB4E2'))

            sheet.cell(row = 1, column = index).border = border

    def set_sheet_data(self, table, sheet):

        """

        @brief      save excel

        @author     kyouho

        @date       2018.08.16

        """

        thin = Side(border_style='thin', color='000000')

        border = Border(left=thin, right=thin, top=thin, bottom=thin)

        for rowIndex in range(table.rowCount()):

            for colIndex in range(table.columnCount()):

                if not colIndex:

                    continue

                widgetItem = table.cellWidget(rowIndex, colIndex)

                if widgetItem is None:

                    data = table.item(rowIndex, colIndex).text() if table.item(rowIndex, colIndex) is not None else ''

                else:

                    if widgetItem.currentIndex() >= 0:

                        data = widgetItem.currentText()

                    else:

                        data = ''

                sheet.cell(rowIndex + 2, colIndex, data)

                sheet.cell(row = rowIndex+2, column = colIndex).border = border

    def auto_resize_columns(self, sheet):

        """

        @brief      auto resize columns with contents

        @author     humkyung

        @date       2018.10.11

        """

        for col in sheet.columns:

            max_length = 0

            column = col[0].column # Get the column name

            for cell in col:

                try: # Necessary to avoid error on empty cells

                    if len(str(cell.value)) > max_length:

                        max_length = len(cell.value)

                except:

                    pass

            adjusted_width = (max_length + 2) * 1.2

            sheet.column_dimensions[column].width = adjusted_width

    '''

        @brief      init combobox

        @author     kyouho

        @date       2018.08.13

    '''

    def initComboBox(self):

        self.ui.comboBoxDoc.addItem('ALL')

        docData = AppDocData.instance()

        documentNameList = []

        documentNameData = docData.getLineDocumentNameList()

        documentNameList.extend(documentNameData)

        #documentNameData = docData.getEquipDocumentNameList()

        #documentNameList.extend(documentNameData)

        for name in documentNameData:

            self.ui.comboBoxDoc.addItem(name)

        if not self.parent.graphicsView.hasImage():

            return

        result = self.ui.comboBoxDoc.findText(docData.imgName)

        if result == -1:

            self.ui.comboBoxDoc.addItem(docData.imgName)

    '''

        @brief      init table widget

        @author     kyouho

        @date       2018.08.13

        @history    Euisung 2018.10.23 added list export order in db

    '''

    def initTableWidget(self):

        try:

            # 엑셀 추출시 사용할 리스트 오더를 db에서 읽거나 추가

            configs = []

            docData = AppDocData.instance()

            lineOrder = docData.getConfigs('LINE_DATA_LIST_EXPORT_ORDER', '1')

            equipOrder = docData.getConfigs('EQUIPMENT_DATA_LIST_EXPORT_ORDER', '2')

            valveOrder = docData.getConfigs('VALVE_DATA_LIST_EXPORT_ORDER', '3')

            instOrder = docData.getConfigs('INSTRUMENT_DATA_LIST_EXPORT_ORDER', '4')

            noteOrder = docData.getConfigs('NOTE_DATA_LIST_EXPORT_ORDER', '5')

            if len(lineOrder) is 0:

                value = ''

                for header in self.lineColumnListAll:

                    value += (header + self.delimiter)

                value = value[:-len(self.delimiter)]

                configs.append(Config('LINE_DATA_LIST_EXPORT_ORDER', '1', value))

            if len(equipOrder) is 0:

                value = ''

                for header in self.equipColumnListAll:

                    value += (header + self.delimiter)

                value = value[:-len(self.delimiter)]

                configs.append(Config('EQUIPMENT_DATA_LIST_EXPORT_ORDER', '2', value))

            if len(valveOrder) is 0:

                value = ''

                for header in self.valveColumnListAll:

                    value += (header + self.delimiter)

                value = value[:-len(self.delimiter)]

                configs.append(Config('VALVE_DATA_LIST_EXPORT_ORDER', '3', value))

            if len(instOrder) is 0:

                value = ''

                for header in self.instColumnListAll:

                    value += (header + self.delimiter)

                value = value[:-len(self.delimiter)]

                configs.append(Config('INSTRUMENT_DATA_LIST_EXPORT_ORDER', '4', value))

            if len(noteOrder) is 0:

                value = ''

                for header in self.noteColumnListAll:

                    value += (header + self.delimiter)

                value = value[:-len(self.delimiter)]

                configs.append(Config('NOTE_DATA_LIST_EXPORT_ORDER', '5', value))

            docData.saveConfigs(configs)

            # 기존의 저장한 export order로 header 값을 정함

            lineOrder = docData.getConfigs('LINE_DATA_LIST_EXPORT_ORDER', '1')[0].value.split(self.delimiter)

            equipOrder = docData.getConfigs('EQUIPMENT_DATA_LIST_EXPORT_ORDER', '2')[0].value.split(self.delimiter)

            valveOrder = docData.getConfigs('VALVE_DATA_LIST_EXPORT_ORDER', '3')[0].value.split(self.delimiter)

            instOrder = docData.getConfigs('INSTRUMENT_DATA_LIST_EXPORT_ORDER', '4')[0].value.split(self.delimiter)

            noteOrder = docData.getConfigs('NOTE_DATA_LIST_EXPORT_ORDER', '5')[0].value.split(self.delimiter)

        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))

            from App import App

            from AppDocData import MessageType

            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)

        lineTable = self.ui.tableWidgetLineDataList

        equipTable = self.ui.tableWidgetEquipmentDataList

        valveTable = self.ui.tableWidgetValveDataList

        instTable = self.ui.tableWidgetInstrumentDataList

        noteTable = self.ui.tableWidgetNoteDataList

        # set table column count

        noteTable.setColumnCount(4)

        valveTable.setColumnCount(3)

        # Table Header Label 설정

        lineTable.setHorizontalHeaderLabels(lineOrder)

        equipTable.setHorizontalHeaderLabels(equipOrder)

        valveTable.setHorizontalHeaderLabels(valveOrder)

        instTable.setHorizontalHeaderLabels(instOrder)

        noteTable.setHorizontalHeaderLabels(noteOrder)

        # Table Header 크기 설정

        lineTable.horizontalHeaderItem(1).setSizeHint(QSize(25, 25))

        equipTable.horizontalHeaderItem(1).setSizeHint(QSize(25, 25))

        valveTable.horizontalHeaderItem(1).setSizeHint(QSize(25, 25))

        instTable.horizontalHeaderItem(1).setSizeHint(QSize(25, 25))

        noteTable.horizontalHeaderItem(1).setSizeHint(QSize(25, 25))

        # UID column hide

        lineTable.hideColumn(0)

        equipTable.hideColumn(0)

        valveTable.hideColumn(0)

        instTable.hideColumn(0)

        noteTable.hideColumn(0)

        '''add by sung'''

        #lineTable.horizontalHeader().moveSection(3, 1)

        lineTable.horizontalHeader().setSectionsMovable(True)

        # talbe Data 설정

        self.settingLineData()

        self.settingEquipmentData()

        self.set_valve_data()

        self.settingInstrumentData()

        self.settingNoteData()

    '''

        @brief      setting line data

        @author     kyouho

        @date       2018.08.13

    '''

    def settingLineData(self):

        lineTable = self.ui.tableWidgetLineDataList

        docData = AppDocData.instance()

        # 기존 저장된 데이터 불러옴

        index = self.ui.comboBoxDoc.currentIndex()

        text = self.ui.comboBoxDoc.itemText(index)

        if self.ui.comboBoxDoc.currentIndex() == 0:

            text = None

        dataList = docData.getLineDataList(text)

        lineTable.setRowCount(len(dataList))

        row = 0

        for data in dataList:

            for dataIndex in range(len(data)):

                #self.lineNoTableComboBoxDic

                if dataIndex in self.lineNoTableComboBoxDic:

                    tempList = self.lineNoTableComboBoxDic[dataIndex]

                    comboBox = QComboBox()

                    comboBox.setEnabled(False)

                    for comboText in tempList:

                        comboBox.addItem(comboText)

                    tempIndex = comboBox.findText(data[dataIndex])

                    comboBox.setCurrentIndex(tempIndex)

                    lineTable.setCellWidget(row, dataIndex, comboBox)

                else:

                    item = QTableWidgetItem(data[dataIndex] if data[dataIndex] is not None else '')

                    item.setFlags(Qt.ItemIsEnabled)

                    lineTable.setItem(row, dataIndex, item)

            row += 1

        # 현재 문서명이 같으면 중복 체크 (line 경우 lineNo로)

        if docData.imgName is not None and (docData.imgName == text or self.ui.comboBoxDoc.currentIndex() == 0):

            rowCount = lineTable.rowCount()

            lineNo = []

            for row in range(rowCount):

                lineNo.append(lineTable.item(row, 3).text())

            for line in self.sceneLineData.keys():

                lineData = self.sceneLineData[line]

                # 중복 (어떻게 할지)

                if lineNo.count(line) >= 1:

                    rowIndex = lineNo.index(line)

                    for index in range(len(lineData)):

                        if str(lineData[index]):

                            if index in self.lineNoTableComboBoxDic:

                                oldData = lineTable.cellWidget(rowIndex, index).currentText()

                                if oldData != lineData[index]:

                                    tempIndex = lineTable.cellWidget(rowIndex, index).findText(lineData[index])

                                    lineTable.cellWidget(rowIndex, index).setCurrentIndex(tempIndex)

                            else:

                                oldData = lineTable.item(rowIndex, index).text()

                                if oldData != lineData[index]:

                                    lineTable.item(rowIndex, index).setText(lineData[index])

                                    lineTable.item(rowIndex, index).setBackground(QColor(int(134), int(229), int(127)))

                # 신규

                else:

                    rowCount += 1

                    lineTable.setRowCount(rowCount)

                    lineData[0] = ''

                    for index in range(len(lineData)):

                        if index in self.lineNoTableComboBoxDic:

                            tempList = self.lineNoTableComboBoxDic[index]

                            comboBox = QComboBox()

                            comboBox.setEnabled(False)

                            for comboText in tempList:

                                comboBox.addItem(comboText)

                            tempIndex = comboBox.findText(lineData[index])

                            comboBox.setCurrentIndex(tempIndex)

                            lineTable.setCellWidget(rowCount - 1, index, comboBox)

                            item = lineTable.item(rowCount - 1, index)

                            if item is not None:

                                lineTable.item(rowCount - 1, index).setFlags(Qt.ItemIsEnabled)

                        else:

                            item = QTableWidgetItem(lineData[index] if lineData[index] is not None else '')

                            item.setFlags(Qt.ItemIsEnabled)

                            if item.text() != '':

                                item.setBackground(QColor(int(134), int(229), int(127)))

                            lineTable.setItem(rowCount - 1, index, item)

    '''

        @brief      setting equip data

        @author     kyouho

        @date       2018.08.14

    '''

    def settingEquipmentData(self):

        equipTable = self.ui.tableWidgetEquipmentDataList

        docData = AppDocData.instance()

        # 기존 저장된 데이터 불러옴

        index = self.ui.comboBoxDoc.currentIndex()

        text = self.ui.comboBoxDoc.itemText(index)

        if self.ui.comboBoxDoc.currentIndex() == 0:

            text = None

        dataList = docData.getEquipmentDataList(text)

        equipTable.setRowCount(len(dataList))

        row = 0

        for data in dataList:

            for dataIndex in range(len(data)):

                item = QTableWidgetItem(data[dataIndex] if data[dataIndex] is not None else '')

                item.setFlags(Qt.ItemIsEnabled)

                equipTable.setItem(row, dataIndex, item)

            row += 1

        # 현재 문서명이 같으면 중복 체크 (Equipment 경우 uid로)

        if docData.imgName is not None and (docData.imgName == text or self.ui.comboBoxDoc.currentIndex() == 0):

            rowCount = equipTable.rowCount()

            uidList = []

            for row in range(rowCount):

                uidList.append(equipTable.item(row, 0).text())

            for uid in self.sceneEquipData.keys():

                equipData = self.sceneEquipData[uid]

                # 중복 (어떻게 할지)

                if uidList.count(uid) >= 1:

                    rowIndex = uidList.index(uid)

                    for index in range(len(equipData)):

                        if str(equipData[index]):

                            oldData = equipTable.item(rowIndex, index).text()

                            if oldData != equipData[index]:

                                equipTable.item(rowIndex, index).setText(equipData[index])

                                equipTable.item(rowIndex, index).setBackground(QColor(int(134), int(229), int(127)))

                # 신규

                else:

                    rowCount += 1

                    equipTable.setRowCount(rowCount)

                    for index in range(len(equipData)):

                        item = QTableWidgetItem(str(equipData[index]) if equipData[index] is not None else '')

                        item.setFlags(Qt.ItemIsEnabled)

                        if item.text() != '':

                            item.setBackground(QColor(int(134), int(229), int(127)))

                        equipTable.setItem(rowCount - 1, index, item)

    def set_valve_data(self):

        """

        @brief      setting valve data

        @author     humkyung 

        @date       2018.10.11

        """ 

        from EngineeringTextItem import QEngineeringTextItem

        valve_table = self.ui.tableWidgetValveDataList

        docData = AppDocData.instance()

        # 기존 저장된 데이터 불러옴

        index = self.ui.comboBoxDoc.currentIndex()

        text = self.ui.comboBoxDoc.itemText(index)

        if self.ui.comboBoxDoc.currentIndex() == 0:

            text = None

        dataList = docData.get_valve_data_list(text)

        valve_table.setRowCount(len(dataList))

        row = 0

        for data in dataList:

            for dataIndex in range(len(data)):

                item = QTableWidgetItem(data[dataIndex] if data[dataIndex] is not None else '')

                item.setFlags(Qt.ItemIsEnabled)

                valve_table.setItem(row, dataIndex, item)

            row += 1

        # get column headers

        headers = []

        for col in range(valve_table.columnCount()):

            headers.append(valve_table.horizontalHeaderItem(col).text())

        # 현재 문서명이 같으면 중복 체크

        if docData.imgName is not None and (docData.imgName == text or self.ui.comboBoxDoc.currentIndex() == 0):

            rowCount = valve_table.rowCount()

            uidList = []

            for row in range(rowCount):

                uidList.append(valve_table.item(row, 0).text())

            for uid in self.scene_valve_data.keys():

                attrs = self.scene_valve_data[uid].getAttributes()

                # 중복 (어떻게 할지)

                if uidList.count(uid) >= 1:

                    rowIndex = uidList.index(uid)

                    for key in attrs.keys():

                        attr_info = docData.getSymbolAttributeByUID(key)

                        attr_name = attr_info[0] if attr_info is not None else ''

                        if attr_name in headers:

                            oldData = valve_table.item(rowIndex, headers.index(attr_name)).text()

                            if oldData != attrs[key]:

                                valve_table.item(rowIndex, index).setText(attrs[key])

                                valve_table.item(rowIndex, index).setBackground(QColor(int(134), int(229), int(127)))

                # 신규

                else:

                    rowCount += 1

                    valve_table.setRowCount(rowCount)

                    for key in attrs.keys():

                        attr_info = docData.getSymbolAttributeByUID(key)

                        attr_name = attr_info[0] if attr_info is not None else ''

                        if attr_name in headers:

                            if attr_info[2] == 'Text Item':

                                items = [item for item in self.parent.graphicsView.scene.items() if issubclass(type(item), QEngineeringTextItem) and item.uid == attrs[key]]

                                item = QTableWidgetItem(items[0].text() if len(items) > 0 else '')

                            else:

                                item = QTableWidgetItem(str(attrs[key]) if attrs[key] is not None else '')

                            item.setFlags(Qt.ItemIsEnabled)

                            if item.text() != '':

                                item.setBackground(QColor(int(134), int(229), int(127)))

                            valve_table.setItem(rowCount - 1, headers.index(attr_name), item)

                    for attr_name in ['UID', 'PNID_NO']:

                        if attr_name in headers:

                            if attr_name == 'UID':

                                item = QTableWidgetItem(uid)

                            elif attr_name == 'PNID_NO':

                                item = QTableWidgetItem(docData.imgName)

                            item.setFlags(Qt.ItemIsEnabled)

                            if item.text() != '':

                                item.setBackground(QColor(int(134), int(229), int(127)))

                            valve_table.setItem(rowCount - 1, headers.index(attr_name), item)

    '''

        @brief      setting Inst data

        @author     kyouho

        @date       2018.08.14

    '''

    def settingInstrumentData(self):

        instTable = self.ui.tableWidgetInstrumentDataList

        docData = AppDocData.instance()

        # 기존 저장된 데이터 불러옴

        index = self.ui.comboBoxDoc.currentIndex()

        text = self.ui.comboBoxDoc.itemText(index)

        if self.ui.comboBoxDoc.currentIndex() == 0:

            text = None

        dataList = docData.getInstrumentDataList(text)

        instTable.setRowCount(len(dataList))

        row = 0

        for data in dataList:

            for dataIndex in range(len(data)):

                item = QTableWidgetItem(data[dataIndex] if data[dataIndex] is not None else '')

                item.setFlags(Qt.ItemIsEnabled)

                instTable.setItem(row, dataIndex, item)

            row += 1

        # 현재 문서명이 같으면 중복 체크 (Inst 경우 uid로)

        if docData.imgName is not None and (docData.imgName == text or self.ui.comboBoxDoc.currentIndex() == 0):

            rowCount = instTable.rowCount()

            uidList = []

            for row in range(rowCount):

                uidList.append(instTable.item(row, 0).text())

            for uid in self.sceneInstData.keys():

                instData = self.sceneInstData[uid]

                # 중복 (어떻게 할지)

                if uidList.count(uid) >= 1:

                    rowIndex = uidList.index(uid)

                    for index in range(len(instData)):

                        if str(instData[index]):

                            oldData = instTable.item(rowIndex, index).text()

                            if oldData != instData[index]:

                                instTable.item(rowIndex, index).setText(instData[index])

                                instTable.item(rowIndex, index).setBackground(QColor(int(134), int(229), int(127)))

                # 신규

                else:

                    rowCount += 1

                    instTable.setRowCount(rowCount)

                    for index in range(len(instData)):

                        item = QTableWidgetItem(str(instData[index]) if instData[index] is not None else '')

                        item.setFlags(Qt.ItemIsEnabled)

                        if item.text() != '':

                            item.setBackground(QColor(int(134), int(229), int(127)))

                        instTable.setItem(rowCount - 1, index, item)

    '''

        @brief      setting note data

        @author     kyouho

        @date       2018.10.10

    '''

    def settingNoteData(self):

        noteTable = self.ui.tableWidgetNoteDataList

        docData = AppDocData.instance()

        # 기존 저장된 데이터 불러옴

        index = self.ui.comboBoxDoc.currentIndex()

        text = self.ui.comboBoxDoc.itemText(index)

        if self.ui.comboBoxDoc.currentIndex() == 0:

            text = None

        dataList = docData.getNoteDataList(text)

        noteTable.setRowCount(len(dataList))

        row = 0

        for data in dataList:

            for dataIndex in range(len(data)):

                item = QTableWidgetItem(data[dataIndex] if data[dataIndex] is not None else '')

                item.setFlags(Qt.ItemIsEnabled)

                noteTable.setItem(row, dataIndex, item)

            row += 1

        # 현재 문서명이 같으면 중복 체크 (Note 경우 uid로)

        if docData.imgName is not None and (docData.imgName == text or self.ui.comboBoxDoc.currentIndex() == 0):

            rowCount = noteTable.rowCount()

            uidList = []

            for row in range(rowCount):

                uidList.append(noteTable.item(row, 0).text())

            for uid in self.sceneNoteData.keys():

                noteData = self.sceneNoteData[uid]

                # 중복 (어떻게 할지)

                if uidList.count(uid) >= 1:

                    rowIndex = uidList.index(uid)

                    for index in range(len(noteData)):

                        if str(noteData[index]):

                            oldData = noteTable.item(rowIndex, index).text()

                            if oldData != noteData[index]:

                                noteTable.item(rowIndex, index).setText(noteData[index])

                                noteTable.item(rowIndex, index).setBackground(QColor(int(134), int(229), int(127)))

                # 신규

                else:

                    rowCount += 1

                    noteTable.setRowCount(rowCount)

                    for index in range(len(noteData)):

                        item = QTableWidgetItem(str(noteData[index]) if noteData[index] is not None else '')

                        item.setFlags(Qt.ItemIsEnabled)

                        if item.text() != '':

                            item.setBackground(QColor(int(134), int(229), int(127)))

                        noteTable.setItem(rowCount - 1, index, item)

    def show_item_data_format_dialog(self):

        """

        show item data format dialog

        """

        from ItemDataFormatDialog import QItemDataFormatDialog

        item_data_format_dialog = QItemDataFormatDialog(self, self.lineColumnListAll, self.equipColumnListAll, self.valveColumnListAll, self.instColumnListAll, self.noteColumnListAll)

        item_data_format_dialog.exec_()

    '''

        @brief      doc name change event

        @author     kyouho

        @date       2018.08.13

    '''

    def docNameChanged(self, text):

        self.settingLineData()

        self.settingEquipmentData()

    def saveSceneData(self):

        """

        @brief      save Line Data at scene

        @author     kyouho

        @date       2018.08.13

        """

        appDocData = AppDocData.instance()

        if not self.parent.graphicsView.hasImage():

            return

        from EngineeringLineNoTextItem import QEngineeringLineNoTextItem

        items = [item for item in self.parent.graphicsView.scene.items() if type(item) is QEngineeringLineNoTextItem]

        for item in items:

            text = item.text()

            self.sceneLineData[text] = item.getLineDataList()

        from QEngineeringEquipmentItem import QEngineeringEquipmentItem

        items = [item for item in self.parent.graphicsView.scene.items() if type(item) is QEngineeringEquipmentItem]

        for item in items:

            self.sceneEquipData[str(item.uid)] = item.getEquipmentDataList()

        from SymbolSvgItem import SymbolSvgItem 

        items = [item for item in self.parent.graphicsView.scene.items() if type(item) is SymbolSvgItem]

        for item in items:

            self.scene_valve_data[str(item.uid)] = item

        from EngineeringInstrumentItem import QEngineeringInstrumentItem

        items = [item for item in self.parent.graphicsView.scene.items() if type(item) is QEngineeringInstrumentItem]

        for item in items:

            self.sceneInstData[str(item.uid)] = item.getInstrumentDataList()

        from QEngineeringNoteItem import QEngineeringNoteItem

        items = [item for item in self.parent.graphicsView.scene.items() if type(item) is QEngineeringNoteItem]

        for item in items:

            loopIndex = 1

            for note in item.getNoteDataList():

                self.sceneNoteData[str(item.uid) + "-" + str(loopIndex)] = note

                loopIndex += 1

    ''' self.equipmentDataList

        @brief      save Datas

        @author     kyouho

        @date       2018.08.13

    ''' 

    def accept(self):

        docData = AppDocData.instance()

        self.saveLineDataList()

        docData.deleteLineDataList(self.removeUID[0])

        self.saveEquipmentDataList()

        docData.deleteEquipDataList(self.removeUID[1])

        self.saveInstrumentDataList()

        docData.deleteInstDataList(self.removeUID[2])

        self.saveNoteDataList()

        docData.deleteNoteDataList(self.removeUID[3])

        QDialog.accept(self)

    '''

        @brief      save Line Data

        @author     kyouho

        @date       2018.08.13

    '''

    def saveLineDataList(self):

        import uuid

        lineTable = self.ui.tableWidgetLineDataList

        docData = AppDocData.instance()

        dataLists = []

        for rowIndex in range(lineTable.rowCount()):

            dataList = []

            for columnIndex in range(lineTable.columnCount()):

                if columnIndex in self.lineNoTableComboBoxDic:

                    widgetItem = lineTable.cellWidget(rowIndex, columnIndex)

                    if widgetItem.currentIndex() >= 0:

                        dataList.append(widgetItem.currentText())

                    else:

                        dataList.append('')

                else:

                    widgetItem = lineTable.item(rowIndex, columnIndex)

                    if widgetItem is not None:

                        dataList.append(widgetItem.text())

                    else:

                        dataList.append('')

            if dataList[0] is None or dataList[0] == '':

                dataList[0] = str(uuid.uuid4())

            dataLists.append(dataList)

        docData.setLineDataList(dataLists)

    '''

        @brief      save Equip Data

        @author     kyouho

        @date       2018.08.13

    '''

    def saveEquipmentDataList(self):

        import uuid

        equipTable = self.ui.tableWidgetEquipmentDataList

        docData = AppDocData.instance()

        dataLists = []

        for rowIndex in range(equipTable.rowCount()):

            dataList = []

            for columnIndex in range(equipTable.columnCount()):

                widgetItem = equipTable.item(rowIndex, columnIndex)

                if widgetItem is not None:

                    dataList.append(widgetItem.text())

                else:

                    dataList.append('')

            dataLists.append(dataList)

        docData.setEquipmentDataList(dataLists)

    '''

        @brief      save inst Data

        @author     kyouho

        @date       2018.08.13

    '''

    def saveInstrumentDataList(self):

        instTable = self.ui.tableWidgetInstrumentDataList

        docData = AppDocData.instance()

        dataLists = []

        for rowIndex in range(instTable.rowCount()):

            dataList = []

            for columnIndex in range(instTable.columnCount()):

                widgetItem = instTable.item(rowIndex, columnIndex)

                if widgetItem is not None:

                    dataList.append(widgetItem.text())

                else:

                    dataList.append('')

            dataLists.append(dataList)

        docData.setInstrumentDataList(dataLists)

    '''

        @brief      save note Data

        @author     kyouho

        @date       2018.10.10

    '''

    def saveNoteDataList(self):

        noteTable = self.ui.tableWidgetNoteDataList

        docData = AppDocData.instance()

        dataLists = []

        for rowIndex in range(noteTable.rowCount()):

            dataList = []

            for columnIndex in range(noteTable.columnCount()):

                widgetItem = noteTable.item(rowIndex, columnIndex)

                if widgetItem is not None:

                    dataList.append(widgetItem.text())

                else:

                    dataList.append('')

            dataLists.append(dataList)

        docData.setNoteDataList(dataLists)

    '''

        @brief      key press event

        @author     kyouho

        @date       2018.08.13

    '''

    def keyPressEvent(self, e):

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

            _tabWidget = self.ui.tabWidget

            currentTabIndex = _tabWidget.currentIndex()

            tableName = ''

            if currentTabIndex == 0:

                tableName = 'tableWidgetLineDataList'

            elif currentTabIndex == 1:

                tableName = 'tableWidgetEquipmentDataList'

            elif currentTabIndex == 2:

                tableName = 'tableWidgetInstrumentDataList'

            else:

                tableName = 'tableWidgetNoteDataList'

            table = self.findChild(QTableWidget, tableName)

            if table:

                selectedIndexes = table.selectedIndexes()

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

                model = table.model()

                rowsIndex = []

                for row in selectedRows:

                    rowsIndex.append(row)

                #중복 제거

                rowsIndex = list(set(rowsIndex))

                rowsIndex.reverse()

                for row in rowsIndex:

                    uidCell = table.item(row, 0)

                    if uidCell is not None:

                        uid = table.item(row, 0).text()

                        self.removeUID[currentTabIndex].append(uid)

                    model.removeRow(row)