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