def ktpxpg(user_id): if request.method == 'GET': user = SC_User.query.filter_by(id=user_id).first() kpi_train = SC_Kpi_Train.query.filter_by(user_id=user_id).first() return render_template("Performance/ygpgkh/ktpxpg.html",user=user,kpi_train=kpi_train) else: try: kpi_train = SC_Kpi_Train.query.filter_by(user_id=user_id).first() if kpi_train: kpi_train.train_date = request.form['train_date'] kpi_train.job_tendency = request.form['job_tendency'] kpi_train.class_hour = request.form['class_hour'] kpi_train.cqqk_1 = request.form['cqqk_1'] kpi_train.cqqk_2 = request.form['cqqk_2'] kpi_train.ktjl_1 = request.form['ktjl_1'] kpi_train.ktjl_2 = request.form['ktjl_2'] kpi_train.ktfy_1 = request.form['ktfy_1'] kpi_train.ktfy_2 = request.form['ktfy_2'] kpi_train.ktcs_1 = request.form['ktcs_1'] kpi_train.ktcs_2 = request.form['ktcs_2'] kpi_train.mnbx_1 = request.form['mnbx_1'] kpi_train.mnbx_2 = request.form['mnbx_2'] kpi_train.ztbx_1 = request.form['ztbx_1'] kpi_train.ztbx_2 = request.form['ztbx_2'] kpi_train.jszs_1 = request.form['jszs_1'] kpi_train.jszs_2 = request.form['jszs_2'] kpi_train.tdxz_1 = request.form['tdxz_1'] kpi_train.tdxz_2 = request.form['tdxz_2'] kpi_train.xtgt_1 = request.form['xtgt_1'] kpi_train.xtgt_2 = request.form['xtgt_2'] kpi_train.jyks_1 = request.form['jyks_1'] kpi_train.jyks_2 = request.form['jyks_2'] kpi_train.total = request.form['total'] kpi_train.result = request.form['result'] kpi_train.performance = request.form['performance'] kpi_train.focus_on = request.form['focus_on'] kpi_train.next_work_target = request.form['next_work_target'] kpi_train.individual_expectations = request.form['individual_expectations'] kpi_train.user_id = user_id kpi_train.date_1 = datetime.datetime.now() kpi_train.manager = current_user.id kpi_train.date_2 = datetime.datetime.now() else: SC_Kpi_Train(request.form['train_date'],request.form['job_tendency'],request.form['class_hour'], request.form['cqqk_1'],request.form['cqqk_2'],request.form['ktjl_1'],request.form['ktjl_2'], request.form['ktfy_1'],request.form['ktfy_2'],request.form['ktcs_1'],request.form['ktcs_2'], request.form['mnbx_1'],request.form['mnbx_2'],request.form['ztbx_1'],request.form['ztbx_2'], request.form['jszs_1'],request.form['jszs_2'],request.form['tdxz_1'],request.form['tdxz_2'], request.form['xtgt_1'],request.form['xtgt_2'],request.form['jyks_1'],request.form['jyks_2'], request.form['total'],request.form['result'],request.form['performance'],request.form['focus_on'], request.form['next_work_target'],request.form['individual_expectations'], user_id,datetime.datetime.now(),current_user.id,datetime.datetime.now()).add() #同时修改SC_Kpi_Train_Final表 kpi_train_final = SC_Kpi_Train_Final.query.filter_by(user_id=user_id).first() if kpi_train_final: kpi_train_final.score_1 = request.form['total'] else: kpi_train_final = SC_Kpi_Train_Final(user_id) kpi_train_final.add() db.session.flush() kpi_train_final.score_1 = request.form['total'] # 事务提交 db.session.commit() # 消息闪现 flash('保存成功','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('保存失败','error') return redirect('Performance/ygpgkh/pxqpglist')
def sjczpg(index,user_id): if request.method == 'GET': user = SC_User.query.filter_by(id=user_id).first() kpi_train_operate = SC_Kpi_Train_Operate.query.filter_by(index=index,user_id=user_id).first() return render_template("Performance/ygpgkh/sjczpg.html",user=user,index=index,kpi_train_operate=kpi_train_operate) else: try: kpi_train_operate = SC_Kpi_Train_Operate.query.filter_by(index=index,user_id=user_id).first() if kpi_train_operate: kpi_train_operate.job_tendency = request.form['job_tendency'] kpi_train_operate.index = index kpi_train_operate.assess_date = request.form['assess_date'] kpi_train_operate.marketing_plain = request.form['marketing_plain'] kpi_train_operate.marketing_complete = request.form['marketing_complete'] kpi_train_operate.marketing_score = request.form['marketing_score'] kpi_train_operate.sign_plain = request.form['sign_plain'] kpi_train_operate.sign_complete = request.form['sign_complete'] kpi_train_operate.sign_score = request.form['sign_score'] kpi_train_operate.loan_balance_plain = request.form['loan_balance_plain'] kpi_train_operate.loan_balance_complete = request.form['loan_balance_complete'] kpi_train_operate.loan_balance_score = request.form['loan_balance_score'] kpi_train_operate.monitor_plain = request.form['monitor_plain'] kpi_train_operate.monitor_complete = request.form['monitor_complete'] kpi_train_operate.monitor_score = request.form['monitor_score'] kpi_train_operate.ywdlx = request.form['ywdlx'] kpi_train_operate.yxnl = request.form['yxnl'] kpi_train_operate.dqdc = request.form['dqdc'] kpi_train_operate.sdhcs = request.form['sdhcs'] kpi_train_operate.jszs = request.form['jszs'] kpi_train_operate.khfw = request.form['khfw'] kpi_train_operate.kqjl = request.form['kqjl'] kpi_train_operate.zrx = request.form['zrx'] kpi_train_operate.gtxt = request.form['gtxt'] kpi_train_operate.tdxz = request.form['tdxz'] kpi_train_operate.total = request.form['total'] kpi_train_operate.result = request.form['result'] kpi_train_operate.performance = request.form['performance'] kpi_train_operate.focus_on = request.form['focus_on'] kpi_train_operate.next_work_target = request.form['next_work_target'] kpi_train_operate.individual_expectations = request.form['individual_expectations'] kpi_train_operate.user_id = user_id kpi_train_operate.date_1 = datetime.datetime.now() kpi_train_operate.manager = current_user.id kpi_train_operate.date_2 = datetime.datetime.now() else: SC_Kpi_Train_Operate(request.form['job_tendency'],index,request.form['assess_date'],request.form['marketing_plain'], request.form['marketing_complete'],request.form['marketing_score'],request.form['sign_plain'], request.form['sign_complete'],request.form['sign_score'],request.form['loan_balance_plain'], request.form['loan_balance_complete'],request.form['loan_balance_score'],request.form['monitor_plain'], request.form['monitor_complete'],request.form['monitor_score'],request.form['ywdlx'],request.form['yxnl'], request.form['dqdc'],request.form['sdhcs'],request.form['jszs'],request.form['khfw'],request.form['kqjl'], request.form['zrx'],request.form['gtxt'],request.form['tdxz'],request.form['total'],request.form['result'], request.form['performance'],request.form['focus_on'],request.form['next_work_target'],request.form['individual_expectations'], user_id,datetime.datetime.now(),current_user.id,datetime.datetime.now()).add() #同时修改SC_Kpi_Train_Final表 kpi_train_final = SC_Kpi_Train_Final.query.filter_by(user_id=user_id).first() if kpi_train_final: if index == 1: kpi_train_final.score_2 = request.form['total'] elif index == 2: kpi_train_final.score_3 = request.form['total'] elif index == 3: kpi_train_final.score_4 = request.form['total'] else: kpi_train_final = SC_Kpi_Train_Final(user_id) kpi_train_final.add() db.session.flush() if index == 1: kpi_train_final.score_2 = request.form['total'] elif index == 2: kpi_train_final.score_3 = request.form['total'] elif index == 3: kpi_train_final.score_4 = request.form['total'] # 事务提交 db.session.commit() # 消息闪现 flash('保存成功','success') except: # 回滚 db.session.rollback() logger.exception('exception') # 消息闪现 flash('保存失败','error') return redirect('Performance/ygpgkh/pxqpglist')