def get_column_value(db_table_name, condition_column_name,
condition_column_value, select_column_name):
select_column_value = MySqlOperate().get_one_column_value(
db_table_name, condition_column_name, condition_column_value,
select_column_name)
print("select_column_value:", select_column_value)
return select_column_value
def get_partner_taskid(reportno):
# 获取案件在系统中的taskid
taskid = get_task_id(reportno)
sql = "SELECT task_id FROM zbcf_partner_test.t_partner_operate_record WHERE task_id like '%s%%' and provider !='共享公司' order by id desc LIMIT 1" % taskid
workid = MySqlOperate().mysql_execute(sql)
print("获取partner服务的内部workid为", workid)
return workid
def get_task_id(report_no):
task_id_value = MySqlOperate().get_one_column_value(
'zbcf_business_test.t_cs_task_info', 'case_no', report_no, 'id')
try:
if task_id_value:
print("task_id_value:", task_id_value)
return task_id_value
except Exception as e:
print("无订单可以销案！", e)
def get_user_id(login_name):
# user_id_value = MySqlOperate().get_one_encryption_column_value('zbcf_business_test.t_us_login', 'mobile', mobile, 'id')
user_id_value = MySqlOperate().get_one_column_value(
'zbcf_business_test.t_us_login', 'login_name', login_name, 'id')
try:
if user_id_value:
print("user_id_value:", user_id_value)
return str(user_id_value)
except Exception as e:
print("兼业人员接单失败，中台无订单！", e)
def get_order_status(report_no):
order_status = MySqlOperate().get_one_column_value(
'zbcf_business_test.t_od_order', 'case_no', report_no, 'order_status')
# print('status:', order_status)
return order_status
def get_car_model_id(report_no):
car_model_id_value = MySqlOperate().get_one_column_value(
'zbcf_business_test.t_wk_car_model', 'case_no', report_no, 'id')
print("id:", car_model_id_value)
return car_model_id_value
def get_work_id(order_no):
work_id_value = MySqlOperate().get_one_column_value(
'zbcf_business_test.t_wk_parttime_survey', 'order_no', order_no, 'id')
print("id:", work_id_value)
return work_id_value
def get_company_id(report_no):
company_id_value = MySqlOperate().get_one_column_value(
'db_zbcf_casecenter_test.t_report_info', 'report_no', report_no,
'company_id')
print("company_id:", company_id_value)
return company_id_value
def get_confirm(order_no):
confirm_value = MySqlOperate().get_one_column_value(
'zbcf_business_test.t_wk_parttime_survey', 'order_no', order_no,
'confirm')
print("confirm_value:", confirm_value)
return confirm_value
def get_order_no(report_no):
order_no_value = MySqlOperate().get_one_column_value(
'zbcf_business_test.t_od_order', 'case_no', report_no, 'order_no')
# print("order_no_value:", order_no_value)
return order_no_value
def get_company_id_value(company_name):
company_id_value = MySqlOperate().get_one_column_value(
'zbcf_business_test.t_us_company_info', 'company_name', company_name,
'id')
return company_id_value
def get_member_id(mobile):
memberid = MySqlOperate().get_one_encryption_column_value(
'zbcf_business_test.t_us_member_info', 'mobile', mobile, 'id')
return memberid