
    	ig                     0    d dl mZ d dlmZ  G d d      Zy)    )Session)TransbankDataModelc                        e Zd ZdefdZddZy)BranchOfficeTransbankClassdbc                     || _         y )N)r   )selfr   s     ]/var/www/intrajisbackend.com/public_html/app/backend/classes/branch_office_transbank_class.py__init__z#BranchOfficeTransbankClass.__init__   s	        Nc                     	 | j                   j                  t        j                  t        j                  t        j
                  t        j                  t        j                  t        j                  t        j                  t        j                  t        j                  t        j                  
      }|"|j                  t        j                  |k(        }|dkD  r|j                         }||z   dz
  |z  }|dk  s
|dkD  r
||kD  rdddS |j                  |dz
  |z        j!                  |      j#                         }g }|D ]  }	|j%                  |	j                  |	j                  |	j
                  |	j                  |	j                  |	j                  |	j                  |	j                  |	j                  |	j                  d
        |||||dS |j#                         }g }|D ]  }	|j%                  |	j                  |	j                  |	j
                  |	j                  |	j                  |	j                  |	j                  |	j                  |	j                  |	j                  d
        |S # t&        $ r}
t)        |
      }d|dcY d }
~
S d }
~
ww xY w)Nr      errorzInvalid page number)statusmessage)
idbranch_office_idbranch_officecodigo_comerciodte_codeaddressregioncommuner   responsable)total_itemstotal_pagescurrent_pageitems_per_pagedata)r   queryr   r   r   r   r   r   r   r   r   r   r   filtercountoffsetlimitallappend	Exceptionstr)r	   pager   r   r    r   r   resultserialized_dataroweerror_messages               r
   get_allz"BranchOfficeTransbankClass.get_all   sK   L	AGGMM"%%"33"00"22"++"**"))"**"))"..E  +%7%H%HL\%\] ax#kkm*^;a?NR!8aD;4F&-:OPP tax>&ABHHX\\^ #%! C#**!ff,/,@,@),):):+.+>+>$'LL#&;;"%**#&;;"%**'*,  $/#.$(&4+  "$! C#**!ff,/,@,@),):):+.+>+>$'LL#&;;"%**#&;;"%**'*,  '& 	AFM%-@@	As,   DI* 
CI* BI* *	J3JJJ)r   
   N)__name__
__module____qualname__r   r   r/    r   r
   r   r      s    7 MAr   r   N)sqlalchemy.ormr   app.backend.db.modelsr   r   r4   r   r
   <module>r7      s    " 4QA QAr   