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
