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 financial_flow where ID='%s'""" % ID
deleted = MySqlite(sql).select_sql()[0][0]
if deleted == '1':
self.close()
QMessageBox.about(self, "警告", "该条数据已被删除，请刷新列表！")
return
sql = """update financial_flow set deleted=1,update_time='%s' where ID='%s';""" % (
base.time_time(), ID)
MySqlite(sql).update_sql()
self.close()
QMessageBox.about(self, "提示", "该条数据删除成功！")
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 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 decoration_list(self):
"""
硬装清单提交及验证
:return:
"""
base.consoleLog('硬装清单提交及验证')
#制定物品清单
url = 'http://decorate.ishangzu.com/isz_decoration/NewDecorationStuffController/preview'
commonData = [
{
"acceptance_num": None,
"acceptance_num_this": 0,
"acceptance_time": None,
"create_time": base.time_time('second'),
"create_uid": base.get_conf('loginUser','user_id'),
"data_type": "成品安装",
"data_type_len": 26,
"decoration_detial": "家具安装",
"deleted": 0,
"function_zone": "甲",
"function_zone_len": 100,
"hard_deliver_audit_status": None,
"order_type": None,
"predict_delivery_date": None,
"project_id": self.project_id,
"purchase_num": "10",
"purchase_order_no": None,
"remark": None,
"remark_accept": None,
"remark_detail": "",
"remark_return": None,
"replacement_order": None,
"return_name": None,
"return_num": None,
"return_num_this": 0,
"stuff_fees_change_reason": None,
"stuff_list_id": None,
"stuff_list_status": "DRAFT",
"submit_time": None,
"supplier_id": None,
"supplier_name": None,
"total_account": None,
"total_paid": "100.00",
"unit_id": None,
"unit_name": "件",
"unit_price": 10,
"update_time": base.time_time('second'),
"update_uid": base.get_conf('loginUser','user_id'),
"zone_type": None,
"type_index": 0,
"fun_index": 0
}, {
"acceptance_num": None,
"acceptance_num_this": 0,
"acceptance_time": None,
"create_time": base.time_time('second'),
"create_uid": base.get_conf('loginUser','user_id'),
"data_type": "成品安装",
"data_type_len": 26,
"decoration_detial": "嵌入式天花灯-改造",
"deleted": 0,
"function_zone": "甲",
"function_zone_len": 100,
"hard_deliver_audit_status": None,
"order_type": None,
"predict_delivery_date": None,
"project_id": self.project_id,
"purchase_num": "11",
"purchase_order_no": None,
"remark": None,
"remark_accept": None,
"remark_detail": "",
"remark_return": None,
"replacement_order": None,
"return_name": None,
"return_num": None,
"return_num_this": 0,
"stuff_fees_change_reason": None,
"stuff_list_id": None,
"stuff_list_status": "DRAFT",
"submit_time": None,
"supplier_id": None,
"supplier_name": None,
"total_account": None,
"total_paid": "264.00",
"unit_id": None,
"unit_name": "个",
"unit_price": 24,
"update_time": base.time_time('second'),
"update_uid": base.get_conf('loginUser','user_id'),
"zone_type": None,
"fun_index": 1,
"type_index": 1
}, {
"acceptance_num": None,
"acceptance_num_this": 0,
"acceptance_time": None,
"create_time": base.time_time('second'),
"create_uid": base.get_conf('loginUser','user_id'),
"data_type": "成品安装",
"data_type_len": 26,
"decoration_detial": "明装筒灯-改造",
"deleted": 0,
"function_zone": "甲",
"function_zone_len": 100,
"hard_deliver_audit_status": None,
"order_type": None,
"predict_delivery_date": None,
"project_id": self.project_id,
"purchase_num": "12",
"purchase_order_no": None,
"remark": None,
"remark_accept": None,
"remark_detail": "",
"remark_return": None,
"replacement_order": None,
"return_name": None,
"return_num": None,
"return_num_this": 0,
"stuff_fees_change_reason": None,
"stuff_list_id": None,
"stuff_list_status": "DRAFT",
"submit_time": None,
"supplier_id": None,
"supplier_name": None,
"total_account": None,
"total_paid": "403.20",
"unit_id": None,
"unit_name": "个",
"unit_price": 33.6,
"update_time": base.time_time('second'),
"update_uid": base.get_conf('loginUser','user_id'),
"zone_type": None,
"fun_index": 1,
"type_index": 1
}
]
result = interface.myRequest(url,commonData)
if result['code'] != 0:
return result['msg']
#提交硬装清单
url = 'http://decorate.ishangzu.com/isz_decoration/NewDecorationStuffController/saveStuffLists'
sql = """SELECT
b.address,
a.config_order_no,
b.contract_id,
b.contract_num,
b.create_time,
b.entrust_end_date,
b.entrust_start_date,
b.house_code,
b.housekeep_mange_uid,
b.info_id,
a.project_no,
b.sign_date,
b.city_code,
b.city_name
FROM
decoration_house_info b
INNER JOIN new_decoration_project a ON a.info_id = b.info_id
AND a.project_id = '%s' """ % self.project_id
projectInfo = base.searchSQL(sql,db='isz_decoration')[0]
data = {
"newStuffList": commonData,
"project": {
"address": projectInfo[0],
"build_area": "120.00",
"cable_laying_type": "INNERPIPEINNERLINE",
"cable_laying_type_name": None,
"city_code": "330100",
"city_name": "杭州市",
"closed_water_test_result": "Y",
"complete_two_nodes": "[\"VOLUME_SCORE\",\"SURVEY_PROPERTY_DELIVERY\",\"WATER_CLOSED_TEST\",\"PROJECT_PLAN\",\"GOODS_CONFIG_LIST\"]",
"complete_two_nodes_list": ["VOLUME_SCORE", "SURVEY_PROPERTY_DELIVERY", "WATER_CLOSED_TEST",
"PROJECT_PLAN", "GOODS_CONFIG_LIST"],
"config_list_status": "CHECKED",
"config_list_status_name": "已验收",
"config_order_no": projectInfo[1],
"config_progress": "WAIT_DESIGN",
"config_progress_name": "待设计",
"config_submit_time": '%s 13:35:00' % self.now_times,
"config_submit_uid": base.get_conf('loginUser','user_id'),
"config_submit_uname": base.get_conf('loginUser','user_name'),
"construct_uid": "1610",
"construct_uname": "徐经纬",
"construct_uname_phone": "徐经纬/13105715060",
"contract_id": projectInfo[2],
"contract_num": projectInfo[3],
"contract_type": "NEWSIGN",
"contract_type_name": "新签",
"create_time": str(projectInfo[4]),
"create_uid": "8AEF8688600F30F30160257579287F96",
"current_one_node": "PROJECT_PLAN",
"decoration_style": "WUSHE_BREEZE",
"decoration_style_name": "随寓和风",
"deleted": 0,
"deliver_room_date": "1970-01-02 00:00:00.0",
"dispach_remark": "测试",
"entrust_end_date": str(projectInfo[5]),
"entrust_start_date": str(projectInfo[6]),
"entrust_type_fact": "SHARE",
"entrust_type_fact_name": "合租",
"grade": 20,
"hidden_check_date": "1970-01-02 00:00:00.0",
"house_code": projectInfo[7],
"housekeep_mange_name": None,
"housekeep_mange_uid": projectInfo[8],
"info_id": projectInfo[9],
"is_active": "Y",
"is_active_name": "是",
"one_level_nodes": "[\"PLACE_ORDER\",\"DISPATCH_ORDER\",\"SURVEY\",\"PROJECT_PLAN\",\"CONSTRUCTING\",\"PROJECT_CHECK\",\"PROJECT_COMPLETION\"]",
"order_status_name": "进程中",
"order_type_name": "新收配置订单",
"overall_check_date": "1970-01-02 00:00:00.0",
"phone": "18815286582",
"place_order_date": "2018-03-20 20:47:38",
"place_order_dep": "",
"place_order_dep_name": None,
"place_order_reason": "测试",
"place_order_uid": base.get_conf('loginUser','user_id'),
"place_order_uname": base.get_conf('loginUser','user_name'),
"plumbing_type": "INNERPIPE",
"plumbing_type_name": None,
"predict_complete_date": "",
"predict_days": 0,
"predict_hidden_check_date": '%s 00:00:00' % base.now_time(2),
"predict_overall_check_date": '%s 00:00:00' % base.now_time(2),
"predict_stuff_check_date": '%s 00:00:00' % base.now_time(2),
"predict_survey_date": '%s 09:00:00' % base.now_time(2),
"project_id": self.project_id,
"project_no": projectInfo[10],
"project_order_status": "INPROCESS",
"project_order_type": "NEW_COLLECT_ORDER",
"reform_way": "OLDRESTYLE",
"reform_way_fact": "OLDRESTYLE",
"reform_way_fact_name": "老房全装",
"reform_way_name": "老房全装",
"remark": "",
"room_toilet": "3/2",
"sign_date": str(projectInfo[11]),
"sign_name": None,
"sign_uid": "8A2152435DC1AEAA015DDE96F9276279",
"sign_user_phone": None,
"start_time": '%s 00:00:00' % base.now_time(2),
"stuff_check_date": "1970-01-02 00:00:00.0",
"stuff_list_status": "DRAFT",
"stuff_list_status_name": "待下单",
"stuff_order_no": "",
"stuff_submit_time": "1970-01-02 00:00:00.0",
"stuff_submit_uid": "",
"stuff_submit_uname": "",
"supplier_id": "8A2152435FBAEFC3015FBAEFC3000000",
"supplier_name": "测试专用硬装供应商",
"supplier_uid": "8AB398CA5FBAF072015FBB26338A0002",
"supplier_uname": "测试专用硬装员工",
"supplier_uname_phone": "测试专用硬装员工/18815286582",
"timeMap": None,
"total_paid": 0,
"two_level_nodes": "[\"VOLUME_SCORE\",\"SURVEY_PROPERTY_DELIVERY\",\"WATER_CLOSED_TEST\",\"DECORATION_CONFIG_LIST\",\"GOODS_CONFIG_LIST\",\"PROJECT_PLAN\",\"CONCEALMENT_ACCEPTANCE\",\"HARD_ACCEPTANCE\",\"ACCEPTANCE_PROPERTY_DELIVERY\",\"COST_SETTLEMENT\",\"OVERALL_ACCEPTANCE\",\"HOUSE_DELIVERY\",\"INDOOR_PICTURE\"]",
"update_time": '%s 13:35:00' % self.now_times,
"update_uid": "8AEF8688600F30F30160257579287F96",
"wall_condition": "OLDHOUSE",
"wall_condition_name": None
}
}
result = interface.myRequest(url,data)
if result['code'] != 0:
return result['msg']
#装修清单验收
geturl = 'http://decorate.ishangzu.com/isz_decoration/NewDecorationStuffController/getSuffList/%s' % self.project_id
result = interface.myRequest(geturl, method='get')
if result['code'] != 0:
return result['msg']
url = 'http://decorate.ishangzu.com/isz_decoration/NewDecorationStuffController/acceptanceAll'
acceptance_time = base.time_time('second')
data = result['obj']['newStuffList']
for stufflist in data:
stufflist['acceptance_time'] = acceptance_time
stufflist['acceptance_num_this'] = stufflist['purchase_num']
result = interface.myRequest(url, data)
if result['code'] != 0:
base.consoleLog('硬装清单提交验收接口执行失败！')
return result['msg']
base.consoleLog('硬装清单提交验收接口执行成功！')
return
def config_list(self):
"""
物品清单提交及验证
:return:
"""
base.consoleLog('物品清单提交及验证')
#查找房间
url = 'http://decorate.ishangzu.com/isz_decoration/NewConfigurationController/queryZone/%s' % self.project_id
result = interface.myRequest(url, method='get')
if result['code'] != 0:
return result['msg']
result = result['obj']
zoneId = None
for i in result:
if i['function_zone'] == u'甲':
zoneId = i['zone_id']
#添加物品
url = 'http://decorate.ishangzu.com/isz_decoration/NewDecorationConfigController/confirm'
data = [{
"acceptance_num": None,
"acceptance_num_this": None,
"brand_id": None,
"brand_name": "爱上租定制",
"category_flag": None,
"category_one_id": None,
"category_one_len": None,
"category_one_nm": "家具",
"category_two_id": None,
"category_two_nm": "书桌",
"config_list_id": None,
"config_list_status": None,
"config_list_status_name": None,
"create_name": None,
"create_time": None,
"create_uid": None,
"deleted": None,
"flag": None,
"function_zone": "甲",
"function_zone_len": None,
"new_replenish_id": None,
"order_type": None,
"predict_delivery_date": None,
"project_id": self.project_id,
"purchase_num": "10",
"purchase_order_no": None,
"real_delivery_time": None,
"remark": None,
"remark_accept": None,
"remark_return": None,
"replacement_order": None,
"return_num": None,
"return_num_this": None,
"standard_id": None,
"standard_name": "0.86M（3.0）",
"submit_time": None,
"supplier_id": "8A2152435CF3FFF3015D0C64330F0011",
"supplier_name": "浙江品至家具有限公司",
"total_account": None,
"total_paid": 3100,
"unit_id": None,
"unit_name": "张",
"unit_price": 310,
"update_time": None,
"update_uid": None,
"zone_id": zoneId,
"index": 0,
"disabled": "true"}]
result = interface.myRequest(url,data)
if result['code'] != 0:
return result['msg']
#提交订单
url = 'http://decorate.ishangzu.com/isz_decoration/NewDecorationConfigController/submitOrder'
data = [{
"predict_delivery_date": '%s 13:00:00' % self.now_times,
"project_id": self.project_id,
"supplier_id": "8A2152435CF3FFF3015D0C64330F0011",
"supplier_name": "家具供应商:浙江品至家具有限公司"
}]
result = interface.myRequest(url, data)
if result['code'] != 0:
return result['msg']
#验收物品清单
url = 'http://decorate.ishangzu.com/isz_decoration/NewDecorationConfigController/supplierOrdersDetail'
sql = "select supplier_id from new_config_list where project_id='%s' and deleted=0 and config_list_status<>'CHECKED'" % self.project_id
supplier_id = base.searchSQL(sql,db='isz_decoration')[0][0]
data = {"project_id": self.project_id, "supplier_id": supplier_id}
result = interface.myRequest(url, data)
if result['code'] != 0:
return result['msg']
result = result['obj']
url = 'http://decorate.ishangzu.com/isz_decoration/NewDecorationConfigController/acceptance/confirm'
for i in result:
i['real_delivery_time'] = base.time_time('second')
results = interface.myRequest(url, result)
if results['code'] != 0:
base.consoleLog('配置清单接口执行失败！')
return results['msg']
base.consoleLog('配置清单接口执行成功！')
return