def get_all_staff(id_mapping = False): sql_statment = 'SELECT id, name, gender, is_partner, is_admin, is_club_member FROM staff WHERE is_deleted = 0' if id_mapping: result = helper.select_query(sql_statment, None, True, 'id') else: result = helper.select_query(sql_statment, None, True) return result
def get_min_and_max_pair_id(): sql_statment = 'SELECT MIN(pair_id) AS MIN_ID, MAX(pair_id) AS MAX_ID FROM staff_id_to_pair_id_mapping WHERE is_valid = 1' result = helper.select_query(sql_statment, None, True) if len(result) == 1: return result[0] else: raise SQLError()
def get_all_groups_info(dict_flag=True): sql_statment = "SELECT group_id, group_name, group_member_count, group_budget, group_expense_total FROM interest_group WHERE is_registered = 1" sql_key = None if dict_flag == True: sql_key = "group_id" result = helper.select_query(sql_statment, None, True, sql_key) return result
def get_all_staff(): sql_statment = 'SELECT id, name, gender, is_partner, is_admin, is_club_member FROM staff WHERE is_deleted = 0' result = helper.select_query(sql_statment, None, True) return result
def get_expense_by_date(start_date, end_date): sql_statment = "SELECT %s FROM interest_group_expense WHERE is_deleted = 0" % GROUP_EXPENSE_FIELDS params = (start_date, end_date) result = helper.select_query(sql_statment, params, True) return result
def get_expense_by_group(group_id): sql_statment = "SELECT %s FROM interest_group_expense WHERE is_deleted = 0 AND group_id = ?" % GROUP_EXPENSE_FIELDS params = (group_id,) result = helper.select_query(sql_statment, params, True) return result
def get_all_expense_history(): sql_statment = "SELECT %s FROM interest_group_expense WHERE is_deleted = 0" % GROUP_EXPENSE_FIELDS result = helper.select_query(sql_statment, None, True) return result
def get_staff_id_mapping(): sql_statment = 'SELECT staff_id, pair_id FROM staff_id_to_pair_id_mapping WHERE is_valid = 1' result = helper.select_query(sql_statment, None, True) return result