HYTOS

# coding: utf-8

"""

This is Engineering Instrument Item module

"""

import sys

import os

import math

from PyQt5.QtGui import *

from PyQt5.QtCore import *

from PyQt5.QtSvg import *

from PyQt5.QtWidgets import (QApplication, QGraphicsItem)

from SymbolSvgItem import SymbolSvgItem

from EngineeringConnectorItem import QEngineeringConnectorItem

from EngineeringTextItem import QEngineeringTextItem

from UserInputAttribute import UserInputAttribute

class QEngineeringInstrumentItem(SymbolSvgItem):

    """

    This is Engineering Instrument Item class

    """

    clicked = pyqtSignal(QGraphicsSvgItem)

    #removed = pyqtSignal(QGraphicsItem)

    INST_COLUMN_LIST = None #['UID', 'ITEM_NO', 'SERVICE', 'FLOW_RATE', 'PRESSURE', 'TEMPERATURE', 'TPYE', 'RANGE', 'NOR_LEVEL_MM', 'NOR_LEVEL_PERCENT', 'DEL_PRESS', 'SHUT_OFF', 'LOCATION', 'PNID_NO', 'REV']

    '''

    '''

    def __init__(self, path, uid=None):

        SymbolSvgItem.__init__(self, path, uid)

        self._measuredVairableCode = None

        self._typeModifier = None

        self._tagSeqNo = None

        self._tagSuffix = None

        if QEngineeringInstrumentItem.INST_COLUMN_LIST is None:

            from AppDocData import AppDocData

            appDocData = AppDocData.instance()

            QEngineeringInstrumentItem.INST_COLUMN_LIST = appDocData.getColNames('INSTRUMENT_DATA_LIST')

    '''

        @brief  getter of measured variable code

        @author humkyung

        @date   2018.05.06

    '''

    @property

    def measuredVariableCode(self):

        return self._measuredVairableCode

    '''

        @brief  setter of measured variable code

        @author humkyung

        @date   2018.05.06

    '''

    @measuredVariableCode.setter

    def measuredVariableCode(self, value):

        self._measuredVairableCode = value

    '''

        @brief  getter of type modifier

        @author humkyung

        @date   2018.05.06

    '''

    @property

    def typeModifier(self):

        return self._typeModifier

    '''

        @brief  setter of type modifier

        @author humkyung

        @date   2018.05.06

    '''

    @typeModifier.setter

    def typeModifier(self, value):

        self._typeModifier = value

    '''

        @brief  getter of tag seq no

        @author humkyung

        @date   2018.05.06

    '''

    @property

    def tagSeqNo(self):

        return self._tagSeqNo

    '''

        @brief  setter of tag seq no

        @author humkyung

        @date   2018.05.06

    '''

    @tagSeqNo.setter

    def tagSeqNo(self, value):

        self._tagSeqNo = value

    '''

        @brief  getter of tag suffix

        @author humkyung

        @date   2018.05.06

    '''

    @property

    def tagSuffix(self):

        return self._tagSuffix

    '''

        @brief  setter of tag suffix

        @author humkyung

        @date   2018.05.06

    '''

    @tagSuffix.setter

    def tagSuffix(self, value):

        self._tagSuffix = value

    '''

        @brief  connect attribute

        @author humkyung

        @date   2018.05.06

    '''

    def connectAttribute(self, attributes):

        self._texts.clear()

        self._symbols.clear()

        try:

            rect = self.sceneBoundingRect()

            for attr in attributes:

                if rect.contains(attr.center()):

                    if issubclass(type(attr), QEngineeringTextItem):

                        attr.owner = self  # set owner of text

                        self._texts.append(attr)

                    elif issubclass(type(attr), SymbolSvgItem):

                        attr._owner = self.uid  # set owner of symbol

                        self._symbols.append(attr)

            self._texts = sorted(self._texts, key=lambda attr: attr.loc[1])    # sort by y coordinate

        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      get attributes

        @author     humkyung

        @date       2018.06.14

    '''

    def getAttributes(self):

        _attrs = {}

        try:

            from AppDocData import AppDocData

            from EngineeringTextItem import QEngineeringTextItem

            # 해당 Type의 attribute setting

            docData = AppDocData.instance()

            symbolAttrs = docData.getSymbolAttribute(self.type)

            for attr in symbolAttrs:

                if attr.AttributeType == 'Text Item':

                    at = int(attr.AttrAt)

                    if len(self._texts) > at:

                        item = self._texts[at]

                        _attrs[attr] = eval(attr.Expression) if attr.Expression else ''

                    else:

                        _attrs[attr] = ''

                elif attr.AttributeType == 'Symbol Item':

                    at = int(attr.AttrAt)

                    if len(self._symbols) > at:

                        item = self._symbols[at]

                        _attrs[attr] = eval(attr.Expression) if attr.Expression else ''

                    else:

                        _attrs[attr] = ''

                else:

                    _attrs[attr] = ''#self.attrs[attr[1]] if attr[1] in self.attrs.keys() else ''

        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)

        return _attrs

    '''

        @brief  generate xml code for attribute

        @author humkyung

        @date   2018.05.06

    '''

    def toXmlAsAttribute(self, parentNode):

        from xml.etree.ElementTree import Element, SubElement, dump, ElementTree

        try:

            attrNode = Element('ATTRIBUTE')

            uidNode = Element('UID')

            uidNode.text = str(self.uid)

            attrNode.append(uidNode)

            nameNode = Element('NAME')

            nameNode.text = 'Measured Variable Code'

            attrNode.append(nameNode)

            valueNode = Element('VALUE')

            valueNode.text = self.measuredVariableCode

            attrNode.append(valueNode)

            parentNode.append(attrNode) 

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

        try:

            attrNode = Element('ATTRIBUTE')

            uidNode = Element('UID')

            uidNode.text = str(self.uid)

            attrNode.append(uidNode)

            nameNode = Element('NAME')

            nameNode.text = 'Type Modifier'

            attrNode.append(nameNode)

            valueNode = Element('VALUE')

            valueNode.text = self.typeModifier

            attrNode.append(valueNode)

            parentNode.append(attrNode) 

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

        try:

            attrNode = Element('ATTRIBUTE')

            uidNode = Element('UID')

            uidNode.text = str(self.uid)

            attrNode.append(uidNode)

            nameNode = Element('NAME')

            nameNode.text = 'Tag Seq No'

            attrNode.append(nameNode)

            valueNode = Element('VALUE')

            valueNode.text = self.tagSeqNo

            attrNode.append(valueNode)

            parentNode.append(attrNode) 

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

        try:

            attrNode = Element('ATTRIBUTE')

            uidNode = Element('UID')

            uidNode.text = str(self.uid)

            attrNode.append(uidNode)

            nameNode = Element('NAME')

            nameNode.text = 'Tag Suffix'

            attrNode.append(nameNode)

            valueNode = Element('VALUE')

            valueNode.text = self.tagSuffix

            attrNode.append(valueNode)

            parentNode.append(attrNode) 

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

    def toSql(self):

        """

        convert instrument data to sql query

        """

        from AppDocData import AppDocData

        appDocData = AppDocData.instance()

        cols = ['UID', 'PNID_NO']

        values = ['?','?']

        param = [str(self.uid), appDocData.activeDrawing.name]

        _attrs = self.getAttributes()

        for key in _attrs.keys():

            cols.append(key.Attribute)

            values.append('?')

            param.append(_attrs[key])

        sql = 'insert or replace into INSTRUMENT_DATA_LIST({}) values({})'.format(','.join(cols), ','.join(values))

        return (sql, tuple(param))

    '''

        @brief      return inst Data List

        @author     kyouho

        @date       2018.08.14

    '''

    def getInstrumentDataList(self):

        dataList = []

        try:

            from AppDocData import AppDocData

            docData = AppDocData.instance()

            attrs = self.getAttributes()

            for index in range(len(QEngineeringInstrumentItem.INST_COLUMN_LIST)):

                dataList.append('')

            dataList[0] = str(self.uid)

            dataList[13] = docData.imgName

            for key in attrs.keys():

                attrInfo = docData.getSymbolAttributeByUID(key.UID)

                attrName = attrInfo.Attribute

                if attrName in QEngineeringInstrumentItem.INST_COLUMN_LIST:

                    colIndex = QEngineeringInstrumentItem.INST_COLUMN_LIST.index(attrName)

                    dataList[colIndex] = attrs[key]

        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)

        return dataList