def roomassign():
'''
숙소 배정
'''
if request.method == 'POST':
member_list = request.form.getlist('member_idx')
room_idx = request.form.get('room_idx')
for member_idx in member_list:
member = db.session.query(Member).filter(
Member.idx == member_idx).one()
member.room_idx = room_idx
db.session.commit()
next_url = request.args.get('next')
if next_url is not None:
return redirect(next_url)
else:
return redirect(url_for('.roomassign'))
camp_idx = Camp.get_idx(campcode)
query = db.session.query(Member)
if campcode == 'cmc' or campcode == 'cbtj':
cmc_idx = Camp.get_idx('cmc')
cbtj_idx = Camp.get_idx('cbtj')
room_stat = Room.get_stat(camp_idx=[cmc_idx, cbtj_idx])
filtered_query = query.filter(
or_(Member.camp_idx == cmc_idx, Member.camp_idx == cbtj_idx))
room_list = db.session.query(Roomsetting).filter(
Roomsetting.camp_idx == cmc_idx).all()
else:
filtered_query = query.filter(Member.camp_idx == camp_idx)
room_stat = Room.get_stat(camp_idx=camp_idx)
room_list = db.session.query(Roomsetting).filter(
Roomsetting.camp_idx == camp_idx).all()
filtered_query = get_member_list_query(
filtered_query, request, orderby=['camp_idx', 'sex', 'area_idx'])
page = int(request.args.get('page', 1))
member_list = filtered_query.limit(50).offset((page - 1) * 50).all()
count = filtered_query.count()
area_list = Area.get_list(campcode)
group_list = db.session.query(Group).filter(
Group.camp_idx == camp_idx).all()
return render_template('%s/room_assign.html' % campcode,
room_list=room_list,
members=member_list,
count=count - (page - 1) * 50,
nav=range(1,
int(count / 50) + 2),
area_list=area_list,
group_list=group_list,
room_stat=room_stat)
def perform_mutate(cls, form, info):
room = None
users = form.cleaned_data['users']
if Room.exists(users[0].id, users[1].id):
room = Room.get_by_users(users[0].id, users[1].id)
return cls(room=room)
room = form.save()
return cls(room=room)
def room():
'''
숙소 현황
'''
if request.method == 'POST':
member_list = request.form.getlist('member_idx')
for member_idx in member_list:
member = db.session.query(Member).filter(Member.idx == member_idx).one()
member.room_idx = None
db.session.commit()
next_url = request.args.get('next')
if next_url is not None:
return redirect(next_url)
else:
return redirect(url_for('.room'))
else:
camp_idx = Camp.get_idx(campcode)
query = db.session.query(Member)
if campcode == 'cmc' or campcode == 'cbtj':
cmc_idx = Camp.get_idx('cmc')
cbtj_idx = Camp.get_idx('cbtj')
filtered_query = query.filter(or_(Member.camp_idx == cmc_idx, Member.camp_idx == cbtj_idx))
room_stat = Room.get_stat(camp_idx=[cmc_idx, cbtj_idx])
room_list = db.session.query(Roomsetting).filter(Roomsetting.camp_idx == cmc_idx).all()
else:
filtered_query = query.filter(Member.camp_idx == camp_idx)
room_stat = Room.get_stat(camp_idx=camp_idx)
room_list = db.session.query(Roomsetting).filter(Roomsetting.camp_idx == camp_idx).all()
filtered_query = get_member_list_query(filtered_query, request, orderby=['camp_idx', 'sex', 'area_idx'])
page = int(request.args.get('page', 1))
# filtered_query = filtered_query.limit(50).offset((page - 1) * 50)
if request.args.get('room_idx', None) is not None:
# member_list = filtered_query.limit(50).offset((page - 1) * 50).all()
member_list = filtered_query.all()
count = filtered_query.count()
else:
member_list = []
count = 0
area_list = Area.get_list(campcode)
group_list = db.session.query(Group).filter(Group.camp_idx == camp_idx).all()
return render_template('%s/room.html' % campcode, room_list=room_list,
members=member_list, count=count, area_list=area_list,
group_list=group_list, room_stat=room_stat)
def rooms_create(request):
name = request.POST.get('roomName')
floor_id = request.POST.get('floorId')
room = Room()
room.name = name
room.floor_id = floor_id
room.latitude = request.POST.get('roomLatitude')
room.longitude = request.POST.get('roomLongitude')
room.feature_collection = request.POST.get('roomFeatureCollection')
room.save()
return redirect('/')
def post(self, request):
type = request.POST["type"]
service = request.POST["service"]
images = request.POST["image"]
description = request.POST["description"]
price = request.POST["price"]
# print(type,service,images,description,price)
data = Room(type=type,
service=service,
images=images,
description=description,
price=price)
data.save()
return render(request, 'core/room.html')
def getrooms(request):
"""Gets info for the given rooms, from `rids` params."""
rids = json.loads(request.GET['rids'])
result = {}
for shortname in rids:
room, _ = Room.get_or_create_by_shortname(shortname)
result[room.shortname] = room.to_dict()
return json_response(result)
def save(cls, data, instance=None):
try:
room = instance if instance else Room()
for key, value in data.items():
setattr(room, key, value)
room.save()
return room
except Exception as ex:
# todo: handle log
raise ex
def setUp(self):
first_room = Room(room_number=1, room_name="Deluxe")
first_room.save()
second_room = Room(room_number=2, room_name="Combo")
second_room.save()
first_reservation = Reservation(first_name="Bat",
last_name="Dorj",
e_mail_address="*****@*****.**",
country_name="MN",
address="this_address",
phone_number="C12345678")
first_reservation.save()
second_reservation = Reservation(first_name="Bayar",
last_name="Bold",
e_mail_address="*****@*****.**",
country_name="MN",
address="this_address",
phone_number="C9999999")
second_reservation.save()
def handle(self, *args, **options):
today = date.today()
print('Creating user test with password test')
self._create_user('test', '*****@*****.**', 'test')
# Create a hotel
hotel = Venue(name='HotelABC', address='1 Lane', city='Los Angeles',
zipcode='90000')
hotel.save()
print('Created Hotel: %s' % hotel)
# Create Rooms
room1 = Room(venue=hotel, room_number='1')
room1.save()
print('Created Room: %s' % room1)
room2 = Room(venue=hotel, room_number='2')
room2.save()
print('Created Room: %s' % room2)
room3 = Room(venue=hotel, room_number='3')
room3.save()
print('Created Room: %s' % room3)
# Create Guests
guest1 = Guest(name='Guest 1', address='ABC', city='Los Angeles',
zipcode='90000')
guest1.save()
print('Created Guest: %s' % guest1)
guest2 = Guest(name='Guest 2', address='BOS', city='Boston',
zipcode='40000')
guest2.save()
print('Created Guest: %s' % guest2)
# Create a Reservation
# Guest 1 for 3 days starting today
three_days = timedelta(days=3)
reservation1 = Reservation(venue=hotel, room=room1, guest=guest1,
amount=300, checkin=today,
checkout=today + three_days)
reservation1.save()
print('Created Reservation #1: %s' % reservation1)
# Guest 2 for 5 days starting today
checkin = today + timedelta(days=2)
five_days = timedelta(days=5)
reservation2 = Reservation(venue=hotel, room=room2, guest=guest2,
amount=500, checkin=today,
checkout=today + five_days)
reservation2.save()
print('Created Reservation #2: %s' % reservation2)
# Save the reservation in Calendar for future in 30 days
self._create_calendar(today, today + timedelta(days=30))
def getroom(request):
"""Gets info for the given room, from `title` param."""
shortname = request.GET['shortname']
room, _ = Room.get_or_create_by_shortname(shortname)
return json_response(room.to_dict())
def _get_parsed_schedule_param(param_collection) -> ScheduleParam:
def _str_to_array(str_values):
values = []
for i in str_values.split(","):
if i != '':
values.append(int(i))
return array(values)
ROOMS, TIMESLOTS, COURSES, INSTRUCTORS, COURSE_GROUPS = param_collection
all_theory_courses = list(filter(lambda x: x[4] == "Theory", COURSES))
all_theory_course_indices = [c[0] for c in all_theory_courses]
# Rooms - col 3: allowed_courses
for i in range(len(ROOMS)):
allowed_course_idxs = ROOMS[i][3]
if allowed_course_idxs == "ALL_THEORY":
allowed_course_idxs = all_theory_course_indices
elif allowed_course_idxs[:4] == "NOT:":
not_allowed_courses = [
int(i) for i in allowed_course_idxs[4:].split(',')
]
allowed_course_idxs = []
for c in range(len(COURSES)):
if c not in not_allowed_courses:
allowed_course_idxs.append(c)
else:
allowed_course_idxs = [
int(i) for i in allowed_course_idxs.split(',')
]
ROOMS[i][3] = allowed_course_idxs
# Instructors - col 2, 3
for i in range(len(INSTRUCTORS)):
INSTRUCTORS[i][2] = _str_to_array(INSTRUCTORS[i][2])
INSTRUCTORS[i][3] = _str_to_array(INSTRUCTORS[i][3])
# CourseGroups - col 2, 3
for i in range(len(COURSE_GROUPS)):
COURSE_GROUPS[i][2] = _str_to_array(COURSE_GROUPS[i][2])
COURSE_GROUPS[i][3] = _str_to_array(COURSE_GROUPS[i][3])
'''
NOTE: the following sanity check can be deduced: (if NUM_OF_LECS_BEING_OFFERED > MAX_LECS_THAT_CAN_BE_OFFERED)
'''
for i in range(len(TIMESLOTS)):
if TIMESLOTS[i][3] == '-':
TIMESLOTS[i][3] = []
elif len(TIMESLOTS[i][3]) == 1:
TIMESLOTS[i][3] = [int(TIMESLOTS[i][3])]
else:
TIMESLOTS[i][3] = _str_to_array(TIMESLOTS[i][3])
Rooms = [Room(r[0], r[1], r[2], r[3]) for r in ROOMS]
Timeslots = [Timeslot(t[0], t[1], t[2], t[3]) for t in TIMESLOTS]
Courses = [Course(c[0], c[1], c[2], c[3], c[4]) for c in COURSES]
Instructors = [
Instructor(i[0], i[1], i[2], i[3], i[4]) for i in INSTRUCTORS
]
CourseGroups = [
CourseGroup(cg[0], cg[1], cg[2], cg[3]) for cg in COURSE_GROUPS
]
sections = _get_all_sections(Courses)
daily_slots = _get_all_daily_slots(Timeslots)
day_codes = _get_all_day_codes(Timeslots)
return ScheduleParam(Rooms, Timeslots, Courses, Instructors, CourseGroups,
sections, daily_slots, day_codes)
