def initUI(self):
mainLayout = QVBoxLayout()
self.button1 = QPushButton("选择人事拆账表-印力")
self.button1.clicked.connect(self.click_select_my1)
self.button1.setMinimumHeight(70)
self.button2 = QPushButton("选择人事拆账表-印铭")
self.button2.clicked.connect(self.click_select_my2)
self.button2.setMinimumHeight(70)
self.button3 = QPushButton("选择部门编码表")
self.button3.clicked.connect(self.click_select_refer)
self.button3.setMinimumHeight(70)
time_str = Globals.get_time_text_str()
self.label = QLineEdit(time_str)
self.label.setPlaceholderText("输入凭证日期 如2018/11/6...")
self.label.setMinimumHeight(50)
self.button4 = QPushButton("开始处理")
self.button4.clicked.connect(self.click_judge_btn)
self.button4.setMinimumHeight(70)
self.text_browser = QTextBrowser()
mainLayout.addWidget(self.label)
mainLayout.addWidget(self.button1)
mainLayout.addWidget(self.button2)
mainLayout.addWidget(self.button3)
mainLayout.addWidget(self.button4)
mainLayout.addWidget(self.text_browser)
# data
self.my_filename1 = "C:\\Users\\pangjm\\Desktop\\1.xls" #""
self.my_filename2 = "C:\\Users\\pangjm\\Desktop\\2.xlsx" #""
self.refer_filename = "C:\\Users\\pangjm\\Desktop\\部门.xlsx" #""
self.output_dir = Globals.desktop_path + "工资社保公积金\\"
self.out_put_filename1 = Globals.desktop_path + "工资社保公积金\\工资社保公积金汇总.xlsx"
self.out_put_filename2 = Globals.desktop_path + "工资社保公积金\\结转工资.xlsx"
self.out_put_filename3 = Globals.desktop_path + "工资社保公积金\\结转公积金.xlsx"
self.out_put_filename4 = Globals.desktop_path + "工资社保公积金\\结转社保.xlsx"
self.out_put_filename5 = Globals.desktop_path + "工资社保公积金\\预提工资.xlsx"
self.out_put_filename6 = Globals.desktop_path + "工资社保公积金\\预提社保.xlsx"
self.refer_data = None
self.my_data = None
self.setLayout(mainLayout)
self.setWindowTitle("工资社保公积金")
self.setGeometry(550, 150, 900, 800)
self.show()
if not Globals.user:
self.close()
def initUI(self):
mainLayout = QVBoxLayout()
self.button1 = QPushButton("选择古北当月银行流水")
self.button1.clicked.connect(self.click_select_my)
self.button1.setMinimumHeight(70)
self.button2 = QPushButton("选择EAS编码基础信息表")
self.button2.clicked.connect(self.click_select_refer)
self.button2.setMinimumHeight(70)
time_str = Globals.get_time_text_str()
self.label = QLineEdit(time_str)
self.label.setPlaceholderText("输入凭证日期 如2018/11/6...")
self.label.setMinimumHeight(50)
self.button3 = QPushButton("开始处理")
self.button3.clicked.connect(self.click_judge_btn)
self.button3.setMinimumHeight(70)
self.text_browser = QTextBrowser()
mainLayout.addWidget(self.button1)
# mainLayout.addWidget(self.button2)
mainLayout.addWidget(self.label)
mainLayout.addWidget(self.button3)
mainLayout.addWidget(self.text_browser)
# data
self.my_filename = None # "C:\\Users\\pangjm\\Desktop\\源.csv" #""
# self.out_put_filename2 = "C:\\Users\\pangjm\\Desktop\\收到云pos汇总表.xlsx"
self.out_put_filename = Globals.desktop_path + "停车场支付宝返款.xlsx"
self.out_put_filename1 = Globals.desktop_path + "停车场微信返款.xlsx"
self.refer_filename = ""
self.refer_data = None
self.my_data = None
self.setLayout(mainLayout)
self.setWindowTitle("停车场支付宝返款")
self.setGeometry(550, 150, 900, 800)
self.show()
if not Globals.user:
self.close()
def initUI(self):
mainLayout = QVBoxLayout()
self.button1 = QPushButton("选择地产表：标准凭证引出-GX凭证类型")
self.button1.clicked.connect(self.click_select_my)
self.button1.setMinimumHeight(70)
self.button2 = QPushButton("选择基础信息表")
self.button2.clicked.connect(self.click_select_bank)
self.button2.setMinimumHeight(70)
time_str = Globals.get_time_text_str()
self.label = QLineEdit(time_str)
self.label.setPlaceholderText("输入凭证日期 如2018/11/6...")
self.label.setMinimumHeight(50)
self.button3 = QPushButton("开始处理")
self.button3.clicked.connect(self.click_judge_btn)
self.button3.setMinimumHeight(70)
self.text_browser = QTextBrowser()
mainLayout.addWidget(self.button1)
mainLayout.addWidget(self.button2)
mainLayout.addWidget(self.label)
mainLayout.addWidget(self.button3)
mainLayout.addWidget(self.text_browser)
# data
self.my_filename = None # "C:\\Users\\pangjm\\Desktop\\共享导入\\10月导出.xls" #""
self.bank_filename = None # "C:\\Users\\pangjm\\Desktop\\共享导入\\共享凭证导入模板.xlsx" #""
self.out_put_filename = Globals.desktop_path + "共享生成凭证.xlsx"
self.my_data= None
self.bank_data = None
self.setLayout(mainLayout)
self.setWindowTitle("共享导入")
self.setGeometry(550, 150, 900, 800)
self.show()
if not Globals.user:
self.close()
