HYTOS

        @brief      get line documentName list

        @author     kyouho

        @date       2018.08.13

    '''

    def getLineDocumentNameList(self):

        result = []

        try:

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

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), 'ITI_PID.db')

            conn = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = conn.cursor()

            sql = 'select DISTINCT(documentName) from LINE_DATA_LIST'

            cursor.execute(sql)

            rows = cursor.fetchall()

            for row in rows:

                result.append(row[0])

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

        finally:

            # Close the db connection

            conn.close()

        return result

    '''

        @brief      get line data list

        @author     kyouho

        @date       2018.08.13

    '''

    def getLineDataList(self, docName = None):

        result = []

        try:

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

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), 'ITI_PID.db')

            conn = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = conn.cursor()

            sql = 'select UID, lineNo, nominalDiameter, fluidCode, tagSeqNo, insulationPurpose, streamNo, phase, pressure, temperature, documentName from LINE_DATA_LIST'

            if docName is not None:

                sql += " where documentName = '{}'".format(docName)

            cursor.execute(sql)

            #columnName = list(map(lambda x: x[0].upper(), cursor.description))

            rows = cursor.fetchall()

            for row in rows:

                data = []

                for index in range(len(cursor.description)):

                    data.append(row[index])

                result.append(data)

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

        finally:

            # Close the db connection

            conn.close()

        return result

    '''

        @brief      set line data list

        @author     kyouho

        @date       2018.08.13

    '''

    def setLineDataList(self, dataLists):

        try:

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

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), 'ITI_PID.db')

            conn = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = conn.cursor()

            for data in dataLists:

                sql = "insert or replace into LINE_DATA_LIST(UID, lineNo, nominalDiameter, fluidCode, tagSeqNo, insulationPurpose, streamNo, phase, pressure, temperature, documentName) values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

                param = (data[0], data[1], data[2], data[3], data[4], data[5], data[6], data[7], data[8], data[9], data[10])

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

        finally:

            # Close the db connection

            conn.close()

    '''

        @brief      delete line data list

        @author     kyouho

        @date       2018.08.13

    '''

    def deleteLineDataList(self, removeUID):

        try:

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

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), 'ITI_PID.db')

            conn = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = conn.cursor()

            for uid in removeUID:

                sql = "delete from LINE_DATA_LIST where uid = '{}'".format(uid)

                cursor.execute(sql)

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

        finally:

            # Close the db connection

            conn.close()

    '''

# coding: utf-8

import os

import sys

from PyQt5.QtCore import *

from PyQt5.QtGui import *

from PyQt5.QtWidgets import *

import sqlite3

from AppDocData import AppDocData

from AppDocData import Config

import ItemDataExport_UI

class QItemDataExportDialog(QDialog):

    def __init__(self, parent):

        QDialog.__init__(self, parent)

        self.sceneLineData = {}

        self.lineColumnList = []

        self.equipColumnList = []

        self.instColumnList = []

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

        self.parent = parent

        self.ui = ItemDataExport_UI.Ui_ItemDataExportDialog()

        self.ui.setupUi(self)

        # save scene data

        self.saveLineDataAtScene()

        # setting combobox

        self.initComboBox()

        # setting table

        self.initTableWidget()

        # evnet connect

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

    '''

        @brief      init combobox

        @author     kyouho

        @date       2018.08.13

    '''

    def initComboBox(self):

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

        self.ui.comboBoxDoc

        docData = AppDocData.instance()

        documentNameData = docData.getLineDocumentNameList()

        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

    '''

    def initTableWidget(self):

        lineTable = self.ui.tableWidgetLineDataList

        equipTable = self.ui.tableWidgetEquipmentDataList

        instTable = self.ui.tableWidgetInstrumentDataList

        # Table Header Label 설정

        self.lineColumnList = ['UID', 'LINENO', 'NOMINALDIAMETER', 'FLUIDCODE', 'TAGSEQNO', 'INSULATIONPURPOSE', 'STREAMNO', 'PHASE', 'PRESSURE', 'TEMPERATURE', 'DOCUMENTNAME']

        self.equipColumnList = ['UID', 'NAME', 'PRESSURE', 'TEMPERATURE', 'DOCUMENTNAME']

        self.instColumnList = ['UID', 'NAME', 'VARIABLECODE', 'TYPEMODIFIER', 'TAGSEQNO', 'TAGSUFFIX', 'DOCUMENTNAME']

        lineTable.setHorizontalHeaderLabels(['UID', 'Line No', 'Nominal\r\nDiameter', 'Fluid Code', 'Tag Seq No', 'Insulation\r\nPurpose', 'Stream No', 'Phase', 'Pressure', 'Temperature', 'Document Name'])

        equipTable.setHorizontalHeaderLabels(['UID', 'Name', 'Pressure', 'Temperature', 'Document Name'])

        instTable.setHorizontalHeaderLabels(['UID', 'Name', 'Variable Code', 'Type Modifier', 'Tag Seq No', 'Tag Suffix', 'Document Name'])

        # Table Header 크기 설정

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

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

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

        # linedata 설정

        self.settingLineData()

    '''

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

                lineTable.setItem(row, dataIndex, QTableWidgetItem(data[dataIndex] if data[dataIndex] is not None else ''))

            row += 1

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

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

            lineTable = self.ui.tableWidgetLineDataList

            rowCount = lineTable.rowCount()

            lineNo = []

            for row in range(rowCount):

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

            for line in self.sceneLineData.keys():

                # 중복 (어떻게 할지)

                if lineNo.count(line) >= 1:

                    continue

                # 신규

                else:

                    rowCount += 1

                    lineTable.setRowCount(rowCount)

                    lineData = self.sceneLineData[line]

                    index = self.lineColumnList.index('DOCUMENTNAME')

                    widgetItem = QTableWidgetItem(docData.imgName)

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

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

                    for data in lineData:

                        columnName = data[0].upper().replace(' ', '')

                        if self.lineColumnList.count(columnName):

                            index = self.lineColumnList.index(columnName)

                            widgetItem = QTableWidgetItem(data[1] if data[1] is not None else '')

                            if widgetItem.text() != '':

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

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

    '''

        @brief      doc name change event

        @author     kyouho

        @date       2018.08.13

    '''

    def docNameChanged(self, text):

        self.settingLineData()

    '''

        @brief      save Line Data at scene

        @author     kyouho

        @date       2018.08.13

    '''

    def saveLineDataAtScene(self):

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

            return

        from QEngineeringLineNoTextItem import QEngineeringLineNoTextItem

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

        for item in items:

            text = item.text()

            attrs = item.getLineNoAttributes(True)

            self.sceneLineData[text] = attrs

    '''

        @brief      save Datas

        @author     kyouho

        @date       2018.08.13

    '''

    def accept(self):

        docData = AppDocData.instance()

        self.saveLineDataList()

        docData.deleteLineDataList(self.removeUID[0])

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

                widgetItem = lineTable.item(rowIndex, columnIndex)

                if widgetItem is not None:

                    dataList.append(widgetItem.text())

                else:

                    if columnIndex == 0:

                        dataList.append(str(uuid.uuid4()))

                    else:

                        dataList.append('')

            dataLists.append(dataList)

        docData.setLineDataList(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'

            else:

                tableName = 'tableWidgetInstrumentDataList'

            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)

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

# Form implementation generated from reading ui file './UI/ItemDataExport.ui'

#

# Created by: PyQt5 UI code generator 5.9.2

#

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

from PyQt5 import QtCore, QtGui, QtWidgets

class Ui_ItemDataExportDialog(object):

    def setupUi(self, ItemDataExportDialog):

        ItemDataExportDialog.setObjectName("ItemDataExportDialog")

        ItemDataExportDialog.resize(1142, 709)

        font = QtGui.QFont()

        font.setFamily("맑은 고딕")

        ItemDataExportDialog.setFont(font)

        self.gridLayout = QtWidgets.QGridLayout(ItemDataExportDialog)

        self.gridLayout.setObjectName("gridLayout")

        self.tabWidget = QtWidgets.QTabWidget(ItemDataExportDialog)

        self.tabWidget.setObjectName("tabWidget")

        self.tabLineList = QtWidgets.QWidget()

        self.tabLineList.setObjectName("tabLineList")

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

        self.gridLayout_3.setObjectName("gridLayout_3")

        self.tableWidgetLineDataList = QtWidgets.QTableWidget(self.tabLineList)

        self.tableWidgetLineDataList.setColumnCount(11)

        self.tableWidgetLineDataList.setObjectName("tableWidgetLineDataList")

        self.tableWidgetLineDataList.setRowCount(0)

        self.tableWidgetLineDataList.verticalHeader().setVisible(False)

        self.gridLayout_3.addWidget(self.tableWidgetLineDataList, 0, 0, 1, 1)

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

        self.tabEquipmentList = QtWidgets.QWidget()

        self.tabEquipmentList.setObjectName("tabEquipmentList")

        self.gridLayout_5 = QtWidgets.QGridLayout(self.tabEquipmentList)

        self.gridLayout_5.setObjectName("gridLayout_5")

        self.tableWidgetEquipmentDataList = QtWidgets.QTableWidget(self.tabEquipmentList)

        self.tableWidgetEquipmentDataList.setColumnCount(5)

        self.tableWidgetEquipmentDataList.setObjectName("tableWidgetEquipmentDataList")

        self.tableWidgetEquipmentDataList.setRowCount(0)

        self.tableWidgetEquipmentDataList.verticalHeader().setVisible(False)

        self.gridLayout_5.addWidget(self.tableWidgetEquipmentDataList, 0, 0, 1, 1)

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

        self.tabInstrumentList = QtWidgets.QWidget()

        self.tabInstrumentList.setObjectName("tabInstrumentList")

        self.gridLayout_7 = QtWidgets.QGridLayout(self.tabInstrumentList)

        self.gridLayout_7.setObjectName("gridLayout_7")

        self.tableWidgetInstrumentDataList = QtWidgets.QTableWidget(self.tabInstrumentList)

        self.tableWidgetInstrumentDataList.setColumnCount(7)

        self.tableWidgetInstrumentDataList.setObjectName("tableWidgetInstrumentDataList")

        self.tableWidgetInstrumentDataList.setRowCount(0)

        self.tableWidgetInstrumentDataList.verticalHeader().setVisible(False)

        self.gridLayout_7.addWidget(self.tableWidgetInstrumentDataList, 0, 0, 1, 1)

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

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

        self.horizontalLayout = QtWidgets.QHBoxLayout()

        self.horizontalLayout.setObjectName("horizontalLayout")

        self.comboBoxDoc = QtWidgets.QComboBox(ItemDataExportDialog)

        self.comboBoxDoc.setObjectName("comboBoxDoc")

        self.horizontalLayout.addWidget(self.comboBoxDoc)

        self.pushButtonExport = QtWidgets.QPushButton(ItemDataExportDialog)

        self.pushButtonExport.setMaximumSize(QtCore.QSize(64, 24))

        self.pushButtonExport.setObjectName("pushButtonExport")

        self.horizontalLayout.addWidget(self.pushButtonExport)

        self.buttonBox = QtWidgets.QDialogButtonBox(ItemDataExportDialog)

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

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

        self.buttonBox.setObjectName("buttonBox")

        self.horizontalLayout.addWidget(self.buttonBox)

        self.gridLayout.addLayout(self.horizontalLayout, 1, 1, 1, 1)

        self.retranslateUi(ItemDataExportDialog)

        self.tabWidget.setCurrentIndex(0)

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

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

        QtCore.QMetaObject.connectSlotsByName(ItemDataExportDialog)

    def retranslateUi(self, ItemDataExportDialog):

        _translate = QtCore.QCoreApplication.translate

        ItemDataExportDialog.setWindowTitle(_translate("ItemDataExportDialog", "리스트 출력"))

        self.tabWidget.setTabText(self.tabWidget.indexOf(self.tabLineList), _translate("ItemDataExportDialog", "라인 리스트"))

        self.tabWidget.setTabText(self.tabWidget.indexOf(self.tabEquipmentList), _translate("ItemDataExportDialog", "장치 리스트"))

        self.tabWidget.setTabText(self.tabWidget.indexOf(self.tabInstrumentList), _translate("ItemDataExportDialog", "계장 리스트"))

        self.pushButtonExport.setText(_translate("ItemDataExportDialog", "Export"))

if __name__ == "__main__":

    import sys

    app = QtWidgets.QApplication(sys.argv)

    ItemDataExportDialog = QtWidgets.QDialog()

    ui = Ui_ItemDataExportDialog()

    ui.setupUi(ItemDataExportDialog)

    ItemDataExportDialog.show()

    sys.exit(app.exec_())

        from ItemDataExportDialog import QItemDataExportDialog

        self.dlgLineDataList = QItemDataExportDialog(self)

CREATE TABLE IF NOT EXISTS LINE_DATA_LIST (

	UID TEXT,

	lineNo TEXT,

	nominalDiameter TEXT,

	fluidCode TEXT,

	tagSeqNo TEXT,

	insulationPurpose TEXT,

	streamNo TEXT,

	phase TEXT,

	pressure TEXT,

	temperature TEXT,

	documentName TEXT,

	CONSTRAINT LINE_DATA_LIST_PK PRIMARY KEY (UID)

);

CREATE UNIQUE INDEX IF NOT EXISTS LINE_DATA_LIST_TAG_NO_IDX ON LINE_DATA_LIST (UID);

    def getLineNoAttributes(self, getLineNo = False):

            if getLineNo:

                res.append(('Line No', self.uid))

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

<ui version="4.0">

 <class>ItemDataExportDialog</class>

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

  <property name="geometry">

   <rect>

    <x>0</x>

    <y>0</y>

    <width>1142</width>

    <height>709</height>

   </rect>

  </property>

  <property name="font">

   <font>

    <family>맑은 고딕</family>

   </font>

  </property>

  <property name="windowTitle">

   <string>리스트 출력</string>

  </property>

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

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

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

     <property name="currentIndex">

      <number>0</number>

     </property>

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

      <attribute name="title">

       <string>라인 리스트</string>

      </attribute>

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

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

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

         <property name="columnCount">

          <number>11</number>

         </property>

         <attribute name="verticalHeaderVisible">

          <bool>false</bool>

         </attribute>

         <column/>

         <column/>

         <column/>

         <column/>

         <column/>

         <column/>

         <column/>

         <column/>

         <column/>

         <column/>

         <column/>

        </widget>

       </item>

      </layout>

     </widget>

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

      <attribute name="title">

       <string>장치 리스트</string>

      </attribute>

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

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

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

         <property name="columnCount">

          <number>5</number>

         </property>

         <attribute name="verticalHeaderVisible">

          <bool>false</bool>

         </attribute>

         <column/>

         <column/>

         <column/>

         <column/>

         <column/>

        </widget>

       </item>

      </layout>

     </widget>

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

      <attribute name="title">

       <string>계장 리스트</string>

      </attribute>

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

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

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

         <property name="columnCount">

          <number>7</number>

         </property>

         <attribute name="verticalHeaderVisible">

          <bool>false</bool>

         </attribute>

         <column/>

         <column/>

         <column/>

         <column/>

         <column/>

         <column/>

         <column/>

        </widget>

       </item>

      </layout>

     </widget>

    </widget>

   </item>

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

    <layout class="QHBoxLayout" name="horizontalLayout">

     <item>

      <widget class="QComboBox" name="comboBoxDoc"/>

     </item>

     <item>

      <widget class="QPushButton" name="pushButtonExport">

       <property name="maximumSize">

        <size>

         <width>64</width>

         <height>24</height>

        </size>

       </property>

       <property name="text">

        <string>Export</string>

       </property>

      </widget>

     </item>

     <item>

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

       <property name="orientation">

        <enum>Qt::Horizontal</enum>

       </property>

       <property name="standardButtons">

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

       </property>

      </widget>

     </item>

    </layout>

   </item>

  </layout>

 </widget>

 <resources/>

 <connections>

  <connection>

   <sender>buttonBox</sender>

   <signal>accepted()</signal>

   <receiver>ItemDataExportDialog</receiver>

   <slot>accept()</slot>

   <hints>

    <hint type="sourcelabel">

     <x>248</x>

     <y>254</y>

    </hint>

    <hint type="destinationlabel">

     <x>157</x>

     <y>274</y>

    </hint>

   </hints>

  </connection>

  <connection>

   <sender>buttonBox</sender>

   <signal>rejected()</signal>

   <receiver>ItemDataExportDialog</receiver>

   <slot>reject()</slot>

   <hints>

    <hint type="sourcelabel">

     <x>316</x>

     <y>260</y>

    </hint>

    <hint type="destinationlabel">

     <x>286</x>

     <y>274</y>

    </hint>

   </hints>

  </connection>

 </connections>

</ui>