3
Ø€Œh¶. ã               @   sl  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mZ d dlmZ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$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l0m1Z1 d dl2m3Z3 d dl4m5Z5 d dl6m7Z7 d dl8m9Z9 d dl:m;Z; d dl<m=Z= d dl>m?Z? d dl@mAZA d dlBmCZC d dlDmEZE d dlFmGZG d dlHmIZI d d lJmKZK d d!lLmMZM d d"lNmOZOmPZPmQZQ d d#lRmSZS d d$lTT d%d&„ ZUejVd'ƒd(d)„ ƒZWejVd*ƒd+d,„ ƒZXejVd-d.gd/d0d1„ ƒZYejVd2ƒd3d4„ ƒZZejVd5ƒd6d7„ ƒZ[dS )8é    )ÚFlaskÚjsonifyÚrender_templateÚurl_forÚrequestÚredirectÚjson)ÚdatetimeÚ	timedeltaÚdateN)Úapp)Údb)Úget_booking_status_idÚcurrencyPostProcessorÚconvertAmount)ÚBookingTypeSeedÚBookingStatusSeedÚMandatoryPaymentsSeed)ÚBookingGuestTypesSeed)ÚBookingType)ÚBooking)ÚBookingGuest)ÚBookingPayment)ÚBookingStatus)Ú
CreditNote)ÚCreditNoteFacility)ÚCreditNoteGuest)ÚCreditNoteInventory)ÚCreditNoteVehicle)ÚFacility)Ú	Inventory)ÚDetail)Ú	Mandatory)ÚTransaction)ÚGatepass)ÚGatepassGuest)ÚGatepassDetail)Ú	GuestType)ÚGatepassVehicle)ÚPaymentGateway)ÚVehicle)ÚSchool)ÚSchoolBooking)ÚDestination)ÚbookingTotalÚcreditNoteTotalÚget_details_currency)ÚGenerateDateFromString)Ú*c             C   s   | j jƒ  d S )N)ÚsessionÚclose)Úself© r6   ú6/booking_service/app/routes/bookings_batchfile_urls.pyr4   *   s    r4   z/batchfile/generate/data/oldc        8      C   s~@  t jjtƒjttjtjkƒjtjtj	tj
tjtjtjtjtjtjtjƒ
jtjd kƒjtjd kƒjtjtdƒkƒjtjtdƒkƒjtjtdƒkƒjtjd kƒjƒ } tjƒ tdd jdƒ}g }g };x¼| D ;]²}|j|krÚqÈ|jjdƒdkrÈi }tjtj|jƒƒ}t||jdƒ |j}|j	d	 |j }t |ƒd
kr@|d d… }	n|}	x$|d D ]}
|
d dkrPt jjt!ƒjt!jd kƒjt!j|jkƒj"ƒ }i }|
d |d< |	|d< |
d |d< t#|jjdƒƒ|d< d|d< t$|
d dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |r|j&r|j&n*|rD|j'rD|j(rD|j'› d"|j(› nd |d#< |
d$ |d%< |
d& |d'< t$|
d( dƒ|d)< |j)|ƒ i }d*|d< |	|d< |
d |d< t#|jjdƒƒ|d< d|d< t$|
d dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |r
|j&r
|j&n*|r2|j'r2|j(r2|j'› d"|j(› nd |d#< d+|d'< d+|d%< t$|
d, dƒ|d)< |j)|ƒ qPW xú|d- D ]ì}|d- dkrxi }|d. |d< |	|d< |d/ |d< t#|jjdƒƒ|d< d|d< t$|d dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |r|j&r|j&n*|rB|j'rB|j(rB|j'› d"|j(› nd |d#< |d0 |d'< |d1 |d%< t$|d( dƒ|d)< |j)|ƒ i }d*|d< |	|d< |d/ |d< t#|jjdƒƒ|d< d|d< t$|d dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |r|j&r|j&n*|r0|j'r0|j(r0|j'› d"|j(› nd |d#< d+|d'< d+|d%< t$|d, dƒ|d)< |j)|ƒ qxW |d2 r xˆ|d2 D ]z}|d3 dkr@|d |d4 @ rti }|d5 |d< |	|d< |d6 |d< t#|jjdƒƒ|d< |d3 |d< t$|d7 dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |r8|j&r8|j&n*|r`|j'r`|j(r`|j'› d"|j(› nd |d#< |d8 |d'< |d9 |d%< t$|d: dƒ|d)< |j)|ƒ i }d*|d< |	|d< |d6 |d< t#|jjdƒƒ|d< |d3 |d< t$|d; dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |r*|j&r*|j&n*|rR|j'rR|j(rR|j'› d"|j(› nd |d#< d+|d'< d+|d%< t$|d< dƒ|d)< |j)|ƒ i }d=|d< |	|d< |d6 |d< t#|jjdƒƒ|d< |d3 |d< t$|d> dƒ|d< d |d< d|d< t%|d ƒ|d< d |d!< |r|j&r|j&n*|r<|j'r<|j(r<|j'› d"|j(› nd |d#< d+|d'< d+|d%< t$|d? dƒ|d)< |j)|ƒ nÌ|d 
r`i }|d5 |d< |	|d< |d6 |d< t#|jjdƒƒ|d< |d3 |d< t$|d@ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |	r|j&	r|j&n*|	r8|j'	r8|j(	r8|j'› d"|j(› nd |d#< |d8 |d'< |d9 |d%< t$|dA dƒ|d)< |j)|ƒ i }d*|d< |	|d< |d6 |d< t#|jjdƒƒ|d< |d3 |d< t$|d; dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |
r|j&
r|j&n*|
r*|j'
r*|j(
r*|j'› d"|j(› nd |d#< d+|d'< d+|d%< t$|d< dƒ|d)< |j)|ƒ nöi }|d5 |d< |	|d< |d6 |d< t#|jjdƒƒ|d< |d3 |d< t$|dB dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |
rò|j&
rò|j&n*|r|j'r|j(r|j'› d"|j(› nd |d#< |d8 |d'< |d9 |d%< t$|dC dƒ|d)< |j)|ƒ |d4 r@i }|d5 |d< |	|d< |d6 |d< t#|jjdƒƒ|d< |d3 |d< t$|dD dƒ|d< d |d< d|d< t%|d ƒ|d< d |d!< |rò|j&rò|j&n*|r|j'r|j(r|j'› d"|j(› nd |d#< |d8 |d'< |d9 |d%< t$|dE dƒ|d)< |j)|ƒ i }d=|d< |	|d< |d6 |d< t#|jjdƒƒ|d< |d3 |d< t$|d> dƒ|d< d |d< d|d< t%|d ƒ|d< d |d!< |rä|j&rä|j&n*|r|j'r|j(r|j'› d"|j(› nd |d#< d+|d'< d+|d%< t$|d? dƒ|d)< |j)|ƒ |dF dkr€|d |d4 @ r.i }|d5 |d< |	|d< |d6 |d< t#|jjdƒƒ|d< |dF |d< t$|dG dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |rò|j&rò|j&n*|r|j'r|j(r|j'› d"|j(› nd |d#< |d8 |d'< |d9 |d%< t$|dH dƒ|d)< |j)|ƒ i }d*|d< |	|d< |d6 |d< t#|jjdƒƒ|d< |dF |d< t$|dI dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |rä|j&rä|j&n*|r|j'r|j(r|j'› d"|j(› nd |d#< d+|d'< d+|d%< t$|dJ dƒ|d)< |j)|ƒ i }d=|d< |	|d< |d6 |d< t#|jjdƒƒ|d< |dF |d< t$|dK dƒ|d< d |d< d|d< t%|d ƒ|d< d |d!< |rÎ|j&rÎ|j&n*|rö|j'rö|j(rö|j'› d"|j(› nd |d#< d+|d'< d+|d%< t$|dL dƒ|d)< |j)|ƒ q€|d ri }|d5 |d< |	|d< |d6 |d< t#|jjdƒƒ|d< |dF |d< t$|dM dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |rÊ|j&rÊ|j&n*|rò|j'rò|j(rò|j'› d"|j(› nd |d#< |d8 |d'< |d9 |d%< t$|dN dƒ|d)< |j)|ƒ i }d*|d< |	|d< |d6 |d< t#|jjdƒƒ|d< |dF |d< t$|dI dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |r¼|j&r¼|j&n*|rä|j'rä|j(rä|j'› d"|j(› nd |d#< d+|d'< d+|d%< t$|dJ dƒ|d)< |j)|ƒ nöi }|d5 |d< |	|d< |d6 |d< t#|jjdƒƒ|d< |dF |d< t$|dO dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |r¬|j&r¬|j&n*|rÔ|j'rÔ|j(rÔ|j'› d"|j(› nd |d#< |d8 |d'< |d9 |d%< t$|dP dƒ|d)< |j)|ƒ |d4 r€i }|d5 |d< |	|d< |d6 |d< t#|jjdƒƒ|d< |dF |d< t$|dQ dƒ|d< d |d< d|d< t%|d ƒ|d< d |d!< |r¬|j&r¬|j&n*|rÔ|j'rÔ|j(rÔ|j'› d"|j(› nd |d#< |d8 |d'< |d9 |d%< t$|dR dƒ|d)< |j)|ƒ i }d=|d< |	|d< |d6 |d< t#|jjdƒƒ|d< |dF |d< t$|dK dƒ|d< d |d< d|d< t%|d ƒ|d< d |d!< |rž|j&rž|j&n*|rÆ|j'rÆ|j(rÆ|j'› d"|j(› nd |d#< d+|d'< d+|d%< t$|dL dƒ|d)< |j)|ƒ q€W |dS ;rJ&x<|dS D &].}|dT dUk2r:|dV dWk,r²|d |d4 @ rê|dX |dY  dkr.i }|dZ |d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |rî|j&rî|j&n*|r|j'r|j(r|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|d_ dƒ|d)< |j)|ƒ i }d*|d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |rÜ|j&rÜ|j&n*|r|j'r|j(r|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|d` dƒ|d)< |j)|ƒ i }d=|d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |rÊ|j&rÊ|j&n*|rò|j'rò|j(rò|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|da dƒ|d)< |j)|ƒ |db dkr
i }|dZ |d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |rÊ|j&rÊ|j&n*|rò|j'rò|j(rò|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|dc dƒ|d)< |j)|ƒ i }d*|d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |r¸|j&r¸|j&n*|rà|j'rà|j(rà|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|dd dƒ|d)< |j)|ƒ i }d=|d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |r¦|j&r¦|j&n*|rÎ|j'rÎ|j(rÎ|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|de dƒ|d)< |j)|ƒ |df dk,r®i }|dZ |d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |r¦|j&r¦|j&n*|rÎ|j'rÎ|j(rÎ|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|dg dƒ|d)< |j)|ƒ i } d*| d< |	| d< |d[ | d< t#|jjdƒƒ| d< d| d< t$|d\ dƒ| d< d| d< d| d< t%|d ƒ| d< d | d!< |r”|j&r”|j&n*|r¼|j'r¼|j(r¼|j'› d"|j(› nd | d#< |d] | d'< |d^ | d%< t$|dh dƒ| d)< |j)| ƒ i }!d=|!d< |	|!d< |d[ |!d< t#|jjdƒƒ|!d< d|!d< t$|d\ dƒ|!d< d|!d< d|!d< t%|d ƒ|!d< d |!d!< |r‚|j&r‚|j&n*|rª|j'rª|j(rª|j'› d"|j(› nd |!d#< |d] |!d'< |d^ |!d%< t$|di dƒ|!d)< |j)|!ƒ 2q6|d #rÊ|dX |dY  dkrêi }|dZ |d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |r˜|j&r˜|j&n*|rÀ|j'rÀ|j(rÀ|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|dj dƒ|d)< |j)|ƒ i }d*|d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |r†|j&r†|j&n*|r®|j'r®|j(r®|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|d` dƒ|d)< |j)|ƒ |db dk!rØi }|dZ |d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< | r†|j& r†|j&n*| r®|j' r®|j( r®|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|dk dƒ|d)< |j)|ƒ i }d*|d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |!rt|j&!rt|j&n*|!rœ|j'!rœ|j(!rœ|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|dd dƒ|d)< |j)|ƒ |df dk&rÒi }|dZ |d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |"rt|j&"rt|j&n*|"rœ|j'"rœ|j("rœ|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|dl dƒ|d)< |j)|ƒ i } d*| d< |	| d< |d[ | d< t#|jjdƒƒ| d< d| d< t$|d\ dƒ| d< d| d< d| d< t%|d ƒ| d< d | d!< |#rb|j&#rb|j&n*|#rŠ|j'#rŠ|j(#rŠ|j'› d"|j(› nd | d#< |d] | d'< |d^ | d%< t$|dh dƒ| d)< |j)| ƒ n|dX |dY  dk$rÒi }|dZ |d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |$rn|j&$rn|j&n*|$r–|j'$r–|j($r–|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|dm dƒ|d)< |j)|ƒ |db dk%rÒi }|dZ |d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |%rn|j&%rn|j&n*|%r–|j'%r–|j(%r–|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|dn dƒ|d)< |j)|ƒ |df dk&rÒi }|dZ |d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |&rn|j&&rn|j&n*|&r–|j'&r–|j(&r–|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|do dƒ|d)< |j)|ƒ |d4 2r6|dX |dY  dk(rÒi }|dZ |d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |'r€|j&'r€|j&n*|'r¨|j''r¨|j('r¨|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|dp dƒ|d)< |j)|ƒ i }d=|d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |(rn|j&(rn|j&n*|(r–|j'(r–|j((r–|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|da dƒ|d)< |j)|ƒ |db dk*rÀi }|dZ |d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |)rn|j&)rn|j&n*|)r–|j')r–|j()r–|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|dq dƒ|d)< |j)|ƒ i }d=|d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |*r\|j&*r\|j&n*|*r„|j'*r„|j(*r„|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|de dƒ|d)< |j)|ƒ |df dk2r6i }|dZ |d< |	|d< |d[ |d< t#|jjdƒƒ|d< d|d< t$|d\ dƒ|d< d|d< d|d< t%|d ƒ|d< d |d!< |+r\|j&+r\|j&n*|+r„|j'+r„|j(+r„|j'› d"|j(› nd |d#< |d] |d'< |d^ |d%< t$|dr dƒ|d)< |j)|ƒ i }!d=|!d< |	|!d< |d[ |!d< t#|jjdƒƒ|!d< d|!d< t$|d\ dƒ|!d< d|!d< d|!d< t%|d ƒ|!d< d |!d!< |,rJ|j&,rJ|j&n*|,rr|j',rr|j(,rr|j'› d"|j(› nd |!d#< |d] |!d'< |d^ |!d%< t$|di dƒ|!d)< |j)|!ƒ ;qD|dV dsk;rD|d |d4 @ 2r |dX dk/rxi }"|dZ |"d< |	|"d< |d[ |"d< t#|jjdƒƒ|"d< d|"d< d|"d< d|"d< t%|d ƒ|"d< d |"d!< |-r\|j&-r\|j&n*|-r„|j'-r„|j(-r„|j'› d"|j(› nd |"d#< |d] |"d'< |d^ |"d%< t$|dt dƒ|"d)< |j)|"ƒ i }#d*|#d< |	|#d< |d[ |#d< t#|jjdƒƒ|#d< d|#d< d|#d< d|#d< t%|d ƒ|#d< d |#d!< |.r8|j&.r8|j&n*|.r`|j'.r`|j(.r`|j'› d"|j(› nd |#d#< |d] |#d'< |d^ |#d%< t$|d< dƒ|#d)< |j)|#ƒ i }$d=|$d< |	|$d< |d[ |$d< t#|jjdƒƒ|$d< d|$d< d|$d< d|$d< t%|d ƒ|$d< d |$d!< |/r|j&/r|j&n*|/r<|j'/r<|j(/r<|j'› d"|j(› nd |$d#< |d] |$d'< |d^ |$d%< t$|d? dƒ|$d)< |j)|$ƒ |dY dk2r6i }%|dZ |%d< |	|%d< |d[ |%d< t#|jjdƒƒ|%d< d|%d< d|%d< d|%d< t%|d ƒ|%d< d |%d!< |0r|j&0r|j&n*|0r*|j'0r*|j(0r*|j'› d"|j(› nd |%d#< |d] |%d'< |d^ |%d%< t$|du dƒ|%d)< |j)|%ƒ i }&d*|&d< |	|&d< |d[ |&d< t#|jjdƒƒ|&d< d|&d< d|&d< d|&d< t%|d ƒ|&d< d |&d!< |0rÞ|j&0rÞ|j&n*|1r|j'1r|j(1r|j'› d"|j(› nd |&d#< |d] |&d'< |d^ |&d%< t$|dJ dƒ|&d)< |j)|&ƒ i }'d=|'d< |	|'d< |d[ |'d< t#|jjdƒƒ|'d< d|'d< d|'d< d|'d< t%|d ƒ|'d< d |'d!< |1rº|j&1rº|j&n*|1râ|j'1râ|j(1râ|j'› d"|j(› nd |'d#< |d] |'d'< |d^ |'d%< t$|dL dƒ|'d)< |j)|'ƒ n|d 2r,n |d4 ;rDq|dT dvkr|d |d4 @ 2r^q|d 8r8i }(|dZ |(d< |	|(d< |d[ |(d< t#|jjdƒƒ|(d< d|(d< t$|dw dƒ|(d< d|(d< d|(d< t%|d ƒ|(d< d |(d!< |2rö|j&2rö|j&n*|3r|j'3r|j(3r|j'› d"|j(› nd |(d#< |d] |(d'< |d^ |(d%< t$|dx dƒ|(d)< |j)|(ƒ i })d*|)d< |	|)d< |d[ |)d< t#|jjdƒƒ|)d< d|)d< t$|dw dƒ|)d< d|)d< d|)d< t%|d ƒ|)d< d |)d!< |3rä|j&3rä|j&n*|4r|j'4r|j(4r|j'› d"|j(› nd |)d#< |d] |)d'< |d^ |)d%< t$|dy dƒ|)d)< |j)|)ƒ |dX |db  dk6r>i }*|dZ |*d< |	|*d< |d[ |*d< t#|jjdƒƒ|*d< d|*d< t$|dz dƒ|*d< d|*d< d|*d< t%|d ƒ|*d< d |*d!< |4rì|j&4rì|j&n*|5r|j'5r|j(5r|j'› d"|j(› nd |*d#< |d] |*d'< |d^ |*d%< t$|d{ dƒ|*d)< |j)|*ƒ i }+d*|+d< |	|+d< |d[ |+d< t#|jjdƒƒ|+d< d|+d< t$|dz dƒ|+d< d|+d< d|+d< t%|d ƒ|+d< d |+d!< |5rÚ|j&5rÚ|j&n*|6r|j'6r|j(6r|j'› d"|j(› nd |+d#< |d] |+d'< |d^ |+d%< t$|d| dƒ|+d)< |j)|+ƒ |dY |df  dk;r:i },|dZ |,d< |	|,d< |d[ |,d< t#|jjdƒƒ|,d< d|,d< t$|d} dƒ|,d< d|,d< d|,d< t%|d ƒ|,d< d |,d!< |6râ|j&6râ|j&n*|7r
|j'7r
|j(7r
|j'› d"|j(› nd |,d#< |d] |,d'< |d^ |,d%< t$|d~ dƒ|,d)< |j)|,ƒ i }-d*|-d< |	|-d< |d[ |-d< t#|jjdƒƒ|-d< d|-d< t$|d} dƒ|-d< d|-d< d|-d< t%|d ƒ|-d< d |-d!< |7rÐ|j&7rÐ|j&n*|7rø|j'7rø|j(7rø|j'› d"|j(› nd |-d#< |d] |-d'< |d^ |-d%< t$|d dƒ|-d)< |j)|-ƒ ni }(|dZ |(d< |	|(d< |d[ |(d< t#|jjdƒƒ|(d< d|(d< t$|dw dƒ|(d< d|(d< d|(d< t%|d ƒ|(d< d |(d!< |8rÆ|j&8rÆ|j&n*|8rî|j'8rî|j(8rî|j'› d"|j(› nd |(d#< |d] |(d'< |d^ |(d%< t$|d€ dƒ|(d)< |j)|(ƒ |dX |db  dk:r2i }*|dZ |*d< |	|*d< |d[ |*d< t#|jjdƒƒ|*d< d|*d< t$|dz dƒ|*d< d|*d< d|*d< t%|d ƒ|*d< d |*d!< |9rÎ|j&9rÎ|j&n*|9rö|j'9rö|j(9rö|j'› d"|j(› nd |*d#< |d] |*d'< |d^ |*d%< t$|d dƒ|*d)< |j)|*ƒ |dY |df  dk;r:i },|dZ |,d< |	|,d< |d[ |,d< t#|jjdƒƒ|,d< d|,d< t$|d} dƒ|,d< d|,d< d|,d< t%|d ƒ|,d< d |,d!< |:rÖ|j&:rÖ|j&n*|:rþ|j':rþ|j(:rþ|j'› d"|j(› nd |,d#< |d] |,d'< |d^ |,d%< t$|d‚ dƒ|,d)< |j)|,ƒ |d4 rqW i }.|dƒ |.d< |	|.d< |j*ƒ d„ d d… |.d< t#|jjdƒƒ|.d< d|.d< t$|d† dƒ|.d< d‡|.d< |dˆ |.dˆ< |d‰ |.d‰< |dŠ |.dŠ< |d‹ |.d‹< t%|d ƒ|.d< d |.d!< |<r|j&<r|j&n*|<r4|j'<r4|j(<r4|j'› d"|j(› nd |.d#< d+|.d'< d+|.d%< t$|d† dƒ|.d)< ||.dŒ< |j)|.ƒ |j)|jƒ qÈW t jjt+ƒjtt+jtjkƒjtt+jtjkƒjt+jt+j,t+j-t+j.t+j/t+j0t+j1t+j2t+j3tjtj	tj
tjtjtjtjtjtjƒjt+jd kƒjtjtdƒkƒjƒ }/g }0g }1xH|/D ]>}2|2j0|0k=r>=q(|2jjdƒdk=r(|2j/dk=r`=q(i }3i }4tjtj|2j.ƒƒ}5t|3|2jdƒ |2j	d	 |2j }t |ƒd
k=r´|d d… }	n|}	|2j|4dŽ< t#|2jjdƒƒ|4d< |	|4d< d|4d< |2j
|4d#< |2j|4d< |5j*ƒ d„ d d… |4d< d|4d< t$t%|2j,ƒdƒ|4d< d |4d!< d+|4d'< d+|4d%< t%|2j2ƒ|4d< |3dƒ |4d< |1j)|4ƒ i }6tjtj|2j.ƒƒ}5t|3|2jdƒ |2j|6dŽ< t#|2jjdƒƒ|6d< |	|6d< d‡|6d< |2j
|6d#< |2j|6d< |5j*ƒ d„ d d… |6d< d|6d< t$t%|2j,ƒdƒ|6d< d |6d!< d+|6d'< d+|6d%< t%|2j2ƒ|6d< |2j/dk?rBd‘|6d< n|2j/d’k?rXd‘|6d< nø|2j/d“k?rnd”|6d< nâ|2j/d•k?rÂ|5j*ƒ d„ d d… d–k?ržd—|6d< n"|5j*ƒ d„ d d… d˜k@rPd™|6d< nŽ|2j/dšk?rØd‘|6d< nx|2j3@r
t jjt4ƒjt4j5|2j3kƒj"ƒ }7|7j6|6d< nF|5j*ƒ d„ d d… d–k@r.d›|6d< n"|5j*ƒ d„ d d… d˜k@rPdœ|6d< |1j)|6ƒ |0j)|2j0ƒ =q(W t7||1dœƒdžfS )ŸNÚDeletedÚ	CancelledÚ	Abandonedé   )Údaysz%Y-%m-%dz
2019-04-03Tú é   é   ÚguestsÚpayment_guestsr   Úpayment_person_income_codeÚincome_accountÚcustomer_referenceÚpayment_person_currencyÚcurrencyz%d%m%YÚ
sales_dateÚtran_quantityÚprice_minus_vaté   Ú
unit_priceÚVÚvatÚCÚ	dc_markerÚcurrency_selling_rate_at_timeÚconversion_rateÚVIÚjournal_typez...Úaccount_descriptionÚpayment_person_dept_codeÚ
departmentÚdestination_outlet_codeÚoutletÚbase_amount_minus_vatÚbase_amountÚ510001ú#Úbase_vatÚvehiclesÚvehicle_charge_income_codeÚvehicle_charge_cost_currencyÚvehicle_charge_outlet_codeÚvehicle_charge_dept_codeÚinventory_bookingsÚinventory_booking_adultsÚcatering_levyÚinventory_income_codeÚinventory_booking_currencyÚadult_minus_taxesÚinventory_outlet_codeÚinventory_dept_analysis_codeÚbase_adult_price_minus_taxesÚ	adult_vatÚbase_adult_vatÚ511006Úadult_caterÚbase_adult_caterÚadult_price_minus_vatÚbase_adult_price_minus_vatÚadult_priceÚbase_adult_priceÚadult_price_minus_caterÚbase_adult_price_minus_caterÚinventory_booking_childrenÚchild_minus_taxesÚbase_child_price_minus_taxesÚ	child_vatÚbase_child_vatÚchild_caterÚbase_child_caterÚchild_price_minus_vatÚbase_child_price_minus_vatÚchild_priceÚbase_child_priceÚchild_price_minus_caterÚbase_child_price_minus_caterÚfacility_bookingsÚfacility_typeÚAccomodationÚaccomodation_typeÚStablesÚfacility_booking_adultsÚfacility_booking_childrenÚfacility_income_codeÚfacility_booking_currencyÚcost_per_roomÚfacility_outlet_codeÚfacility_dept_analysis_codeÚbase_fixed_minus_taxesÚbase_fixed_vatÚbase_fixed_caterÚfacility_booking_extra_adultsÚbase_extra_adult_minus_taxesÚbase_extra_adult_vatÚbase_extra_adult_caterÚfacility_booking_extra_childrenÚbase_extra_child_minus_taxesÚbase_extra_child_vatÚbase_extra_child_caterÚbase_fixed_minus_vatÚbase_extra_adult_minus_vatÚbase_extra_child_minus_vatÚ
base_fixedÚbase_extra_adultÚbase_extra_childÚbase_fixed_minus_caterÚbase_extra_adult_minus_caterÚbase_extra_child_minus_caterÚPelicanÚbase_adult_minus_taxesÚbase_child_minus_taxeszCamping SitesÚfacility_booking_fixed_costÚbase_fixed_cost_minus_vatÚbase_fixed_cost_vatÚfacility_booking_adult_costÚbase_adult_cost_minus_vatÚbase_adult_cost_vatÚfacility_booking_child_costÚbase_child_cost_minus_vatÚbase_child_cost_vatÚbase_fixed_costÚbase_adult_costÚbase_child_costÚcustomer_codeÚdataÚcurrency_nameÚ
total_costÚDÚbooking_typeÚpartner_bookingÚguest_bookingÚgate_bookingÚcuinvoicenumberz$746bb582-89ed-4c83-ac3c-f25d9d60b266Úbooking_public_idÚcurrency_codez$5550ff2f-bc48-4f0e-8944-d08f7f2b93fdÚ407003z$cbff45f3-4f12-41da-8b4a-bf308112f032z$653e10f6-168c-493e-bcbb-0219537c24f6Ú407009z$33ad20be-3a89-4deb-ab71-7510ba51677eÚKESÚ407016ÚUSDÚ407017z$1c9d01cc-ef31-4757-a390-10c765fcecabÚ407007Ú407008)r´   Útransation_dataéÈ   )8r   r3   Úqueryr   Újoinr$   r½   Ú
booking_idÚadd_columnsÚbooking_ref_codeÚticketr¼   rF   Úbooking_done_byÚ
created_atÚbooking_check_in_dateÚgatepass_public_idÚgatepass_dateÚfilterÚdeletion_markerÚstatusr   Úallr	   Únowr
   ÚstrftimeÚrequestsÚgetÚget_currencyÚformatr.   Úlenr   ÚfirstÚstrÚroundÚfloatÚmpesa_referenceÚcard_first_fourÚcard_last_fourÚappendr   r#   Útransaction_totalÚtransaction_total_currencyÚtransaction_payment_currencyÚtransaction_payment_methodÚtransaction_booking_public_idÚ$payment_currency_buying_rate_at_timeÚ%payment_currency_selling_rate_at_timeÚtransaction_payment_gatewayr)   Úpayment_gateway_public_idÚpayment_gateway_coder   )8Úselect_bookingsÚ	yesterdayÚexisting_bookingsr´   Úsingle_bookingÚreturn_dataÚbooking_currencyr¼   Úcustomer_refrD   Úsingle_gatepass_guestÚget_booking_paymentÚincome_gatepass_dataÚvat_gatepass_dataÚsingle_gatepass_vehicleÚincome_gatepass_vehicle_dataÚvat_gatepass_vehicle_dataÚsingle_inventoryÚincome_adult_inventory_dataÚvat_adult_inventory_dataÚcater_adult_inventory_dataÚincome_child_inventory_dataÚvat_child_inventory_dataÚcater_child_inventory_dataÚsingle_facilityÚincome_fixed_stables_dataÚvat_fixed_stables_dataÚcater_fixed_stables_dataÚincome_adult_stables_dataÚvat_adult_stables_dataÚcater_adult_stables_dataÚincome_child_stables_dataÚvat_child_stables_dataÚcater_child_stables_dataÚincome_adult_pelican_dataÚvat_adult_pelican_dataÚcater_adult_pelican_dataÚincome_child_pelican_dataÚvat_child_pelican_dataÚcater_child_pelican_dataÚincome_camp_fee_dataÚvat_camp_fee_dataÚincome_adult_campsite_dataÚvat_adult_campsite_dataÚincome_child_campsite_dataÚvat_child_campsite_dataÚbooking_dataÚselect_transactionsÚexisting_transactionsÚtransaction_dataÚsingle_transactionÚgeneral_booking_dataÚcustomer_dataÚtransaction_currencyÚ	bank_dataÚget_gatewayr6   r6   r7   Úgenerate_full_batchfile_data_/   sj   



D



D

D




D





D




D


D




D





D



D






D





D





D




D


D




D





D



D






D





D



D




D



D




D




D



D





D




D



D





D



D




D



D





D



D




D



D



D




D



D



D



D




D



D






D




D



D




D




D



D







D




D






D





D





D





D



D






D





D





D




















r&  z/batchfile/generate/datac        N   %   C   s¨f  yt jd } t jd }W n$ tk
r<   tjƒ } tjƒ }Y nX tjjtƒj	t
tjt
jkƒjtjtjtjtjtjtjtjtjt
jt
jƒ
jtjd kƒjtjd kƒjtjtdƒkƒjtjtdƒkƒjtjtdƒkƒjtjj| |ƒƒjt
jd kƒjƒ }g }g }_xì|D _]â}|j|krqþi }tjtj |jƒƒ}t!||jdƒ tjjt"ƒj	t#t"j$t#j%kƒjt#j&ƒjt"jd kƒjt"j|jkƒj'ƒ }tjjt(ƒjt(jd kƒjt(j|jkƒj'ƒ }	|j}
|rØy
|j&}W n tk
rÔ   |j}Y nX n|j}|jd | }t)|ƒdkr|d d	… }n|}x
|d
 D ]ü}|d dkri }|d |d< ||d< |d |d< t*|jj+dƒƒ|d< d|d< t,|d dƒ|d< d|d< d|d< t-|d ƒ|d< d|d < |	rº|	j.rº|	j.n*|	râ|	j/râ|	j0râ|	j/› d!|	j0› nd |d"< |d# |d$< |d% |d&< t,|d' dƒ|d(< |
|d)< |j1|ƒ i }d*|d< ||d< |d |d< t*|jj+dƒƒ|d< d|d< t,|d dƒ|d< d|d< d|d< t-|d ƒ|d< d|d < |	r°|	j.r°|	j.n*|	rØ|	j/rØ|	j0rØ|	j/› d!|	j0› nd |d"< d+|d&< d+|d$< t,|d, dƒ|d(< |
|d)< |j1|ƒ qW x
|d- D ]ü}|d- dkr&i }|d. |d< ||d< |d/ |d< t*|jj+dƒƒ|d< d|d< t,|d dƒ|d< d|d< d|d< t-|d ƒ|d< d|d < |	rÈ|	j.rÈ|	j.n*|	rð|	j/rð|	j0rð|	j/› d!|	j0› nd |d"< |d0 |d&< |d1 |d$< t,|d' dƒ|d(< |
|d)< |j1|ƒ i }d*|d< ||d< |d/ |d< t*|jj+dƒƒ|d< d|d< t,|d dƒ|d< d|d< d|d< t-|d ƒ|d< d|d < |	r¾|	j.r¾|	j.n*|	ræ|	j/ræ|	j0ræ|	j/› d!|	j0› nd |d"< d+|d&< d+|d$< t,|d, dƒ|d(< |
|d)< |j1|ƒ q&W |d2 r>x|d2 D ]ú}|d3 dkr>|d |d4 @ 	rJi }|d5 |d< ||d< |d6 |d< t*|jj+dƒƒ|d< |d3 |d< t,|d7 dƒ|d< d|d< d|d< t-|d ƒ|d< d|d < |	rö|	j.rö|	j.n*|	r|	j/r|	j0r|	j/› d!|	j0› nd |d"< |d8 |d&< |d9 |d$< t,|d: dƒ|d(< |
|d)< |j1|ƒ i }d*|d< ||d< |d6 |d< t*|jj+dƒƒ|d< |d3 |d< t,|d; dƒ|d< d|d< d|d< t-|d ƒ|d< d|d < |	rð|	j.rð|	j.n*|	r|	j/r|	j0r|	j/› d!|	j0› nd |d"< d+|d&< d+|d$< t,|d< dƒ|d(< |
|d)< |j1|ƒ i }d=|d< ||d< |d6 |d< t*|jj+dƒƒ|d< |d3 |d< t,|d> dƒ|d< d |d< d|d< t-|d ƒ|d< d|d < |	râ|	j.râ|	j.n*|		r
|	j/	r
|	j0	r
|	j/› d!|	j0› nd |d"< d+|d&< d+|d$< t,|d? dƒ|d(< |
|d)< |j1|ƒ nô|d rFi }|d5 |d< ||d< |d6 |d< t*|jj+dƒƒ|d< |d3 |d< t,|d@ dAƒ|d< d|d< d|d< t-|d ƒ|d< d|d < |		ræ|	j.	ræ|	j.n*|	
r|	j/
r|	j0
r|	j/› d!|	j0› nd |d"< |d8 |d&< |d9 |d$< t,|dB dAƒ|d(< |
|d)< |j1|ƒ i }d*|d< ||d< |d6 |d< t*|jj+dƒƒ|d< |d3 |d< t,|d; dAƒ|d< d|d< d|d< t-|d ƒ|d< d|d < |	
rà|	j.
rà|	j.n*|	r|	j/r|	j0r|	j/› d!|	j0› nd |d"< d+|d&< d+|d$< t,|d< dAƒ|d(< |
|d)< |j1|ƒ nþi }|d5 |d< ||d< |d6 |d< t*|jj+dƒƒ|d< |d3 |d< t,|dC dƒ|d< d|d< d|d< t-|d ƒ|d< d|d < |	rØ|	j.rØ|	j.n*|	r |	j/r |	j0r |	j/› d!|	j0› nd |d"< |d8 |d&< |d9 |d$< t,|dD dƒ|d(< |
|d)< |j1|ƒ |d4 r>i }|d5 |d< ||d< |d6 |d< t*|jj+dƒƒ|d< |d3 |d< t,|dE dƒ|d< d |d< d|d< t-|d ƒ|d< d|d < |	rà|	j.rà|	j.n*|	r|	j/r|	j0r|	j/› d!|	j0› nd |d"< |d8 |d&< |d9 |d$< t,|dF dƒ|d(< |
|d)< |j1|ƒ i }d=|d< ||d< |d6 |d< t*|jj+dƒƒ|d< |d3 |d< t,|d> dƒ|d< d |d< d|d< t-|d ƒ|d< d|d < |	rÚ|	j.rÚ|	j.n*|	r|	j/r|	j0r|	j/› d!|	j0› nd |d"< d+|d&< d+|d$< t,|d? dƒ|d(< |
|d)< |j1|ƒ |dG dkr>|d |d4 @ rDi }|d5 |d< ||d< |d6 |d< t*|jj+dƒƒ|d< |dG |d< t,|dH dƒ|d< d|d< d|d< t-|d ƒ|d< d|d < |	rð|	j.rð|	j.n*|	r|	j/r|	j0r|	j/› d!|	j0› nd |d"< |d8 |d&< |d9 |d$< t,|dI dƒ|d(< |
|d)< |j1|ƒ i }d*|d< ||d< |d6 |d< t*|jj+dƒƒ|d< |dG |d< t,|dJ dƒ|d< d|d< d|d< t-|d ƒ|d< d|d < |	rê|	j.rê|	j.n*|	r|	j/r|	j0r|	j/› d!|	j0› nd |d"< d+|d&< d+|d$< t,|dK dƒ|d(< |
|d)< |j1|ƒ i }d=|d< ||d< |d6 |d< t*|jj+dƒƒ|d< |dG |d< t,|dL dƒ|d< d |d< d|d< t-|d ƒ|d< d|d < |	rÜ|	j.rÜ|	j.n*|	r|	j/r|	j0r|	j/› d!|	j0› nd |d"< d+|d&< d+|d$< t,|dM dƒ|d(< |
|d)< |j1|ƒ q>|d r@i }|d5 |d< ||d< |d6 |d< t*|jj+dƒƒ|d< |dG |d< t,|dN dƒ|d< d|d< d|d< t-|d ƒ|d< d|d < |	rà|	j.rà|	j.n*|	r|	j/r|	j0r|	j/› d!|	j0› nd |d"< |d8 |d&< |d9 |d$< t,|dO dƒ|d(< |
|d)< |j1|ƒ i }d*|d< ||d< |d6 |d< t*|jj+dƒƒ|d< |dG |d< t,|dJ dƒ|d< d|d< d|d< t-|d ƒ|d< d|d < |	rÚ|	j.rÚ|	j.n*|	r|	j/r|	j0r|	j/› d!|	j0› nd |d"< d+|d&< d+|d$< t,|dK dƒ|d(< |
|d)< |j1|ƒ nþi }|d5 |d< ||d< |d6 |d< t*|jj+dƒƒ|d< |dG |d< t,|dP dƒ|d< d|d< d|d< t-|d ƒ|d< d|d < |	rÒ|	j.rÒ|	j.n*|	rú|	j/rú|	j0rú|	j/› d!|	j0› nd |d"< |d8 |d&< |d9 |d$< t,|dQ dƒ|d(< |
|d)< |j1|ƒ |d4 r>i }|d5 |d< ||d< |d6 |d< t*|jj+dƒƒ|d< |dG |d< t,|dR dƒ|d< d |d< d|d< t-|d ƒ|d< d|d < |	rÚ|	j.rÚ|	j.n*|	r|	j/r|	j0r|	j/› d!|	j0› nd |d"< |d8 |d&< |d9 |d$< t,|dS dƒ|d(< |
|d)< |j1|ƒ i }d=|d< ||d< |d6 |d< t*|jj+dƒƒ|d< |dG |d< t,|dL dƒ|d< d |d< d|d< t-|d ƒ|d< d|d < |	rÔ|	j.rÔ|	j.n*|	rü|	j/rü|	j0rü|	j/› d!|	j0› nd |d"< d+|d&< d+|d$< t,|dM dƒ|d(< |
|d)< |j1|ƒ q>W |dT Ur¶?xj|dT D ?]\}|dU dVkCr€|dW dXk=rÈ|d |d4 @ #r6|dY |dZ  dkrÆ|d[ rà|d\ }x&|D ] }|d }|d] }|d^ } t2|ƒd_ |  }!i }"||"d< ||"d< |d` |"d< t*|jj+dƒƒ|"d< d|"d< t,|da dƒ|"d< d|"d< d|"d< t-|d ƒ|"d< d|"d < |	rp|	j.rp|	j.n*|	r˜|	j/r˜|	j0r˜|	j/› d!|	j0› nd |"d"< |db |"d&< |dc |"d$< t,|!dƒ|"d(< |
|"d)< |j1|"ƒ q¸W núi }"|dd |"d< ||"d< |d` |"d< t*|jj+dƒƒ|"d< d|"d< t,|da dƒ|"d< d|"d< d|"d< t-|d ƒ|"d< d|"d < |	rn|	j.rn|	j.n*|	r–|	j/r–|	j0r–|	j/› d!|	j0› nd |"d"< |db |"d&< |dc |"d$< t,|d^ dƒ|"d(< |
|"d)< |j1|"ƒ i }#d*|#d< ||#d< |d` |#d< t*|jj+dƒƒ|#d< d|#d< t,|da dƒ|#d< d|#d< d|#d< t-|d ƒ|#d< d|#d < |	rd|	j.rd|	j.n*|	rŒ|	j/rŒ|	j0rŒ|	j/› d!|	j0› nd |#d"< |db |#d&< |dc |#d$< t,|de dƒ|#d(< |
|#d)< |j1|#ƒ i }$d=|$d< ||$d< |d` |$d< t*|jj+dƒƒ|$d< d|$d< t,|da dƒ|$d< d|$d< d|$d< t-|d ƒ|$d< d|$d < |	rZ|	j.rZ|	j.n*|	r‚|	j/r‚|	j0r‚|	j/› d!|	j0› nd |$d"< |db |$d&< |dc |$d$< t,|df dƒ|$d(< |
|$d)< |j1|$ƒ |dg dkrü|d[ r|d\ }x&|D ] }|d }|d] }|dh } t2|ƒd_ |  }!i }%||%d< ||%d< |d` |%d< t*|jj+dƒƒ|%d< d|%d< t,|da dƒ|%d< d|%d< d|%d< t-|d ƒ|%d< d|%d < |	r¦|	j.r¦|	j.n*|	rÎ|	j/rÎ|	j0rÎ|	j/› d!|	j0› nd |%d"< |db |%d&< |dc |%d$< t,|!dƒ|%d(< |
|%d)< |j1|%ƒ qîW núi }%|dd |%d< ||%d< |d` |%d< t*|jj+dƒƒ|%d< d|%d< t,|da dƒ|%d< d|%d< d|%d< t-|d ƒ|%d< d|%d < |	r¤|	j.r¤|	j.n*|	rÌ|	j/rÌ|	j0rÌ|	j/› d!|	j0› nd |%d"< |db |%d&< |dc |%d$< t,|dh dƒ|%d(< |
|%d)< |j1|%ƒ i }&d*|&d< ||&d< |d` |&d< t*|jj+dƒƒ|&d< d|&d< t,|da dƒ|&d< d|&d< d|&d< t-|d ƒ|&d< d|&d < |	rš|	j.rš|	j.n*|	rÂ|	j/rÂ|	j0rÂ|	j/› d!|	j0› nd |&d"< |db |&d&< |dc |&d$< t,|di dƒ|&d(< |
|&d)< |j1|&ƒ i }'d=|'d< ||'d< |d` |'d< t*|jj+dƒƒ|'d< d|'d< t,|da dƒ|'d< d|'d< d|'d< t-|d ƒ|'d< d|'d < |	r|	j.r|	j.n*|	r¸|	j/r¸|	j0r¸|	j/› d!|	j0› nd |'d"< |db |'d&< |dc |'d$< t,|dj dƒ|'d(< |
|'d)< |j1|'ƒ |dk dk=rÄ|d[  rL|d\ }x&|D ] }|d }|d] }|dl } t2|ƒd_ |  }!i }(||(d< ||(d< |d` |(d< t*|jj+dƒƒ|(d< d|(d< t,|da dƒ|(d< d|(d< d|(d< t-|d ƒ|(d< d|(d < |	rÜ|	j.rÜ|	j.n*|	 r|	j/ r|	j0 r|	j/› d!|	j0› nd |(d"< |db |(d&< |dc |(d$< t,|!dƒ|(d(< |
|(d)< |j1|(ƒ q$W núi }(|dd |(d< ||(d< |d` |(d< t*|jj+dƒƒ|(d< d|(d< t,|da dƒ|(d< d|(d< d|(d< t-|d ƒ|(d< d|(d < |	 rÚ|	j. rÚ|	j.n*|	!r|	j/!r|	j0!r|	j/› d!|	j0› nd |(d"< |db |(d&< |dc |(d$< t,|dl dƒ|(d(< |
|(d)< |j1|(ƒ i })d*|)d< ||)d< |d` |)d< t*|jj+dƒƒ|)d< d|)d< t,|da dƒ|)d< d|)d< d|)d< t-|d ƒ|)d< d|)d < |	!rÐ|	j.!rÐ|	j.n*|	!rø|	j/!rø|	j0!rø|	j/› d!|	j0› nd |)d"< |db |)d&< |dc |)d$< t,|dm dƒ|)d(< |
|)d)< |j1|)ƒ i }*d=|*d< ||*d< |d` |*d< t*|jj+dƒƒ|*d< d|*d< t,|da dƒ|*d< d|*d< d|*d< t-|d ƒ|*d< d|*d < |	"rÆ|	j."rÆ|	j.n*|	"rî|	j/"rî|	j0"rî|	j/› d!|	j0› nd |*d"< |db |*d&< |dc |*d$< t,|dn dƒ|*d(< |
|*d)< |j1|*ƒ Cq||d -r|dY |dZ  dk&rˆ|d[ $r˜|d\ }x&|D ] }|d }|d] }|do } t2|ƒd_ |  }!i }"||"d< ||"d< |d` |"d< t*|jj+dƒƒ|"d< d|"d< t,|da dƒ|"d< d|"d< d|"d< t-|d ƒ|"d< d|"d < |	$r(|	j.$r(|	j.n*|	$rP|	j/$rP|	j0$rP|	j/› d!|	j0› nd |"d"< |db |"d&< |dc |"d$< t,|!dƒ|"d(< |
|"d)< |j1|"ƒ #qpW núi }"|dd |"d< ||"d< |d` |"d< t*|jj+dƒƒ|"d< d|"d< t,|da dƒ|"d< d|"d< d|"d< t-|d ƒ|"d< d|"d < |	%r&|	j.%r&|	j.n*|	%rN|	j/%rN|	j0%rN|	j/› d!|	j0› nd |"d"< |db |"d&< |dc |"d$< t,|do dƒ|"d(< |
|"d)< |j1|"ƒ i }#d*|#d< ||#d< |d` |#d< t*|jj+dƒƒ|#d< d|#d< t,|da dƒ|#d< d|#d< d|#d< t-|d ƒ|#d< d|#d < |	&r|	j.&r|	j.n*|	&rD|	j/&rD|	j0&rD|	j/› d!|	j0› nd |#d"< |db |#d&< |dc |#d$< t,|de dƒ|#d(< |
|#d)< |j1|#ƒ |dg dk)rÈ|d[ 'rØ|d\ }x&|D ] }|d }|d] }|dp } t2|ƒd_ |  }!i }%||%d< ||%d< |d` |%d< t*|jj+dƒƒ|%d< d|%d< t,|da dƒ|%d< d|%d< d|%d< t-|d ƒ|%d< d|%d < |	'rh|	j.'rh|	j.n*|	'r|	j/'r|	j0'r|	j/› d!|	j0› nd |%d"< |db |%d&< |dc |%d$< t,|!dƒ|%d(< |
|%d)< |j1|%ƒ &q°W núi }%|dd |%d< ||%d< |d` |%d< t*|jj+dƒƒ|%d< d|%d< t,|da dƒ|%d< d|%d< d|%d< t-|d ƒ|%d< d|%d < |	(rf|	j.(rf|	j.n*|	(rŽ|	j/(rŽ|	j0(rŽ|	j/› d!|	j0› nd |%d"< |db |%d&< |dc |%d$< t,|dp dƒ|%d(< |
|%d)< |j1|%ƒ i }&d*|&d< ||&d< |d` |&d< t*|jj+dƒƒ|&d< d|&d< t,|da dƒ|&d< d|&d< d|&d< t-|d ƒ|&d< d|&d < |	)r\|	j.)r\|	j.n*|	)r„|	j/)r„|	j0)r„|	j/› d!|	j0› nd |&d"< |db |&d&< |dc |&d$< t,|di dƒ|&d(< |
|&d)< |j1|&ƒ |dk dk3rò|d[ +r|d\ }x&|D ] }|d }|d] }|dq } t2|ƒd_ |  }!i }(||(d< ||(d< |d` |(d< t*|jj+dƒƒ|(d< d|(d< t,|da dƒ|(d< d|(d< d|(d< t-|d ƒ|(d< d|(d < |	*r¨|	j.*r¨|	j.n*|	*rÐ|	j/*rÐ|	j0*rÐ|	j/› d!|	j0› nd |(d"< |db |(d&< |dc |(d$< t,|!dƒ|(d(< |
|(d)< |j1|(ƒ )qðW núi }(|dd |(d< ||(d< |d` |(d< t*|jj+dƒƒ|(d< d|(d< t,|da dƒ|(d< d|(d< d|(d< t-|d ƒ|(d< d|(d < |	+r¦|	j.+r¦|	j.n*|	+rÎ|	j/+rÎ|	j0+rÎ|	j/› d!|	j0› nd |(d"< |db |(d&< |dc |(d$< t,|dq dƒ|(d(< |
|(d)< |j1|(ƒ i })d*|)d< ||)d< |d` |)d< t*|jj+dƒƒ|)d< d|)d< t,|da dƒ|)d< d|)d< d|)d< t-|d ƒ|)d< d|)d < |	,rœ|	j.,rœ|	j.n*|	,rÄ|	j/,rÄ|	j0,rÄ|	j/› d!|	j0› nd |)d"< |db |)d&< |dc |)d$< t,|dm dƒ|)d(< |
|)d)< |j1|)ƒ næ|dY |dZ  dk/r^|d[ .rd|d\ }x&|D ] }|d }|d] }|dr } t2|ƒd_ |  }!i }"||"d< ||"d< |d` |"d< t*|jj+dƒƒ|"d< d|"d< t,|da dƒ|"d< d|"d< d|"d< t-|d ƒ|"d< d|"d < |	-rô|	j.-rô|	j.n*|	.r|	j/.r|	j0.r|	j/› d!|	j0› nd |"d"< |db |"d&< |dc |"d$< t,|!dƒ|"d(< |
|"d)< |j1|"ƒ -q<W núi }"|dd |"d< ||"d< |d` |"d< t*|jj+dƒƒ|"d< d|"d< t,|da dƒ|"d< d|"d< d|"d< t-|d ƒ|"d< d|"d < |	.rò|	j..rò|	j.n*|	/r|	j//r|	j0/r|	j/› d!|	j0› nd |"d"< |db |"d&< |dc |"d$< t,|dr dƒ|"d(< |
|"d)< |j1|"ƒ |dg dk1r¨|d[ 0r®|d\ }x&|D ] }|d }|d] }|ds } t2|ƒd_ |  }!i }%||%d< ||%d< |d` |%d< t*|jj+dƒƒ|%d< d|%d< t,|da dƒ|%d< d|%d< d|%d< t-|d ƒ|%d< d|%d < |	0r>|	j.0r>|	j.n*|	0rf|	j/0rf|	j00rf|	j/› d!|	j0› nd |%d"< |db |%d&< |dc |%d$< t,|!dƒ|%d(< |
|%d)< |j1|%ƒ /q†W núi }%|dd |%d< ||%d< |d` |%d< t*|jj+dƒƒ|%d< d|%d< t,|da dƒ|%d< d|%d< d|%d< t-|d ƒ|%d< d|%d < |	1r<|	j.1r<|	j.n*|	1rd|	j/1rd|	j01rd|	j/› d!|	j0› nd |%d"< |db |%d&< |dc |%d$< t,|ds dƒ|%d(< |
|%d)< |j1|%ƒ |dk dk3rò|d[ 2rø|d\ }x&|D ] }|d }|d] }|dt } t2|ƒd_ |  }!i }(||(d< ||(d< |d` |(d< t*|jj+dƒƒ|(d< d|(d< t,|da dƒ|(d< d|(d< d|(d< t-|d ƒ|(d< d|(d < |	2rˆ|	j.2rˆ|	j.n*|	2r°|	j/2r°|	j02r°|	j/› d!|	j0› nd |(d"< |db |(d&< |dc |(d$< t3|!dƒ|(d(< |
|(d)< |j1|(ƒ 1qÐW núi }(|dd |(d< ||(d< |d` |(d< t*|jj+dƒƒ|(d< d|(d< t,|da dƒ|(d< d|(d< d|(d< t-|d ƒ|(d< d|(d < |	3r†|	j.3r†|	j.n*|	3r®|	j/3r®|	j03r®|	j/› d!|	j0› nd |(d"< |db |(d&< |dc |(d$< t,|dt dƒ|(d(< |
|(d)< |j1|(ƒ |d4 Cr||dY |dZ  dk7rD|d[ 5rT|d\ }x&|D ] }|d }|d] }|du } t2|ƒd_ |  }!i }"||"d< ||"d< |d` |"d< t*|jj+dƒƒ|"d< d|"d< t,|da dƒ|"d< d|"d< d|"d< t-|d ƒ|"d< d|"d < |	4rä|	j.4rä|	j.n*|	5r|	j/5r|	j05r|	j/› d!|	j0› nd |"d"< |db |"d&< |dc |"d$< t,|!dƒ|"d(< |
|"d)< |j1|"ƒ 4q,W núi }"|dd |"d< ||"d< |d` |"d< t*|jj+dƒƒ|"d< d|"d< t,|da dƒ|"d< d|"d< d|"d< t-|d ƒ|"d< d|"d < |	5râ|	j.5râ|	j.n*|	6r
|	j/6r
|	j06r
|	j/› d!|	j0› nd |"d"< |db |"d&< |dc |"d$< t,|df dƒ|"d(< |
|"d)< |j1|"ƒ i }$d=|$d< ||$d< |d` |$d< t*|jj+dƒƒ|$d< d|$d< t,|da dƒ|$d< d|$d< d|$d< t-|d ƒ|$d< d|$d < |	6rØ|	j.6rØ|	j.n*|	7r |	j/7r |	j07r |	j/› d!|	j0› nd |$d"< |db |$d&< |dc |$d$< t,|df dƒ|$d(< |
|$d)< |j1|$ƒ |dg dk:r„|d[ 8r”|d\ }x&|D ] }|d }|d] }|dv } t2|ƒd_ |  }!i }%||%d< ||%d< |d` |%d< t*|jj+dƒƒ|%d< d|%d< t,|da dƒ|%d< d|%d< d|%d< t-|d ƒ|%d< d|%d < |	8r$|	j.8r$|	j.n*|	8rL|	j/8rL|	j08rL|	j/› d!|	j0› nd |%d"< |db |%d&< |dc |%d$< t,|!dƒ|%d(< |
|%d)< |j1|%ƒ 7qlW núi }%|dd |%d< ||%d< |d` |%d< t*|jj+dƒƒ|%d< d|%d< t,|da dƒ|%d< d|%d< d|%d< t-|d ƒ|%d< d|%d < |	9r"|	j.9r"|	j.n*|	9rJ|	j/9rJ|	j09rJ|	j/› d!|	j0› nd |%d"< |db |%d&< |dc |%d$< t,|dv dƒ|%d(< |
|%d)< |j1|%ƒ i }'d=|'d< ||'d< |d` |'d< t*|jj+dƒƒ|'d< d|'d< t,|da dƒ|'d< d|'d< d|'d< t-|d ƒ|'d< d|'d < |	:r|	j.:r|	j.n*|	:r@|	j/:r@|	j0:r@|	j/› d!|	j0› nd |'d"< |db |'d&< |dc |'d$< t,|dj dƒ|'d(< |
|'d)< |j1|'ƒ |dk dkCr||d[ ;rÔ|d\ }x&|D ] }|d }|d] }|dw } t2|ƒd_ |  }!i }(||(d< ||(d< |d` |(d< t*|jj+dƒƒ|(d< d|(d< t,|da dƒ|(d< d|(d< d|(d< t-|d ƒ|(d< d|(d < |	;rd|	j.;rd|	j.n*|	;rŒ|	j/;rŒ|	j0;rŒ|	j/› d!|	j0› nd |(d"< |db |(d&< |dc |(d$< t3|!dƒ|(d(< |
|(d)< |j1|(ƒ :q¬W núi }(|dd |(d< ||(d< |d` |(d< t*|jj+dƒƒ|(d< d|(d< t,|da dƒ|(d< d|(d< d|(d< t-|d ƒ|(d< d|(d < |	<rb|	j.<rb|	j.n*|	<rŠ|	j/<rŠ|	j0<rŠ|	j/› d!|	j0› nd |(d"< |db |(d&< |dc |(d$< t,|dw dƒ|(d(< |
|(d)< |j1|(ƒ i }*d=|*d< ||*d< |d` |*d< t*|jj+dƒƒ|*d< d|*d< t,|da dƒ|*d< d|*d< d|*d< t-|d ƒ|*d< d|*d < |	=rX|	j.=rX|	j.n*|	=r€|	j/=r€|	j0=r€|	j/› d!|	j0› nd |*d"< |db |*d&< |dc |*d$< t,|dn dƒ|*d(< |
|*d)< |j1|*ƒ Uq°|dW dxkUr°|d |d4 @ Crf|dY dk@r¦i }+|dd |+d< ||+d< |d` |+d< t*|jj+dƒƒ|+d< d|+d< d|+d< d|+d< t-|d ƒ|+d< d|+d < |	>rr|	j.>rr|	j.n*|	>rš|	j/>rš|	j0>rš|	j/› d!|	j0› nd |+d"< |db |+d&< |dc |+d$< t,|dy dƒ|+d(< |
|+d)< |j1|+ƒ i },d*|,d< ||,d< |d` |,d< t*|jj+dƒƒ|,d< d|,d< d|,d< d|,d< t-|d ƒ|,d< d|,d < |	?rV|	j.?rV|	j.n*|	?r~|	j/?r~|	j0?r~|	j/› d!|	j0› nd |,d"< |db |,d&< |dc |,d$< t,|d< dƒ|,d(< |
|,d)< |j1|,ƒ i }-d=|-d< ||-d< |d` |-d< t*|jj+dƒƒ|-d< d|-d< d|-d< d|-d< t-|d ƒ|-d< d|-d < |	@r:|	j.@r:|	j.n*|	@rb|	j/@rb|	j0@rb|	j/› d!|	j0› nd |-d"< |db |-d&< |dc |-d$< t,|d? dƒ|-d(< |
|-d)< |j1|-ƒ |dZ dkCr|i }.|dd |.d< ||.d< |d` |.d< t*|jj+dƒƒ|.d< d|.d< d|.d< d|.d< t-|d ƒ|.d< d|.d < |	Ar0|	j.Ar0|	j.n*|	ArX|	j/ArX|	j0ArX|	j/› d!|	j0› nd |.d"< |db |.d&< |dc |.d$< t,|dz dƒ|.d(< |
|.d)< |j1|.ƒ i }/d*|/d< ||/d< |d` |/d< t*|jj+dƒƒ|/d< d|/d< d|/d< d|/d< t-|d ƒ|/d< d|/d < |	Br|	j.Br|	j.n*|	Br<|	j/Br<|	j0Br<|	j/› d!|	j0› nd |/d"< |db |/d&< |dc |/d$< t,|dK dƒ|/d(< |
|/d)< |j1|/ƒ i }0d=|0d< ||0d< |d` |0d< t*|jj+dƒƒ|0d< d|0d< d|0d< d|0d< t-|d ƒ|0d< d|0d < |	Brø|	j.Brø|	j.n*|	Cr |	j/Cr |	j0Cr |	j/› d!|	j0› nd |0d"< |db |0d&< |dc |0d$< t,|dM dƒ|0d(< |
|0d)< |j1|0ƒ n|d Crrn |d4 Ur°qT|dU d{krT|d |d4 @ Lr‚i }1|dd |1d< ||1d< |d` |1d< t*|jj+dƒƒ|1d< d|1d< t,|d| dƒ|1d< d|1d< d|1d< t-|d ƒ|1d< d|1d < |	Dr.|	j.Dr.|	j.n*|	DrV|	j/DrV|	j0DrV|	j/› d!|	j0› nd |1d"< |db |1d&< |dc |1d$< t,|d} dƒ|1d(< |
|1d)< |j1|1ƒ i }2d*|2d< ||2d< |d` |2d< t*|jj+dƒƒ|2d< d|2d< t,|d| dƒ|2d< d|2d< d|2d< t-|d ƒ|2d< d|2d < |	Er$|	j.Er$|	j.n*|	ErL|	j/ErL|	j0ErL|	j/› d!|	j0› nd |2d"< |db |2d&< |dc |2d$< t,|d~ dƒ|2d(< |
|2d)< |j1|2ƒ i }3d=|3d< ||3d< |d` |3d< t*|jj+dƒƒ|3d< d|3d< t,|d| dƒ|3d< d|3d< d|3d< t-|d ƒ|3d< d|3d < |	Fr|	j.Fr|	j.n*|	FrB|	j/FrB|	j0FrB|	j/› d!|	j0› nd |3d"< |db |3d&< |dc |3d$< t,|d dƒ|3d(< |
|3d)< |j1|3ƒ |dY |dg  dkIr‚i }4|dd |4d< ||4d< |d` |4d< t*|jj+dƒƒ|4d< d|4d< t,|d€ dƒ|4d< d|4d< d|4d< t-|d ƒ|4d< d|4d < |	Gr*|	j.Gr*|	j.n*|	GrR|	j/GrR|	j0GrR|	j/› d!|	j0› nd |4d"< |db |4d&< |dc |4d$< t,|d dƒ|4d(< |
|4d)< |j1|4ƒ i }5d*|5d< ||5d< |d` |5d< t*|jj+dƒƒ|5d< d|5d< t,|d€ dƒ|5d< d|5d< d|5d< t-|d ƒ|5d< d|5d < |	Hr |	j.Hr |	j.n*|	HrH|	j/HrH|	j0HrH|	j/› d!|	j0› nd |5d"< |db |5d&< |dc |5d$< t,|d‚ dƒ|5d(< |
|5d)< |j1|5ƒ i }6d=|6d< ||6d< |d` |6d< t*|jj+dƒƒ|6d< d|6d< t,|d€ dƒ|6d< d|6d< d|6d< t-|d ƒ|6d< d|6d < |	Ir|	j.Ir|	j.n*|	Ir>|	j/Ir>|	j0Ir>|	j/› d!|	j0› nd |6d"< |db |6d&< |dc |6d$< t,|dƒ dƒ|6d(< |
|6d)< |j1|6ƒ |dZ |dk  dkUr°i }7|dd |7d< ||7d< |d` |7d< t*|jj+dƒƒ|7d< d|7d< t,|d„ dƒ|7d< d|7d< d|7d< t-|d ƒ|7d< d|7d < |	Jr&|	j.Jr&|	j.n*|	JrN|	j/JrN|	j0JrN|	j/› d!|	j0› nd |7d"< |db |7d&< |dc |7d$< t,|d… dƒ|7d(< |
|7d)< |j1|7ƒ i }8d*|8d< ||8d< |d` |8d< t*|jj+dƒƒ|8d< d|8d< t,|d„ dƒ|8d< d|8d< d|8d< t-|d ƒ|8d< d|8d < |	Kr|	j.Kr|	j.n*|	KrD|	j/KrD|	j0KrD|	j/› d!|	j0› nd |8d"< |db |8d&< |dc |8d$< t,|d† dƒ|8d(< |
|8d)< |j1|8ƒ i }9d=|9d< ||9d< |d` |9d< t*|jj+dƒƒ|9d< d|9d< t,|d„ dƒ|9d< d|9d< d|9d< t-|d ƒ|9d< d|9d < |	Lr|	j.Lr|	j.n*|	Lr:|	j/Lr:|	j0Lr:|	j/› d!|	j0› nd |9d"< |db |9d&< |dc |9d$< t,|d‡ dƒ|9d(< |
|9d)< |j1|9ƒ qT|d RrŒi }1|dd |1d< ||1d< |d` |1d< t*|jj+dƒƒ|1d< d|1d< t,|d| dƒ|1d< d|1d< d|1d< t-|d ƒ|1d< d|1d < |	Mr|	j.Mr|	j.n*|	MrB|	j/MrB|	j0MrB|	j/› d!|	j0› nd |1d"< |db |1d&< |dc |1d$< t,|dˆ dƒ|1d(< |
|1d)< |j1|1ƒ i }2d*|2d< ||2d< |d` |2d< t*|jj+dƒƒ|2d< d|2d< t,|d| dƒ|2d< d|2d< d|2d< t-|d ƒ|2d< d|2d < |	Nr|	j.Nr|	j.n*|	Nr8|	j/Nr8|	j0Nr8|	j/› d!|	j0› nd |2d"< |db |2d&< |dc |2d$< t,|d~ dƒ|2d(< |
|2d)< |j1|2ƒ |dY |dg  dkPr‚i }4|dd |4d< ||4d< |d` |4d< t*|jj+dƒƒ|4d< d|4d< t,|d€ dƒ|4d< d|4d< d|4d< t-|d ƒ|4d< d|4d < |	Or |	j.Or |	j.n*|	OrH|	j/OrH|	j0OrH|	j/› d!|	j0› nd |4d"< |db |4d&< |dc |4d$< t,|d‰ dƒ|4d(< |
|4d)< |j1|4ƒ i }5d*|5d< ||5d< |d` |5d< t*|jj+dƒƒ|5d< d|5d< t,|d€ dƒ|5d< d|5d< d|5d< t-|d ƒ|5d< d|5d < |	Pr|	j.Pr|	j.n*|	Pr>|	j/Pr>|	j0Pr>|	j/› d!|	j0› nd |5d"< |db |5d&< |dc |5d$< t,|d‚ dƒ|5d(< |
|5d)< |j1|5ƒ |dZ |dk  dkUr¦i }7|dd |7d< ||7d< |d` |7d< t*|jj+dƒƒ|7d< d|7d< t,|d„ dƒ|7d< d|7d< d|7d< t-|d ƒ|7d< d|7d < |	Qr&|	j.Qr&|	j.n*|	QrN|	j/QrN|	j0QrN|	j/› d!|	j0› nd |7d"< |db |7d&< |dc |7d$< t,|dŠ dƒ|7d(< |
|7d)< |j1|7ƒ i }8d*|8d< ||8d< |d` |8d< t*|jj+dƒƒ|8d< d|8d< t,|d„ dƒ|8d< d|8d< d|8d< t-|d ƒ|8d< d|8d < |	Rr|	j.Rr|	j.n*|	RrD|	j/RrD|	j0RrD|	j/› d!|	j0› nd |8d"< |db |8d&< |dc |8d$< t,|d† dƒ|8d(< |
|8d)< |j1|8ƒ ni }1|dd |1d< ||1d< |d` |1d< t*|jj+dƒƒ|1d< d|1d< t,|d| dƒ|1d< d|1d< d|1d< t-|d ƒ|1d< d|1d < |	Sr|	j.Sr|	j.n*|	SrB|	j/SrB|	j0SrB|	j/› d!|	j0› nd |1d"< |db |1d&< |dc |1d$< t,|d‹ dƒ|1d(< |
|1d)< |j1|1ƒ |dY |dg  dkTr–i }4|dd |4d< ||4d< |d` |4d< t*|jj+dƒƒ|4d< d|4d< t,|d€ dƒ|4d< d|4d< d|4d< t-|d ƒ|4d< d|4d < |	Tr*|	j.Tr*|	j.n*|	TrR|	j/TrR|	j0TrR|	j/› d!|	j0› nd |4d"< |db |4d&< |dc |4d$< t,|dŒ dƒ|4d(< |
|4d)< |j1|4ƒ |dZ |dk  dkUr¦i }7|dd |7d< ||7d< |d` |7d< t*|jj+dƒƒ|7d< d|7d< t,|d„ dƒ|7d< d|7d< d|7d< t-|d ƒ|7d< d|7d < |	Ur:|	j.Ur:|	j.n*|	Urb|	j/Urb|	j0Urb|	j/› d!|	j0› nd |7d"< |db |7d&< |dc |7d$< t,|d dƒ|7d(< |
|7d)< |j1|7ƒ |d4 rTqTW |dŽ _r¶	xò|dŽ D 	]ä}:|:d |:d4 @ YrÈi };|:dd |;d< ||;d< |:d` |;d< t*|jj+dƒƒ|;d< d|;d< t,|:da dƒ|;d< d|;d< d|;d< t-|d ƒ|;d< d|;d < |	Vrr|	j.Vrr|	j.n*|	Vrš|	j/Vrš|	j0Vrš|	j/› d!|	j0› nd |;d"< |:db |;d&< |:dc |;d$< t,|:d dƒ|;d(< |
|;d)< |j1|;ƒ i }<d*|<d< ||<d< |:d` |<d< t*|jj+dƒƒ|<d< d|<d< t,|:da dƒ|<d< d|<d< d|<d< t-|d ƒ|<d< d|<d < |	Wrh|	j.Wrh|	j.n*|	Wr|	j/Wr|	j0Wr|	j/› d!|	j0› nd |<d"< |:db |<d&< |:dc |<d$< t,|:de dƒ|<d(< |
|<d)< |j1|<ƒ i }=d=|=d< ||=d< |:d` |=d< t*|jj+dƒƒ|=d< d|=d< t,|:da dƒ|=d< d|=d< d|=d< t-|d ƒ|=d< d|=d < |	Xr^|	j.Xr^|	j.n*|	Xr†|	j/Xr†|	j0Xr†|	j/› d!|	j0› nd |=d"< |:db |=d&< |:dc |=d$< t,|:df dƒ|=d(< |
|=d)< |j1|=ƒ i }>|:d |>d< ||>d< |:d` |>d< t*|jj+dƒƒ|>d< d|>d< t,|:da dƒ|>d< d|>d< d|>d< t-|d ƒ|>d< d|>d < |	YrX|	j.YrX|	j.n*|	Yr€|	j/Yr€|	j0Yr€|	j/› d!|	j0› nd |>d"< |:db |>d&< |:dc |>d$< t,|:d‘ dƒ|>d(< |
|>d)< |j1|>ƒ UqÌ|:d \r¼i };|:dd |;d< ||;d< |:d` |;d< t*|jj+dƒƒ|;d< d|;d< t,|:da dƒ|;d< d|;d< d|;d< t-|d ƒ|;d< d|;d < |	Zr`|	j.Zr`|	j.n*|	Zrˆ|	j/Zrˆ|	j0Zrˆ|	j/› d!|	j0› nd |;d"< |:db |;d&< |:dc |;d$< t,|:d’ dƒ|;d(< |
|;d)< |j1|;ƒ i }<d*|<d< ||<d< |:d` |<d< t*|jj+dƒƒ|<d< d|<d< t,|:da dƒ|<d< d|<d< d|<d< t-|d ƒ|<d< d|<d < |	[rV|	j.[rV|	j.n*|	[r~|	j/[r~|	j0[r~|	j/› d!|	j0› nd |<d"< |:db |<d&< |:dc |<d$< t,|:d“ dƒ|<d(< |
|<d)< |j1|<ƒ i }>|:d |>d< ||>d< |:d` |>d< t*|jj+dƒƒ|>d< d|>d< t,|:da dƒ|>d< d|>d< d|>d< t-|d ƒ|>d< d|>d < |	\rP|	j.\rP|	j.n*|	\rx|	j/\rx|	j0\rx|	j/› d!|	j0› nd |>d"< |:db |>d&< |:dc |>d$< t,|:d” dƒ|>d(< |
|>d)< |j1|>ƒ |:d4 UrÌi };|:dd |;d< ||;d< |:d` |;d< t*|jj+dƒƒ|;d< d|;d< t,|:da dƒ|;d< d|;d< d|;d< t-|d ƒ|;d< d|;d < |	]rT|	j.]rT|	j.n*|	]r||	j/]r||	j0]r||	j/› d!|	j0› nd |;d"< |:db |;d&< |:dc |;d$< t,|:d• dƒ|;d(< |
|;d)< |j1|;ƒ i }=d=|=d< ||=d< |:d` |=d< t*|jj+dƒƒ|=d< d|=d< t,|:da dƒ|=d< d|=d< d|=d< t-|d ƒ|=d< d|=d < |	^rJ|	j.^rJ|	j.n*|	^rr|	j/^rr|	j0^rr|	j/› d!|	j0› nd |=d"< |:db |=d&< |:dc |=d$< t,|:df dƒ|=d(< |
|=d)< |j1|=ƒ i }>|:d |>d< ||>d< |:d` |>d< t*|jj+dƒƒ|>d< d|>d< t,|:da dƒ|>d< d|>d< d|>d< t-|d ƒ|>d< d|>d < |	_rD|	j._rD|	j.n*|	_rl|	j/_rl|	j0_rl|	j/› d!|	j0› nd |>d"< |:db |>d&< |:dc |>d$< t,|:d– dƒ|>d(< |
|>d)< |j1|>ƒ UqÌW i }?|d— |?d< ||?d< |jƒ d˜ d d™ |?d< t*|jj+dƒƒ|?d< d|?d< t,|dš dƒ|?d< d›|?d< |dœ |?dœ< |d |?d< |dž |?dž< |dŸ |?dŸ< t-|d ƒ|?d< d|?d < |	`rx|	j.`rx|	j.n*|	`r |	j/`r |	j0`r |	j/› d!|	j0› nd |?d"< d+|?d&< d+|?d$< |dš |?d(< |
|?d)< |j1|?ƒ |j1|jƒ qþW yt jd }@t jd }AW n& tk
ar$   tjƒ }@tjƒ }AY nX tj4|@d ƒ}B|Bt5dd¡ }@|@j+d ƒ}@tj4|Ad ƒ}C|Ct5dd¡ }A|Aj+d ƒ}Atjjt6ƒj	tt6jtjkƒjt6jt6j7t6j8t6j9t6j:t6j;t6j<t6j=t6j>t6j?tjtjtjtjtjtjtjtj@tjAƒjt6jd kƒjtjd kƒjtjtdƒkƒjt6j?|@kƒjt6j?|Ak ƒjƒ }Dg }Eg }Fxl|DD ]b}G|Gj;|EkbrDbq.|Gj:d¢kbrTbq.|Gj:d£kbrdbq.|Gj:d¤kbrtbq.i }Hi }Itjtj |Gjƒƒ}tjtj |Gj9ƒƒ}Jt!|H|Gjdƒ |Gj}
tjjt"ƒj	t#t"j$t#j%kƒjt#j&ƒjt"jd kƒjt"j|Gjkƒj'ƒ }|cr&y
|j&}W n tk
cr"   |Gj}Y nX n|Gj}|Gjd | }t)|ƒdkcrV|d d	… }n|}tjjt(ƒjt(jd kƒjt(jB|Gj;kƒj'ƒ }	|	j/crž|	j/d! |	j0 }Kn|	j.}K|Gj|Id¥< t*|Gj?j+dƒƒ|Id< ||Id< d|Id< |Gj|Id"< |Gj|Id¦< |Jjƒ d˜ d d™ |Id< d|Id< t,t-|Gj7ƒdƒ|Id< d|Id < d+|Id&< d+|Id$< yt-|Gj=ƒ|Id< W n  tk
drd   t|Gjƒ‚Y nX |Hd— |Id< |
|Id)< |Fj1|Iƒ i }Ltjtj |Gj9ƒƒ}Jt!|H|Gjdƒ |Gj|Ld¥< t*|Gj?j+dƒƒ|Ld< ||Ld< d›|Ld< |K|Ld"< |Gj|Ld¦< |Jjƒ d˜ d d™ |Ld< d|Ld< t,t-|Gj7ƒdƒ|Ld< d|Ld < d+|Ld&< d+|Ld$< t-|Gj=ƒ|Ld< |
|Ld)< |Gj:d§kerbd¨|Ld< n|Gj:d©kerzd¨|Ld< n |Gj:dªkerd«|Ld< nê|Gj:d¬kerä|Jjƒ d˜ d d™ d­kerÀd®|Ld< n"|Jjƒ d˜ d d™ d¯kfrzd°|Ld< n–|Gj:d±kerúd¨|Ld< n€|Gj>fr,tjjtCƒjtCjD|Gj>kƒj'ƒ }M|MjE|Ld< nN|Jjƒ d˜ d d™ d­kfrPd²|Ld< n*|Jjƒ d˜ d d™ d¯kfrzd³|Ld< |
|Ld)< |Fj1|Lƒ |Ej1|Gj;ƒ bq.W tF||Fd´œƒdµfS )¶NÚ
start_dateÚend_dater8   r9   r:   Tr=   r>   r?   r@   rA   r   rB   rC   rD   rE   rF   z%d%m%YrG   r;   rH   rI   rJ   rK   rL   rM   rN   rO   rP   rQ   rR   rS   z...rT   rU   rV   rW   rX   rY   rZ   r¼   r[   r\   r]   r^   r_   r`   ra   rb   rc   rd   re   rf   rg   rh   ri   rj   rk   rl   rm   rn   ro   rp   rq   é   rr   rs   rt   ru   rv   rw   rx   ry   rz   r{   r|   r}   r~   r   r€   r   r‚   rƒ   r„   r…   r†   r‡   rˆ   r‰   rŠ   Úhas_revenue_splitÚrevenue_split_percentZincome_account_percentr   éd   rŒ   r   rŽ   r   r‹   r‘   r’   r“   r”   r•   r–   r—   r˜   r™   rš   r›   rœ   r   rž   rŸ   r    r¡   r¢   r£   r¤   r¥   r¦   zCamping Sitesr§   Úbase_fixed_cost_minus_taxesr©   Úbase_fixed_cost_caterrª   Úbase_adult_cost_minus_taxesr¬   Úbase_adult_cost_caterr­   Úbase_child_cost_minus_taxesr¯   Úbase_child_cost_caterr¨   r«   r®   r°   r±   r²   Úexternal_facility_bookingsÚ#external_facility_price_minus_taxesÚcommission_account_codeÚcommission_price_minus_taxesÚ!external_facility_price_minus_vatÚ	fixed_vatÚcommission_price_minus_vatÚ(base_external_facility_price_minus_caterÚ!base_commission_price_minus_caterr³   r´   rµ   Útotal_cost_batchfiler·   r¸   r¹   rº   r»   z%Y-%m-%d)r<   z$746bb582-89ed-4c83-ac3c-f25d9d60b266z$37da2c36-59d2-4bf5-916e-f1c7a1596fc0z$f5ea21e8-c65d-46e9-852d-c9314c9cf59cr½   r¾   z$5550ff2f-bc48-4f0e-8944-d08f7f2b93fdr¿   z$cbff45f3-4f12-41da-8b4a-bf308112f032z$653e10f6-168c-493e-bcbb-0219537c24f6rÀ   z$33ad20be-3a89-4deb-ab71-7510ba51677erÁ   rÂ   rÃ   rÄ   z$1c9d01cc-ef31-4757-a390-10c765fcecabrÅ   rÆ   )r´   rÇ   rÈ   )Gr   r   Ú	Exceptionr	   rØ   r   r3   rÉ   r   rÊ   r$   r½   rË   rÌ   rÍ   rÎ   rF   rÏ   rÐ   r¼   rÑ   rÒ   rÓ   rÔ   rÕ   rÖ   r   Úbetweenr×   rÚ   rÛ   rÜ   rÝ   r.   r,   r+   Ú	school_idÚschool_public_idÚschool_namerß   r   rÞ   rà   rÙ   rá   râ   rã   rä   rå   ræ   ÚintZrountÚstrptimer
   r#   rç   rè   ré   rê   rë   rì   rí   rî   Útransaction_dateÚcurrency_buying_rate_at_timerP   Útransaction_idr)   rï   rð   r   )NZstart_date_requestZend_date_requestrñ   ró   r´   rô   rõ   rö   Úcheck_school_bookingrù   r¼   rÏ   r÷   rD   rø   rú   rû   rü   rý   rþ   rÿ   r   r  r  r  r  r  r  Zpercent_revenueÚpercentrC   Zincome_percentZbase_facility_amountrZ   r  r  r	  r
  r  r  r  r  r  r  r  r  r  r  r  r  r  Úcater_camp_fee_datar  r  Úcater_adult_campsite_datar  r  Úcater_child_campsite_dataÚsingle_external_facilityZ#income_fixed_external_facility_dataZ vat_fixed_external_facility_dataZ"cater_fixed_external_facility_dataZ'commission_fixed_external_facility_datar  r'  r(  Zstart_date_objZend_date_objr  r  r  r   r!  r"  r#  Úbank_referencer$  r%  r6   r6   r7   Úgenerate_full_batchfile_dataý  s   



D



D

D



D




D




D


D



D




D


D







D




D





D




D


D



D




D


D







D




D





D



D





D





D





D



D





D




D





D



D





D




D





D



D



D





D



D



D





D



D



D




D



D




D



D




D



D





D



D


D





D



D



D






D



D



D





D



D




D




D



D




D







D





D




D




D



D



D




D



D



D




D



D





D





D





D





D



D





D






D







D



D



D





D





D





D





D





D





D





D


D





















rN  z/credit-notes/dataÚPOST)Úmethodsc        .      C   sØ8  t jd } t jd }tj| ƒ}tj|ƒ}g }x*||krV|j|jdƒƒ |tdd }q.W tjj	t
ƒjt
jd kƒjƒ }g }8xL|D 8]B}8x:|D 8]0}|jjdƒ|krŽtjj	tƒjtj|jkƒjƒ }	tjj	tƒjtj|jkƒjƒ }
tjj	tƒjttjtjkƒjtjƒjtjd kƒjtj|	jkƒjƒ }i }t|j|j|dd tjj	tƒjtj|jkƒjƒ }|j}|rŽy
|j}W n tk
rŠ   |	j}Y nX n|	j}|	j d | }|j!}t"|ƒd	krÄ|d d
… }n|}t#|j$ƒ}x|d D ]ú}i }|d |d< ||d< ||d< |jƒ d d d |d< t%|jjdƒƒ|d< d|d< |d |d< d|d< d|d< t&|	j'ƒ|d< d|d< |
r~|
j(r~|
j(n*|
r¦|
j)r¦|
j*r¦|
j)› d |
j*› nd |d!< |d" |d#< |d$ |d%< |d |d&< ||d'< |j|ƒ i }d(|d< ||d< ||d< |jƒ d d d |d< t%|jjdƒƒ|d< d|d< |d |d< d|d< d|d< t&|	j'ƒ|d< d|d< |
rz|
j(rz|
j(n*|
r¢|
j)r¢|
j*r¢|
j)› d |
j*› nd |d!< d)|d#< d)|d%< |d |d&< ||d'< |j|ƒ qÞW x|d* D ]ú}i }|d+ |d< ||d< ||d< |jƒ d d d |d< t%|jjdƒƒ|d< d|d< |d |d< d|d< d|d< t&|	j'ƒ|d< d|d< |
rŠ|
j(rŠ|
j(n*|
r²|
j)r²|
j*r²|
j)› d |
j*› nd |d!< |d, |d#< |d- |d%< |d |d&< ||d'< |j|ƒ i }d(|d< ||d< ||d< |jƒ d d d |d< t%|jjdƒƒ|d< d|d< |d |d< d|d< d|d< t&|	j'ƒ|d< d|d< |
r†|
j(r†|
j(n*|
r®|
j)r®|
j*r®|
j)› d |
j*› nd |d!< d)|d#< d)|d%< |d |d&< ||d'< |j|ƒ qêW x4|d. D ]&}|d/ dkr|d |d0 @ 	ri }|d1 |d< ||d< ||d< |jƒ d d d |d< t%|jjdƒƒ|d< d|d< |d2 |d< d|d< d|d< t&|	j'ƒ|d< d|d< |
r¶|
j(r¶|
j(n*|
rÞ|
j)rÞ|
j*rÞ|
j)› d |
j*› nd |d!< |d3 |d#< |d4 |d%< |d2 |d&< ||d'< |j|ƒ i }d(|d< ||d< ||d< |jƒ d d d |d< t%|jjdƒƒ|d< d|d< |d5 |d< d|d< d|d< t&|	j'ƒ|d< d|d< |
r²|
j(r²|
j(n*|
rÚ|
j)rÚ|
j*rÚ|
j)› d |
j*› nd |d!< d)|d#< d)|d%< |d5 |d&< ||d'< |j|ƒ i }d6|d< ||d< ||d< |jƒ d d d |d< t%|jjdƒƒ|d< d|d< |d7 |d< d|d< d|d< t&|	j'ƒ|d< d|d< |
r¦|
j(r¦|
j(n*|
rÎ|
j)rÎ|
j*rÎ|
j)› d |
j*› nd |d!< d)|d#< d)|d%< |d7 |d&< ||d'< |j|ƒ n|d r
i }|d1 |d< ||d< ||d< |jƒ d d d |d< t%|jjdƒƒ|d< d|d< |d8 |d< d|d< d|d< t&|	j'ƒ|d< d|d< |
	r¬|
j(	r¬|
j(n*|
	rÔ|
j)	rÔ|
j*	rÔ|
j)› d |
j*› nd |d!< |d3 |d#< |d4 |d%< |d8 |d&< ||d'< |j|ƒ i }d(|d< ||d< ||d< |jƒ d d d |d< t%|jjdƒƒ|d< d|d< |d5 |d< d|d< d|d< t&|	j'ƒ|d< d|d< |

r¨|
j(
r¨|
j(n*|

rÐ|
j)
rÐ|
j*
rÐ|
j)› d |
j*› nd |d!< d)|d#< d)|d%< |d5 |d&< ||d'< |j|ƒ n|d0 ri }|d1 |d< ||d< ||d< |jƒ d d d |d< t%|jjdƒƒ|d< d|d< |d9 |d< d|d< d|d< t&|	j'ƒ|d< d|d< |
r®|
j(r®|
j(n*|
rÖ|
j)rÖ|
j*rÖ|
j)› d |
j*› nd |d!< |d3 |d#< |d4 |d%< |d9 |d&< ||d'< |j|ƒ i }d6|d< ||d< ||d< |jƒ d d d |d< t%|jjdƒƒ|d< d|d< |d7 |d< d|d< d|d< t&|	j'ƒ|d< d|d< |
rª|
j(rª|
j(n*|
rÒ|
j)rÒ|
j*rÒ|
j)› d |
j*› nd |d!< d)|d#< d)|d%< |d7 |d&< ||d'< |j|ƒ n i }|d1 |d< ||d< ||d< |jƒ d d d |d< t%|jjdƒƒ|d< d|d< |d: |d< d|d< d|d< t&|	j'ƒ|d< d|d< |
r¦|
j(r¦|
j(n*|
rÎ|
j)rÎ|
j*rÎ|
j)› d |
j*› nd |d!< |d3 |d#< |d4 |d%< |d: |d&< ||d'< |j|ƒ |d; dkrö|d |d0 @ ri }|d1 |d< ||d< ||d< |jƒ d d d |d< t%|jjdƒƒ|d< d|d< |d< |d< d|d< d|d< t&|	j'ƒ|d< d|d< |
rÆ|
j(rÆ|
j(n*|
rî|
j)rî|
j*rî|
j)› d |
j*› nd |d!< |d3 |d#< |d4 |d%< |d< |d&< ||d'< |j|ƒ i }d(|d< ||d< ||d< |jƒ d d d |d< t%|jjdƒƒ|d< d|d< |d= |d< d|d< d|d< t&|	j'ƒ|d< d|d< |
rÂ|
j(rÂ|
j(n*|
rê|
j)rê|
j*rê|
j)› d |
j*› nd |d!< d)|d#< d)|d%< |d= |d&< ||d'< |j|ƒ i } d6| d< || d< || d< |jƒ d d d | d< t%|jjdƒƒ| d< d| d< |d> | d< d| d< d| d< t&|	j'ƒ| d< d| d< |
r¶|
j(r¶|
j(n*|
rÞ|
j)rÞ|
j*rÞ|
j)› d |
j*› nd | d!< d)| d#< d)| d%< |d> | d&< || d'< |j| ƒ qö|d ri }|d1 |d< ||d< ||d< |jƒ d d d |d< t%|jjdƒƒ|d< d|d< |d? |d< d|d< d|d< t&|	j'ƒ|d< d|d< |
r¼|
j(r¼|
j(n*|
rä|
j)rä|
j*rä|
j)› d |
j*› nd |d!< |d3 |d#< |d4 |d%< |d? |d&< ||d'< |j|ƒ i }d(|d< ||d< ||d< |jƒ d d d |d< t%|jjdƒƒ|d< d|d< |d= |d< d|d< d|d< t&|	j'ƒ|d< d|d< |
r¸|
j(r¸|
j(n*|
rà|
j)rà|
j*rà|
j)› d |
j*› nd |d!< d)|d#< d)|d%< |d= |d&< ||d'< |j|ƒ qö|d0 ri }|d1 |d< ||d< ||d< |jƒ d d d |d< t%|jjdƒƒ|d< d|d< |d@ |d< d|d< d|d< t&|	j'ƒ|d< d|d< |
r¾|
j(r¾|
j(n*|
ræ|
j)ræ|
j*ræ|
j)› d |
j*› nd |d!< |d3 |d#< |d4 |d%< |d@ |d&< ||d'< |j|ƒ i } d6| d< || d< || d< |jƒ d d d | d< t%|jjdƒƒ| d< d| d< |d> | d< d| d< d| d< t&|	j'ƒ| d< d| d< |
rº|
j(rº|
j(n*|
râ|
j)râ|
j*râ|
j)› d |
j*› nd | d!< d)| d#< d)| d%< |d> | d&< || d'< |j| ƒ qöi }|d1 |d< ||d< ||d< |jƒ d d d |d< t%|jjdƒƒ|d< d|d< |dA |d< d|d< d|d< t&|	j'ƒ|d< d|d< |
r¶|
j(r¶|
j(n*|
rÞ|
j)rÞ|
j*rÞ|
j)› d |
j*› nd |d!< |d3 |d#< |d4 |d%< |dA |d&< ||d'< |j|ƒ qöW x^|dB D ]P}!|!d/ dkrD|!d |!d0 @ r@i }"|!dC |"d< ||"d< ||"d< |jƒ d d d |"d< t%|jjdƒƒ|"d< d|"d< |!d2 |"d< d|"d< d|"d< t&|	j'ƒ|"d< d|"d< |
rî|
j(rî|
j(n*|
r|
j)r|
j*r|
j)› d |
j*› nd |"d!< |!dD |"d#< |!dE |"d%< |!d2 |"d&< ||"d'< |j|"ƒ i }#d(|#d< ||#d< ||#d< |jƒ d d d |#d< t%|jjdƒƒ|#d< d|#d< |!d5 |#d< d|#d< d|#d< t&|	j'ƒ|#d< d|#d< |
rê|
j(rê|
j(n*|
r|
j)r|
j*r|
j)› d |
j*› nd |#d!< d)|#d#< d)|#d%< |!d5 |#d&< ||#d'< |j|#ƒ i }$d6|$d< ||$d< ||$d< |jƒ d d d |$d< t%|jjdƒƒ|$d< d|$d< |!d7 |$d< d|$d< d|$d< t&|	j'ƒ|$d< d|$d< |
rÞ|
j(rÞ|
j(n*|
r|
j)r|
j*r|
j)› d |
j*› nd |$d!< d)|$d#< d)|$d%< |!d7 |$d&< ||$d'< |j|$ƒ n|!d rBi }"|!dC |"d< ||"d< ||"d< |jƒ d d d |"d< t%|jjdƒƒ|"d< d|"d< |!dF |"d< d|"d< d|"d< t&|	j'ƒ|"d< d|"d< |
rä|
j(rä|
j(n*|
r|
j)r|
j*r|
j)› d |
j*› nd |"d!< |!dD |"d#< |!dE |"d%< |!dF |"d&< ||"d'< |j|"ƒ i }#d(|#d< ||#d< ||#d< |jƒ d d d |#d< t%|jjdƒƒ|#d< d|#d< |!d5 |#d< d|#d< d|#d< t&|	j'ƒ|#d< d|#d< |
rà|
j(rà|
j(n*|
r|
j)r|
j*r|
j)› d |
j*› nd |#d!< d)|#d#< d)|#d%< |!d5 |#d&< ||#d'< |j|#ƒ n|!d0 rDi }"|!dC |"d< ||"d< ||"d< |jƒ d d d |"d< t%|jjdƒƒ|"d< d|"d< |!dG |"d< d|"d< d|"d< t&|	j'ƒ|"d< d|"d< |
ræ|
j(ræ|
j(n*|
r|
j)r|
j*r|
j)› d |
j*› nd |"d!< |!dD |"d#< |!dE |"d%< |!dG |"d&< ||"d'< |j|"ƒ i }$d6|$d< ||$d< ||$d< |jƒ d d d |$d< t%|jjdƒƒ|$d< d|$d< |!d7 |$d< d|$d< d|$d< t&|	j'ƒ|$d< d|$d< |
râ|
j(râ|
j(n*|
r
|
j)r
|
j*r
|
j)› d |
j*› nd |$d!< d)|$d#< d)|$d%< |!d7 |$d&< ||$d'< |j|$ƒ n i }"|!dC |"d< ||"d< ||"d< |jƒ d d d |"d< t%|jjdƒƒ|"d< d|"d< |!d: |"d< d|"d< d|"d< t&|	j'ƒ|"d< d|"d< |
rÞ|
j(rÞ|
j(n*|
r|
j)r|
j*r|
j)› d |
j*› nd |"d!< |!dD |"d#< |!dE |"d%< |!d: |"d&< ||"d'< |j|"ƒ |!d; dk&rT|!d |!d0 @ !rPi }%|!dC |%d< ||%d< ||%d< |jƒ d d d |%d< t%|jjdƒƒ|%d< d|%d< |!d< |%d< d|%d< d|%d< t&|	j'ƒ|%d< d|%d< |
rþ|
j(rþ|
j(n*|
r&|
j)r&|
j*r&|
j)› d |
j*› nd |%d!< |!dD |%d#< |!dE |%d%< |!d< |%d&< ||%d'< |j|%ƒ i }&d(|&d< ||&d< ||&d< |jƒ d d d |&d< t%|jjdƒƒ|&d< d|&d< |!d= |&d< d|&d< d|&d< t&|	j'ƒ|&d< d|&d< |
rú|
j(rú|
j(n*|
 r"|
j) r"|
j* r"|
j)› d |
j*› nd |&d!< d)|&d#< d)|&d%< |!d= |&d&< ||&d'< |j|&ƒ i }'d6|'d< ||'d< ||'d< |jƒ d d d |'d< t%|jjdƒƒ|'d< d|'d< |!d> |'d< d|'d< d|'d< t&|	j'ƒ|'d< d|'d< |
 rî|
j( rî|
j(n*|
!r|
j)!r|
j*!r|
j)› d |
j*› nd |'d!< d)|'d#< d)|'d%< |!d> |'d&< ||'d'< |j|'ƒ n|!d #rRi }%|!dC |%d< ||%d< ||%d< |jƒ d d d |%d< t%|jjdƒƒ|%d< d|%d< |!dH |%d< d|%d< d|%d< t&|	j'ƒ|%d< d|%d< |
!rô|
j(!rô|
j(n*|
"r|
j)"r|
j*"r|
j)› d |
j*› nd |%d!< |!dD |%d#< |!dE |%d%< |!dH |%d&< ||%d'< |j|%ƒ i }&d(|&d< ||&d< ||&d< |jƒ d d d |&d< t%|jjdƒƒ|&d< d|&d< |!d= |&d< d|&d< d|&d< t&|	j'ƒ|&d< d|&d< |
"rð|
j("rð|
j(n*|
#r|
j)#r|
j*#r|
j)› d |
j*› nd |&d!< d)|&d#< d)|&d%< |!d= |&d&< ||&d'< |j|&ƒ n|!d0 %rTi }%|!dC |%d< ||%d< ||%d< |jƒ d d d |%d< t%|jjdƒƒ|%d< d|%d< |!dI |%d< d|%d< d|%d< t&|	j'ƒ|%d< d|%d< |
#rö|
j(#rö|
j(n*|
$r|
j)$r|
j*$r|
j)› d |
j*› nd |%d!< |!dD |%d#< |!dE |%d%< |!dI |%d&< ||%d'< |j|%ƒ i }'d6|'d< ||'d< ||'d< |jƒ d d d |'d< t%|jjdƒƒ|'d< d|'d< |!d> |'d< d|'d< d|'d< t&|	j'ƒ|'d< d|'d< |
$rò|
j($rò|
j(n*|
%r|
j)%r|
j*%r|
j)› d |
j*› nd |'d!< d)|'d#< d)|'d%< |!d> |'d&< ||'d'< |j|'ƒ n i }%|!dC |%d< ||%d< ||%d< |jƒ d d d |%d< t%|jjdƒƒ|%d< d|%d< |!dA |%d< d|%d< d|%d< t&|	j'ƒ|%d< d|%d< |
%rî|
j(%rî|
j(n*|
&r|
j)&r|
j*&r|
j)› d |
j*› nd |%d!< |!dD |%d#< |!dE |%d%< |!dA |%d&< ||%d'< |j|%ƒ |!d |!d0 @ )r\|!dJ .r~i }(|!dC |(d< ||(d< ||(d< |jƒ d d d |(d< t%|jjdƒƒ|(d< d|(d< |!dJ |(d< d|(d< d|(d< t&|	j'ƒ|(d< d|(d< |
'r
|
j('r
|
j(n*|
'r2|
j)'r2|
j*'r2|
j)› d |
j*› nd |(d!< |!dD |(d#< |!dE |(d%< |!dJ |(d&< ||(d'< |j|(ƒ i })d(|)d< ||)d< ||)d< |jƒ d d d |)d< t%|jjdƒƒ|)d< d|)d< |!dK |)d< d|)d< d|)d< t&|	j'ƒ|)d< d|)d< |
(r|
j((r|
j(n*|
(r.|
j)(r.|
j*(r.|
j)› d |
j*› nd |)d!< d)|)d#< d)|)d%< |!dK |)d&< ||)d'< |j|)ƒ i }*d6|*d< ||*d< ||*d< |jƒ d d d |*d< t%|jjdƒƒ|*d< d|*d< |!dL |*d< d|*d< d|*d< t&|	j'ƒ|*d< d|*d< |
(rú|
j((rú|
j(n*|
)r"|
j))r"|
j*)r"|
j)› d |
j*› nd |*d!< d)|*d#< d)|*d%< |!dL |*d&< ||*d'< |j|*ƒ q.|!d +rh|!dM .r~i }(|!dC |(d< ||(d< ||(d< |jƒ d d d |(d< t%|jjdƒƒ|(d< d|(d< |!dM |(d< d|(d< d|(d< t&|	j'ƒ|(d< d|(d< |
*r
|
j(*r
|
j(n*|
*r2|
j)*r2|
j**r2|
j)› d |
j*› nd |(d!< |!dD |(d#< |!dE |(d%< |!dM |(d&< ||(d'< |j|(ƒ i })d(|)d< ||)d< ||)d< |jƒ d d d |)d< t%|jjdƒƒ|)d< d|)d< |!dK |)d< d|)d< d|)d< t&|	j'ƒ|)d< d|)d< |
+r|
j(+r|
j(n*|
+r.|
j)+r.|
j*+r.|
j)› d |
j*› nd |)d!< d)|)d#< d)|)d%< |!dK |)d&< ||)d'< |j|)ƒ q.|!d0 -rt|!dN .r~i }(|!dC |(d< ||(d< ||(d< |jƒ d d d |(d< t%|jjdƒƒ|(d< d|(d< |!dN |(d< d|(d< d|(d< t&|	j'ƒ|(d< d|(d< |
,r|
j(,r|
j(n*|
,r>|
j),r>|
j*,r>|
j)› d |
j*› nd |(d!< |!dD |(d#< |!dE |(d%< |!dN |(d&< ||(d'< |j|(ƒ i }*d6|*d< ||*d< ||*d< |jƒ d d d |*d< t%|jjdƒƒ|*d< d|*d< |!dL |*d< d|*d< d|*d< t&|	j'ƒ|*d< d|*d< |
-r|
j(-r|
j(n*|
-r:|
j)-r:|
j*-r:|
j)› d |
j*› nd |*d!< d)|*d#< d)|*d%< |!dL |*d&< ||*d'< |j|*ƒ q.|!dO r.i }(|!dC |(d< ||(d< ||(d< |jƒ d d d |(d< t%|jjdƒƒ|(d< d|(d< |!dO |(d< d|(d< d|(d< t&|	j'ƒ|(d< d|(d< |
.r|
j(.r|
j(n*|
.r@|
j).r@|
j*.r@|
j)› d |
j*› nd |(d!< |!dD |(d#< |!dE |(d%< |!dO |(d&< ||(d'< |j|(ƒ q.W 	x>|dP D 	]0}+|+d |+d0 @ 1rž|+dJ 7rÀi }(|+dC |(d< ||(d< ||(d< |jƒ d d d |(d< t%|jjdƒƒ|(d< d|(d< |+dJ |(d< d|(d< d|(d< t&|	j'ƒ|(d< d|(d< |
/rL|
j(/rL|
j(n*|
/rt|
j)/rt|
j*/rt|
j)› d |
j*› nd |(d!< |+dD |(d#< |+dE |(d%< |+dJ |(d&< ||(d'< |j|(ƒ i })d(|)d< ||)d< ||)d< |jƒ d d d |)d< t%|jjdƒƒ|)d< d|)d< |+dK |)d< d|)d< d|)d< t&|	j'ƒ|)d< d|)d< |
0rH|
j(0rH|
j(n*|
0rp|
j)0rp|
j*0rp|
j)› d |
j*› nd |)d!< d)|)d#< d)|)d%< |+dK |)d&< ||)d'< |j|)ƒ i }*d6|*d< ||*d< ||*d< |jƒ d d d |*d< t%|jjdƒƒ|*d< d|*d< |+dL |*d< d|*d< d|*d< t&|	j'ƒ|*d< d|*d< |
1r<|
j(1r<|
j(n*|
1rd|
j)1rd|
j*1rd|
j)› d |
j*› nd |*d!< d)|*d#< d)|*d%< |+dL |*d&< ||*d'< |j|*ƒ .q|+d 4rª|+dM 7rÀi }(|+dC |(d< ||(d< ||(d< |jƒ d d d |(d< t%|jjdƒƒ|(d< d|(d< |+dQ |(d< d|(d< d|(d< t&|	j'ƒ|(d< d|(d< |
2rL|
j(2rL|
j(n*|
2rt|
j)2rt|
j*2rt|
j)› d |
j*› nd |(d!< |+dD |(d#< |+dE |(d%< |+dM |(d&< ||(d'< |j|(ƒ i },|+dR |,d< ||,d< ||,d< |jƒ d d d |,d< t%|jjdƒƒ|,d< d|,d< |+dQ |,d< d|,d< d|,d< t&|	j'ƒ|,d< d|,d< |
3rL|
j(3rL|
j(n*|
3rt|
j)3rt|
j*3rt|
j)› d |
j*› nd |,d!< |+dD |,d#< |+dE |,d%< |+dS |,d&< ||,d'< |j|,ƒ i })d(|)d< ||)d< ||)d< |jƒ d d d |)d< t%|jjdƒƒ|)d< d|)d< |+dK |)d< d|)d< d|)d< t&|	j'ƒ|)d< d|)d< |
4rH|
j(4rH|
j(n*|
4rp|
j)4rp|
j*4rp|
j)› d |
j*› nd |)d!< d)|)d#< d)|)d%< |+dK |)d&< ||)d'< |j|)ƒ .q|+d0 6r¶|+dN 7rÀi }(|+dC |(d< ||(d< ||(d< |jƒ d d d |(d< t%|jjdƒƒ|(d< d|(d< |+dN |(d< d|(d< d|(d< t&|	j'ƒ|(d< d|(d< |
5rX|
j(5rX|
j(n*|
5r€|
j)5r€|
j*5r€|
j)› d |
j*› nd |(d!< |+dD |(d#< |+dE |(d%< |+dN |(d&< ||(d'< |j|(ƒ i }*d6|*d< ||*d< ||*d< |jƒ d d d |*d< t%|jjdƒƒ|*d< d|*d< |+dL |*d< d|*d< d|*d< t&|	j'ƒ|*d< d|*d< |
6rT|
j(6rT|
j(n*|
6r||
j)6r||
j*6r||
j)› d |
j*› nd |*d!< d)|*d#< d)|*d%< |+dL |*d&< ||*d'< |j|*ƒ .q|+dO .ri }(|+dC |(d< ||(d< ||(d< |jƒ d d d |(d< t%|jjdƒƒ|(d< d|(d< |+dO |(d< d|(d< d|(d< t&|	j'ƒ|(d< d|(d< |
7rZ|
j(7rZ|
j(n*|
7r‚|
j)7r‚|
j*7r‚|
j)› d |
j*› nd |(d!< |+dD |(d#< |+dE |(d%< |+dO |(d&< ||(d'< |j|(ƒ .qW i }-|dT |-d< ||-d< ||-d< |jƒ d d d |-d< t%|jjdƒƒ|-d< d|-d< |dU |-d< d|-d< dV|-d< t&|	j'ƒ|-d< d|-d< |
8r`|
j(8r`|
j(n*|
8rˆ|
j)8rˆ|
j*8rˆ|
j)› d |
j*› nd |-d!< d)|-d#< d)|-d%< |dU |-d&< |j|-d'< |j|-ƒ qŽW q€W t+d|iƒdWfS )XNr'  r(  z%Y-%m-%dr;   )r<   T)Ú	batchfiler=   r>   r?   r@   rB   rC   rD   Úcredit_note_refr´   r   rµ   rF   z%d%m%YrG   rH   Útotal_minus_vatrK   rL   rM   r·   rO   rQ   rR   rS   z...rT   rU   rV   rW   rX   rZ   r¼   r[   r\   r^   r_   rb   ra   Ú	inventoryÚcredit_no_of_adultsre   rf   rh   rj   ri   rl   rn   ro   Úadult_total_minus_vatÚadult_total_minus_caterÚadult_totalÚcredit_no_of_childrenrx   rz   r|   Úchild_total_minus_vatÚchild_total_minus_caterÚchild_totalÚ
facilitiesr‹   Úfacility_analysis_coderŽ   Úadult_minus_vatÚadult_minus_caterÚchild_minus_vatÚchild_minus_caterÚfixed_minus_taxesr8  Úfixed_caterÚfixed_minus_vatÚfixed_minus_caterÚfixed_totalÚexternal_facilitiesr   r5  Úfixed_commission_minus_vatr³   ÚtotalrN   rÈ   ),r   r   r1   ÚgenerateDateræ   rÙ   r
   r   r3   rÉ   r   rÔ   rÕ   r×   rÐ   r   r½   rË   rß   r   r,   rÊ   r+   r?  r@  rÌ   rA  r/   Úcredit_note_public_idr¼   r=  rÏ   rÍ   rR  rÞ   r0   Úcredit_note_currencyrà   râ   rP   rã   rä   rå   r   ).r'  r(  ÚstartÚendÚ
date_arrayZget_credit_note_infor´   Úsingle_credit_noteÚsingle_dateÚget_bookingrù   rG  Úcredit_note_detailsZget_cuinvoicenumberr¼   rÏ   r÷   rR  rD   rm  Úsingle_guestZincome_guest_dataZvat_guest_dataÚsingle_vehicleZincome_vehicle_dataZvat_vehicle_dataÚsingle_activityZincome_inventory_adult_dataZvat_inventory_adult_dataZcater_inventory_adult_dataZincome_inventory_child_dataZvat_inventory_child_dataZcater_inventory_child_datar  Zincome_facility_adult_dataZvat_facility_adult_dataZcater_facility_adult_dataZincome_facility_child_dataZvat_facility_child_dataZcater_facility_child_dataZincome_facility_fixed_dataZvat_facility_fixed_dataZcater_facility_fixed_datarL  Zcommission_facility_datar  r6   r6   r7   Úcredit_note_functionX  s6   








D



D

D



D


D



D
D


D




D



D




D


D






D



D
D


D




D



D




D


D





D



D
D


D




D



D




D


D






D



D
D


D




D



D




D


D







D



D
D



D




D




D




D



D





D




D


D




D





D




D




D




D



D



D
rx  z/credit/batchfilec        5      C   sÀ?  ddddddddd	d
dg} t jjtƒjttjtjkƒjtjtj	tj
tjtjtjtjtjtjtjƒ
jtjd kƒjtjd kƒjtj	j| ƒƒjtjtdƒkƒjtjtdƒkƒjtjtdƒkƒjtjd kƒjƒ }tjƒ tdd jdƒ}g }g }>xÄ|D >]º}|j|krqði }y$tjtj|jƒƒ}t ||jdƒ W n t!k
rD   P Y nX t jjt"ƒjt"j|jkƒj#ƒ }t jjt$ƒjt%t$j&t%j'kƒjt%j(ƒjt$jd kƒjt$j|jkƒj#ƒ }	|j}
|	rÜy
|	j(}W n t!k
rØ   |j}Y nX n|j}|j	d | }t)|ƒdkr|d d… }n|}x|d D ]}|d dkr|j	dkr´i }|d |d< ||d< |d |d< t*|jjdƒƒ|d < d!|d"< t+|d# d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |d. |d/< |d0 |d1< t+|d# d!ƒ|d2< |
|d3< |j.|ƒ i }d4|d< ||d< |d |d< t*|jjdƒƒ|d < d!|d"< t+|d& d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< d5|d1< d5|d/< t+|d& d!ƒ|d2< |
|d3< |j.|ƒ qi }|d |d< ||d< |d |d< t*|jjdƒƒ|d < d|d"< t+|d# d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |d. |d/< |d0 |d1< t+|d6 d!ƒ|d2< |
|d3< |j.|ƒ i }d4|d< ||d< |d |d< t*|jjdƒƒ|d < d|d"< t+|d& d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< d5|d1< d5|d/< t+|d7 d!ƒ|d2< |
|d3< |j.|ƒ qW x–|d8 D ]ˆ}|d8 dkr:i }|d9 |d< ||d< |d: |d< t*|jjdƒƒ|d < d|d"< t+|d# d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |d; |d1< |d< |d/< t+|d6 d!ƒ|d2< |
|d3< |j.|ƒ i }d4|d< ||d< |d: |d< t*|jjdƒƒ|d < d|d"< t+|d& d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< d5|d1< d5|d/< t+|d7 d!ƒ|d2< |
|d3< |j.|ƒ q:W |d= r2x\|d= D ]N}|d> dkr|d& |d? @ 	r<i }|d@ |d< ||d< |dA |d< t*|jjdƒƒ|d < |d> |d"< t+|dB d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dC |d1< |dD |d/< t+|dE d!ƒ|d2< |
|d3< |j.|ƒ i }d4|d< ||d< |dA |d< t*|jjdƒƒ|d < |d> |d"< t+|dF d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< d5|d1< d5|d/< t+|dG d!ƒ|d2< |
|d3< |j.|ƒ i }dH|d< ||d< |dA |d< t*|jjdƒƒ|d < |d> |d"< t+|dI d!ƒ|d$< d |d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< d5|d1< d5|d/< t+|dJ d!ƒ|d2< |
|d3< |j.|ƒ nÆ|d& r¸|j	dKkr:i }|d@ |d< ||d< |dA |d< t*|jjdƒƒ|d < |d> |d"< t+|dL d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dC |d1< |dD |d/< t+|dM d!ƒ|d2< |
|d3< |j.|ƒ i }d4|d< ||d< |dA |d< t*|jjdƒƒ|d < |d> |d"< t+|dF d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< d5|d1< d5|d/< t+|dG d!ƒ|d2< |
|d3< |j.|ƒ i }dN|d< ||d< |dA |d< t*|jjdƒƒ|d < |d> |d"< t+|dL d!ƒ|d$< d%|d&< dO|d(< dP|d*< d+|d,< |j-|d-< |dC |d1< |dD |d/< t+|dM d!ƒ|d2< |
|d3< |j.|ƒ i }d4|d< ||d< |dA |d< t*|jjdƒƒ|d < |d> |d"< t+|dF d!ƒ|d$< d%|d&< dO|d(< dP|d*< d+|d,< |j-|d-< d5|d1< d5|d/< t+|dG d!ƒ|d2< |
|d3< |j.|ƒ q|i }|d@ |d< ||d< |dA |d< t*|jjdƒƒ|d < |d> |d"< t+|dL d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dC |d1< |dD |d/< t+|dM d!ƒ|d2< |
|d3< |j.|ƒ i }d4|d< ||d< |dA |d< t*|jjdƒƒ|d < |d> |d"< t+|dF d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< d5|d1< d5|d/< t+|dG d!ƒ|d2< |
|d3< |j.|ƒ nÄi }|d@ |d< ||d< |dA |d< t*|jjdƒƒ|d < |d> |d"< t+|dQ d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dC |d1< |dD |d/< t+|dR d!ƒ|d2< |
|d3< |j.|ƒ |d? ri }|d@ |d< ||d< |dA |d< t*|jjdƒƒ|d < |d> |d"< t+|dS d!ƒ|d$< d |d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dC |d1< |dD |d/< t+|dT d!ƒ|d2< |
|d3< |j.|ƒ i }dH|d< ||d< |dA |d< t*|jjdƒƒ|d < |d> |d"< t+|dI d!ƒ|d$< d |d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< d5|d1< d5|d/< t+|dJ d!ƒ|d2< |
|d3< |j.|ƒ |dU dkrÞ|d& |d? @ rZi }|d@ |d< ||d< |dA |d< t*|jjdƒƒ|d < |dU |d"< t+|dV d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dC |d1< |dD |d/< t+|dW d!ƒ|d2< |
|d3< |j.|ƒ i }d4|d< ||d< |dA |d< t*|jjdƒƒ|d < |dU |d"< t+|dX d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< d5|d1< d5|d/< t+|dY d!ƒ|d2< |
|d3< |j.|ƒ i }dH|d< ||d< |dA |d< t*|jjdƒƒ|d < |dU |d"< t+|dZ d!ƒ|d$< d |d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< d5|d1< d5|d/< t+|d[ d!ƒ|d2< |
|d3< |j.|ƒ qÞ|d& râi }|d@ |d< ||d< |dA |d< t*|jjdƒƒ|d < |dU |d"< t+|d\ d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dC |d1< |dD |d/< t+|d] d!ƒ|d2< |
|d3< |j.|ƒ i }d4|d< ||d< |dA |d< t*|jjdƒƒ|d < |dU |d"< t+|dX d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< d5|d1< d5|d/< t+|dY d!ƒ|d2< |
|d3< |j.|ƒ nÄi }|d@ |d< ||d< |dA |d< t*|jjdƒƒ|d < |dU |d"< t+|d^ d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dC |d1< |dD |d/< t+|d_ d!ƒ|d2< |
|d3< |j.|ƒ |d? rÞi }|d@ |d< ||d< |dA |d< t*|jjdƒƒ|d < |dU |d"< t+|d` d!ƒ|d$< d |d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dC |d1< |dD |d/< t+|da d!ƒ|d2< |
|d3< |j.|ƒ i }dH|d< ||d< |dA |d< t*|jjdƒƒ|d < |dU |d"< t+|dZ d!ƒ|d$< d |d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< d5|d1< d5|d/< t+|d[ d!ƒ|d2< |
|d3< |j.|ƒ qÞW |db ;rà%x |db D %]’}|dc ddk-r|de dfk)r4|d& |d? @ rZ|dg |dh  dkrÊi }|di |d< ||d< |dj |d< t*|jjdƒƒ|d < d|d"< t+|dk d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dl |d1< |dm |d/< t+|dn d!ƒ|d2< |
|d3< |j.|ƒ i }d4|d< ||d< |dj |d< t*|jjdƒƒ|d < d|d"< t+|dk d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dl |d1< |dm |d/< t+|do d!ƒ|d2< |
|d3< |j.|ƒ i }dH|d< ||d< |dj |d< t*|jjdƒƒ|d < d|d"< t+|dk d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dl |d1< |dm |d/< t+|dp d!ƒ|d2< |
|d3< |j.|ƒ |dq dkri }|di |d< ||d< |dj |d< t*|jjdƒƒ|d < d|d"< t+|dk d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dl |d1< |dm |d/< t+|dr d!ƒ|d2< |
|d3< |j.|ƒ i } d4| d< || d< |dj | d< t*|jjdƒƒ| d < d| d"< t+|dk d!ƒ| d$< d%| d&< d'| d(< t,|d) ƒ| d*< d+| d,< |j-| d-< |dl | d1< |dm | d/< t+|ds d!ƒ| d2< |
| d3< |j.| ƒ i }!dH|!d< ||!d< |dj |!d< t*|jjdƒƒ|!d < d|!d"< t+|dk d!ƒ|!d$< d%|!d&< d'|!d(< t,|d) ƒ|!d*< d+|!d,< |j-|!d-< |dl |!d1< |dm |!d/< t+|dt d!ƒ|!d2< |
|!d3< |j.|!ƒ |du dk)r0i }"|di |"d< ||"d< |dj |"d< t*|jjdƒƒ|"d < d|"d"< t+|dk d!ƒ|"d$< d%|"d&< d'|"d(< t,|d) ƒ|"d*< d+|"d,< |j-|"d-< |dl |"d1< |dm |"d/< t+|dv d!ƒ|"d2< |
|d3< |j.|"ƒ i }#d4|#d< ||#d< |dj |#d< t*|jjdƒƒ|#d < d|#d"< t+|dk d!ƒ|#d$< d%|#d&< d'|#d(< t,|d) ƒ|#d*< d+|#d,< |j-|#d-< |dl |#d1< |dm |#d/< t+|dw d!ƒ|#d2< |
|#d3< |j.|#ƒ i }$dH|$d< ||$d< |dj |$d< t*|jjdƒƒ|$d < d|$d"< t+|dk d!ƒ|$d$< d%|$d&< d'|$d(< t,|d) ƒ|$d*< d+|$d,< |j-|$d-< |dl |$d1< |dm |$d/< t+|dx d!ƒ|$d2< |
|$d3< |j.|$ƒ -qŒ|d& "r|dg |dh  dkröi }|di |d< ||d< |dj |d< t*|jjdƒƒ|d < d|d"< t+|dk d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dl |d1< |dm |d/< t+|dy d!ƒ|d2< |
|d3< |j.|ƒ i }d4|d< ||d< |dj |d< t*|jjdƒƒ|d < d|d"< t+|dk d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dl |d1< |dm |d/< t+|do d!ƒ|d2< |
|d3< |j.|ƒ |dq dk r€i }|di |d< ||d< |dj |d< t*|jjdƒƒ|d < d|d"< t+|dk d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dl |d1< |dm |d/< t+|dz d!ƒ|d2< |
|d3< |j.|ƒ i } d4| d< || d< |dj | d< t*|jjdƒƒ| d < d| d"< t+|dk d!ƒ| d$< d%| d&< d'| d(< t,|d) ƒ| d*< d+| d,< |j-| d-< |dl | d1< |dm | d/< t+|ds d!ƒ| d2< |
| d3< |j.| ƒ |du dk$r€i }"|di |"d< ||"d< |dj |"d< t*|jjdƒƒ|"d < d|"d"< t+|dk d!ƒ|"d$< d%|"d&< d'|"d(< t,|d) ƒ|"d*< d+|"d,< |j-|"d-< |dl |"d1< |dm |"d/< t+|d{ d!ƒ|"d2< |
|"d3< |j.|"ƒ i }#d4|#d< ||#d< |dj |#d< t*|jjdƒƒ|#d < d|#d"< t+|dk d!ƒ|#d$< d%|#d&< d'|#d(< t,|d) ƒ|#d*< d+|#d,< |j-|#d-< |dl |#d1< |dm |#d/< t+|dw d!ƒ|#d2< |
|#d3< |j.|#ƒ nr|dg |dh  dk"räi }|di |d< ||d< |dj |d< t*|jjdƒƒ|d < d|d"< t+|dk d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dl |d1< |dm |d/< t+|d| d!ƒ|d2< |
|d3< |j.|ƒ |dq dk#r²i }|di |d< ||d< |dj |d< t*|jjdƒƒ|d < d|d"< t+|dk d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dl |d1< |dm |d/< t+|d} d!ƒ|d2< |
|d3< |j.|ƒ |du dk$r€i }"|di |"d< ||"d< |dj |"d< t*|jjdƒƒ|"d < d|"d"< t+|dk d!ƒ|"d$< d%|"d&< d'|"d(< t,|d) ƒ|"d*< d+|"d,< |j-|"d-< |dl |"d1< |dm |"d/< t+|d~ d!ƒ|"d2< |
|"d3< |j.|"ƒ |d? -rŒ|dg |dh  dk&ri }|di |d< ||d< |dj |d< t*|jjdƒƒ|d < d|d"< t+|dk d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dl |d1< |dm |d/< t+|d d!ƒ|d2< |
|d3< |j.|ƒ i }dH|d< ||d< |dj |d< t*|jjdƒƒ|d < d|d"< t+|dk d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dl |d1< |dm |d/< t+|dp d!ƒ|d2< |
|d3< |j.|ƒ |dq dk'r¦i }|di |d< ||d< |dj |d< t*|jjdƒƒ|d < d|d"< t+|dk d!ƒ|d$< d%|d&< d'|d(< t,|d) ƒ|d*< d+|d,< |j-|d-< |dl |d1< |dm |d/< t+|d€ d!ƒ|d2< |
|d3< |j.|ƒ i }!dH|!d< ||!d< |dj |!d< t*|jjdƒƒ|!d < d|!d"< t+|dk d!ƒ|!d$< d%|!d&< d'|!d(< t,|d) ƒ|!d*< d+|!d,< |j-|!d-< |dl |!d1< |dm |!d/< t+|dt d!ƒ|!d2< |
|!d3< |j.|!ƒ |du dk-rŒi }"|di |"d< ||"d< |dj |"d< t*|jjdƒƒ|"d < d|"d"< t+|dk d!ƒ|"d$< d%|"d&< d'|"d(< t,|d) ƒ|"d*< d+|"d,< |j-|"d-< |dl |"d1< |dm |"d/< t+|d d!ƒ|"d2< |
|"d3< |j.|"ƒ i }$dH|$d< ||$d< |dj |$d< t*|jjdƒƒ|$d < d|$d"< t+|dk d!ƒ|$d$< d%|$d&< d'|$d(< t,|d) ƒ|$d*< d+|$d,< |j-|$d-< |dl |$d1< |dm |$d/< t+|dx d!ƒ|$d2< |
|$d3< |j.|$ƒ ;qÚ|de d‚k;rÚ|d& |d? @ -rv|dg dk+rdi }%|di |%d< ||%d< |dj |%d< t*|jjdƒƒ|%d < d|%d"< d%|%d&< d'|%d(< t,|d) ƒ|%d*< d+|%d,< |j-|%d-< |dl |%d1< |dm |%d/< t+|dƒ d!ƒ|%d2< |
|%d3< |j.|%ƒ i }&d4|&d< ||&d< |dj |&d< t*|jjdƒƒ|&d < d|&d"< d%|&d&< d'|&d(< t,|d) ƒ|&d*< d+|&d,< |j-|&d-< |dl |&d1< |dm |&d/< t+|dG d!ƒ|&d2< |
|&d3< |j.|&ƒ i }'dH|'d< ||'d< |dj |'d< t*|jjdƒƒ|'d < d|'d"< d%|'d&< d'|'d(< t,|d) ƒ|'d*< d+|'d,< |j-|'d-< |dl |'d1< |dm |'d/< t+|dJ d!ƒ|'d2< |
|'d3< |j.|'ƒ |dh dk-rŒi }(|di |(d< ||(d< |dj |(d< t*|jjdƒƒ|(d < d|(d"< d%|(d&< d'|(d(< t,|d) ƒ|(d*< d+|(d,< |j-|(d-< |dl |(d1< |dm |(d/< t+|d„ d!ƒ|(d2< |
|(d3< |j.|(ƒ i })d4|)d< ||)d< |dj |)d< t*|jjdƒƒ|)d < d|)d"< d%|)d&< d'|)d(< t,|d) ƒ|)d*< d+|)d,< |j-|)d-< |dl |)d1< |dm |)d/< t+|dY d!ƒ|)d2< |
|)d3< |j.|)ƒ i }*dH|*d< ||*d< |dj |*d< t*|jjdƒƒ|*d < d|*d"< d%|*d&< d'|*d(< t,|d) ƒ|*d*< d+|*d,< |j-|*d-< |dl |*d1< |dm |*d/< t+|d[ d!ƒ|*d2< |
|*d3< |j.|*ƒ n|d& -r‚n |d? ;rÚqH|dc d…krH|d& |d? @ 4r˜|j	d†k-rÀn8i }+|di |+d< ||+d< |dj |+d< t*|jjdƒƒ|+d < d|+d"< t+|d‡ d!ƒ|+d$< d%|+d&< d'|+d(< t,|d) ƒ|+d*< d+|+d,< |j-|+d-< |dl |+d1< |dm |+d/< t+|dˆ d!ƒ|+d2< |
|+d3< |j.|+ƒ i },d4|,d< ||,d< |dj |,d< t*|jjdƒƒ|,d < d|,d"< t+|d‡ d!ƒ|,d$< d%|,d&< d'|,d(< t,|d) ƒ|,d*< d+|,d,< |j-|,d-< |dl |,d1< |dm |,d/< t+|d‰ d!ƒ|,d2< |
|,d3< |j.|,ƒ i }-dH|-d< ||-d< |dj |-d< t*|jjdƒƒ|-d < d|-d"< t+|d‡ d!ƒ|-d$< d%|-d&< d'|-d(< t,|d) ƒ|-d*< d+|-d,< |j-|-d-< |dl |-d1< |dm |-d/< t+|dŠ d!ƒ|-d2< |
|-d3< |j.|-ƒ |dg |dq  dk2rFi }.|di |.d< ||.d< |dj |.d< t*|jjdƒƒ|.d < d|.d"< t+|d‹ d!ƒ|.d$< d%|.d&< d'|.d(< t,|d) ƒ|.d*< d+|.d,< |j-|.d-< |dl |.d1< |dm |.d/< t+|dŒ d!ƒ|.d2< |
|.d3< |j.|.ƒ i }/d4|/d< ||/d< |dj |/d< t*|jjdƒƒ|/d < d|/d"< t+|d‹ d!ƒ|/d$< d%|/d&< d'|/d(< t,|d) ƒ|/d*< d+|/d,< |j-|/d-< |dl |/d1< |dm |/d/< t+|d d!ƒ|/d2< |
|/d3< |j.|/ƒ i }0dH|0d< ||0d< |dj |0d< t*|jjdƒƒ|0d < d|0d"< t+|d‹ d!ƒ|0d$< d%|0d&< d'|0d(< t,|d) ƒ|0d*< d+|0d,< |j-|0d-< |dl |0d1< |dm |0d/< t+|dŽ d!ƒ|0d2< |
|0d3< |j.|0ƒ |dh |du  dk;rÚi }1|di |1d< ||1d< |dj |1d< t*|jjdƒƒ|1d < d|1d"< t+|d d!ƒ|1d$< d%|1d&< d'|1d(< t,|d) ƒ|1d*< d+|1d,< |j-|1d-< |dl |1d1< |dm |1d/< t+|d d!ƒ|1d2< |
|1d3< |j.|1ƒ i }2d4|2d< ||2d< |dj |2d< t*|jjdƒƒ|2d < d|2d"< t+|d d!ƒ|2d$< d%|2d&< d'|2d(< t,|d) ƒ|2d*< d+|2d,< |j-|2d-< |dl |2d1< |dm |2d/< t+|d‘ d!ƒ|2d2< |
|2d3< |j.|2ƒ i }3dH|3d< ||3d< |dj |3d< t*|jjdƒƒ|3d < d|3d"< t+|d d!ƒ|3d$< d%|3d&< d'|3d(< t,|d) ƒ|3d*< d+|3d,< |j-|3d-< |dl |3d1< |dm |3d/< t+|d’ d!ƒ|3d2< |
|3d3< |j.|3ƒ qH|d& 9rV|j	d†k4r²n|i }+|di |+d< ||+d< |dj |+d< t*|jjdƒƒ|+d < d|+d"< t+|d‡ d!ƒ|+d$< d%|+d&< d'|+d(< t,|d) ƒ|+d*< d+|+d,< |j-|+d-< |dl |+d1< |dm |+d/< t+|d“ d!ƒ|+d2< |
|+d3< |j.|+ƒ i },d4|,d< ||,d< |dj |,d< t*|jjdƒƒ|,d < d|,d"< t+|d‡ d!ƒ|,d$< d%|,d&< d'|,d(< t,|d) ƒ|,d*< d+|,d,< |j-|,d-< |dl |,d1< |dm |,d/< t+|d‰ d!ƒ|,d2< |
|,d3< |j.|,ƒ |dg |dq  dk7rÀi }.|di |.d< ||.d< |dj |.d< t*|jjdƒƒ|.d < d|.d"< t+|d‹ d!ƒ|.d$< d%|.d&< d'|.d(< t,|d) ƒ|.d*< d+|.d,< |j-|.d-< |dl |.d1< |dm |.d/< t+|d” d!ƒ|.d2< |
|.d3< |j.|.ƒ i }/d4|/d< ||/d< |dj |/d< t*|jjdƒƒ|/d < d|/d"< t+|d‹ d!ƒ|/d$< d%|/d&< d'|/d(< t,|d) ƒ|/d*< d+|/d,< |j-|/d-< |dl |/d1< |dm |/d/< t+|d d!ƒ|/d2< |
|/d3< |j.|/ƒ |dh |du  dk;rÐi }1|di |1d< ||1d< |dj |1d< t*|jjdƒƒ|1d < d|1d"< t+|d d!ƒ|1d$< d%|1d&< d'|1d(< t,|d) ƒ|1d*< d+|1d,< |j-|1d-< |dl |1d1< |dm |1d/< t+|d• d!ƒ|1d2< |
|1d3< |j.|1ƒ i }2d4|2d< ||2d< |dj |2d< t*|jjdƒƒ|2d < d|2d"< t+|d d!ƒ|2d$< d%|2d&< d'|2d(< t,|d) ƒ|2d*< d+|2d,< |j-|2d-< |dl |2d1< |dm |2d/< t+|d‘ d!ƒ|2d2< |
|2d3< |j.|2ƒ nz|j	d†k9rdnÀi }+|di |+d< ||+d< |dj |+d< t*|jjdƒƒ|+d < d|+d"< t+|d‡ d!ƒ|+d$< d%|+d&< d'|+d(< t,|d) ƒ|+d*< d+|+d,< |j-|+d-< |dl |+d1< |dm |+d/< t+|d– d!ƒ|+d2< |
|+d3< |j.|+ƒ |dg |dq  dk:rúi }.|di |.d< ||.d< |dj |.d< t*|jjdƒƒ|.d < d|.d"< t+|d‹ d!ƒ|.d$< d%|.d&< d'|.d(< t,|d) ƒ|.d*< d+|.d,< |j-|.d-< |dl |.d1< |dm |.d/< t+|d— d!ƒ|.d2< |
|.d3< |j.|.ƒ |dh |du  dk;rÐi }1|di |1d< ||1d< |dj |1d< t*|jjdƒƒ|1d < d|1d"< t+|d d!ƒ|1d$< d%|1d&< d'|1d(< t,|d) ƒ|1d*< d+|1d,< |j-|1d-< |dl |1d1< |dm |1d/< t+|d˜ d!ƒ|1d2< |
|1d3< |j.|1ƒ |d? rHqHW |j	dk<rÞi }4|d™ |4d< ||4d< |j/ƒ dš d d› |4d< t*|jjdƒƒ|4d < d!|4d"< t+dœd!ƒ|4d$< dO|4d(< |d |4d< |dž |4dž< |dŸ |4dŸ< |d  |4d < t,|d) ƒ|4d*< d+|4d,< |j-|4d-< d5|4d1< d5|4d/< t+dœd!ƒ|4d2< |
|4d3< |j.|4ƒ |j.|jƒ qð|j	dKk>r´i }4|d™ |4d< ||4d< |j/ƒ dš d d› |4d< t*|jjdƒƒ|4d < d|4d"< t+|d¡ d!ƒ|4d$< dO|4d(< |d |4d< |dž |4dž< |dŸ |4dŸ< |d  |4d < t,|d) ƒ|4d*< d+|4d,< |j-|4d-< d5|4d1< d5|4d/< t+|d¡ d!ƒ|4d2< |
|4d3< |j.|4ƒ i }4dN|4d< ||4d< d¢|4d< t*|jjdƒƒ|4d < d|4d"< t+|d¡ d!ƒ|4d$< d'|4d(< |d |4d< |dž |4dž< |dŸ |4dŸ< |d  |4d < dP|4d*< d+|4d,< |j-|4d-< d5|4d1< d5|4d/< t+|d¡ d!ƒ|4d2< |
|4d3< |j.|4ƒ |j.|jƒ qði }4|d™ |4d< ||4d< |j/ƒ dš d d› |4d< t*|jjdƒƒ|4d < d|4d"< t+|d¡ d!ƒ|4d$< dO|4d(< |d |4d< |dž |4dž< |dŸ |4dŸ< |d  |4d < t,|d) ƒ|4d*< d+|4d,< |j-|4d-< d5|4d1< d5|4d/< t+|d¡ d!ƒ|4d2< |
|4d3< |j.|4ƒ |j.|jƒ qðW t0dš|iƒd£fS )¤Nz
017a8b56-az
c12a3178-dz
adbb105d-cz
eb716599-9z
9d8b00ce-ez
96505aae-3z
649d3ffd-4z
4dd15a27-2z
e7a87637-1z
1779f0be-4z
55c2fcc9-2r8   r9   r:   r;   )r<   z%Y-%m-%dTr=   r>   r?   r@   rA   r   z
491a14d1-4rB   rC   rD   rE   rF   z%d%m%YrG   rJ   rH   rI   rK   rL   rM   r·   rO   rP   rQ   rR   rS   rT   rU   rV   rW   rX   rZ   r¼   r[   r\   rY   r]   r^   r_   r`   ra   rb   rc   rd   re   rf   rg   rh   ri   rj   rk   rl   rm   rn   ro   rp   z
5787740c-8rq   rr   Ú406GA002rN   gTã¥›ÄY@rs   rt   ru   rv   rw   rx   ry   rz   r{   r|   r}   r~   r   r€   r   r‚   rƒ   r„   r…   r†   r‡   rˆ   r‰   rŠ   r‹   rŒ   r   rŽ   r   r   r‘   r’   r“   r”   r•   r–   r—   r˜   r™   rš   r›   rœ   r   rž   rŸ   r    r¡   r¢   r£   r¤   r¥   r¦   zCamping Sitesz
5c9388fe-0r§   r-  r©   r.  rª   r/  r¬   r0  r­   r1  r¯   r2  r¨   r«   r®   r°   r±   r²   r³   r´   rµ   éZ   r¸   r¹   rº   r»   r¶   rÃ   rÈ   )1r   r3   rÉ   r   rÊ   r$   r½   rË   rÌ   rÍ   rÎ   r¼   rF   rÏ   rÐ   rÑ   rÒ   rÓ   rÔ   rÕ   Úin_rÖ   r   r×   r	   rØ   r
   rÙ   rÚ   rÛ   rÜ   rÝ   r.   r=  r   rß   r,   r+   r?  r@  rA  rÞ   rà   rá   râ   rã   ræ   r   r   )5Úbookings_arrayrñ   rò   ró   r´   rô   rõ   rö   Úbooking_paymentsrG  r¼   rÏ   r÷   rD   rø   rú   rû   rü   rý   rþ   rÿ   r   r  r  r  r  r  r  r  r  r	  r
  r  r  r  r  r  r  r  r  r  r  r  r  r  rI  r  r  rJ  r  r  rK  r  r6   r6   r7   Úgenerate_credit_note_batchfile¹%  s    




















































































































































































































































































































































































































































































r~  z/payments/credit/batchfilec              C   sd  dg} t jjtƒjttjtjkƒjtjtj	tj
tjtjtjtjtjtjtjtjtjtjtjtjtjtjtjtjƒjtjd kƒjtjj| ƒƒjtjd kƒjtjtdƒkƒjƒ }g }g }x |D ]–}|j|krÎq¼|jdkrÚq¼i }t j!t"j#|jƒƒ}t j!t"j#|jƒƒ}t$||jdƒ t jjt%ƒjt%j|jkƒj&ƒ }|j}	t jjt'ƒjt(t'j)t(j*kƒjt(j+ƒjt'jd kƒjt'j|jkƒj&ƒ }
|
r¦y
|
j+}W n t,k
r¢   |j}Y nX n|j}|jd | }t-|ƒdkrÖ|d d… }n|}t jjt%ƒjt%jd kƒjt%j.|jkƒj&ƒ }|j/r|j/d |j0 }n|j1}i }|j|d	< t2|jj3d
ƒƒ|d< ||d< d|d< |j1|d< |j|d< d|d< d|d< t4t5|j	ƒdƒ|d< d|d< d|d< d|d< t5dƒ|d< |d |d< |	|d< |j6|ƒ i }|j|d	< t2|jj3d
ƒƒ|d< ||d< d |d< |j1|d< |j|d< |j7ƒ d! d" d# |d< d|d< t4t5|j	ƒdƒ|d< d|d< d|d< d|d< t5|jƒ|d< |d |d< |	|d< |j6|ƒ t j!t"j#|jƒƒ}t$||jdƒ i }|j|d	< t2|jj3d
ƒƒ|d< ||d< d |d< ||d< |j|d< d|d< d|d< t4t5|j	ƒdƒ|d< d|d< d|d< d|d< t5dƒ|d< |jd$krRd%|d< n|jd&krhd%|d< nø|jd'kr~d(|d< nâ|jd)krÒ|j7ƒ d! d" d# dkr®d*|d< n"|j7ƒ d! d" d# d+kr`d,|d< nŽ|jd-krèd%|d< nx|jrt jjt8ƒjt8j9|jkƒj&ƒ }|j:|d< nF|j7ƒ d! d" d# dkr>d.|d< n"|j7ƒ d! d" d# d+kr`d/|d< |	|d< |j6|ƒ i }|j|d	< t2|jj3d
ƒƒ|d< ||d< d|d< ||d< |j|d< |j7ƒ d! d" d# |d< d|d< t4t5|j	ƒdƒ|d< d|d< d|d< d|d< t5|jƒ|d< |jd$kr(d%|d< n|jd&kr>d%|d< nø|jd'krTd(|d< nâ|jd)kr¨|j7ƒ d! d" d# dkr„d*|d< n"|j7ƒ d! d" d# d+kr6d,|d< nŽ|jd-kr¾d%|d< nx|jrðt jjt8ƒjt8j9|jkƒj&ƒ }|j:|d< nF|j7ƒ d! d" d# dkrd.|d< n"|j7ƒ d! d" d# d+kr6d/|d< |	|d< |j6|ƒ |j6|jƒ q¼W t;d!|iƒS )0Nz$5ef2a6cd-9455-4968-affe-33454736f03fr9   z$746bb582-89ed-4c83-ac3c-f25d9d60b266Tr=   r>   r?   z...r½   z%d%m%YrG   rD   rN   rO   rT   r¾   rÁ   rF   r;   rH   rJ   rK   rR   rS   r\   rX   rV   rQ   r³   rC   r¼   r·   r´   r   rµ   z$5550ff2f-bc48-4f0e-8944-d08f7f2b93fdr¿   z$cbff45f3-4f12-41da-8b4a-bf308112f032z$653e10f6-168c-493e-bcbb-0219537c24f6rÀ   z$33ad20be-3a89-4deb-ab71-7510ba51677erÂ   rÃ   rÄ   z$1c9d01cc-ef31-4757-a390-10c765fcecabrÅ   rÆ   )<r   r3   rÉ   r#   rÊ   r   rË   r½   rÌ   rç   rè   ré   rê   rë   rì   rí   rî   rD  rÍ   rÎ   rF   rÏ   rÐ   rE  rP   r¼   rÔ   rÕ   r{  rÖ   r   r×   rÚ   rÛ   rÜ   rÝ   r.   r   rß   r,   r+   r?  r@  rA  r=  rÞ   rF  rä   rå   rã   rà   rÙ   rá   râ   ræ   r   r)   rï   rð   r   )r|  r  r  r  r   r!  rö   r#  r}  r¼   rG  rÏ   r÷   rD   rù   rM  r"  Z
debit_datar$  r%  Zcredit_datar6   r6   r7   Úissue_payments_credit_note‡3  s~   


































r  )\Úflaskr   r   r   r   r   r   r   r	   r
   r   ÚpymysqlÚosÚmathrÚ   ÚuuidÚroutesr   r   Úroutes.bookings_urlsr   r   r   Úroutes.seed_functionsr   r   r   r   Údatabase.booking_typesr   Údatabase.bookingsr   Údatabase.booking_guestsr   Údatabase.booking_paymentsr   Údatabase.booking_statusr   Údatabase.credit_noter   Údatabase.credit_note_facilitiesr   Údatabase.credit_note_guestsr   Údatabase.credit_note_inventoryr   Údatabase.credit_note_vehiclesr   Údatabase.facilityr   Údatabase.inventoryr    Údatabase.booking_detailsr!   Údatabase.mandatory_paymentsr"   Údatabase.transactionr#   Údatabase.gatepassr$   Údatabase.gatepass_guestsr%   Údatabase.gatepass_detailsr&   Údatabase.booking_guest_typesr'   Údatabase.gatepass_vehiclesr(   Údatabase.payment_gatewaysr)   Údatabase.vehicler*   Údatabase.schoolr+   Údatabase.school_bookingr,   Údatabase.destinationr-   Úfunctions.booking_snippetsr.   r/   r0   Úfunctions.date_operatorsr1   Ú	variablesr4   Úrouter&  rN  rx  r~  r  r6   r6   r6   r7   Ú<module>   s  $(                       e                                  }                q                           i