def get_sys_dict(config_type: int) -> dict:
cursor = mms_db.cursor(pymysql.cursors.DictCursor)
# 582, 1137898764612157433, 583, 584, 566, 567
sql = ('SELECT `VALUE` '
'FROM mms_db.td_s_dict '
'WHERE ID={id};').format(id=config_type)
cursor.execute(sql)
data = cursor.fetchone()
cursor.close()
return data
def get_user_by_user_id(user_id) -> dict:
"""查询会员的详细信息"""
cursor = mms_db.cursor(pymysql.cursors.DictCursor)
sql = ('SELECT `USER_ID`,'
'`CUSTOMER_ID`,`USER_NM`,`USER_TYPE`,`CONTACTER`,`CONTACTER_PHONE` '
'FROM mms_db.tf_f_user '
f'WHERE `USER_ID`={user_id};').format(user_id=user_id)
cursor.execute(sql)
data = cursor.fetchone()
cursor.close()
return data
def get_user_by_serial_number(serial_number: Union[str, int]) -> dict:
"""查询会员的详细信息"""
cursor = mms_db.cursor(pymysql.cursors.DictCursor)
sql = ('SELECT `USER_ID`,'
'`CUSTOMER_ID`,`USER_NM`,`USER_TYPE`,`CONTACTER`,`CONTACTER_PHONE` '
'FROM mms_db.tf_f_user '
'WHERE SERIAL_NUMBER={phone};').format(phone=serial_number)
cursor.execute(sql)
data = cursor.fetchone()
cursor.close()
return data
def get_consignor_config(user_id, config_type: int or str) -> dict:
cursor = mms_db.cursor(pymysql.cursors.DictCursor)
# 56，57，98，128
sql = ('SELECT `VALUE` '
'FROM mms_db.tf_f_consignor_config '
'WHERE USER_ID={user_id} '
'AND CONFIG_TYPE={config_type};').format(user_id=user_id,
config_type=config_type)
cursor.execute(sql)
data = cursor.fetchone()
cursor.close()
return data
def get_pre_order_config(user_id):
"""查询货主预挂配置"""
cursor = mms_db.cursor()
sql = ('SELECT '
'`VALUE` '
'FROM mms_db.tf_f_consignor_config '
'WHERE USER_ID = {user_id} '
'AND config_type = 94 '
'AND DELETE_FLAG=0;').format(user_id=user_id)
cursor.execute(sql)
data = cursor.fetchone()
if not data:
raise ValueError('数据库返回None，检查user_id')
order_config = json.loads(data[0])
cursor.close()
return order_config
def get_consignor_type(user_id):
"""获取货主的交易类型：现结/账期"""
cursor = mms_db.cursor(pymysql.cursors.DictCursor)
sql = ('SELECT '
'`BUSINESS_TYPE`,'
'`SETTLE_METHOD`,'
'`STATUS`,'
'`UP_SETTLE_PART_NAME`,'
'`DOWN_SETTLE_PART_NAME`,'
'`DELETE_FLAG` '
'FROM mms_db.td_b_account_subject_config '
'WHERE USER_ID = {user_id} '
'AND STATUS = 1;').format(user_id=user_id)
cursor.execute(sql)
consignor_type = cursor.fetchone()
cursor.close()
return consignor_type