def iter_documents(self):
table = self.doc.xpath('//table[@id="releveCompteMensuel"]')[0].xpath(
'.//tr')
for tr in table:
list_tds = tr.xpath('.//td')
if len(list_tds) == 0:
continue
date_str = tr.xpath('.//td[@class="cAlignGauche"]')[0].text
month_str = date_str.split()[0]
date = datetime.strptime(
re.sub(month_str, str(FRENCH_MONTHS.index(month_str) + 1),
date_str), "%m %Y").date()
amount = tr.xpath('.//td[@class="cAlignDroite"]')[0].text
amount = re.sub('[^\d,-]+', '', amount)
for format in ('CSV', 'PDF'):
bil = Bill()
bil.id = date.strftime("%Y%m") + format
bil.date = date
clean_amount = amount.strip().replace(',', '.')
if clean_amount != '':
bil.price = Decimal('-' + clean_amount)
else:
bil.price = 0
bil.label = u'' + date.strftime("%Y%m%d")
bil.format = u'' + format
bil.type = DocumentTypes.BILL
filedate = date.strftime("%m%Y")
bil.url = u'/PortailPS/fichier.do'
bil._data = {
'FICHIER.type': format.lower() + '.releveCompteMensuel',
'dateReleve': filedate,
'FICHIER.titre': 'Releve' + filedate
}
yield bil
def iter_bills(self):
table = self.doc.xpath('//table[@id="releveCompteMensuel"]')[0].xpath('.//tr')
for tr in table:
list_tds = tr.xpath('.//td')
if len(list_tds) == 0:
continue
date_str = tr.xpath('.//td[@class="cAlignGauche"]')[0].text
month_str = date_str.split()[0]
date = datetime.strptime(re.sub(month_str, str(FRENCH_MONTHS.index(month_str) + 1), date_str), "%m %Y").date()
amount = tr.xpath('.//td[@class="cAlignDroite"]')[0].text
amount = re.sub('[^\d,-]+', '', amount)
for format in ('CSV', 'PDF'):
bil = Bill()
bil.id = date.strftime("%Y%m") + format
bil.date = date
clean_amount = amount.strip().replace(',','.')
if clean_amount != '':
bil.price = Decimal('-'+clean_amount)
else:
bil.price = 0
bil.label = u''+date.strftime("%Y%m%d")
bil.format = u''+format
filedate = date.strftime("%m%Y")
bil._url = '/PortailPS/fichier.do'
bil._data = {'FICHIER.type': format.lower()+'.releveCompteMensuel',
'dateReleve': filedate,
'FICHIER.titre': 'Releve' + filedate
}
yield bil
