Herhangi Bir Raporun Alınması
Dia'daki tanımlı standart raporlar ve özel raporlar web servis yoluyla alınabilmektedir. Öncelikle servis çağrısı atan kullanıcının rapora yetkili olması gerekmektedir. rpr_raporsonuc_getir servisi ile rapor sonuçları döndürülmektedir. Şimdi bu servisin parametrelerini inceleleyelim.
Servis Parametreleri:
- session_id : login ile alınmış session id bilgisi
- firma_kodu : firma gerçek kodu
- donem_kodu : dönem gerçek kodu
- report_code : çağrılmak istenen raporun kodu (scf1110a, scf2201c, …)
- tasarim_key : raporun hazırlanırken hangi tasarımın kullanılacağı.
- param : rapora gönderilecek parametreler
- format_type : rapor sonucunun hangi formatta istendiği. (dia, html, excel, pdf, json)
Servis Sonucu:
- result : base64 encode edilmiş bir text data dönecektir, decode edip dosyaya yazabilirsiniz sonucu (dosya uzantısını
format_typegöre verebilirsiniz)
Tasarım (tasarim_key) Bilgisini Alınması
rpr_tasarimlar_listele servisi ile tasarımlara ulaşılabilmektedir. Dikkat edilmesi gereken nokta hangi rapor için alınmak istendiğinin filtrelerde belirtilmesi gerekmektedir.
{"rpr_tasarimlar_listele" :
{"session_id": "b2d4820cc43f4d98a8c6698686b6d386",
"firma_kodu": 34,
"donem_kodu": 1,
"filters":[{"field": "raporkodu", "operator": "=", "value": "scf1110a"},
{"field": "dil", "operator": "=", "value": "tr"}],
"sorts": ""
}
}
Rapor Parametreleri (param) Bilgisini Oluşturulması
Dia'da rapor parametre ekranı 4 kısımdan oluşmaktadır. Ana parametreler, filtreler, siralama, gruplama. İstemciden herhangi bir rapor açıldığında bu alanları gözlemlemek mümkün. Peki bu ekrandaki nesnelere nasıl ulaşıp, param nesnesini oluşturacağız? Bunun için rpr_dinamik_raporparametreleri_getir servisi kullanılabilir. scf1110a Cari hesap ekstresi için aşağıdaki gibi bir çağrı atılması gerekiyor:
{"rpr_dinamik_raporparametreleri_getir" :
{"session_id": "b2d4820cc43f4d98a8c6698686b6d386",
"firma_kodu": 34,
"donem_kodu": 1,
"report_code":"scf1110a"
}
}
Çağrı sonucunda result içerisinde 4 item'dan oluşan bir liste dönecektir. İlk listede ana ekran nesnelerine ait bilgi, diğerlerinde sırayla filtreler, gruplama ve sıralama elemanlarına ait bilgi görüntülenir. Ana ekran parametre 'key' değerleri için fieldname alanına bakılabilir. Örneğin 'fieldname': 'param._key' '_key' değeri beklediğini söylebiliriz. 'fieldname': 'param.tarihbaslangic' değerinden tarihbaslangic değeri beklendiğini anlayabiliriz.
Örnek Çağrı (Input):
{"rpr_raporsonuc_getir" :
{"session_id": "{session_id}",
"firma_kodu": {firma_kodu},
"donem_kodu": {donem_kodu},
"report_code":"scf1110a",
"tasarim_key": "1200",
"param": {"_key": "178717",
"tarihbaslangic": "2016-01-01",
"tarihbitis": "2016-12-31",
"tarihreferans": "2016-09-08",
"vadeyontem": "B",
"vadefarki": "0",
"__ekparametreler": ["acilisbakiyesi"],
"__fisturleri": [],
"_key_sis_sube": 0,
"_subeler": [],
"topluekstre": "False",
"tekniksformgoster": "False",
"baesitsegosterme": "False",
"filtreler": [{"filtreadi": "vadetarihi",
"filtreturu": "aralik",
"ilkdeger": "2016-01-01",
"sondeger": "2016-12-31",
"serbest": ""
}],
"siralama":[{"fieldname": "vadetarihi",
"sorttype": "asc"
}],
"gruplama":[{"fieldname": "turu"}]
},
"format_type": "pdf"
}
}
Örnek Çıktı (Response):
{'code': '200',
'result': 'JVBERi0xLjQKMSAwIG9iago8PAovVGl0bGUgKP7/AEMAYQByAGkAIABIAGUAcwBhAHAAIABFAGsAcwB0AHIAZQBzAGkpCi9DcmVhdG9yICj+/ykKL1Byb2R1Y2VyIChRdCA0LjYuMiAoQykgMjAxMCBOb2tpYSBDb3Jwb3JhdGlvbiBhbmQvb3IgaXRzIHN1YnNpZGlhcnkoLWllcykpCi9DcmVhdGlvbkRhdGUgKEQ6MjAxNzA5MjExMjE4MjUpCj4+CmVuZG9iagoyIDAgb2JqCjw8Ci9UeXBlIC9DYXRhbG9nCi9QYWdlcyAzIDAgUgo+PgplbmRvYmoKNCAwIG9iago8PAovVHlwZSAvRXh0R1N0YXRlCi9TQSB0cnVlCi9TTSAwLjAyCi9jYSAxLjAKL0NBIDEuMAovQUlTIGZhbHNlCi9TTWFzayAvTm9uZT4+CmVuZG9iago1IDAgb2JqClsvUGF0dGVybiAvRGV2aWNlUkdCXQplbmRvYmoKNiAwIG9iago8PAovVHlwZSAvUGFnZQovUGFyZW50IDMgMCBSCi9Db250ZW50cyA4IDAgUgovUmVzb3VyY2VzIDEwIDAgUgovQW5ub3RzIDExIDAgUgovTWVkaWFCb3ggWzAgMCA1OTUgODQyXQo+PgplbmRvYmoKMTAgMCBvYmoKPDwKL0NvbG9yU3BhY2UgPDwKL1BDU3AgNSAwIFIKL0NTcCAvRGV2aWNlUkdCCi9DU3BnIC9EZXZpY2VHcmF5Cj4+Ci9FeHRHU3RhdGUgPDwKL0dTYSA0IDAgUgo+PgovUGF0dGVybiA8PAo+PgovRm9udCA8PAovRjcgNyAwIFIKPj4KL1hPYmplY3QgPDwKPj4KPj4KZW5kb2JqCjExIDAgb2JqClsgXQplbmRvYmoKOCAwIG9iago8PAovTGVuZ3RoIDkgMCBSCi9GaWx0ZXIgL0ZsYXRlRGVjb2RlCj4+CnN0cmVhbQp4nO2dUU/bMBDH3/Mp/Iy0NraTJpGmSYPBnhGVeJ6YNjRRtIrvLy1pYJT7gy6JWnyl/1Yl5hfHOTtuc747O/PvVz/c7wc3P7v6624et2dXWT4LRd6/XPf+9BLURXA3q2zt1tlldtn+fdp2O1dZKKqmTdz1iVjmdZvOnxPdrtvs+sTdbw7c/kwqJJSzulrUYVG5ws+KPDQhVJsiyjjzIfoX/G6b17FudzS+Ljv+XM5b/EU5/+uwzsKsfMrSibb17+sHt6331OZ9Cz/c3Gfz/mpkp8tsflE572c+b7qXW/5yvr8Q/Wa5yoo2XbrlT/e5vSb+i1v+ybpzvwWCBFE9BECh5iglWEhQqWXUEjQSfFVznI6vHAEBAQEBQRpwJsE3Cc4luNAO8bkEu5B0F7f5HpwvN4pfEvUppr7gBAQEBAQEBATjQUr1qRhuffLS+kRAQEBAQEBAsGdgUX1aaMIREBB8bODBCy8N5x6c7mBrh0LBPA/+cXA1wGnVs0ChHmz+8ixeuvaxcrqkumAEBATvAFKqTxWtTwQEBAQEBAR2gUX1qdGEIyAgICAgICCwB1KqTz4fYX6S5ngPlnOY0AZh/OqENrC+e7C+Q6EwnQAKlbMHMIecgbAXEFQ5CAgICAgICAaBpPpTGC7u++hPGAEhywjjW1rXnwIYC+G0MkQkyKCJAPEeIJhssSCjKKBNg2wPlAOiOaTGGaBQEH3oPFECAgICAgIjIKn+FEcs/URAQEBAQGAUBHUEH+QIHoaweAgMP2GACnLAkksyB8xhwNPKHPqAHXJMcbxAXaR7Z8IhQffVyDLiUF9NUv2pHN43cdbKeGsKLNSl20p28bXSuxGsC4p9QooeoQxpGYIcUCgCcPnB0mZGfqoICAgITAHQn1Dn0N0IeozJu+g+Zm58oD+pt8bj0Z8WtD8REBAQEBAQHB5Iqj/Vw8Xdi9adqOkh3GnCKAQe/wK2tAltGkEwNYex7kwwvBdCD1ItuuA6QBPvLvopBN2pQYgYp6f6RSIsOqV6PQgOFWBfB88D3D2sdIcJXRuMSfAFshpxOsAFCu0BtQWT1T68Shb0p2a4/SlK3edwgJW6WJGDgFf/EAQj4KVk5QhebyAD+lPwmnQEBAQEBIcJrNz9qGJMVA8IFJBUfwqMfyIgIPi4YB+Po4ez4OQacLSOn/gFDk7wmg6IDzYCIGA4wmQjNcbYSl2Oq3LWQVL9qbDRBgQEBAQEuwZWzCu0P42tnJXHplgBJvWncoT9CQZQsNoEzB6VA6gJSx7AggYDcoxf9cLKzx0BAcEuAT4bWF/UV50Yg2eh/WnkL+5HMtGwcgkrl1R/qqxdLQICAgICguMGVuw+VoBJ/akebn/CNbAgh7pSaYSpj7tYaUsfHcIhkEMO5LByBzPUIyAgICAgOAKw0Z/at1u3WlS/7RScVRaKqmkTd30ilnndpvPnRLfrNrs+cfebA7c/j4W5y+wfgRryFWVuZHN0cmVhbQplbmRvYmoKOSAwIG9iagoxMTA2CmVuZG9iagoxMiAwIG9iago8PCAvVHlwZSAvRm9udERlc2NyaXB0b3IKL0ZvbnROYW1lIC9RTUFBQUErU291cmNlQ29kZVByby1SZWd1bGFyCi9GbGFncyA0IAovRm9udEJCb3ggWy0zOSAtNDAwIDcwNiAxMDAwIF0KL0l0YWxpY0FuZ2xlIDAgCi9Bc2NlbnQgOTg0IAovRGVzY2VudCAtMjczIAovQ2FwSGVpZ2h0IDk4NCAKL1N0ZW1WIDUwIAovRm9udEZpbGUyIDEzIDAgUgo+PiBlbmRvYmoKMTMgMCBvYmoKPDwKL0xlbmd0aDEgMjIxMTIgCi9MZW5ndGggMTYgMCBSCi9GaWx0ZXIgL0ZsYXRlRGVjb2RlCj4+CnN0cmVhbQp4nN16C3Rb1Znu2UeynTgQcBzbCYHk2IqjPPx+xq/YsizZimVJluTYifOSpWPrxJKOoocdk0CA1ASThBAS3iGEAJmQCSGlwDDtNG3gtoWGXMqis1qmM7fDgju9XaUM09VO74VY3H8/jh5+hMCszqx7A8feOmfvf3//6/v/fWQOcRw3h7uLU3Gc1VFaEfr5z/4Edw7CtX3INzZ4vOuTpTD+hONy/90rujzuV02XOC7vY7hX44Ubc/aoKzlu0a3webnXH9mV9by2Aj63wOePfbLb9dj+E9/nuMXL4XPE79oV5Jq5LfD5MfgsBFx+Me3Y3Bfg8+sc13iaU/F96EEujeP4+/k+mNFJf6OtXAUS4O68tLkqtYrn1fAhA3bB2Mk/XVurgWvhhC94/tMv0zlO9UuUtZ1DR/Ez9M/8MbwbaJjG7eU4tSWtA8YZ3DxuAbeI4yrzs/KzsxD8gx/ZtZV52flIq83PyNirevdq+ThKj32OfoDUsauxxx8LzBl+ePIPKH1wP/pwv5jW8cXjqpdjhbFV6BfoV1ct6BeTP0Dz338/9gf+1A//+McfcoiLfvkv6sK0Sq6B42pz4V9lbk1NTe0K+KetrokP09PTM/LgA0zIWwgfNDl4bg6M0rUFeEJ0eX/00IaBF/atR6h6Y0TXKHauRqg1+lR/S+Sp7k0tz20dHdaissFnw3e9urMalfaEWlv8WyzLTq5orVyKKl339+n9zrqb5mTXWVyNlt09xQgt1rfvaDAhZLeU1PTql9+NCg3b6tf2NeejRWvWYmNzNrDV5rQl3FxuIVgRAb5KwJmVr8nSoJz8rMqsSpSJ3EJbfqYqHaEdl1+ZDPOnnr6MPkMXS7eX1d5eGxtWrbl6cWfsMeQFAdzl2OtqPu08jjSkQZVq/rFJ16Np5/9PJux1HvbypDWDT3KwRyqwaXh+hQY8U5m7AFsi4zyyHfv4eDfiP/3No7HXzx77+GNUd/bjTS9dfQa1IG7jF2b1KhT7t9jdb72HMPo3QWJm+hGQmIclVoOXq/MBdj6qwFYHm+cszH1T1R57GVmu/i3qin0HPVuh43ldRaVOd0S97PDhLz5MK2ysLG3g+YbSykYssxVkHgCUc7ks0KEWWwQ8lpddifWBsDneXNCaP2eZfnnz2VdijZdijefvRr/hNVcCH0ajHwauTP5TWvPnl9ATYAv/l79Rt6X1cVqOy164AOICZGVheOB87PHqqhoSD3nxAOH9zuM/v3vfldbYBnTDyt3t7ielmjr5yW3b7inffptps6wb/4eTPfzJ07HYq5tRn56vPhQ7tWJ155HLd+156wEz4g1VvqV1pbchtO2VWAwQQEarm4jF49bB1yeq7sl+fs3k3/NHrr55BP2vI+j0YZh9FmZrYHY2zK7MAkSV2agyS5MFCDUqpDl7is9Sq+9Dr5w/hW7KSNsfM5/nL0rve2OfXr2Q1jzZ4fsHD8pWWXEYLQBJTpAEWZ6P99SgBarWycEzR9TnYZ8JsIsZ7FJJ8iWvIp4iWvyzOm4TbBHsQGx+nCt5ECBwd6L/z4/4L+zRIVTS7Wv6flGPYRU6tGfgZOsm88/vdD0T1VX2DFX9sHKDvhDxTz4QfKvz/BYJ1UkH7KadjpZb7DdpK4zl/RJCbfWB9f2Qaq67zZ1BR/0CZ97qqvYKMYpQvxni4HlAuUx1lSvEOLMxCuy/yjxsGYYN5zPNaMCmTk/PW4E/Yvemw5TTFVt2d0iXe9JvmkAVnkcHW+8MDxTqCmz9Wyva3c238W/EPn2x+3lUc9cvT2444yy2NGkQ3yaZCtFm/X5+YMsjvnqEbllTviicszo/F6GVhv7yrPqNe41ltubi+bHPOzrRAm0TzjlPzKn2qj7ilgDODIBJDIo0KgCoAaQqDcqAYcE5zS1thc5xsfM29NrTH9yydvEcofnWP55F7y1d8a2h8tin986dV7H1TrO6evIDw8PGjof1vPbqkvXbogjv8T549GTaZcylaIUGK5+Xk0YIAvxbvaKmtiI3T33y0EPeR91lKPYRuu00eia2DY2Or/M3pR2pR/XSw/3OzL1XT6s2TWy6fYLPvQVyDV368jeqG9TLuJu4ZSCXmpjEAjavaspndAm1NWmMhlvALAajpqkNTfmsCncbFqG2llWFzUYeLTZcfd9ihM/NK7XN7TzMwXq8DXrUAd/dwHGFWaBHBmaLnPxq/qM71h0fQrmxB1TBA+oH88tv8l1tOnAAsxaagDi4SKoJl80y6Lxq59XD5GreO3l5L5a8H+JFhqjWKNkOFKSdPdP39z79y7vuervbrXto08BxuaFBPj7g2F+9fWnXluHG8X882cvSXNzqNZnjGY70tb5ljcVLIMNfjX0J6K6APn7CVuB9VFlDskSrwUzOskpDWRyN/vr4njUI/dXxX/P/Hjurl63wof2Os4OxrWf/FbWpX0POft2+e9BkE7/+Zt3WO21DD/at+vwSXzv5NtbuFOyzhjEJ+DwL8wLk9alzfPm5c5PvnuPHJvcDCVzhKzGHvkeqSjM3n1tM5ldWJNAA2VfQGqh97+wf/K/ug/rUcc+rcsxz9lcb9vWuQecu8AvLvceHfY9vXj3p4nNvbfC0P7AfKd47BXJvIFKBnRCQMpSqt8/9Fo3/IKZFZy5NXk4/h86imyeNqmaem9zGPwPrNsC6UVgHHsyvpDWCv/kc+t4Xv0bfVV84fBhjPoRZCfJ9KeVrlu+KB7X5SXU8Xcn7vEOOh94Ijl5c32g4tsF5n1inUs3jVQg1Rc/scL9y2HlublN/sPnAEzz6bM+l/QakL5eLykr793YvqLhVOrtHj5DpvkvajpANCv3TD2MNjwKKakBRrfQS2HLVZGNyJcURRULokXQSCyHHV2iPFvt2379+x3PBRlTuPuYxyLcjtKhuW3v/03r7is1PBb1PSdWowTth3XhHZ8H4+PhPbPvy165ZVNq9o3ltn7HulpsL1zXdWrUyD6G6Uv/iorU8KjIPNtb0GaoX5BWXVN6q70OmZmyvi7HNajsgzeNWQS4pUGurKLIMjVYDQZKVVVNTybib0iIaaBvt0mw6ded6VCM97tn2HWP6/INnzI/oTTva8hEqtcut1TvWe9dVZLUf+Mld4e+NdyDeod/7+RiyoSb0WWcnEPb+7q1HhqrRymKMYzd0XxhHdtxvtfH+S1OATVSVIOl05s7dlokLnoFvT1gRsk58e8BzYcJyfk1PxGSM4rapuCdqNEV61qDP7njjXgNChnvfuGPPG/vb2/e/safn0FAtQrVDh3p6D3pqajwHFQzz014GdlyhYCDGwNVCk5Wn+IoAAaLMwnVsd2P4hLt4o6NTSJ9/4EyG8cG+Taf2ms5DW6druadt/OjBx9Bnd74xbsCtWv7daRdid7/eCJS3/r5LI84D4lpUuy528zGEfoKj5imImkyoALiH00D90aavqIWN05WSpc48Y3/QsWeYP4vOfGfna51z50+oPpq0uPoQuv8Q75x85MfvoOH+c8BxR0BSA/SyC8CaEINpieIMnKXCmmXHLalNj1NbltJvpUMByuUHfS/eDvVZd/uLvsD511Hz7ecD+rC9FLs3rDeEHUVFjrChysTzpqolJdVQg0sWb3pp8rlnr/51L0K9sS9jf/Pc5Eub1D9CzfveOXjo3XuxrHvfPXTwnX3NaHK4vbW5HXqM6ubWGmjRVNwBwNxMMC/nLGCBhL8X4roHIBFrLOht6DQz0MJ4xM7QqLOugzTnqFBo6i7vObazGa2KHum6fUMxOtd559ZKNNC/tmVAr0FO6+R3W++4EAyeH21GSGvcXLOyo3YZxIj34e2bHvI3LK3tWF3jsZWirWV2Q8OSpVW6za1VPZvRcn0/ejanUrehYVvPUoSWNzvKOr5VHxu37tteXb11b2eb1NW8ZM6tBmtvWefeLVUIlW+8vbN6Y2fz4jm3tDiHsd/hRKUqBb+n4cqEa/Hr6N0zkxOqTVBnP4I+DOJBvZ5UB8Z7+EILz/LayQ/4g1d/ym86jH5yGEvC7LdV/TmpIum5ieqFXVxLVmpUUO/RabRi4zF/97OGwqoRw/qBukUI/TaWdyAv9iFajPZtfdRfn79kd84ipDGIbeiDCZQX+23mXsgQjNSW9gogzVawFlbEazsEDUXOZy0pr+P5uvIljXAKWk8VuZJV1dgIvSgyNjYaAOtF0KqUZBuuAthxUFFyQGQVa8sg9i+eWW3utBTfPnzmzIWGoS0O7Zwz/GvF+uK8+w9OnuN3/LcrCC2t6lj5CTqEtT9NOtKXIYIwtoUkMLD6EOHarPzTyHn6aeuWdZo1a/tXbxpCMXXaqquFL7+6KHf+3lugM3P71UEs5QPA9RhIodWpNl6dPjjzCQp8P9aEDv1w8jdzzqD5H8fmwyH4wOQfVb/C3fIaWIcrz0LipZqaPFIfwTQayqNozZm+n4WWlKxas0Rbur3mwEeW9JsO8B2PjaO0ufPmHsnN5ifGfqfYBeTMaheQlWqXzY4Vc+YfnMkwZyGv3mdVfCGtiezExpIluZrn5aZrNFlkBDZ7Hx2WX78P3Pfs0fo+YBj92AuDscPnLjxxAqHHXzhz+aXvIv7vzpUOPOy+/+SiOTetHR3qvcNSOPkmes3tC0Unx9HV0d0T95B6fzRmJtWwDXeds1U8CJ68DHo6yGNZrK1NpHNy2VTFZi6BdseH423NesR7bDfX73CUw0mqfHn/IVc5mlZEVXfMVhTlxg1z9t1UumJ16VynegmYtEm/wJpeaRPrphVWzFpHY9Xq/aoYdzPXzvUD00IPnVsLDVwOeTkAoBMVNQPSEHi2NqnGaiElaR+eQ4lK+YXipEzbLEphqN7Y0vvmzlD1wETvyecfQr//pzvfOdKF/u4Hv/YMa7Ur+1baDkiNKGulBmXGPC2O7geGm5Chur4J1a+xOdGlMkezRgP8VGJvWQ5M1WI/vbpHmwW8bVi5vj4fbWu593Ct6472PTJCaxsL6vKyFxT33dWd32BdcfcSVLnlW9399xTOXekube5eOKdsZyM/gPLX9dZW9WCpPVW1vevysbefA2/bwNtVYA2afxnTmmdtQZydqc+TnM7/ceDbpvXNT/b3HRRroEL3dY2vc67bLzWG33pig+GeCzv02MWdem1W3Q4n+NhYnpdh0/trDQjKeC8t7I01vqbGRQhX+ujfjHfNJQ7VZKnjHoV8JacW1AqnFtr3XOuMcnTKEQSYFrKqGKpVAT2TgwLJpYdoo1Qp+PiI6tGYveEOOBE8A6WxQT7hmvhZj6s50lvaPmwsRJte+vL5IyhDveuXP/relt6D0Bbwwxtdet1ihFYYttTaz//404eAfU8Avxlhzxu5MsAMOUO6Mhob1KZ8xpSCyHDhafyRB19cYH/Rsv8wcJXZjQZ0r474f/R4LzSvr/l6T4wZAZjvkU3iD6x8q3ywe/29Vf4fXdziQIfHWyWzVt3Q2MXbX4z97s0Tvz9uaZQf3+55VARq7Lcc/8W+BlRTBjYJA75iOJWtSe56lQ4uAx+6VHkMjdLFYYzhwv6dhzZuOTdhgx5t96ktZrlWw1smb12zqaBxnWF1x6gTmrnK/l2Gfd9av+wJja7itrqdz/ukJzwVty1C+x6aPFC34LaceUi7XtIb5a5VqKVmKc5M0k2lPQK8l88Vz9JRoZrEC6a8/KQPM7RakwfLmuBMUFbR0FCBDtBxZWPjTB2Y+mW0rqK0hedbSivWoaQxzo/dEDlhyA+B8XsldJL0d0YWeV+D34+wmrH71HJLVYDfX2itCaBTKDTokFcXPtrj1aTP38e/Z+5CL00a47/fPgbUvNl6DvUY9+E8hG4W52FBope9RjI+Zzv61oj/p87ZEo810d2dsyUa7Hie96iX8R/ht4bZyuma9+yFXIMKoFqDmkhnq1iZkB3ESC3u49584fs82rKpoKFkMdI35C/ISd97Z8zc/OdXxw7wKEdbV2hpyFKPPb8WsmAC9CpXsgAVJHSBLMAlpaZmwZQOEHdB7AWtlm++/+CqTrHhwb/O2fBibFHLK7t2vPnkRh513ffajr6nxtrqhh/Z7Pl+t1rvP9hlvreC331of4vXDAe7H1/c2j355yY4vNteRLk/eup3T8Gpoyn4+Bbx0cHy3u4Tv9hXj2rLwQrQiKlbIQvm4z6gZsGCBbX4oJrO8zx690Ja6cDZfVe7+D/sfFqsuYjqUS66+Zj00ETsi9i/xd7Br8DpVfDf/7lp202Nf8Iv/Kf/g5pzKv0IzEuP30L4TXrsX4FzM/FH9SkOTVlUp77C7VXjNw1XuChcNrguw3UerjfhaoXLD9cncJ1VX0EL4PcEXKfh8sD1Pty7BL/fZmv2w3UFrlNwvcfub4DrEFxH4boI1252nYDrCFwH4Hod5Cxk815n8/AeH8D9Nezz+0wGvp5j+x5icsLs9276DGNBRxlWsD23Fv57BLqod7g/oWWoDY2j48DnP+M1/C7+LP/3qvkqrapBNaI6q7qk+r16rnoJdMzfUf85rS5tLO1E2v9Oj6aPpz+R/tP0zzIWZzRm9GXsyXgu43/Occz5x7llc61zJ+Z+kClk+jJPZn6Q+S/zbpi3ed5uYuk6bjPu35kHp/4rQCfi9w3xOQhqj4GNeS6Dc7KxCs6f/WysTpqTBrvczcbpXA73XTbO4LZz77LxHO4WVMrGc7kbkImN53GLUQ8b35j1AQqw8XxueXY7HcOP3OxhNkbcvGy2F+JhfJCNVVxO9qOAEKnhNMLdn32OjRG3dGENG/Pc/IVONlZx5oUDbKxOmpPGhRaeZ+N0bnWOwMYZ3A9z1rPxHK4qN5ON53KLctex8TyuIncDG9+oeS33Pjaez3XUszkAtqj+XjZGXG79y2zMw/gtNlZxq+v/h14OjoWkIW9EqCgrLyvCPysEnUceEAXHWDgi+sOCKeCWQ0E55IqInhJB5/MJdrwgLNjFsBgagZsOORpyi4Je9oiCLSTbxaGozxUqLykrr23AX3g10An4OTwuZs/hkbXVsEEMhSU5INDZNgcelJU1eOWIWw6M4E8ltWUNftewKEcGS3zSQEVJdUl1XVnZjDIZEiksuIRIyOUR/a7QsCAPXkMlQQoIEa8o9AQk/MkRgZuwPOAplUOCDE9CgluOBiIhSQyXzC7G5or6hLYSoQOmeiORYH1p6ejoaIkLLyhxy/7SyFhQ/JrWFlbOKGlVkTAqRbxx+wtGORARLC6/KGipAbQz+0n4S5vnxswbM51eEE8QOeTByKgrRPbzSW4xEAYB0YAHlmCJDpNZsAbFAJ1sphOKhERAlCfkseVYklsOSiBnQPTJo0UYCFHHF5YF14hL8rkGfCI1j0sw6roFV6ReYFYMu0NSMBIuCUu+Ejk0VGo1mvEGxd/8342ZRAmbwSIYrRanYDbpDRaHIVkHoVioqBGM4kAo6gqNgcfLav+DW96YabMbdF2tZgM2jigMyaA9diI26jSDCitBzVUCdkNEFsIRyQ95EgETySGfZ1SCjPWII2DLoF+ERSDFLfvAiNj50ogoDGJRwZC8Q3RHwkVERDQIoREhu5Gn7pAIc0FbcXAQHhAoLjcOLslN/OOTAkNRCbZ2g3C/PwqRBMFCfQcCQfoIxuESBkOiSO7KWIvBEEQ0wBzGITjqldxesl9Y8LvGwP1C2AtKeWgE+LEQGqxBVygSAPt7pSCNAxKkSmyChYxmCBcInjBRIR6YVDbgAdFRuFEExop6JDzwyx5pUGJ7wZ6gS0gaiOJ8wJB9Y4ILQlQODOHfIHSMmDsgR4Sw7INQHcM3/WHRNwI5IjiZ4cACUsDtgz3wwsAYOCIkjVCzY7XhudsVwHAGIGl8GIjoHxA9HjxKRcHSkexGYx/EhZX0YwYGY3tdEfIopDAH/sOGcBwtVhujnQokCTMxQeI5YPTKoxBAIQIWCwG8IdEnuhLJjnekTIE5EIcHMzqVGxJ3RqWQSOIPAijhCLjnAocqjJFEAx4ZUOPNXMEgWB/mEvvJ7iiRQiISbx/Gpo3EscuEeKRQsgIkLtoMRpPF5DRZLY4bMwtSyKsAYAxC/OBNsKSwSLJkUPIBhLii1MVCgt87wBViaGV41UzwsQ3dsDIE2DEDYw+GIbHcXmwRiUY4jQ3YkHI22bAIQkECHzMmo85gWpMcJNoUTC8MyVpgU1G/h4OimwU23V5wDUYYO7vjqoQx5eMdQBsq3woPpIDLp/DcVBthCgG+wJwApkqtBcAAQTkgklAKC8lBPLsN6a5dShbOsOuU9PED+2B5Lg9JrohcBE99YgQ+FOEoCEcHgI4iUXxDKC5WaAM/IlwjQw2B2yRwB5lKcdgK004xQhHe0O11BYawUAhkv4uGHNzGhKmEYqo5MHYhII4KYmBECskBbGeqri4a8cqh6UqGpaEATjcRbyTiEeT3EHClH48jotsbkNwAazQkYV/Gq3QQpMhEOVAmELc6c1kKKgLAZrB3mRwOyAlhhaC3WtqU/LCJIb8UJvUNQhVEi6AhAAhEMDERDsdlBNh5SCxScLPd5YEIpDQhPBJhijFTtieLorgXwAw8VkRmAguLRCDhQMbJY6lESEsK8KwvlbKjgfhH0j2EZ9kWwgLXOcUmgzIuExgsGMwj4XgO12PTlK8SLKJEGW2aRwNySAkcCQJAgpXAvlHwSCKGMPMnAggWTI1tmKFUOVZBQJboGySeqVh17bUzaqfIi9eSr1FBiqaUENEFVEHchyMJHEpLKXQNI8nEAQQNhEfLfBL9EdYHFmTFjfGcR2AWxVQUgTXFLqiokCDirohCft6o3xUoBnL3kC4P/5UfTg2atQRBEIAGQxJucPwAEhIkMd0vRmAUgTZDEn2eMFETr8Mb4DQFe0KDRok9pZ7LYVFZwzAD6UvA3SOSOJogLojYEPFPJYSHPM0ts3sFFpIn02mb1g8AFBbEXUGwnxQheR2B9iiYkoYs/xQs0L9DjQ/isAUtplIqqzIwA/zPeDqAuxiopjg7WPyDIf3EJBgOrhjYHEHcOwSSmAOrTato1SpSzwMMONN3pppIC7FAKS5pbqptoMGDTGY9BelNaLfol3GqiwGPHALL4XTzQAMSkUhlHZtmeJi6yy0GSVq73MMBeRTif0hkdmJMCPO+AjMN4xTQIZoqtKe4hoOIdaqpdaZQTpyYQFiCpopmqkgwORomtkhOXPAFNE/gvOl9BqVDsogZMXnh1N7sP70nm15ynLjkWHS4zkw59w2IQJ5YfhQiAms1IkvQ7Q8ml2iFfhSqjre1kPi0yzM59GadqctgB+kdBnpkc1iNzl6d3SCYHILNbt1gajO0CQU6B3wuKBJ6Tc4Oa49TgBl2ncW5EU4Pgs6yUeg0WdqKBEMfnMQcDsFqF0xdNrPJAPdMFr25p81kaRdaYZ3Fig+FXSYnCHVayVImymRwYGEARt8BH3WtJrPJubFIMJqcFizTCEJ1gk1nd5r0PWadXbD12G1WOFvqLG0g1mKyGO2wi6HLAEqAIL3VttFuau9wFsEiJ9wsEpx2XZuhS2fvLMIIraCyXSBTSgAlyBAMG/BiR4fObBawQeIyhA6ruQ1mtxoAvQ5OmhQOoCcGLBLadF26doMjIRdPYxokLIAXtBssBrvOXCQ4bAa9CQ/AdCa7Qe8kM8HcoLyZIIQmw2Ho7oEbME/ZAnzQYSBbAGYd/K/H4UE1toCGWI7TanfGofSaHIYiQWc3OTAEo90KcLELYQXWsQdMiP1lYXixW/C96QEBs/BqpmCbQWcGgQ4MY9rcklnf+JT6xCGXD577fc6xIO7Tgl58LPZBbxbAr1J0ykhwJYZDiaEHH8ehMEPXx+k5mQtyY1yIk7ghzstFOIGr4Mq4criK4uMKGOk4D8wd4EQYO2BFGOaKnB9+C5yJC3BueBoCWfinizzzcCVknQ/+Ezh7fIcw+STCbxHmjrCZDlgZhc9usgPG5SEjG9yTyfwheO4D2SFAVEJw1XINIL+Na+UMMEqWoKynq4unrKerrGTdBoIiDOhk0EJIkW0Dmcod/F8D4JdBAzeZOxJ/VgKz8VM/SB8GeXjOINz1gdQBsF4JV02uOiLl+nGm2kQilnPBFSE29hD743nDcE+GHb+Zl7DkAJHqJet64JMUf+aAEZ1Jdw/A3VKyXiB6eon9BCI5Ck8jJJbw7JJvhMYGoyiJmDYSPx1MKo6cCMyth91LuVHyXwmxAt2hhEjzw7MI7BRktv3LxbbArfwamFaRHUeJXb0zxL/AGUlMYYwWkOAnWLQpEaD9Wvkk/D8fPTdymeRywiyKPmEjB0EcAYtiDRL64YzD+gaINTCCKNmT7qJgdIA2ZvhtJXESSJFsTpGAvTYTQ5TPiC91dwWTm8ShxPBg6/rgziiRTS2S8I4PfstkNAKXRHhgAH6KKdHjIoh1XDcZRyD+hCmxGIZdsSWDJD5KCHof/MaWH4LnVlhvjmtQ/F/yH9454QkbcLGF6GWF307iCRPkML7rgJ+z+UEASTiXa8haEawVAp/jqBhjOV4G7PxfqyW+bJCjBvBZF1QdM4yUyMGeHQKNqO+VTFQi9asjFPMQ9eYqEg00GyIkinD+SpC/tJ5EWBThGPBB1OF4ojUW/xxhcRkk3EN3olhw/PpYJCqZL5H5AjxXUAVJBdsBd90k5oqSUEThKWWNSJJuibVugprKpb4V4ekgW5GwigtmKsyFbZDIHx9hIVw5Jaa1myH3E/0pJ1FmSc47ipBiH4nbw0XQYUxi0lw57otBYgVsJ2rN4TgLjhIucJMsVfTD+DHTjrHsxxbxMk95UjjAH0eSzKxBMjcCYxr/XpLXyXyQYNKpvEljyEhyzEW8iJknnOSF6YyZjJvah6KOshlFLLKiMJbid/ykk5FgtTRFL6on9UuIdETReH1QrOwj1nExFpWJL5XPFOlYUnQHiMYC4UofY9Wx+Ew/wekjVgyTSuicEnE0BiRS0XxMD2XHAJFEK4ZEWDgR7Yq36Xo3ma1YZ4BVGl/cIhjJAPnkid+7li1Sq2NCt2Tep+jC06pfagR7mC1cxErKqtC0niPAojg8g22j8XgYuC6LzGznRBTMtJ7a0UtikjJQKMmyChJq3xDxqUhiYnplV3RM7imUPlBhj9RIT8aLZe8k3BEiXlP4b5D5YnpGhFj3RDN0ao8xczeAeytqa0UzF+FFH4tdOSX+ZFgbTcKS4EhF+3A8aqcyKmXMRMcjkfHMHkjwRRtUJSPUXAtcTrispPLiJwXX6LwKmDUGGf8omiiYsO6JWjJI+hBqhekeTc5iYcb+vYNlBd5rJaxbdd3WV+LQzfYMMbsrPbCSg2GOVizM4UqMSCkcnswbIsvGRJ+d0LCIsYLE8ji1J0vOjFRfJ+pgwjcF13VimM0XSlQl53uY5IZ7CmMna48/D5J4S+6d3TN4JRzv8hUdqG+S8VvZComgwCeY1H7uq+JI6UJof6H0CTSqrnUuoD1AkMwQk1gpTCw/MxN/kzhM1rVrWi28Pl2vXX38rPdR8LlIZUlwgEwizsOyKsKeFMW5APt1gHVHEaKtsraY9NCp3YayKtHXyOwcQmcnGDe5X53Z2lN72mtHQlFcQzepYQE2dyjOyH5ilwTL0dlKhzmVFa8VHYrdBYJ3lBMI6hHCmHiVEs/J3tUR23nJbtfjyTDRNhCvbmJcIzF+j9bvIdZX+uP3IyTevaR/dTNrjRL7KXk5/SwdZFjkJM8J7J3V9FhPzbLZbVWSdJIxABt1QYVwkPOblZzbVpBMweO2afXDRhD5SbYlzm+UVSlqkfmQWiDA0BVxyX24chqhvfMQJyadMRR7p+qO32VEWJVOdHgJDpsambNrn9gpGn8voPTAY6xnoTJpLywmIUz0gal98tg1O8LkUwrtZ33ctbrsKInWqU8T7x6m5+G1taVsoZznpsbJIGNjmXSn1LI0wjzspCWTylsfj5pyUqstpBtJ7tG+OkcDLMZTGUdiDCCxPWnvG2U5MhMPKT3/TAxEd/gq3g4zD6ae5VLPIBQX9tdgUs5UEO2/+b7X77up+KafS/4yZ5AEi818ChHJ6d2bkn0KJ9EMTT6V0ncNI7N2HLSDlljPlTjNz9z9JXr9MJOYfHJL7ec8BGtyjCpdUYTtU0x8RyOLMvQudlpI7vy8pKPDK4pZ5+5JepfnZXeUqpFcaxM2CDKLBonuyhscP7MkrSAzSfeT+k/vRdjbDInEpIfspnhT2U/RQKmmND7pG7Tkjn3287nMLJu6T6qdaacvsb57hMwcnbHjirJON5E/lYw95OvIlm+SK1GGX1lzPd128vmDWihMtNxFznQS6a0jXKJeRziRdVizV8PU+jfVLvT9Oz3HB+NsS33xVV1q6lmGyqD5n9pPB+LvYoJMD3GGbpxGpD8pShTrKGcMJTqC8fcOCa1SZSneTj6LVhHLKufzwBSLp/r3es+JySdiIaWLm1nuteKGvsGjNTn1PUXivUnyu0U/mSPG+z8P2TfM+hrKMh72BiRCfKTw2th1RHwRizvMeMGkao15YpjgG2X8P5QS5dN7QirvP2bnZDae3dKhlKqS/J7im2VQInaqU2Ln2l3O9I6JIpupm0r0D191RqKSoyTDlLiYreLSvJDY25Ax7vreZyR3h4mdUiNxth2/6r3Z///vya7nlOOMn3IsEMHKeeba3/dhu9POU8EfZRyh+GoEnkocfbc/yM12ip7a/Uztqqe/raUVP/ldHj6d6TkzYDeBFlgXir2DfJeW+JbNQb4fcHK9MNNOnpnIXz3g76uswDMm8l6wDe7gk6+DPS8gEdhLTnodMK+HyKIy7PATy97I0e8eBPIZf+ok1mwjaw1cH/tOzEGkWmEsEKw28s2fgc3DK7AePUQnC9cO91rZfhZYpXxT2EWwUKROuJ/YNRWVieyoIKOW0YMO9KkOZJuIPIy/iFgKjy1xnEaGVEdshCU7yfeUPcTWdnK3B37bYB793lJHdKZoLUQHIzynuhgIAuoJikhPvgvdSGa0Ay4nQWEjMUhnFhEN7eRvWPB6vGsnuUuRWZmX8TghpYTZkuIQyF++GOIxgPU3k2+JlAiZjkMgnjaTXe3ECwZmex37TjPZOtT2iQjE+NrI9586ordjRryKtFQfzBQDyg7tRAsDsYeZzHaQNxR6IskcX49X2sl9Z5JMGt3U8+YkG+rZ2wsD1w27Gljk6IiFUrWgeYDxJ7Sgdtaxn/o4eyT72MJ8qI971EpiabpVeknGGcgsHfGHI24FI8nSLoa8JymOFD/2sCi0xpGl2lfJFmXe9TAElaXsnerBNvItt5khdMSt8dVyKXt9/b/zKSU1d4j0YyVkvR9GTvJUeacWZN/L0m9B6buzAKf8ZYpu2j08b6a7QzPe9XDKN+T01Ezf93H/F5p06QtlbmRzdHJlYW0KZW5kb2JqCjE2IDAgb2JqCjk5ODEKZW5kb2JqCjE0IDAgb2JqCjw8IC9UeXBlIC9Gb250Ci9TdWJ0eXBlIC9DSURGb250VHlwZTIKL0Jhc2VGb250IC9Tb3VyY2VDb2RlUHJvLVJlZ3VsYXIKL0NJRFN5c3RlbUluZm8gPDwgL1JlZ2lzdHJ5IChBZG9iZSkgL09yZGVyaW5nIChJZGVudGl0eSkgL1N1cHBsZW1lbnQgMCA+PgovRm9udERlc2NyaXB0b3IgMTIgMCBSCi9DSURUb0dJRE1hcCAvSWRlbnRpdHkKL0RXIDU5NSA+PgplbmRvYmoKMTUgMCBvYmoKPDwgL0xlbmd0aCA3NTYgPj4Kc3RyZWFtCi9DSURJbml0IC9Qcm9jU2V0IGZpbmRyZXNvdXJjZSBiZWdpbgoxMiBkaWN0IGJlZ2luCmJlZ2luY21hcAovQ0lEU3lzdGVtSW5mbyA8PCAvUmVnaXN0cnkgKEFkb2JlKSAvT3JkZXJpbmcgKFVDUykgL1N1cHBsZW1lbnQgMCA+PiBkZWYKL0NNYXBOYW1lIC9BZG9iZS1JZGVudGl0eS1VQ1MgZGVmCi9DTWFwVHlwZSAyIGRlZgoxIGJlZ2luY29kZXNwYWNlcmFuZ2UKPDAwMDA+IDxGRkZGPgplbmRjb2Rlc3BhY2VyYW5nZQoyIGJlZ2luYmZyYW5nZQo8MDAwMD4gPDAwMDA+IDwwMDAwPgo8MDAwMT4gPDAwMzg+IFs8MDAyMD4gPDAwMzM+IDwwMDM0PiA8MDAyRj4gPDAwNDQ+IDwwMTMwPiA8MDA0MT4gPDAwNDc+IDwwMDQ1PiA8MDA0RT4gPDAwNEM+IDwwMDUzPiA8MDA2MT4gPDAwNzk+IDwwMDY2PiA8MDAzQT4gPDAwMzE+IDwwMDNEPiA8MDA0Mz4gPDAwNTI+IDwwMDQ4PiA8MDA1MD4gPDAwNEI+IDwwMDU0PiA8MDA2NT4gPDAwNzM+IDwwMDcwPiA8MDA2Rj4gPDAwNjQ+IDwwMDc1PiA8MDAzMD4gPDAwMzg+IDwwMTMxPiA8MDA0Nj4gPDAwNzQ+IDwwMDY5PiA8MDA2OD4gPDAwNkM+IDwwMDZCPiA8MDA3Mj4gPDAwNkU+IDwwMDQyPiA8MDE1Rj4gPDAwNjc+IDwwMEU3PiA8MDAyRT4gPDAwMzI+IDwwMDM2PiA8MDAzNT4gPDAwRkM+IDwwMDZEPiA8MDA2Mz4gPDAwMkQ+IDwwMDJDPiA8MDAzOT4gPDAwMzc+IF0KZW5kYmZyYW5nZQplbmRjbWFwCkNNYXBOYW1lIGN1cnJlbnRkaWN0IC9DTWFwIGRlZmluZXJlc291cmNlIHBvcAplbmQKZW5kCmVuZHN0cmVhbQplbmRvYmoKNyAwIG9iago8PCAvVHlwZSAvRm9udAovU3VidHlwZSAvVHlwZTAKL0Jhc2VGb250IC9Tb3VyY2VDb2RlUHJvLVJlZ3VsYXIKL0VuY29kaW5nIC9JZGVudGl0eS1ICi9EZXNjZW5kYW50Rm9udHMgWzE0IDAgUl0KL1RvVW5pY29kZSAxNSAwIFI+PgplbmRvYmoKMyAwIG9iago8PAovVHlwZSAvUGFnZXMKL0tpZHMgClsKNiAwIFIKXQovQ291bnQgMQovUHJvY1NldCBbL1BERiAvVGV4dCAvSW1hZ2VCIC9JbWFnZUNdCj4+CmVuZG9iagp4cmVmCjAgMTcKMDAwMDAwMDAwMCA2NTUzNSBmIAowMDAwMDAwMDA5IDAwMDAwIG4gCjAwMDAwMDAyMDMgMDAwMDAgbiAKMDAwMDAxMzM2OCAwMDAwMCBuIAowMDAwMDAwMjUyIDAwMDAwIG4gCjAwMDAwMDAzNDcgMDAwMDAgbiAKMDAwMDAwMDM4NCAwMDAwMCBuIAowMDAwMDEzMjIxIDAwMDAwIG4gCjAwMDAwMDA2OTAgMDAwMDAgbiAKMDAwMDAwMTg2OSAwMDAwMCBuIAowMDAwMDAwNTA0IDAwMDAwIG4gCjAwMDAwMDA2NzAgMDAwMDAgbiAKMDAwMDAwMTg4OSAwMDAwMCBuIAowMDAwMDAyMTAzIDAwMDAwIG4gCjAwMDAwMTIxOTYgMDAwMDAgbiAKMDAwMDAxMjQxNCAwMDAwMCBuIAowMDAwMDEyMTc1IDAwMDAwIG4gCnRyYWlsZXIKPDwKL1NpemUgMTcKL0luZm8gMSAwIFIKL1Jvb3QgMiAwIFIKPj4Kc3RhcnR4cmVmCjEzNDY2CiUlRU9GCg=='}