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