def return_list_data(self):
"""
根据搜索条件返回搜索结果
:return:
"""
base.consoleLog('加载信用卡页面数据')
sql = """SELECT
card_id,
card_name,
card_number,
card_quota,
account_date,
repayment_date,
binding_payment_name,
welfare,
welfare_data
FROM
credit_card
WHERE
deleted = 0
ORDER BY
create_time ;"""
data = MySqlite(sql).select_sql()
sql = "SELECT count(*) from credit_card where deleted=0;"
count = MySqlite(sql).select_sql()[0][0]
result = {}
result['data'] = data
result['count'] = count
return result
def return_list_data(self, select_dict):
"""
根据搜索条件返回搜索结果
:return:
"""
base.consoleLog('根据搜索条件返回还款计划数据')
base.consoleLog('根据搜索条件' + str(select_dict))
sql_count = """SELECT COUNT(*)
FROM financial_repayment_data
WHERE deleted = 0
AND asset_type like "%s"
AND statement_date >= "%s"
AND statement_date <= "%s"
AND repayment_date >= "%s"
AND repayment_date <= "%s" """ % (
"%" + select_dict['assetTypeData'] + "%",
select_dict['statementStartData'], select_dict['statementEndData'],
select_dict['repaymentStartData'], select_dict['repaymentEndData'])
count = MySqlite(sql_count).select_sql()[0][0]
sql = """SELECT asset_type, statement_date, repayment_date, repayment_period, repayment_amount,ID,repayment_state
FROM financial_repayment_data
WHERE deleted = 0
AND asset_type like "%s"
AND statement_date >= "%s"
AND statement_date <= "%s"
AND repayment_date >= "%s"
AND repayment_date <= "%s" ORDER BY repayment_date limit "%s",25 """ % (
"%" + select_dict['assetTypeData'] + "%",
select_dict['statementStartData'], select_dict['statementEndData'],
select_dict['repaymentStartData'], select_dict['repaymentEndData'],
select_dict['one'])
data = MySqlite(sql).select_sql()
sql_repayment_amount = """SELECT sum(repayment_amount)
FROM financial_repayment_data
WHERE deleted = 0
AND asset_type like "%s"
AND statement_date >= "%s"
AND statement_date <= "%s"
AND repayment_date >= "%s"
AND repayment_date <= "%s" """ % (
"%" + select_dict['assetTypeData'] + "%",
select_dict['statementStartData'], select_dict['statementEndData'],
select_dict['repaymentStartData'], select_dict['repaymentEndData'])
if count == 0:
repayment_amount = 0.00
page_number = '0/' + str(math.ceil(float(count) / 25))
else:
repayment_amount = '%.2f' % MySqlite(
sql_repayment_amount).select_sql()[0][0]
page_number = '1/' + str(math.ceil(float(count) / 25))
result = {}
result['data'] = data
result['count'] = count
result['page_number'] = page_number
result['repayment_amount'] = repayment_amount
base.consoleLog('返回财务流水数据：' + str(result))
return result
def return_list_data(self, dict_data):
"""
根据搜索条件返回搜索结果
:param: dict_data
:return:
"""
base.consoleLog('查询 项目运行 的数据并返回')
sql = """SELECT
project,
project_text,
update_time,
result,
executor,
script,
ID
FROM
test_demo
WHERE
deleted = 0
AND project like '%s'
and project_text like '%s'
and executor like'%s'
ORDER BY
update_time DESC limit '%s','25';""" % (
'%' + dict_data['project'] + '%', '%' + dict_data['project_text'] +
'%', '%' + dict_data['executor'] + '%', dict_data['one'])
data = MySqlite(sql).select_sql()
sql_count = """SELECT
count(*)
FROM
test_demo
WHERE
deleted = 0
AND project like '%s'
and project_text like '%s'
and executor like '%s'
ORDER BY
update_time DESC;""" % ('%' + dict_data['project'] + '%',
'%' + dict_data['project_text'] + '%',
'%' + dict_data['executor'] + '%')
count = MySqlite(sql_count).select_sql()[0][0]
if count == 0:
page_number = '0/0'
else:
page_number = '1/' + str(math.ceil(float(count) / 25))
result = {}
result['data'] = data
result['count'] = count
result['page_number'] = page_number
base.consoleLog('返回项目运行页面数据：' + str(result))
return result
def update_credit_card(self):
base.consoleLog('获取新增信用卡详情的内容，如果修改了重新保存')
card_name = QLineEdit.displayText(self.credit_card_name_lineEdit)
card_number = QLineEdit.displayText(self.credit_card_number_lineEdit)
card_quota = QLineEdit.displayText(self.credit_card_quota_lineEdit)
account_date = QLineEdit.displayText(
self.credit_card_account_date_lineEdit)
repayment_date = QLineEdit.displayText(
self.credit_card_repayment_date_lineEdit)
binding_payment_name = QLineEdit.displayText(
self.credit_card_binding_payment_name_lineEdit)
welfare = QLineEdit.displayText(self.credit_card_welfare_lineEdit)
welfare_data = QLineEdit.displayText(
self.credit_card_welfare_data_lineEdit)
ID = int(self.windowTitle().split('信用卡详情')[1])
if card_name == '' or card_number == '' or card_quota == '' or account_date == '' or repayment_date == '' or binding_payment_name == '' or welfare == '' or welfare_data == '':
QMessageBox.about(self, "提示", "您有部分数据为空，请输入完整信息之后再点击保存!")
return
sql = """update credit_card set card_name='%s',card_number='%s',card_quota='%s',account_date='%s',repayment_date='%s',binding_payment_name='%s',welfare='%s',welfare_data='%s',update_time='%s' where card_id = '%s' ;
""" % (
card_name, card_number, card_quota, account_date, repayment_date,
binding_payment_name, welfare, welfare_data, base.time_time(), ID)
MySqlite(sql).update_sql()
QMessageBox.about(self, "提示", "您的信用卡信息更新成功!")
self.close()
return
def get_yes(self):
"""
点击确定
:return:
"""
base.consoleLog('删除信用卡点击确定按钮')
ID = int(self.windowTitle().split('警告')[1])
#先判断是否被删除
sql = """select deleted from credit_card where card_id='%s'""" % ID
deleted = MySqlite(sql).select_sql()[0][0]
if deleted=='1':
self.close()
QMessageBox.about(self, "警告", "该条数据已被删除，请刷新列表！")
return
sql = """update credit_card set deleted=1,update_time='%s' where card_id='%s';""" % (base.time_time(),ID)
MySqlite(sql).update_sql()
self.close()
QMessageBox.about(self, "提示", "该条数据删除成功！")
return
def return_list_data(self, select_dict):
"""
根据搜索条件返回搜索结果
:return:
"""
base.consoleLog('根据搜索条件返回关键字页面数据')
base.consoleLog('根据搜索条件' + str(select_dict))
sql_count = """SELECT COUNT(*)
FROM keyword
WHERE deleted = 0
AND keyword_name like "%s"
AND keyword_name like "%s"
""" % (
"%" + select_dict['keyword_name'] + "%", "%" + select_dict['keyword_name'] + "%")
count = MySqlite(sql_count).select_sql()[0][0]
sql = """SELECT keyword_name, keyword_text, keyword_data, keyword_data_text, demo,ID
FROM keyword
WHERE deleted = 0
AND keyword_name like "%s"
AND keyword_name like "%s"
""" % (
"%" + select_dict['keyword_name'] + "%", "%" + select_dict['keyword_name'] + "%")
data = MySqlite(sql).select_sql()
if count == 0:
page_number = '0/' + str(math.ceil(float(count) / 25))
else:
page_number = '1/' + str(math.ceil(float(count) / 25))
result = {}
result['data'] = data
result['count'] = count
result['page_number'] = page_number
base.consoleLog('返回关键字页面查询数据：' + str(result))
return result
def get_yes(self):
"""
点击确定
:return:
"""
base.consoleLog('运行项目界面点击确定按钮')
ID = int(self.windowTitle().split('项目执行')[1])
#先判断是否被删除
sql = """select script from test_demo where ID='%s'""" % ID
script = MySqlite(sql).select_sql()[0][0]
subprocess.Popen('python3 %s' % script)
print(script)
QMessageBox.about(self, "提示", "项目正在后台执行中,稍后查看邮件测试报告或者查看明细")
self.close()
return
def update_capital_info(self):
"""
详情更新还款计划的信息
:return:
"""
base.consoleLog('详情更新还款计划的信息')
statementDateData = QLineEdit.displayText(self.statementDateInfoLineEdit)
repaymentDateData = QLineEdit.displayText(self.repaymentDateInfoLineEdit)
repaymentPeriodDateData = QLineEdit.displayText(self.repaymentPeriodInfoLineEdit)
repaymentAmountDate = QLineEdit.displayText(self.repaymentAmountInfoLineEdit)
ID = int(self.windowTitle().split('还款计划信息')[1])
if statementDateData == '' or repaymentDateData == '' or repaymentPeriodDateData == '' or repaymentAmountDate == '':
QMessageBox.about(self, "提示", "您有部分数据为空，请输入完整信息之后再点击保存!")
return
sql = """update financial_repayment_data set statement_date='%s',repayment_date='%s',repayment_period='%s',repayment_amount='%s',update_time='%s' where ID='%s';
""" % (statementDateData, repaymentDateData, repaymentPeriodDateData,repaymentAmountDate,base.time_time(),ID)
MySqlite(sql).update_sql()
QMessageBox.about(self, "提示", "您的还款计划内容更新成功!")
self.close()
return
def update_financial_flow_info(self):
"""
更新账单流水
:return:
"""
base.consoleLog('更新账单流水详情的值')
updateevent = QLineEdit.displayText(self.updateeventLineEdit)
updatedata = QLineEdit.displayText(self.updatedataLineEdit)
updatevalue = QLineEdit.displayText(self.updatevalueLineEdit)
ID = int(self.windowTitle().split('财务流水信息')[1])
if updateevent == '' or updatedata == '' or updatevalue == '':
QMessageBox.about(self, "提示", "您有部分数据为空，请输入完整信息之后再点击保存!")
return
sql = """update financial_flow set event='%s',datas='%s',money='%s',update_time='%s' where ID='%s';
""" % (updateevent, updatedata, updatevalue, base.time_time(), ID)
MySqlite(sql).update_sql()
QMessageBox.about(self, "提示", "您的财务流水信息更新成功!")
self.close()
return
def return_list_data(self, select_dict):
"""
根据搜索条件返回搜索结果
:return:
"""
base.consoleLog('根据搜索条件返回财务流水数据')
base.consoleLog('根据搜索条件' + str(select_dict))
sql_count = """SELECT COUNT(*)
FROM financial_flow
WHERE deleted = 0
AND classification like "%s"
AND create_name like "%s"
AND datas >= "%s"
AND datas <= "%s"
AND money >= "%s"
AND money <= "%s" """ % (
"%" + select_dict['classificationtData'] + "%",
"%" + select_dict['createNameData'] + "%",
select_dict['dataStartData'], select_dict['dataEndData'],
select_dict['moneyMinData'], select_dict['moneyMaxData'])
count = MySqlite(sql_count).select_sql()[0][0]
sql = """SELECT event, classification, datas, money, create_name,ID
FROM financial_flow
WHERE deleted = 0
AND classification like "%s"
AND create_name like "%s"
AND datas >= "%s"
AND datas <= "%s"
AND money >= "%s"
AND money <= "%s" ORDER BY datas desc limit "%s",25 """ % (
"%" + select_dict['classificationtData'] + "%", "%" +
select_dict['createNameData'] + "%", select_dict['dataStartData'],
select_dict['dataEndData'], select_dict['moneyMinData'],
select_dict['moneyMaxData'], select_dict['one'])
data = MySqlite(sql).select_sql()
sql_repayment_amount = """SELECT sum(money)
FROM financial_flow
WHERE deleted = 0
AND classification like "%s"
AND create_name like "%s"
AND datas >= "%s"
AND datas <= "%s"
AND money >= "%s"
AND money <= "%s" """ % (
"%" + select_dict['classificationtData'] + "%",
"%" + select_dict['createNameData'] + "%",
select_dict['dataStartData'], select_dict['dataEndData'],
select_dict['moneyMinData'], select_dict['moneyMaxData'])
if count == 0:
repayment_amount = 0.00
page_number = '0/' + str(math.ceil(float(count) / 25))
else:
repayment_amount = '%.2f' % MySqlite(
sql_repayment_amount).select_sql()[0][0]
page_number = '1/' + str(math.ceil(float(count) / 25))
result = {}
result['data'] = data
result['count'] = count
result['page_number'] = page_number
result['repayment_amount'] = repayment_amount
base.consoleLog('返回还款计划数据：' + str(result))
return result