3 ؀h@sddlmZmZmZmZmZmZmZmZddl m Z m Z m Z ddl Z ddl Z ddlZddlZddlZddlmZddlmZddlmZddlmZddlTd d Zejd d gd ddZejdddZejdddZejddgd ddZejddgd ddZdS))Flaskjsonifyrender_templateurl_forrequestredirectjson make_response)datetime timedeltadateN)app)db)bookings_logger)Location)*cCs|jjdS)N)sessionclose)selfr4/booking_service/app/routes/pickup_locations_urls.pyrsrz /pick-up/newPOST)methodsc,Csg}y&tjdjtjds(|jdWn,tk rV}z|jdWYdd}~XnXy&tjdjtjds||jdWn,tk r}z|jdWYdd}~XnX|rg}|jdtd|id fStjjt j t j dkj }xB|D]:}|j jtjdjkrg}|jd td |id fSqWt ttjtjdjtjdd }tjj|y0tjjttg}|jd td |idfStk r}z8t|tjjttg}|jdtd |id fSd}~XnXdS)NnamezName is empty.zName is missing. session_idzSession ID is empty.zSession ID is missing.z5You appear to be missing some data. Please try again.messagesiz/That pick-up location is already in the system.message)pickup_location_public_idpickup_location_namerz-You have successfully created a new location.zIUnfortunately, you cannot add a pick-up at this moment. Please try again.)rrstripappendKeyErrorrrrqueryrfilterdeletion_markerallrlowerstruuiduuid4titleaddcommitr Exceptionprintrollback)rerZ check_nameZ each_namelocationoutputrrradd_new_locationsV             r4z /pick-up/viewcCs~g}g}tjjtjtjdkjtjjj }|sN|j dt d|idfSx|D]}|j |j qTWt d|idfSdS)Nz;There are no locations in the system at this point in time.ridata) rrr#rr$r%order_byrascr&r!r return_json)r3id_array all_locationssinglerrrget_all_locationsRs    r=z/pick-up/view/cCs~g}g}tjjtjtjdkjtj|kj}|sN|jdt d|idfSx|D]}|j|j qTWt d|idfSdS)NzAThe selected location is not in the system at this point in time.rir5r6) rrr#rr$r%rr&r!rr9) location_idr3r:r;r<rrrget_single_locationis    r?z/pick-up/modifyPATCHc:Cs*g}y&tjdjtjds(|jdWn,tk rV}z|jdWYdd}~XnXy&tjdjtjds||jdWn,tk r}z|jdWYdd}~XnXy&tjdjtjds|jdWn.tk r}z|jd WYdd}~XnX|r&g}|jd td |id fStjjt j t j dkj t j tjdkj }|sxg}|jd td |idfStjdj|_tjd|_tj|_y0tjjttg}|jdtd|idfStk r$}z8t|tjjttg}|jdtd|id fSd}~XnXdS)Nr>zLocation ID is empty.zLocation ID is missing.rzName is empty.zName is missing.rzSession ID is empty.zSession ID is missing.z5You appear to be missing some data. Please try again.riz;The selected pick-up location does not exist in the system.iz,You have successfully modified the location.rr6zGUnfortunately, you modify the pick-up at this moment. Please try again.)rrr r!r"rrrr#rr$r%rfirstr+rrr now updated_atr-rr.r/r0)rr1rZcheck_locationr3rrrmodify_locations\             rDz/pick-up/deletec,Csg}y&tjdjtjds(|jdWn,tk rV}z|jdWYdd}~XnXy&tjdjtjds||jdWn,tk r}z|jdWYdd}~XnX|rg}|jdtd|id fStjjt j t j dkj t j tjdkj }d |_ tjd|_y0tjjttg}|jd td |id fStk r}z8t|tjjttg}|jdtd |id fSd}~XnXdS)Nr>zLocation ID is empty.zLocation ID is missing.rzSession ID is empty.zSession ID is missing.z5You appear to be missing some data. Please try again.riz+You have successfully deleted the location.rr6zMUnfortunately, you cannot delete a location at this moment. Please try again.)rrr r!r"rrrr#rr$r%rrArr-rr.r/r0)rr1rZ get_locationr3rrrdelete_single_locationsF          rF)flaskrrrrrrrr r r r pymysqlosmathrequestsr)routesr rrdatabase.pickup_locationr variablesrrouter4r=r?rDrFrrrrs((    ?@