3
؀h                 @   s   d dl mZmZmZmZmZmZmZ d dlmZm	Z	m
Z
 d dlZd dlZd dlZd dlZd dlZd dlmZ d dlmZ d dlmZmZ d dlmZ d dlmZ d d	lmZ d d
lmZ d dlmZ d dl T dd Z!ej"ddgddd Z#dS )    )Flaskjsonifyrender_templateurl_forrequestredirectjson)datetime	timedeltadateN)app)db)BookingTypeSeedBookingStatusSeed)BookingType)Booking)BookingGuest)BookingStatus)	Inventory)*c             C   s   | j j  d S )N)sessionclose)self r   0/booking_service/app/routes/old_calendar_urls.pyr      s    r   z/calendar/old/viewPOST)methodsc              C   sn  t jd j  s t jd j  r>g } | jd td| idfS g } g }g }g }g }g }t jd jd\}}}t jd jd\}	}
}t|}t|}t|}t|	}t|
}t|}t|||}t|||}tdd}t	j
jtjjtjd kjtjjtjt jd kjtjt jd kj }x@|D ]6}t	j
jtjjtjd kjtj|jkj }i }|j|d	< t	j
jtjjtjd kjtj|jkjtjt jd kjtjt jd kj |d
< x"||kr|j| || }qW xj|D ]b}i }||d< t	j
jtjjtjd kjtj|jkjtj|kj |d
< |j|d	< |j| qW ||d< | j| q&W td| iS )N
start_dateend_datez5You appear to be missing some data. Please try again.messagei  -   )daysinventory_idZbookings_countr   Zwhile_loop_info	inventory)r   r   stripappendr   splitintr   r
   r   r   queryr   r#   filterdeletion_markergroup_byinventory_booking_dateallfirstcount)outputfacility_outputinventory_outputdatesZwhile_loop_array
date_arrayZstripped_start_yearZstripped_start_monthZstripped_start_dayZstripped_end_yearZstripped_end_monthZstripped_end_dayZint_start_yearZint_start_monthZint_start_dayZint_end_yearZint_end_monthZint_end_daystartingendingadd_dayZreturn_inventory_bookingssingleZreturn_bookings_by_institutionreturn_dataone_dateZ
while_loopr   r   r   old_calendar_viewV   sj    





+r<   )$flaskr   r   r   r   r   r   r   r	   r
   r   pymysqlosmathrequestsuuidroutesr   r   routes.seed_functionsr   r   database.booking_typesr   database.bookingsr   database.booking_guestsr   database.booking_statusr   database.inventoryr   	variablesr   router<   r   r   r   r   <module>   s   $(C