def assets_receivable(loan_apply_id): ''' 资产负债表-应收账款,预付账款 账户类型,0:应收账款,1:预付账款 ''' if request.method == 'POST': result={'result':'success'} try: sc_assets_receivable( request.form['loan_apply_id'],request.form['accounts_type'], request.form['customer_name'],request.form['describe'],request.form['proportion'], request.form['amount'] ).add() # 事务提交 db.session.commit() # 消息闪现 #flash('保存成功','Success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 #flash('保存失败','Error') result={'result':'fail'} finally: return json.dumps(result,ensure_ascii=False) else : data = sc_assets_receivable.query.filter_by(loan_apply_id==loan_apply_id).all() encoder.FLOAT_REPR = lambda o: format(o, '.2f')#使float类型字段只显示两位小数 return json.dumps(data,ensure_ascii=False)
def change_password(id): if request.method == 'POST': try: user = SC_User.query.filter_by(id=id).first() if user.login_password == GetStringMD5(request.form['old_password']): user.login_password = GetStringMD5(request.form['login_password']) else: raise Exception # 事务提交 db.session.commit() # 消息闪现 flash('修改密码成功,请重新登录!','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('修改密码失败,为保障账号安全,请重新登录后再尝试修改!','error') logout_user() return redirect("login") else: return render_template("change_password.html")
def assets_fixed_assets(loan_apply_id): ''' 资产负债表-固定资产清单 ''' if request.method == 'POST': result={'result':'success'} try: sc_assets_fixed_assets( request.form['loan_apply_id'],request.form['assets_type'], request.form['assets_name'],request.form['assets_ah'],request.form['describe'], request.form['assets_date'],request.form['price'],request.form['amount'] ).add() # 事务提交 db.session.commit() # 消息闪现 #flash('保存成功','Success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 #flash('保存失败','Error') result={'result':'fail'} finally: return json.dumps(result,ensure_ascii=False) else : data = sc_assets_fixed_assets.query.filter_by(loan_apply_id==loan_apply_id).all() encoder.FLOAT_REPR = lambda o: format(o, '.2f')#使float类型字段只显示两位小数 return json.dumps(data,cls=json_encoding.DateEncoder,ensure_ascii=False)
def assets_receipts(loan_apply_id): """ 资产负债表-预收账款 """ if request.method == "POST": result = {"result": "success"} try: sc_assets_receipts( request.form["loan_apply_id"], request.form["source"], request.form["occur_date"], request.form["describe"], request.form["amount"], ).add() # 事务提交 db.session.commit() # 消息闪现 # flash('保存成功','Success') except: # 回滚 db.session.rollback() logger.exception("exception") # 消息闪现 # flash('保存失败','Error') result = {"result": "fail"} finally: return json.dumps(result, ensure_ascii=False) else: data = sc_assets_receipts.query.filter_by(loan_apply_id == loan_apply_id).all() encoder.FLOAT_REPR = lambda o: format(o, ".2f") # 使float类型字段只显示两位小数 return json.dumps(data, cls=json_encoding.DateEncoder, ensure_ascii=False)
def add(self, request): try: SC_parameter_configure.query.delete() db.session.flush() level_base_list = request.form.getlist('level_base') level_A1_list = request.form.getlist('level_A1') level_A2_list = request.form.getlist('level_A2') level_A3_list = request.form.getlist('level_A3') level_R_list = request.form.getlist('level_R') back_payment = request.form['back_payment'] performance_a = request.form['performance_a'] performance_b = request.form['performance_b'] performance_c = request.form['performance_c'] level_a = request.form['level_a'] level_b = request.form['level_b'] for i in range(len(level_base_list)): SC_parameter_configure(i + 1, level_base_list[i], level_A1_list[i], level_A2_list[i], level_A3_list[i], level_R_list[i], back_payment,performance_a, performance_b, performance_c, level_a, level_b).add() # 事务提交 db.session.commit() # 消息闪现 flash('保存成功', 'success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('保存失败', 'error')
def edit_jggl(id): if request.method == 'POST': try: obj = OA_Org.query.filter_by(id=id).first() obj.name = request.form['name'] obj.manager = request.form['manager'] obj.amount = request.form['amount'] obj.is_caiwu = request.form['is_caiwu'] obj.modify_user = current_user.id obj.modify_date = datetime.datetime.now() # 事务提交 db.session.commit() # 消息闪现 flash('保存成功','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('保存失败','error') return redirect('System/jggl') else: obj = OA_Org.query.filter_by(id=id).first() user = OA_User.query.filter("id!=1").all() return render_template("System/org/edit_jggl.html",obj=obj,user=user)
def edit_zkqd(id): if request.method == 'GET': accounts_list = SC_Accounts_List.query.filter_by(id=id).first() return render_template("Process/dqdc/edit_zkqd.html",accounts_list=accounts_list) else: try: accounts_list = SC_Accounts_List.query.filter_by(id=id).first() accounts_list.name = request.form['name'] accounts_list.original_price = request.form['original_price'] accounts_list.occur_date = request.form['occur_date'] accounts_list.deadline = request.form['deadline'] accounts_list.present_price = request.form['present_price'] accounts_list.cooperation_history = request.form['cooperation_history'] accounts_list.average_period = request.form['average_period'] accounts_list.trading_frequency = request.form['trading_frequency'] accounts_list.turnover = request.form['turnover'] accounts_list.pay_type = request.form['pay_type'] accounts_list.source = request.form['source'] accounts_list.other_info = request.form['other_info'] # 事务提交 db.session.commit() # 消息闪现 flash('保存成功','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('保存失败','error') return redirect('Process/dqdc/dqdc')
def sc_asset_info(belong_customer_type,belong_customer_value): if request.method == 'POST': try: SC_Asset_Info(request.form['asset_name'],request.form['asset_type'], request.form['asset_description'],request.form['asset_position'],request.form['credentials_name'], request.form['credentials_no'],request.form['appraisal'],request.form['is_mortgage'], request.form['mortgage_amount'],request.form['mortgage_object'], belong_customer_type,belong_customer_value).add() # 事务提交 db.session.commit() # 消息闪现 flash('保存成功','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('保存失败','error') return redirect('xxgl') else: asset_type = SC_Asset_Type.query.order_by("id").all() asset_info = SC_Asset_Info.query.filter_by(belong_customer_type=belong_customer_type, belong_customer_value=belong_customer_value).order_by("id").all() if belong_customer_type == 'Company': customer = SC_Company_Customer.query.filter_by(id=belong_customer_value).first() return render_template("Information/sc_asset_info.html",customer=customer,asset_type=asset_type, asset_info=asset_info) else: customer = SC_Individual_Customer.query.filter_by(id=belong_customer_value).first() return render_template("Information/sc_asset_info.html",customer=customer,asset_type=asset_type, asset_info=asset_info)
def sc_financial_affairs(belong_customer_type,belong_customer_value): if request.method == 'POST': try: SC_Financial_Affairs(request.form['main_supplier'],request.form['main_client'], request.form['total_assets'],request.form['stock'],request.form['accounts'], request.form['fixed_assets'],request.form['total_liabilities'],request.form['bank_borrowings'], request.form['private_borrowers'],request.form['monthly_sales'],request.form['profit'], request.form['other_monthly_income'],belong_customer_type,belong_customer_value).add() # 事务提交 db.session.commit() # 消息闪现 flash('保存成功','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('保存失败','error') return redirect('xxgl') else: financial_affairs = SC_Financial_Affairs.query.filter_by(belong_customer_type=belong_customer_type, belong_customer_value=belong_customer_value).order_by("id").first() if belong_customer_type == 'Company': customer = SC_Company_Customer.query.filter_by(id=belong_customer_value).first() return render_template("Information/sc_financial_affairs.html",customer=customer,financial_affairs=financial_affairs) else: customer = SC_Individual_Customer.query.filter_by(id=belong_customer_value).first() return render_template("Information/sc_financial_affairs.html",customer=customer,financial_affairs=financial_affairs)
def sc_dealings(belong_customer_type,belong_customer_value): if request.method == 'POST': try: SC_Dealings(request.form['deal_name'],request.form['deal_description'], belong_customer_type,belong_customer_value).add() # 事务提交 db.session.commit() # 消息闪现 flash('保存成功','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('保存失败','error') return redirect('xxgl') else: dealings = SC_Dealings.query.filter_by(belong_customer_type=belong_customer_type, belong_customer_value=belong_customer_value).order_by("id").all() if belong_customer_type == 'Company': customer = SC_Company_Customer.query.filter_by(id=belong_customer_value).first() return render_template("Information/sc_dealings.html",customer=customer,dealings=dealings) else: customer = SC_Individual_Customer.query.filter_by(id=belong_customer_value).first() return render_template("Information/sc_dealings.html",customer=customer,dealings=dealings)
def sc_relations(belong_customer_type,belong_customer_value): if request.method == 'POST': try: SC_Relations(request.form['relation_no'],request.form['relation_name'], request.form['relation_type'],request.form['cgbl'],request.form['business_name'], request.form['relation_describe'],belong_customer_type,belong_customer_value).add() # 事务提交 db.session.commit() # 消息闪现 flash('保存成功','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('保存失败','error') return redirect('xxgl') else: if belong_customer_type == 'Company': customer = SC_Company_Customer.query.filter_by(id=belong_customer_value).first() return render_template("Information/sc_relations.html",customer=customer) else: customer = SC_Individual_Customer.query.filter_by(id=belong_customer_value).first() return render_template("Information/sc_relations.html",customer=customer)
def delete_khxxgl(type,id): loan_apply = SC_Loan_Apply.query.filter_by(belong_customer_type=type,belong_customer_value=id).first() if loan_apply is None: try: if type == "Individual": SC_Individual_Customer.query.filter_by(id=id).delete() else: SC_Company_Customer.query.filter_by(id=id).delete() SC_Dealings.query.filter_by(belong_customer_type=type,belong_customer_value=id).delete() SC_Relations.query.filter_by(belong_customer_type=type,belong_customer_value=id).delete() SC_Manage_Info.query.filter_by(belong_customer_type=type,belong_customer_value=id).delete() SC_Asset_Info.query.filter_by(belong_customer_type=type,belong_customer_value=id).delete() SC_Financial_Affairs.query.filter_by(belong_customer_type=type,belong_customer_value=id).delete() SC_Other_Info.query.filter_by(belong_customer_type=type,belong_customer_value=id).delete() # 事务提交 db.session.commit() # 消息闪现 flash('删除成功','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('删除失败','error') else: flash('该客户已提交贷款申请,无法删除','error') return redirect('Information/khxxgl')
def assets_loan(loan_apply_id): ''' 资产负债表-银行贷款,社会集资 ''' if request.method == 'POST': result={'result':'success'} try: sc_assets_loan( request.form['loan_apply_id'],request.form['loan_type'], request.form['loan_org'],request.form['loan_amount'],request.form['loan_date'], request.form['loan_deadline'],request.form['guarantee'],request.form['banlance'] ).add() # 事务提交 db.session.commit() # 消息闪现 #flash('保存成功','Success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 #flash('保存失败','Error') result={'result':'fail'} finally: return json.dumps(result,ensure_ascii=False) else : data = sc_assets_loan.query.filter_by(loan_apply_id==loan_apply_id).all() encoder.FLOAT_REPR = lambda o: format(o, '.2f')#使float类型字段只显示两位小数 return json.dumps(data,cls=json_encoding.DateEncoder,ensure_ascii=False)
def dqdcXed_zcfzb(loan_apply_id): if request.method == 'GET': balance_sheets = SC_Balance_Sheet.query.filter_by(loan_apply_id=loan_apply_id).order_by("id").all() count_0 = SC_Balance_Sheet.query.filter_by(loan_apply_id=loan_apply_id,loan_type=0).count() count_2 = SC_Balance_Sheet.query.filter_by(loan_apply_id=loan_apply_id,loan_type=2).count() count_4 = SC_Balance_Sheet.query.filter_by(loan_apply_id=loan_apply_id,loan_type=4).count() count_6 = SC_Balance_Sheet.query.filter_by(loan_apply_id=loan_apply_id,loan_type=6).count() count_10 = SC_Balance_Sheet.query.filter_by(loan_apply_id=loan_apply_id,loan_type=10).count() count_12 = SC_Balance_Sheet.query.filter_by(loan_apply_id=loan_apply_id,loan_type=12).count() return render_template("Process/dqdc/dqdcXed_zcfzb.html",loan_apply_id=loan_apply_id, balance_sheets=balance_sheets,count_0=count_0,count_2=count_2,count_4=count_4,count_6=count_6, count_10=count_10,count_12=count_12) else: try: SC_Balance_Sheet.query.filter_by(loan_apply_id=loan_apply_id).delete() db.session.flush() for i in range(34): for j in range(len(request.form.getlist('type_%s' % i))): SC_Balance_Sheet(loan_apply_id,i,request.form.getlist('name_%s' % i)[j], j,request.form.getlist('value_%s' % i)[j]).add() # 事务提交 db.session.commit() # 消息闪现 flash('保存成功','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('保存失败','error') return redirect('Process/dqdc/dqdcXed_zcfzb/%d' % loan_apply_id)
def assets_stock(loan_apply_id): ''' 资产负债表-存货 ''' if request.method == 'POST': result={'result':'success'} try: sc_assets_stock( request.form['loan_apply_id'],request.form['stock_type'], request.form['stock_evaluate'],request.form['stock_mobility'],request.form['proportion'], request.form['amount'] ).add() # 事务提交 db.session.commit() # 消息闪现 #flash('保存成功','Success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 #flash('保存失败','Error') result={'result':'fail'} finally: return json.dumps(result,ensure_ascii=False) else : data = sc_assets_stock.query.filter_by(loan_apply_id==loan_apply_id).all() encoder.FLOAT_REPR = lambda o: format(o, '.2f')#使float类型字段只显示两位小数 return json.dumps(data,ensure_ascii=False)
def sc_other_info(belong_customer_type,belong_customer_value): if request.method == 'POST': try: # 先获取上传文件 f = request.files['attachment'] fname = f.filename f.save(os.path.join(UPLOAD_FOLDER_ABS, fname)) SC_Other_Info(request.form['info_name'],request.form['info_description'], UPLOAD_FOLDER_REL + fname,belong_customer_type,belong_customer_value).add() # 事务提交 db.session.commit() # 消息闪现 flash('保存成功','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('保存失败','error') return redirect('xxgl') else: other_info = SC_Other_Info.query.filter_by(belong_customer_type=belong_customer_type, belong_customer_value=belong_customer_value).order_by("id").all() if belong_customer_type == 'Company': customer = SC_Company_Customer.query.filter_by(id=belong_customer_value).first() return render_template("Information/sc_other_info.html",customer=customer,other_info=other_info) else: customer = SC_Individual_Customer.query.filter_by(id=belong_customer_value).first() return render_template("Information/sc_other_info.html",customer=customer,other_info=other_info)
def new_assets_aa(loan_apply_id): if request.method == "POST": result = {"result": "success"} try: sc_assets_acceptances( request.form["loan_apply_id"], request.form["bank"], request.form["account_expiry_date"], request.form["account_balance"], ).add() # 事务提交 db.session.commit() # 消息闪现 # flash('保存成功','Success') except: # 回滚 db.session.rollback() logger.exception("exception") # 消息闪现 # flash('保存失败','Error') result = {"result": "fail"} finally: return json.dumps(result, ensure_ascii=False) # return redirect('/Process/dqdc/new_xjlfx') else: cfa_data = sc_assets_acceptances.query.filter_by(loan_apply_id == loan_apply_id).all() return json.dumps(cfa_data, cls=json_encoding.DateEncoder, ensure_ascii=False)
def new_company_customer(target_customer_id): if request.method == 'POST': try: SC_Company_Customer(current_user.id,request.form['customer_no'],request.form['customer_name'], request.form['frdb'],request.form['yyzz'],request.form['yyzz_fzjg'],request.form['swdjz'], request.form['swdjz_fzjg'],request.form['gszczj'],request.form['gsyyfw'],request.form['gsclrq'], request.form['gszclx'],request.form['jbhzh'],request.form['zcdz'],request.form['xdz'],request.form['bgdz'], request.form['qtdz'],request.form['education'],request.form['family'],request.form['telephone'], request.form['mobile'],request.form['contact_phone'],request.form['email']).add() # 事务提交 db.session.commit() # 消息闪现 flash('保存成功','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('保存失败','error') return redirect('Information/khxxgl') else: target_customer = SC_Target_Customer.query.filter_by(id=target_customer_id).first() user = SC_User.query.order_by("id").all() regisiter_type = SC_Regisiter_Type.query.order_by("id").all() return render_template("Information/new_company_customer.html",user=user, regisiter_type=regisiter_type,target_customer=target_customer)
def wdgl_delete(id): try: oa_doc = OA_Doc.query.filter_by(id=id).first() doc_versions = OA_Doc_Version.query.filter_by(doc_id=id).all() #删除db OA_Doc.query.filter_by(id=id).delete() db.session.flush() #删权限 OA_Privilege.query.filter_by(privilege_access="OA_Doc",privilege_access_value=id).delete() db.session.flush() #删文件 for obj in doc_versions: if oa_doc.org_id: dir_version = "OA_Org" + "_" +str(oa_doc.org_id)+"/"+str(id)+"_"+str(obj.version) else: dir_version = "OA_Project" + "_" +str(oa_doc.project_id)+"/"+str(id)+"_"+str(obj.version) shutil.rmtree(os.path.join(UPLOAD_FOLDER_ABS,dir_version)) # 事务提交 db.session.commit() # 消息闪现 flash('保存成功','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('保存失败','error') return render_template("wdgl/wdgl.html")
def new_xjlfx(id,type,loan_apply_id): if request.method == 'POST': result={'result':'success'} try: cash_flow( request.form['loan_apply_id'],request.form['type'],request.form['month'],request.form['early_cash'], request.form['sale_amount'],request.form['accounts_receivable'],request.form['prepaments'], request.form['total_cash_flow'],request.form['cash_purchase'],request.form['accounts_payable'], request.form['advance_purchases'],request.form['total_cash_outflow'], request.form['wage_labor'],request.form['tax'], request.form['transportation_costs'],request.form['rent'],request.form['maintenance_fees'], request.form['utility_bills'],request.form['advertising_fees'],request.form['social_intercourse_fees'], request.form['fixed_asset_investment'],request.form['disposal_of_fixed_assets'], request.form['investment_cash_flow'],request.form['bank_loans'],request.form['repayments_bank'], request.form['financing_cash_flow'],request.form['household_expenditure'],request.form['private_use'], request.form['private_cash_flow'],request.form['fixed_costs'], ).add() # 事务提交 db.session.commit() # 消息闪现 #flash('保存成功','Success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 #flash('保存失败','Error') result={'result':'fail'} finally: return json.dumps(result,ensure_ascii=False) else : cash_flow_data = cash_flow.query.filter_by(loan_apply_id==loan_apply_id,type==type).first() encoder.FLOAT_REPR = lambda o: format(o, '.2f')#使float类型字段只显示两位小数 return json.dumps(cash_flow_data,ensure_ascii=False)
def fyzf_check(id, page, create_user): if request.method == "POST": try: # 报销单信息 reimbursement = OA_Reimbursement.query.filter_by(id=id).first() reimbursement.is_paid = 1 reimbursement.paid_date = datetime.datetime.now() db.session.commit() # 消息闪现 flash("保存成功", "success") except: # 回滚 db.session.rollback() logger.exception("exception") # 消息闪现 flash("保存失败", "error") else: project = OA_Project.query.order_by("id").all() reimbursement = OA_Reimbursement.query.filter_by(id=id).first() return render_template( "bxsq/fysp/checkzf_bxsq.html", reimbursement=reimbursement, project=project, userId=current_user.id, create_user=create_user, parentPage=int(page), )
def edit_dkfk(id): try: #保存SC_Approval_Decision剩余信息 approval_decision = SC_Approval_Decision.query.filter_by(loan_apply_id=id).first() approval_decision.loan_date = request.form['loan_date'] approval_decision.first_repayment_date = request.form['first_repayment_date'] #approval_decision.management_coats = request.form['management_coats'] #approval_decision.agency_coats = request.form['agency_coats'] approval_decision.contract_date = request.form['contract_date'] approval_decision.loan_account = request.form['loan_account'] #approval_decision.bank_customer_no = request.form['bank_customer_no'] approval_decision.loan_contract_number = request.form['loan_contract_number'] approval_decision.guarantee_contract_number = request.form['guarantee_contract_number'] approval_decision.collateral_contract_number = request.form['collateral_contract_number'] #保存还款计划 repayment_plan_id = 0 repayment_plan = SC_Repayment_Plan.query.filter_by(loan_apply_id=id).first() if repayment_plan: repayment_plan_id = repayment_plan.id repayment_plan.repayment_type=request.form['repayment_type'] repayment_plan.amount=request.form['amount'] repayment_plan.lending_date=request.form['loan_date'] repayment_plan.first_repayment_date=request.form['first_repayment_date'] repayment_plan.ratio=request.form['rates'] repayment_plan.installmenst=request.form['deadline'] repayment_plan.modify_user=current_user.id repayment_plan.modify_date=datetime.datetime.now() else: repayment_plan_new = SC_Repayment_Plan(id,request.form['repayment_type'],request.form['amount'], request.form['loan_date'],request.form['loan_date'],request.form['rates'], request.form['deadline']) repayment_plan_new.add() db.session.flush() repayment_plan_id = repayment_plan_new.id #保存还款细则 SC_Repayment_plan_detail.query.filter_by(loan_apply_id=id,change_record=1).delete() db.session.flush() for i in range(1,int(request.form['deadline'])+1): SC_Repayment_plan_detail(repayment_plan_id,id,None,request.form['rates'], request.form['mybj%d' % i],request.form['mylx%d' % i], request.form['mybx%d' % i],i,request.form['myrq%d' % i],None,1).add() loan_apply = SC_Loan_Apply.query.filter_by(id=id).first() loan_apply.process_status = PROCESS_STATUS_DKFKJH # 事务提交 db.session.commit() #计算绩效 reckonIncome(id) # 消息闪现 flash('保存成功','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('保存失败','error') return redirect("Process/dkfk/dkfk")
def editRise(self, manager_id, apply_type, level_id, apply_result): try: # 同意 if apply_result == "2": # 晋级 if apply_type == "1": SC_Privilege.query.filter_by( priviliege_master_id=manager_id, privilege_master="SC_User", priviliege_access="sc_account_manager_level", ).update({"priviliege_access_value": int(level_id) + 1}) else: SC_Privilege.query.filter_by( priviliege_master_id=manager_id, privilege_master="SC_User", priviliege_access="sc_account_manager_level", ).update({"priviliege_access_value": int(level_id) - 1}) SC_examine_rise.query.filter_by(manager_id=manager_id, apply_result=1).update( {"apply_result": apply_result} ) # 事务提交 db.session.commit() except: # 回滚 db.session.rollback() logger.exception("exception")
def yidaitong(self): try: #上一个月的第一天 lst_fist = datetime.date(datetime.datetime.now().year,datetime.datetime.now().month-1,1) #上一个月的最后一天 lst_last = datetime.date(datetime.datetime.now().year,datetime.datetime.now().month,1)-datetime.timedelta(1) #获取所有上月存在利润贷款 lst = str(lst_fist) + " 00:00:00" last = str(lst_last) + " 23:59:59" sql = "loan_due_date > '" + lst + "'" sc_bank_loans_main= SC_Bank_Loans_Main.query.filter(sql).all() logger.info("=======模拟利润更新========") for obj in sc_bank_loans_main: sc_loan_apply = SC_Loan_Apply.query.filter_by(id=obj.loan_apply_id).first() logger.info(sc_loan_apply.loan_type) if sc_loan_apply: if sc_loan_apply.loan_type=='2': #接口--模拟利润 server = SOAPpy.SOAPProxy(WEBSERVICE_URL) dd = server.mnlr(obj.loan_account,lst_last.strftime("%Y%m%d")) logger.info("sc_loan_apply:"+str(sc_loan_apply.id)) data = json.loads(dd) self.return_examp(obj.loan_apply_id,data[0]["BYMNLR"]) except: logger.exception('exception')
def assets_other_non_operate(loan_apply_id): ''' 资产负债表-其它非经营资产 ''' if request.method == 'POST': result={'result':'success'} try: sc_assets_other_non_operate( request.form['loan_apply_id'],request.form['project'], request.form['project_owner'],request.form['describe'],request.form['amount'], ).add() # 事务提交 db.session.commit() # 消息闪现 #flash('保存成功','Success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 #flash('保存失败','Error') result={'result':'fail'} finally: return json.dumps(result,ensure_ascii=False) else : data = sc_assets_other_non_operate.query.filter_by(loan_apply_id==loan_apply_id).all() encoder.FLOAT_REPR = lambda o: format(o, '.2f')#使float类型字段只显示两位小数 return json.dumps(data,ensure_ascii=False)
def new_user(): if request.method == 'GET': roles = OA_Role.query.order_by("id").all() return render_template("System/user/new_user.html",roles=roles) else: try: user = OA_User(request.form['login_name'],GetStringMD5(request.form['login_password']), request.form['real_name'],request.form['sex'],request.form['mobile'],request.form['active'],request.form['email']) user.add() #清理缓存 db.session.flush() OA_UserRole(user.id,request.form['roles']).add() # 事务提交 db.session.commit() # 消息闪现 flash('保存成功','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('保存失败','error') return redirect('System/user/1')
def new_cust_mgr(): if request.method=='POST': try: date=datetime.datetime.now() work_type=request.form['work_type'] work_type_detail=request.form['work_type_detail'] s_beg_date=request.form['beg_date'] s_beg_time=time.strptime(s_beg_date,'%H:%M') beg_date=date.replace(hour=s_beg_time.tm_hour,minute=s_beg_time.tm_min) s_end_date=request.form['end_date'] s_end_time=time.strptime(s_end_date,'%H:%M') end_date=date.replace(hour=s_end_time.tm_hour,minute=s_end_time.tm_min) time_consume=request.form['time_consume'] remark=request.form['remark'] SC_Day_Work(work_type,work_type_detail,beg_date,end_date,time_consume,remark).add() # 事务提交 db.session.commit() # 消息闪现 flash('保存成功','success') except: # 回滚 db.session.rollback() logger.exception('error') # 消息闪现 flash('保存失败','error') return redirect('/Cust_mgr/add') elif request.method=='GET': return render_template('/Performance/gsjl/new_gsjl.html')
def edit_user(id): if request.method == 'GET': user = OA_User.query.filter_by(id=id).first() roles = OA_Role.query.order_by("id").all() role = OA_UserRole.query.filter_by(user_id=id).first().oa_userrole_ibfk_2 return render_template("System/user/edit_user.html",user=user,roles=roles,role=role) else: try: user = OA_User.query.filter_by(id=id).first() user.login_name = request.form['login_name'] #user.login_password = request.form['login_password'] user.real_name = request.form['real_name'] user.sex = request.form['sex'] user.mobile = request.form['mobile'] user.active = request.form['active'] user.email = request.form['email'] user.modify_user = current_user.id user.modify_date = datetime.datetime.now() user_role = OA_UserRole.query.filter_by(user_id=id).first() user_role.role_id = request.form['roles'] user_role.modify_user = current_user.id user_role.modify_date = datetime.datetime.now() # 事务提交 db.session.commit() # 消息闪现 flash('保存成功','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('保存失败','error') return redirect('System/user/1')
def data_import(): if request.method == "POST": try: # 先获取上传文件 f = request.files["attachment"] fname = f.filename if not os.path.exists(os.path.join(LOCALDB_FOLDER_ABS, str(current_user.id))): os.mkdir(os.path.join(LOCALDB_FOLDER_ABS, str(current_user.id))) f.save(os.path.join(LOCALDB_FOLDER_ABS, "%d\\%s" % (current_user.id, fname))) SC_LocalDB.query.filter_by(user_id=current_user.id).delete() db.session.flush() SC_LocalDB(current_user.id, fname).add() # 事务提交 db.session.commit() # 消息闪现 flash("保存成功", "success") except: # 回滚 db.session.rollback() logger.exception("exception") # 消息闪现 flash("保存失败", "error") return redirect("Data/drbdsj")
def check_zcfl(loan_apply_id): if request.method == 'GET': view_query_loan = View_Query_Loan.query.filter_by(loan_apply_id=loan_apply_id).first() co_borrower = SC_Co_Borrower.query.filter_by(loan_apply_id=loan_apply_id).all() guaranty = SC_Guaranty.query.filter_by(loan_apply_id=loan_apply_id).all() guarantees = SC_Guarantees.query.filter_by(loan_apply_id=loan_apply_id).all() loan_product = SC_Loan_Product.query.all() return render_template("Process/zcflsh/check_zcfl.html",view_query_loan=view_query_loan, co_borrower=co_borrower,guaranty=guaranty,guarantees=guarantees,loan_product=loan_product) else: try: loan_apply = SC_Loan_Apply.query.filter_by(id=loan_apply_id).first() loan_apply.classify = request.form['classify'] loan_apply.classify_dec = request.form['classify_dec'] # 事务提交 db.session.commit() # 消息闪现 flash('保存成功','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('保存失败','error') return redirect('Process/zcflsh/zcflsh')