def feedback_to_user(user_id, content):
conn = src.settings._mysql.MYSQL_CONNECTION()
cursor = conn.cursor()
try:
rows_count = src.dao.feedback.insert_platform_return_feedback(cursor, user_id, content)
except Exception as e:
LOGGER_ROOT.exception(e)
return {
'is_success': False,
'des': str(e)
}
else:
cursor.close()
conn.commit()
conn.close()
if rows_count:
return {
'is_success': True,
'user_id': user_id,
'content': content
}
else:
return {
'is_success': False
}
def audit_shop_pass(shop_id):
conn = src.settings._mysql.MYSQL_CONNECTION()
cursor = conn.cursor()
# set fd_t_shopaccount
sql = 'update fd_t_shopaccount set service_deadline = %s, service_status = %s where shop_id = %s'
params = [datetime.datetime.now() + datetime.timedelta(days=365), src.define.SERVICE_STATUS.NORMAL, shop_id]
row_count = cursor.execute(sql, params)
# set fd_t_fansmessage
sql2 = 'update fd_t_fansmessageconfig set ' \
'current_p2p_count = %s, p2p_remain_count = %s, next_p2p_count = %s, ' \
'current_mass_count = %s, mass_remain_count = %s, next_mass_count = %s where shop_id = %s'
params2 = [SETTINGS['fansmessageconfig']['current_p2p_count'],
SETTINGS['fansmessageconfig']['p2p_remain_count'],
SETTINGS['fansmessageconfig']['next_p2p_count'],
SETTINGS['fansmessageconfig']['current_mass_count'],
SETTINGS['fansmessageconfig']['mass_remain_count'],
SETTINGS['fansmessageconfig']['next_mass_count'],
shop_id
]
row_count2 = cursor.execute(sql2, params2)
LOGGER_ROOT.info('audit shop: shop_id: %s, fd_t_shopaccount row count:%s, fd_t_fansmessageconfig row count:%s' % (
shop_id, row_count, row_count2))
cursor.close()
conn.commit()
conn.close()
return row_count, row_count2
def audit_shop_not_pass(shop_id):
conn = src.settings._mysql.MYSQL_CONNECTION()
cursor = conn.cursor()
# set fd_t_shopaccount
sql = 'update fd_t_shopaccount set service_status = %s where shop_id = %s'
params = [src.define.SERVICE_STATUS.AUDIT_NOT_PASS, shop_id]
row_count = cursor.execute(sql, params)
LOGGER_ROOT.info('audit shop not pass: shop_id: %s, fd_t_shopaccount row count:%s' % (shop_id, row_count, ))
cursor.close()
conn.commit()
conn.close()
return True
def get_platform_and_user_feedbacks(user_id):
conn = src.settings._mysql.MYSQL_CONNECTION()
cursor = conn.cursor()
try:
response = src.dao.feedback.get_platform_and_user_feedbacks(cursor, user_id)
num = len(response)
except Exception as e:
LOGGER_ROOT.exception(e)
return {
'is_success': False,
'des': str(e)
}
else:
return {
'is_success': True,
'feedback_infos': response,
'total_num': num
}
def get_user_feedbacks(offset, limit):
conn = src.settings._mysql.MYSQL_CONNECTION()
cursor = conn.cursor()
try:
feedback_infos = src.dao.feedback.get_user_feedbacks(cursor, offset, limit)
return_info = {
'is_success': True,
'feedback_infos': feedback_infos
}
except Exception as e:
LOGGER_ROOT.exception(e)
return_info = {
'is_success': False,
'des': str(e)
}
cursor.close()
conn.close()
return return_info
