3 ؀h@slddlmZmZmZmZmZmZmZmZddl m Z m Z ddl Z ddl Z ddl Z ddlZddlZddlmZddlmZddlmZddlmZddlmZdd lmZdd lmZdd lmZdd lTdd l Tdd l!Td dZ"ej#ddgdddZ$ej#ddgdddZ%ej#ddgdddZ&ej#dddgdddZ'ej#ddd Z(ej#d!d"d#Z)ej#d$d%d&Z*ej#d'd(gdd)d*Z+ej#d+d(gdd,d-Z,ej#d.dgdd/d0Z-ej#d1dgdd2d3Z.ej#d4d(gdd5d6Z/ej#d7d(gdd8d9Z0ej#d:d(gdd;d<Z1ej#d=dgdd>d?Z2ej#d@dgddAdBZ3ej#dCdgddDdEZ4dS)F)Flaskjsonifyrender_templateurl_forrequestredirectjson make_response)datetime timedeltaN)app)db)MandatoryPaymentsSeed) Mandatory) GuestType)MandatoryPaymentPrices) MandatoryPaymentScheduleCalendar) Destination)*cCs|jjdS)N)sessionclose)selfr6/booking_service/app/routes/mandatory_payments_urls.pyrsrz/payments/default/newPOST)methodsc Csg}y&tjdjtjds(|jdWn,tk rV}z|jdWYdd}~XnXy&tjdjtjds||jdWn,tk r}z|jdWYdd}~XnXy&tjdjtjds|jdWn.tk r}z|jd WYdd}~XnXy(tjd jtjd s(|jd Wn.tk rX}z|jd WYdd}~XnXy(tjd jtjd s|jdWn.tk r}z|jdWYdd}~XnXy(tjdjtjds|jdWn.tk r}z|jdWYdd}~XnXy0ttjdjttjds8|jdWn.tk rh}z|jdWYdd}~XnXy(tjdjtjds|jdWn.tk r}z|jdWYdd}~XnX|rg}|jdtd|idfStjj t j t j dkj }xF|D]>}|jjtjdjkrg}|jdtd|idfSqWtjddkr`d}ntjdd krtd!}tjd"}|rd#}nd$}t ttjtjdtjdtjdjtjd tjd||tjdtjtjd% }tjj|tttjdd&tjdtjdtjtjd'} tjj| y0tjjttg}|jd(td|id)fStk r}z6tjjttg}|jd*t|t|d+dfSd}~XnXdS),Nincome_account_codezIncome Account Code is empty.zIncome Account Code is missing.department_analysis_codez"Department Analysis Code is empty.z$Department Analysis Code is missing.personzPerson is empty.zPerson is missing.markerzMarker is empty.zMarker is missing. descriptionzDescription is empty.zDescription is missing.schoolz'School conservancy fee marker is empty.z)School conservancy fee marker is missing. max_numberzMax number is empty.zMax number is missing. session_idzSession ID is empty.zSession ID is missing.z5You appear to be missing some data. Please try again.messagesiz+That category already exists in the system.messageYesYNoNresidency_proofr) payment_public_idpayment_person_income_codepayment_person_dept_codepayment_personrmaximum_numberr!r*r# created_at updated_at)booking_guest_type_public_idbooking_guest_type_namer#r1r2z-You have added a new gate entry fee category.zIThe gate entry fee category could not be added at this moment. Try later.)r%error)rrstripappendKeyErrorstrrr rqueryrfilterdeletion_markerallr/loweruuiduuid4titler nowaddrcommitr Exceptionrollback) r$er% check_name each_namer!proofr*paymentguestrrradd_new_default_payments                     rOz/payments/public/check-in-datec Csntjd}tjjtjtjdkjtjdkjtj |kjtj |kj }|slg}|j dt d|idfStjjtjttjtjkjtjtjtjtjtjtjtjtjtjtjtjtjtjtjtj jtjdkjtj|j!kjtjdkjtjdkjtjdkjtjdkj"tjj#j$}g}x0|D]&}i}|j|d <|j|d <|j|d <|jj%|d <|j|d <|j}|dkrd|d<nd|d<y8t&j't(j)|j}|jddd|d<|j|d<Wn(t*k rd|d<|j|d<YnX|j|d<t+|j|d<d|d<d|d<|j|d<|j|d<d|d<|j|d<|j |d <|j |q.Wt d|id!fSdS)"N check_in_datezYEntry fee pricing for the selected period has not been set. Please contact customer care.r%izEa Resident StudentzNon Resident StudentzCitizen Studentr,r-r.r/payment_scheduler+Tr*Fdatar currency_namepayment_person_currencypayment_person_currency_idzN/Apayment_person_descriptionpayment_person_amountpayment_person_discountpayment_guestsrr!amountr"r#),rrr rr<rr=r>schedule_destinationschedule_start_dateschedule_end_datefirstr9rrjoinrpayment_categoryr, add_columnsprice_public_idrRpayment_currency payment_pricer/r-r.rWrr!r0r*r#schedule_public_idorder_byascr?rCrequestsget get_currencyformatrGfloat) check_in get_scheduler% get_pricesrSsingle return_datarLcurrencyrrrquery_schedule_by_check_in_datesr                         ruz"/payments/public/check-in-out-datec Cstjd}tjd}||kr"d}nd}tjjtjtjdkjtj|kjtj |kjtj |kj }|stjjtjtjdkjtj |kjtj |kj }|sg}|j dt d|idfStjjtjttjtjkjtjtjtjtjtjtjtjtjtjtjtjtjtjtjtj jtjdkjtj|j!kjtjdkjtjdkjtjd kjtjd kj"tjj#j$}g}x0|D]&}i}|j|d <|j|d <|j|d <|jj%|d<|j|d<|j} | dkrd|d<nd|d<y8t&j't(j)|j} | jddd|d<|j|d<Wn(t*k rDd|d<|j|d<YnX|j|d<t+|j|d<d|d<d|d<|j|d<|j|d<d|d <|j|d!<|j |d"<|j |qWt d|id#fSdS)$NrPcheck_out_datez$5717abc1-98e9-4928-ba35-40f2fc93b3d3rQzYEntry fee pricing for the selected period has not been set. Please contact customer care.r%izEa Resident StudentzNon Resident StudentzCitizen Studentr,r-r.r/rRr+Tr*FrSrrTrUrVzN/ArWrXrYrZrr!r[r"r#r\),rrr rr<rr=r>r]r^r_r`r9rrrarrbr,rcrdrRrerfr/r-r.rWrr!r0r*r#rgrhrir?rCrjrkrlrmrGrn) ro check_out destinationrpr%rqrSrrrsrLrtrrr#query_schedule_by_check_in_out_dates                             ryz/payments/default/viewGETcCs.tjjtjtjdkjtjdkjdkr4tj tjjtjtjdkj tj j j }|s~g}|jdtd|idfSg}x|D]}i}|j|d<|j|d<|j|d<|jj|d <|j|d <|j|d <|j|d <|j|d <|j}|dkrd|d<nd|d<|j|d<|j|qWtd|idfS)NInfantrz#There are no pricing schedules set.r%ir,r-r.r/rr!r"r#r+r&r*r(r rSr\)r rr<rr=r>r/countrseed_default_mandatory_paymentsrhr1descr?r9rr,r-r.rCrr!r0r#r*rW)rpr%rSrrrsrLrrrview_default_paymentsJs<                rz#/payments/default/view/cCs&tjjtjtjdkjtjdkjdkr4tj tjjtjtjdkjtj |kj }g}x|D]}i}|j |d<|j |d<|j |d<|jj|d<d|d<d |d <td|d <|j|d <d|d <d|d<d|d<|j|d<|j|d<d|d<|j|d<|j|d<|j|qfWtd|idfS)Nr{rr,r-r.r/KESrUZ1234567rVrXrWrYpayment_person_discount_reasonrZrr!r[r"r#rSr\)r rr<rr=r>r/r|rr}r,r?r-r.rCrnrWrr!r0r#r9r) payment_idreturn_paymentsoutputrrrsrrrview_single_default_paymentsws:               rz/payments/default/view/publicc Csztj}tjjtjtj|jdkjtj |jdkjtj dkj }|sjg}|j dt d|idfSg}x|D]}tjjtjttjtjkjtjtjtjtjtjtjtjtjtjtjtjtjtjtjtj jtj dkjtj|j!kjtj dkjtjdkjtjdkjtjdkj"tjj#j }x0|D]&}i}|j|d<|j|d <|j|d <|jj$|d <|j|d <|j}|d krd|d<nd|d<y8t%j&t'j(|j} | j)ddd|d<|j|d<Wn(t*k rd|d<|j|d<YnX|j|d<t+|j|d<d|d<d|d<|j|d<|j|d<d|d<|j|d<|j |d<|j |q:WqvWt d|id fS)!Nz%Y-%m-%dz#There are no pricing schedules set.r%izEa Resident StudentzNon Resident StudentzCitizen Studentr,r-r.r/rRr+Tr*FrSrrTrUrVzN/ArWrXrYrZrr!r[r"r#r\),r rDr rr<rr=r^strftimer_r>r?r9rrrarrbr,rcrdrRrerfr/r-r.rWrr!r0r*r#rgrhrirCrjrkrlrmrrGrn) todayrpr%rSsingle_schedulerqrrrsrLrtrrrview_default_public_paymentssr                        rz/payments/default/view/schoolc Cstjjtjtjdkjtjdkjdkr4tj t j }tjjt jt jdkjt j |jdkjt j|jdkj}|sg}|jdtd|idfSg}x|D]}tjjtjttjtjkjtjtjtjtjtjtjtjtjtjtjtjtj tj!tj"tj#jtjdkjtj|j$kjtjdkjtj dkj%tjj&j}x0|D]&}i}|j|d<|j|d <|j|d <|jj'|d <|j|d <|j"}|d krd|d<nd|d<y8t(j)t*j+|j} | j,ddd|d<|j|d<Wn(t-k rd|d<|j|d<YnX|j|d<t.|j|d<d|d<d|d<|j|d<|j |d<d|d<|j!|d<|j#|d<|j|qVWqWtd|idfS) Nr{rz%Y-%m-%dz#There are no pricing schedules set.r%ir'r,r-r.r/rRr+Tr*FrSrTrUrVzN/ArWrXrYrZrr!r[r"r#r\)/r rr<rr=r>r/r|rr}r rDrr^rr_r?r9rrrarbr,rcrdrRrerfr-r.rWrr!r0r*r#rgrhrirCrjrkrlrmrrGrn) rrpr%rSrrqrrrsrLrtrrr!view_default_school_trip_paymentssx                        rz/payments/default/modifyPATCHc Csg}y&tjdjtjds(|jdWn,tk rV}z|jdWYdd}~XnXy&tjdjtjds||jdWn,tk r}z|jdWYdd}~XnXy&tjdjtjds|jdWn.tk r}z|jd WYdd}~XnXy(tjd jtjd s(|jd Wn.tk rX}z|jd WYdd}~XnXy(tjd jtjd s|jdWn.tk r}z|jdWYdd}~XnXy(tjdjtjds|jdWn.tk r}z|jdWYdd}~XnXy(tjdjtjds0|jdWn.tk r`}z|jdWYdd}~XnXy0ttjdjttjds|jdWn.tk r}z|jdWYdd}~XnXy(tjdjtjds|jdWn.tk r}z|jdWYdd}~XnXtjd}|r0d}nd}|rXg}|jdtd |id!fStjj t j t j dkj t j tjdkj}|sg}|jd"td#|id!fStjdd$krd%}ntjdd&krd'}tjj tj tj dkj}x0|D](}|jj|jjkrtjd |_qWtjd|_tjd|_tjd |_tjd |_tjd|_||_tjd|_||_tjd|_tj|_y0tjjt tg} | jd(td#| id)fSt!k r}z8t"|tjj#t tg} | jd*td#| id!fSd}~XnXdS)+NrzPayment ID is empty.zPayment ID is missing.rzIncome Account Code is empty.zIncome Account Code is missing.rz"Department Analysis Code is empty.z$Department Analysis Code is missing.rzPerson is empty.zPerson is missing.rzMarker is empty.zMarker is missing.r zDescription is empty.zDescription is missing.r!z'School conservancy fee marker is empty.z)School conservancy fee marker is missing.r"zMax number is empty.zMax number is missing.r#zSession ID is empty.zSession ID is missing.r*r+rz5You appear to be missing some data. Please try again.r$izMThat gate entry fee does not appear to exist in the system. Please try again.r%r&r'r(r)z2The gate entry fee has been modified successfully.r\zRThere was a slight issue modifying the gate entry fee. :-( Please try again later.)$rrr8r9r:r;rr rr<rr=r>r,r`rr?r5r@r/r-r.rr0r!rWr*r#r rDr2rFrrGprintrH) r$rIrLr*r% get_paymentr!get_guest_typesingle_guest_typerrrredit_default_payment[s                       rz/payments/default/deletec,Cs(g}y&tjdjtjds(|jdWn,tk rV}z|jdWYdd}~XnXy&tjdjtjds||jdWn,tk r}z|jdWYdd}~XnX|rg}|jdt||dd fStjjt j t j dkj t j tjdkj }|s"g}|jd td |id fStjjtj tj dkj}x@|D]8}|jj|jjkrDd |_ tjd|_tj|_qDWd |_ tjd|_tj|_y0tjjttg}|jd td |idfStk r"}z8t|tjjttg}|jdtd |id fSd}~XnXdS)NrzPayment ID is empty.zPayment ID is missing.r#zSession ID is empty.zSession ID is missing.z5You appear to be missing some data. Please try again.)r%r$izMThat gate entry fee does not appear to exist in the system. Please try again.r%r+z1The gate entry fee has been deleted successfully.r\zQThere was a slight issue deleting the gate entry fee. :-( Please try again later.)rrr8r9r:rr rr<rr=r>r,r`rr?r5r@r/r#r rDr2rFrrGrrH)r$rIr%rrrrrrrdelete_default_paymentsd             rz/payments/schedule/newc=Csg}y&tjdjtjds(|jdWn,tk rV}z|jdWYdd}~XnXy&tjdjtjds||jdWn,tk r}z|jdWYdd}~XnXy&tjdjtjds|jdWn.tk r}z|jd WYdd}~XnX|rtd |id fStjjt j t j dkj }g}x|D]}|j|j q>Wttjd t|krg}|jd tttjd dtt|dtd|id fSttjd t|krg}|jdtd|id fStjdtjjdkrg}|jdtd|id fStjdtjjdkrVg}|jdtd|id fStjdtjdkrg}|jdtd|id fStjtjd}tjtjd}tjd}y |d} Wntk rd} YnXttj} t| ||| tjdtjtjd} tjj| x^tjd D]P} tttj| | d| dt| dtjdtjtjd} tjj| q$Wy0tjjttg}|jdtd|idfStk rtjjttg}|jdtd|id fSXdS) N start_datezStart date is empty.zStart date is missing.end_datezEnd date is empty.zEnd date is missing.r#zSession ID is empty.zSession ID is missing.r$ifeeszYou have set the pricing for z residency types while z. are expected. Please check on the set values.r%zkYou've set the pricing for more residency types than the system can accept. Please check on the set values.z%Y-%m-%dz.The schedule start date cannot be in the past.z,The schedule end date cannot be in the past.z8The schedule end date cannot come before the start date.destination_detailsdestination_public_id)rgr^r_r]r#r1r2r/rtr[)rdrRrbrerfr#r1r2z Successfully saved the schedule.r6zEThere was an error while saving the schedule. Please try again later.)rrr8r9r:rr rr<rr=r>r?r,lenr;r rDrGenerateDateFromString generateDaterGrArBrrErrnrFrrH)r$rIZget_all_categories categories each_categoryr%rrZdestination_objrx schedule_idZscheduleZeach_feeZpayment_pricesrrradd_new_payment_schedule/s     $               rz/payments/schedule/viewc Cstjjtjtjdkjtjjj }|sJg}|j dt d|idfSg}x|D]}i}|j |d<|j|d<|j |d<|jrtjjtjtjdkjtj|jkj}|j|d<nd|d<|j|d<tjjtjttjtjkjtjtjtjtjtjtjjtjdkjtj|j kj }g}x|D]}i} |j| d <|j| d <y8tjt j!|j} | j"d d d | d<|j| d<Wn(t#k rd| d<|j| d<YnXt$|j| d<|j | q,W||d<|j |qVWt d |idfSdS)Nz4There do not appear to be any pricing schedules set.r%irgr^r_r]Zschedule_destination_idr/rdrSrrTreZpayment_currency_idzN/Arfrr\)%r rr<rr=r>rhr^r~r?r9rrgr_r]rgatepass_destination_public_idr`gatepass_destination_namerrarrbr,rcrdrRrerfr/rjrkrlrmrrGrn) get_schedulesr%rSrZreturn_scheduleget_destinationrqZ price_data single_priceZ return_pricertrrrview_all_payment_scheduless^                 rz/payments/schedule/modifycKCs2g}y&tjdjtjds(|jdWn,tk rV}z|jdWYdd}~XnXy&tjdjtjds||jdWn,tk r}z|jdWYdd}~XnXy&tjdjtjds|jdWn.tk r}z|jd WYdd}~XnXy(tjd jtjd s(|jd Wn.tk rX}z|jd WYdd}~XnX|rptd |idfStjdtjjdkrg}|jdtd|idfStjdtjjdkrg}|jdtd|idfStjdtjdkrg}|jdtd|idfSytjd}Wnt k r<d}YnXt j j t jt jdkjt jtjdkj}|sg}|jdtd|idfStjd|_tjd|_||_tjd |_y0t j jtt g}|jdtd|idfSt k r,t j jtt g}|jdtd|idfSXdS)NrzSchedule ID is empty.zSchedule ID is missing.rzStart date is empty.zStart date is missing.rzEnd date is empty.zEnd date is missing.r#zSession ID is empty.zSession ID is missing.r$iz%Y-%m-%dz.The schedule start date cannot be in the past.r%z,The schedule end date cannot be in the past.z8The schedule end date cannot come before the start date.rxz=The selected schedule does not appear to exist in the system.iz'The selected schedule has been updated.r\zCThere was an error updating the selected schedule. Try again later.)rrr8r9r:rr rDrrGr rr<rr=r>rgr`r^r_r]r#rFrrH)r$rIr%rxrprrrupdate_payment_schedules               rz/payments/schedule/item/modifycCCsLg}y&tjdjtjds(|jdWn,tk rV}z|jdWYdd}~XnXy&tjdjtjds||jdWn,tk r}z|jdWYdd}~XnXy&tjdjtjds|jdWn.tk r}z|jd WYdd}~XnXy(tjd jtjd s(|jd Wn.tk rX}z|jd WYdd}~XnXtjjtj tj dkj tj tjdkj }|sg}|jd t d|idfStjd|_ttjd|_tjd |_y0tjjttg}|jdt d|idfStk rFtjjttg}|jdt d|idfSXdS)Nprice_idzPrice ID is empty.zPrice ID is missing.rtzCurrency is empty.zCurrency is missing.r[zAmount is empty.zAmount is missing.r#zSession ID is empty.zSession ID is missing.z2The selected pricing schedule item does not exist.r%r\z)Successfully saved the change to pricing.zEThere was an error saving the change to the pricing. Try again later.i)rrr8r9r:r rr<rr=r>rdr`rrernrfr#rFrrGrH)r$rIZget_schedule_itemr%rrrupdate_payment_schedule_itemWs`            rz/payments/schedule/deletec'Csg}y&tjdjtjds(|jdWn,tk rV}z|jdWYdd}~XnXy&tjdjtjds||jdWn,tk r}z|jdWYdd}~XnXtjjtj tj dkj tj tjdkj }|sg}|jdt d|id fSd |_ tj|_tjd|_tjjtj tj dkj tj|j kj}x*|D]"}d |_ tj|_tjd|_qJWy0tjjttg}|jd t d|id fStk rtjjttg}|jd t d|idfSXdS)NrzSchedule ID is empty.zSchedule ID is missing.r#zSession ID is empty.zSession ID is missing.z=The selected schedule does not appear to exist in the system.r%ir+z'The selected schedule has been deleted.r\zCThere was an error deleting the selected schedule. Try again later.i)rrr8r9r:r rr<rr=r>rgr`rr rDr2r#rrRr?rFrrGrH)r$rIrr%rqrrrrdelete_payment_schedulesX             rz/payments/schedule/clearc Cs0tj}tjjtjtjdkjtj|j dkj }|sXg}|j dt d|idfSxp|D]h}d|_tj|_ d|_tjjtjtjdkjtj|jkj }x"|D]}d|_tj|_ d|_qWq^Wy0tjjttg}|j dt d|idfStk r*g}|j dt d|idfSXdS) Nz%Y-%m-%dz(There are no expired schedules to clear.r%r\r+z Clear taskz'Successfully cleared expired schedules.z&Unable to clear the expired schedules.)r rDr rr<rr=r>r_rr?r9rr2r#rrRrgrFrrG)rrpr%rrrrqrrrclear_expired_scheduless:            rz/payments/entry_feesc (Cstj}ytjd}Wntk r.d}YnXytjd}Wntk rVd}YnXytjd}Wntk r~d}YnXg}|r2tjjtj tj dkj tj |kj tj tjdkj tj tjdkj}|jd|stjjtj tj dkj tj tjdkj tj tjdkj}|jdnVtjjtj tj dkj tj dkj tj tjdkj tj tjdkj}|jd|sg}|jdt||d d fSg}tjjtjttjtjkjtjtjtjtjtjtjtjtjtjtjtjtj tj!tj"tj#j tj dkj tj|j$kj tj dkj%tjj&j'}x0|D]&}i} |j| d <|j| d <|j| d <|jj(| d<|j| d<|j"} | dkrd| d<nd| d<y8t)j*t+j,|j} | jddd| d<|j| d<Wn(tk rd| d<|j| d<YnX|j| d<t-|j| d<d| d<d| d<|j| d<|j | d<d| d <|j!| d!<|j#| d"<|j| qLWtd|id#fSdS)$NrPrvrxzStage 1zStage 2rQzStage 3z#There are no pricing schedules set.)r%rSir,r-r.r/rRr+Tr*FrSrrTrUrVzN/ArWrXrYrZrr!r[r"r#r\).r rDrrrGr rr<rr=r>r]r^r_r`r9rrrarrbr,rcrdrRrerfr/r-r.rWrr!r0r*r#rgrhrir?rCrjrkrlrmrn) rrrrxrSrpr%rqrrrsrLrtrrrview_entry_fees_schedules                                rz/payments/entry_fees/schoolc )Cstj}ytjd}Wntk r.d}YnXytjd}Wntk rVd}YnXytjd}Wntk r~d}YnX|r&tjjtj tj dkj tj |kj tj tjdkj tj tjdkj}|srtjjtj tj dkj tj dkj tj tjdkj tj tjdkj}nLtjjtj tj dkj tj dkj tj tjdkj tj tjdkj}|sg}|jdtd|idfSg}x|D]}tjjtjttjtjkjtjtjtjtjtjtjtjtjtjtjtjtj tj!tj"tj#j tj dkj tj|j$kj tj dkj tj dkj%tjj&j}x0|D]&} i} | j| d<| j| d <| j| d <| jj'| d <| j| d <| j"} | d krd| d<nd| d<y8t(j)t*j+| j} | jddd| d<| j| d<Wn(tk rd| d<| j| d<YnX| j| d<t,| j| d<d| d<d| d<| j| d<| j | d<d| d<| j!| d<| j#| d<|j| qNWqWtd|id fSdS)!NrPrvrxz#There are no pricing schedules set.r%ir'r,r-r.r/rRr+Tr*FrSrrTrUrVzN/ArWrXrYrZrr!r[r"r#r\)-r rDrrrGr rr<rr=r>r]r^r_r?r9rrrarrbr,rcrdrRrerfr/r-r.rWrr!r0r*r#rgrhrirCrjrkrlrmrn) rrrrxrpr%rSrrqrrrsrLrtrrrview_school_entry_fees_schedules                                r)5flaskrrrrrrrr r r pymysqlosmathrjrAroutesr r routes.seed_functionsrdatabase.mandatory_paymentsrdatabase.booking_guest_typesr!database.mandatory_payment_pricesrZ#database.mandatory_payment_schedulerdatabase.destinationr variablesfunctions.booking_snippetsfunctions.date_operatorsrrouterOruryrrrrrrrrrrrrrrrrrrsB((        O]-5VY JN[A>+~