3 qi~@sddlmZmZmZmZmZmZmZddlmZm Z ddl Z ddl Z ddl Z ddl Z ddlZddlZddlZddlZddlmZmZmZmZddlmZddlmZddlmZddlmZdd lm Z dd l!m"Z"dd l#m$Z$dd l%m&Z&dd l'm(Z(ddlm)Z)ddl*m+Z+ddl,Tddl-Tddl.m/Z/ej0ddgdddZ1ddZ2ddZ3ddZ4ddZ5dd Z6ej0d!d"d#Z7dS)$)Flaskjsonifyrender_templateurl_forrequestredirectjson)datetime timedeltaN)EmailContentMailPersonalization)app)Booking)BookingActivity) BookingGuest) BookingType) BookingStatus)Partner) Transaction)Detail)db)get_booking_status_id)*)or_z/bookings/no_showPOST)methodscCstddidfS)NmessageOk)rr!r!7/booking_service/app/routes/bookings_operations_urls.py getNoShowssr#cCstjtdd}|jd}tjjtjtj dkjtj dkjtj dkjtj t dkjtj|kj}tjtddjd}ytjd}Wntk rd}YnX|sg}|jdtd|idfSx^|D]V}|jjd|krt d |_ tj|_tttj|jd |tjd }tjj|qqWytjjtjjWn6tk r|tjjtjjtdd id fSXtddid fSdS)N)daysz%Y-%m-%d Unconfirmed session_idz*There are no bookings to mark as no-shows.rizNo-Showz%Booking status was updated to No Show)booking_activity_public_id booking_idbooking_activity_descriptionr' created_atz4There was an error marking the booking as a no-show.r r) r todayr strftimersessionqueryrfilterdeletion_markeractual_booking_check_in_date checked_instatusrbooking_check_in_dateallnowrr Exceptionappendr updated_atrstruuiduuid4booking_public_idaddcommitcloserollback)yesterday_datetime yesterdayZ get_bookingsr'rsinglebooking_activityr!r!r"changeToNoShowssP               rGc0CsL tj}|jd}tjtdd}tjtddjd}tjtddjd}tjtddjd}tjjtj tj dkj tj dkj tj dkj tj |kjtjjj}tjjtj tj dkj tjdkj tjdkj tj|kjtjjj}tjjtjttjtjkjttjtjkjttjtjkjtjtjtj tjtj tjtjtj tjtj tj!tj"tjtj#tj$tj%tj&tj'j tj dkj tjdkj tjdkj tj dkj tj|kj tj|kjtjjj}tjjtjttjtjkjttjtjkjttjtjkjtjtjtj tjtj tjtjtj tjtj tj!tj"tjtj#tj$tj%tj&tj'j tj dkj tj dkj tj dkj tj |kj tj |kj tj dkjtjjj} tjjtjttjtjkjttjtjkjtjtjtj tjtj tjtjtj tjtj tj!tj"tjtj#tj$tj%tj&tj'j tj dkj tj(dkj tj |kj tj |kj tj'dkj tj#dkptj#dkjtjjj} tjjtjt)tjt)jkjttjtjkjttjtjkjtjtjtj tjtj tjtjtj tjtj tj!tj"tjtj#tj$tj%tj&tj'j tj dkj tj |kjtjjj} g} g} g}g}g}g}x>|D]6}i}|j|d<|j$|d <d |j|d <| j*|qnWx>|D]6}i}|j|d<|j$|d <d |j|d <| j*|qWxf|D]^}i}|j|d<|j$|d <|j |d <|j|d <|j&|d<|j'|d<d |j|d <|j*|qWxR| D]J}i}|j|d<|j$|d <|j'|d<|j |d<d |j|d <|j*|qVWxZ| D]R}i}|j|d<|j$|d <|j&|d<|j p|j |d<d |j|d <|j*|qWx>| D]4}|j#}|dks<|dkr,qi}|j|d<|j$|d <|j&|d<d |j|d <|sld|d<n&|dkrd|d<n|dkrd|d<|jdkr*tjjt+j t+j|jkj,}|r2t-j.t/j0|j1} |j%dkr| j2d|d<n4|j%dkr2d| j2kr| j2d|d<nd|d<n|jdkrb|j%dkrLd|d<n|j%dkr2d|d<nyi}!t3|j |!|!d dkr|j%dkr|!d!|d<n|j%dkr|!d|d<n*|j%dkrd"|d<n|j%dkrd#|d<WnNt4k r0}"z0|j%dkr d"|d<n|j%dkr d#|d<WYdd}"~"XnX|j*|qWtjjd| | ||||d$}#t5j6t7j8t5j9d%d&}$d'}%d'}&t:|%}'t:|&}(d(})t;d)tj?j@jA|+j.d,},g}-|-j*tB|,tCd-d.id/fSt4k r<}"z.tDjE}.tFjG}/t4d0tB|"d1|/WYdd}"~"XnXWdQRXdS)2Nz%Y-%m-%d)r%< Abandonedr>booking_ref_codez1https://bookings.olpejetaconservancy.org/booking/ booking_urlr5booking_check_out_datebooking_type_namer4r2r$ booking_typezNot Paidbooking_payment_statusz To InvoicezIncomplete PaymentPB001A20z$162fface-f5f1-41de-913b-d2bb784dda3a customer_codez$6bf74e49-7ff6-4555-a080-15541d62204acustomer_code_usd406B036GB601X10406B047 has_accountcustomer_code_kes406GA001406GA002)r, checkin_todaycheckout_today overstaysnot_checked_inpayment_status_todayno_cuiSENDGRID_API_KEY)api_keyz$obtsbookings@olpejetaconservancy.orgzEnd Of Day Process Reminderz text/htmlzbooking_endofday_process.html)data) request_bodyrzSuccessfuly sent email.r zUser email notification: z . Trace: )Hr r7r-r,r rr.r/rr0r1r2r3r5order_byr)descr6actual_booking_check_out_date checked_outrOjoinrr>rrQbooking_type_public_idrr4booking_status_public_id add_columnsbooking_done_byr'r+r:payment_statusrMcurrencyrPbooking_status_namecuinvoicenumberrr9rfirstrequestsgetget_partner_detailsformat partner_idrgetBookingSessionUserr8r app_contextsendgridSendGridAPIClientconfigr r rr clientmailsendpostr;rsysexc_info traceback format_exc)0r7r,a_week_ago_datetime a_week_ago two_days_agoZsixty_days_agoget_checkIn_bookingsget_checkOut_bookingsget_overstayed_bookingsget_not_checked_in get_no_cuiget_payment_status_bookingsr^r_rbr`rarcsingle_check_inreturn_data_checkinsingle_check_outreturn_data_checkoutsingle_overstayreturn_data_overstayssingle_not_checked_inreturn_data_not_checked_in single_no_cuireturn_data_no_cuisingle_booking_paymentp_statusreturn_data_payment get_partner partner_info user_infoe reminder_datasgsender recipient from_emailto_emailsubjectcontentrresponseemail_response error_tupletracer!r!r"endOfDayEveningOs                                                                                                rc/Cs4 tj}|jd}tjtdd}tjtddjd}tjtddjd}tjjtj tj dkj tj dkj tj dkj tj |kjtjjj}tjjtj tj dkj tjdkj tjdkj tj|kjtjjj}tjjtjttjtjkjttjtjkjttjtjkjtjtjtj tjtj tjtjtj tjtj tj!tj"tjtj#tj$tj%tj&tj'j tj dkj tjdkj tjdkj tj dkj tj|kj tj|kjtjjj}tjjtjttjtjkjttjtjkjttjtjkjtjtjtj tjtj tjtjtj tjtj tj!tj"tjtj#tj$tj%tj&tj'j tj dkj tj dkj tj dkj tj |kj tj |kj tj dkjtjjj}tjjtjttjtjkjttjtjkjtjtjtj tjtj tjtjtj tjtj tj!tj"tjtj#tj$tj%tj&tj'j tj dkj tj(dkj tj |kj tj |kj tj'dkj tj#dkpttj#dkjtjjj} tjjtjt)tjt)jkjttjtjkjttjtjkjtjtjtj tjtj tjtjtj tjtj tj!tj"tjtj#tj$tj%tj&tj'j tj dkj tj |kjtjjj} g} g} g} g}g}g}x>|D]6}i}|j|d<|j$|d<d |j|d <| j*|qVWx>|D]6}i}|j|d<|j$|d<d |j|d <| j*|qWxf|D]^}i}|j|d<|j$|d<|j |d <|j|d <|j&|d <|j'|d<d |j|d <|j*|qWxR|D]J}i}|j|d<|j$|d<|j'|d<|j |d<d |j|d <|j*|q>WxZ| D]R}i}|j|d<|j$|d<|j&|d <|j p|j |d<d |j|d <|j*|qWx>| D]4}|j#}|dks$|dkrqi}|j|d<|j$|d<|j&|d<d |j|d <|sTd|d<n&|dkrhd|d<n|dkrzd|d<|jdkrtjjt+j t+j|jkj,}|rt-j.t/j0|j1}|j%dkr|j2d|d<n4|j%dkrd|j2kr|j2d|d<nd|d<n|jdkrJ|j%dkr4d|d<n|j%dkrd|d<nyi} t3|j | | ddkr|j%dkr| d |d<n|j%dkr| d|d<n*|j%dkrd!|d<n|j%dkrd"|d<WnNt4k r}!z0|j%dkrd!|d<n|j%dkrd"|d<WYdd}!~!XnX| j*|qWtjjd| | ||| |d#}"t5j6t7j8t5j9d$d%}#d&}$d&}%t:|$}&t:|%}'d'}(t;d(tj?j@jA|*j.d+}+g},|,j*tB|+tCd,d-id.fSt4k r$}!z.tDjE}-tFjG}.t4d/tB|!d0|.WYdd}!~!XnXWdQRXdS)1Nz%Y-%m-%drH)r%rIrKrLr>rMz1https://bookings.olpejetaconservancy.org/booking/rNr5rOrPr4r2r$rQzNot PaidrRrSz To InvoicezIncomplete PaymentrTz$162fface-f5f1-41de-913b-d2bb784dda3arUz$6bf74e49-7ff6-4555-a080-15541d62204arVrWrXrYrZr[r\r])r,r^r_r`rarbrcrd)rez'kenneth.kagunda@olpejetaconservancy.orgz"End Of Day Process Reminder - Testz text/htmlzbooking_endofday_process.html)rf)rgrzSuccessfuly sent email.r zUser email notification: z . Trace: )Hr r7r-r,r rr.r/rr0r1r2r3r5rhr)rir6rjrkrOrlrr>rrQrmrr4rnrorpr'r+r:rqrMrrrPrsrtrr9rrurvrwrxryrzrr{r8rr|r}r~rr r rr rrrrr;rrrrr)/r7r,rrrrrrrrrr^r_rbr`rarcrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr!r!r" endOfDayTestQs                                                                                                rcCsny tj}|jd}|tddjd}tjjtjt tj t j kjt tj t j kj tjjj}g}x|D]}tjjt jt j |j kjt jdkj}| sr|j rqr|jd|j}|jjd}d|j } tjtjdd} d } t| } t|j} td }d |j}d |d |jd|d| d| d }td|}t| ||d}t}|j| |j ||j!|y:| j"j#j$j%|j&d}|j'|j|jd dt(|j)dWqrt*k r}z$|j'|j|jd dt(|dWYdd}~XqrXqrWt+dt,dd|Dd|ddfSt*k rh}z(t-j.}t/j0}t+dt(||d d!fSd}~XnXdS)"z[Send payment reminders to clients with pending payments for bookings starting within a weekz%Y-%m-%drH)r%N z1https://bookings.olpejetaconservancy.org/booking/rd)rez$obtsbookings@olpejetaconservancy.orgz'kenneth.kagunda@olpejetaconservancy.orgz-Payment Reminder for Your Upcoming Booking - zi

Payment Reminder

Dear z[,

This is a reminder that payment for your upcoming booking zN is still pending. Your check-in date is on z.

Please complete your payment to confirm your reservation.

You can view your booking and make payment here: z


Best regards,
Ol Pejeta Conservancy Booking Team

z text/html)rrZ html_content)rgsent) booking_ref client_emailcc_emailr4rfailed)rrrr4errorz)Payment reminder process completed. Sent cSsg|]}|ddkr|qS)r4rr!).0rr!r!r" sz(sendPaymentReminders..z emails.)rdetailsr z!Error in payment reminder process)rrri)1r r7r-r rr.r/rrlrr>r)rrhr5ascrur0r1 email_address first_name last_namer}r~rrr rMr r radd_toadd_ccadd_personalizationrrrrrwr9r; status_coder8rlenrrrr)r7r,Zone_week_from_nowZpending_payment_bookingsZemail_responsesbookingbooking_detailsZ client_name check_in_daterNrrrrrrZ email_contentrrpersonalizationrrrrr!r!r"sendPaymentRemindersRsz       &    $rc Cs6tjtdd}|jd}tjjtjtj dkjtj dkjtj dkjtj |kj tjjj}tjjtjtj dkjtjdkjtjdkjtj|kj tjjj}tjjtjttjtjkjttjtjkjttjtjkjtjtjtj tjtj tjtjtj tjtjtj tj!tjtj"tj#tj$tj%tj&jtj dkjtj |kj tjjj}g}g}g}x>|D]6}i} |j| d<|j#| d<d|j| d<|j'| qvWx>|D]6} i} | j| d<| j#| d<d| j| d<|j'| qWx>|D]4} | j"} | dks,| dkrqi}| j|d<| j#|d<| j%|d <d| j|d<| s\d |d <n&| d krpd |d <n| dkrd|d <| jdkrtjjt(jt(j| jkj)}|r"t*j+t,j-|j.}| j$dkr|j/d|d<n4| j$dkr"d|j/kr|j/d|d<nd|d<n| jdkrR| j$dkrj?|j+d%}|j't@|tAd&d'id(fSt1k r0}z.tBjC}tDjE}t1d)t@|d*|WYdd}~XnXdS)+Nr$)r%z%Y-%m-%dr>rMz1https://bookings.olpejetaconservancy.org/booking/rNrLrQzNot PaidrRrSz To InvoicerIzIncomplete PaymentrTz$162fface-f5f1-41de-913b-d2bb784dda3arUz$6bf74e49-7ff6-4555-a080-15541d62204arVrWrXrYrZr[r\r])r,r^r_rbrd)rez'patricia.kanana@olpejetaconservancy.orgz$obtsbookings@olpejetaconservancy.orgzEnd Of Day Process Reminderz text/htmlzbooking_endofday_process.html)rf)rgrzSuccessfuly sent email.r zUser email notification: z . Trace: )Fr r,r r-rr.r/rr0r1r2r3r5rhr)rir6rjrkrOrlrr>rrQrmrr4rnrorpr'r+r:rqrMrrrPrsr9rrurvrwrxryrzrr{r8r7rr|r}r~rr r rr rrrrr;rrrrr) rCrDrrrr^r_rbrrrrrrrrrrrrrrrrrrrrrrrrr!r!r"endOfDayMornings                                                      rz/reminders/cCstjtddjd}tjjtjt tj t j kj tj tj tjtjtjtjtjtjtjtjtjtjtjtjtjtjt jt jt jt jt j t j!j"tj#dkj"tj |kj"t jt$dkj"t jt$dkj%}|sg}|j&dt'd|idfSg}g}t(j)t*j+d d }d }x|D]}i} tjjd | d <|j| d<|jjd| d<|jjd| d<d|jd|j| d<|j| d<|j | d<tjjd| d<g} tjjt,jt-t,j.t-j/kj t-j0t,j1j"t,j#dkj"t,j |j kj%} x| D]} | j&t2| j1qWt3| | d<g} t3| | d<t4|}t4|j}d}t5dt6d| d}t7||||}y.|j8j9j:j;|j<d}|j&d|jdWn2t=k r}z|j&t>|WYdd}~XnXqWt'd|iSdS) Nr$)r%z%Y-%m-%dUpdated Cancelled.rird)apikeyz$reservations@olpejetaconservancy.orgz%B %Yr,rMz %A %d %B %Yrcheck_out_daterrrr)z%Ycopyright_year num_of_guestsnum_of_vehicleszBooking Reminderz text/htmlzbookingreminder.html)rf)rgzReminder email sent to )?r r7r r-rr.r/rrlrr>r)rorQr5rOr2rjrpr3rkrMr'r+r:r4rqrrrrr phone_numberaddressadditional_noter0r1rr6r9rr}r~rrr GuestType guest_typebooking_guest_type_public_idbooking_guest_type_name guest_countintsumr r rr rrrrrwr8r;)r)Ztomorrowget_all_bookingsrZ return_arrayZ error_arrayrrZ each_bookingr guest_sumZget_all_guests each_guest vehicle_sumrrrrrrrr!r!r"sendReminderEmail_sn                &r)8flaskrrrrrrrr r pymysqlosmathrvr<rrr}sendgrid.helpers.mailr r r rroutesrdatabase.bookingsrdatabase.booking_activity_logrdatabase.booking_guestsrdatabase.booking_typesrdatabase.booking_statusrdatabase.partnerrdatabase.transactionrdatabase.booking_detailsrrZroutes.bookings_urlsrfunctions.booking_snippets variables sqlalchemyrrouter#rGrrrrrr!r!r!r"s<$8            7m!