/ - Diff - HYTOS - 일정관리

                     sheet.cell(row = 1, column = col).fill = PatternFill(patternType='solid', fill_type='solid', fgColor=Color('8DB4E2'))
                     sheet.cell(row = 1, column = col).border = border
                     col += 1
                 '''
                 withoutEmpty = []
                 emptys = []
                 for col in range(len(self.columnOrder[index])):
                     if self.columnOrder[index][col].split(self.delimiterCombine)[0] == self.emptyCol:
                         emptys.append(col)
                     else:
                         withoutEmpty.append(self.columnOrder[index][col])
                 logicalCol = []
                 for header in range(len(withoutEmpty)):
                     target = withoutEmpty[header].split(self.delimiterCombine)[0]
                     for col in range(len(self.columnListAll[index])):
                         if target == self.columnListAll[index][col]:
                             logicalCol.append(table.horizontalHeader().logicalIndex(col))
                             break
                 col = 1
                 emp = 0
                 for header in logicalCol:
                     if header is 0:
                         continue
                     if emp < len(emptys) and col is emptys[emp]:
                         userHeader = self.columnOrder[index][emptys[emp]].split(self.delimiterCombine)[1]
                         sheet.cell(1, col, userHeader)
                         sheet.cell(row = 1, column = col).alignment = Alignment(horizontal='center', vertical='center', wrapText=True)
                         sheet.cell(row = 1, column = col).fill = PatternFill(patternType='solid', fill_type='solid', fgColor=Color('8DB4E2'))
                         sheet.cell(row = 1, column = col).border = border
                         col += 1
                         emp += 1
                     userHeader = table.horizontalHeaderItem(header).text()
                     sheet.cell(1, col, table.horizontalHeaderItem(header).text())
                     sheet.cell(row = 1, column = col).alignment = Alignment(horizontal='center', vertical='center', wrapText=True)
                     sheet.cell(row = 1, column = col).fill = PatternFill(patternType='solid', fill_type='solid', fgColor=Color('8DB4E2'))
                     sheet.cell(row = 1, column = col).border = border
                     col += 1
                 '''
             except Exception as ex:
                 from App import App
                 from AppDocData import MessageType
-...
             @brief      save excel
             @author     kyouho
             @date       2018.08.16
             @history    2018.10.31  euisung     export order apply
             """
             try:
                 thin = Side(border_style='thin', color='000000')
-...
                     target = withoutEmpty[header].split(self.delimiterCombine)[0]
                     for col in range(len(self.columnListAll[index])):
                         if target == self.columnListAll[index][col]:
                             logicalCol.append(table.horizontalHeader().logicalIndex(col))
                             logicalCol.append(col)
                             break
                 exportCol = [0]
-...
                 for table in self.viewTables:
                     self.initialTables.append(table.horizontalHeader().saveState())
                 # config -> list
                 for index in range(len(self.viewTables)):
                     self.columnOrder[index] = docData.getConfigs(dbListOrderName[index], str(index))[0].value.split(self.delimiter)
                 self.sortListOrder()
             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))
-...
                     self.viewTables[index].setColumnCount(len(self.columnListAll[index]))
                     self.viewTables[index].setHorizontalHeaderLabels(self.columnListAll[index])
                     self.viewTables[index].horizontalHeader().restoreState(self.initialTables[index])
                     #self.columnOrder[index] = docData.getConfigs(dbListOrderName[index], str(index))[0].value.split(self.delimiter)
                     self.columnOrder[index] = docData.getConfigs(dbListOrderName[index], str(index))[0].value.split(self.delimiter)
                     withoutEmpty = []
                     emptys = []
                     emptysUserHeader = []
-...
             """
             from ItemDataFormatDialog import QItemDataFormatDialog
             docData = AppDocData.instance()
             for index in range(len(self.viewTables)):
                 self.columnOrder[index] = docData.getConfigs(dbListOrderName[index], str(index))[0].value.split(self.delimiter)
             item_data_format_dialog = QItemDataFormatDialog(self, self.columnListAll, self.columnOrder)
             item_data_format_dialog.exec_()
             for index in range(len(self.viewTables)):
                 self.columnOrder[index] = docData.getConfigs(dbListOrderName[index], str(index))[0].value.split(self.delimiter)
             self.sortListOrder()
         '''

                 for logicalCol in range(headerCount):
                     logicalList.append(self.tableWidgets[index].horizontalHeaderItem(logicalCol).text())
                     ueserList.append(self.tableWidgets[index].item(0, logicalCol).text())
                 for i in range(len(self.columnListAll[index])):
                 for i in range(headerCount):
                     currentCol.append(self.tableWidgets[index].horizontalHeader().logicalIndex(i))
                 value = ''

         def retranslateUi(self, ItemDataFormatDialog):
             _translate = QtCore.QCoreApplication.translate
             ItemDataFormatDialog.setWindowTitle(_translate("ItemDataFormatDialog", "리스트 추출 양식 설정"))
             self.pushButtonApply.setText(_translate("ItemDataFormatDialog", "Apply"))
             self.pushButtonClose.setText(_translate("ItemDataFormatDialog", "Close"))
             self.pushButtonApply.setText(_translate("ItemDataFormatDialog", "적용"))
             self.pushButtonClose.setText(_translate("ItemDataFormatDialog", "닫기"))
             self.pushButtonLineAdd.setText(_translate("ItemDataFormatDialog", "선택 속성 추가"))
             self.pushButtonLineEmptyColumn.setText(_translate("ItemDataFormatDialog", "빈 열 삽입"))
             self.pushButtonLineDelete.setText(_translate("ItemDataFormatDialog", "열 삭제"))

             </size>
            </property>
            <property name="text">
             <string>Apply</string>
             <string>적용</string>
            </property>
           </widget>
          </item>
-...
             </size>
            </property>
            <property name="text">
             <string>Close</string>
             <string>닫기</string>
            </property>
           </widget>
          </item>

ID	208c270b57396db167bcb8e9b75498e287ee532d
상위	92c24ec5
하위	162868bf

프로젝트

일반

사용자정보

HYTOS

개정판 208c270b