Merge lp:~gs.clearcorp/openerp-costa-rica/7.0_l10n_cr_account_banking_cr_davivienda into lp:openerp-costa-rica

[Glen Sojo]

[FIX] - Fixed import when comes from debit/credit cards accounts
[IMP] - Added description message for module in __openerp__.py file

[lp:~gs.clearcorp/openerp-costa-rica/7.0_l10n_cr_account_banking_cr_davivienda]

265. By Ronald Rubi on 2014-01-17

[MRG] Add security for profit statement, situation balance, statement change of equity and trial balance report.

266. By Ronald Rubi on 2014-01-21

[MRG] Fix security in reports. Add create permission

267. By Ronald Rubi on 2014-01-21

[MRG] Fixed import when comes from debit/credit cards accounts. l10n_cr_account_banking_davivienda - Fixed starting and ending balanace calculations for account.bank.statement during import. Fixed davivienda's parser import date when importing bank statements files

=== modified file 'l10n_cr_account_banking_cr_davivienda/__openerp__.py'
--- l10n_cr_account_banking_cr_davivienda/__openerp__.py	2013-12-04 17:39:51 +0000
+++ l10n_cr_account_banking_cr_davivienda/__openerp__.py	2014-01-14 16:52:36 +0000
@@ -33,7 +33,7 @@
     'init_xml': [],
     'update_xml': [],
     'demo_xml': [],
-    'description': '',
+    'description': 'Module intended to import Davivienda\'s statements files',
     'active': False,
     'installable': True,
 }

=== modified file 'l10n_cr_account_banking_cr_davivienda/davivienda_parser.py'
--- l10n_cr_account_banking_cr_davivienda/davivienda_parser.py	2013-12-09 18:32:13 +0000
+++ l10n_cr_account_banking_cr_davivienda/davivienda_parser.py	2014-01-14 16:52:36 +0000
@@ -71,7 +71,12 @@
         first_line_split = fist_line.split(';')
         
         account_number_wizard = kwargs['account_number']#from wizard
-        account_number_file = first_line_split[11]#from file.
+        from_card = False
+        try:
+            account_number_file = first_line_split[11]#from account file.
+        except:
+            from_card = True
+            account_number_file = first_line_split[10]#from credit or debit card file
         
         #if the account_number in the file match with the account
         #selected in the wizard, return True
@@ -88,23 +93,27 @@
             line_dict['currencycode'] = kwargs['local_currency']
             
             line_dict['statementnr'] = kwargs['date_from_str'] + ' - '+ \
-            kwargs['date_to_str'] + 'Extracto Davivienda ' + \
+            kwargs['date_to_str'] + ' Extracto Davivienda ' + \
             line_dict['account_number'] #Interval time of the file.
              
             startingbalance = endingbalance = 0.0
             
             #transmission_number (Date when done the import)
-            date_obj= datetime.now()
+            date_obj = datetime.strptime(kwargs['date_from_str'],"%Y-%m-%d")
+            #REVISAR
             line_dict['transref'] = date_obj.strftime("%d-%m-%Y %H:%M:%S")
             #bookingdate
             line_dict['bookingdate'] = date_obj.strftime("%d-%m-%Y %H:%M:%S")
-        
+            #FIN REVISAR
             #with the first line compute the initial_balance
             fist_line = list_split[1]
             first_line_split = fist_line.split(';')
-            startingbalance = float(first_line_split[5].replace(",","")) + \
-            float(first_line_split[3].replace(",","")) - \
-            float(first_line_split[4].replace(",",""))
+            #If it comes from credit/debit card account we don't have access to starting
+            #balance assuming 0.0
+            if not from_card:
+                startingbalance = float(first_line_split[5].replace(",","")) + \
+                float(first_line_split[3].replace(",","")) - \
+                float(first_line_split[4].replace(",",""))
             line_dict['startingbalance'] =  str(startingbalance)
             
             #the ending_balance is the balance of the last line.        
@@ -118,7 +127,16 @@
                     if len(last_line) > 0 and last_line != "" and last_line != '\r':
                         break       
             last_line_split = last_line.split(';')
-            endingbalance += float(last_line_split[5].replace(",",""))      
+            if not from_card:
+                endingbalance += float(last_line_split[5].replace(",",""))
+            #Calculating ending_balance assuming starting balance as 0.0
+            else:
+                for line in list_split[1:]:
+                    if line == '':
+                        break;
+                    line = line.split(';')
+                    endingbalance += -float(line[3].replace(",","")) + float(line[4].replace(",",""))
+                  
             line_dict['endingbalance'] =  str(endingbalance)
             
             line_dict['amount'] = str(startingbalance + endingbalance)