
    :g4                         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 d dl	m
Z
 d dlmZ d dlmZ d dlmZmZmZmZmZmZ d d	lmZ d d
lmZ d dlZd dlmZ d dlmZ d Zd Z ed        Z!d Z"d Z#d Z$y)    N)messages)Sum)HttpResponseHttpResponseRedirect)render)csrf_exempt)Extenos)tipoServicio	OrdenPagoDetalleOrdenClientesNotaCreditoDetalleNotaCredito)TipoDocumento)render_to_pdf)Configuracion)generar_xmlc                 $   g }d}d}t         j                  j                  | j                  j	                  d      d      }t        | j                         | j                  j	                  d      rt        | j                  j	                  d            }|dk\  r|dk  r|j                  dd      }n|d	k\  r|d
k  r|j                  d	d
      }n|dk\  r|dk  r|j                  dd      }n|dk\  r|dk  r|j                  dd      }nr|dk\  r|dk  r|j                  dd      }nT|dk\  r|dk  r|j                  dd      }n6|dk\  r|dk  r|j                  dd      }n|dk\  r|j                  dd      }| j                  j	                  d      rt        | j                  j	                  d            }|dk\  r|dk  r|j                  dd      }nT|dk\  r|dk  r|j                  dd      }n6|dk\  r|dk  r|j                  dd      }n|dk\  r|j                  dd       }|D ]  }	 |j                  |j                  |j                  t        |j                        t        |j                        |j                  j                  d!|j                  j                  |j                  j                  d!|j                  j                  t        |j                         d"        t        |       t#        t%        j&                  |      d#$      S #  |j                  |j                  |j                  t        |j                        t        |j                        ddt        |j                         d"       Y \xY w)%N qT)descripcion__icontainsestadoar   i  )avaluo__desdeavaluo__hastai  i@  iA  i.  i.  i>  i>  i N  i!N  i0u  i	R  i1u  i@  iy  iA  tg      @)tonelaje__desdetonelaje__hastagGz@
   g333333$@   g4@d   z - )pkdescripcioncostoadministrativoavaluotonelajetotalzapplication/json)content_type)r
   objectsfilterGETgetprintfloatappendidr#   r$   r%   r&   desdehastar'   r(   r   jsondumps)requestdatar&   r'   tipois         >C:\Users\user\PycharmProjects\TransitoApp\Facturacion\views.pybuscar_servicior;      s   DFH&&gkkooc>R[_&`D	'++{{sw{{s+,Q;6T>;;Qd;CDt^$;;T;FDt^%;;T;GDu_5;;U%;HDu_5;;U%;HDu_5;;U%;HDu_5;;U%;HDu_;;U!;DD{{s-.q=X_;;q#;FD(b.;;tR;HD8r>;;ub;ID;;uc;JD 	KKdd }}qww"'(8(8"9'(xx~~qxx~~F)*)9)91::;K;KLqww * 
$K

4(7IJJ		KKdd }}qww"'(8(8"9qww s   7C L$$A(Nc                 x    dt         j                   j                         j                         i}t        | d|      S )Nfechazfacturacion/orden_pago.html)datetimenowdater   )r6   contextos     r:   
orden_pagorB   R   s8    ""&&(--/H '8(CC    c                    | j                   rad }t        j                  j                  | j                   j                  d            }	 t        j                  j                  |      }t        j
                  t        j                  |j                  j                         j                  |j                  j                         j                        d   |j                  j                         j                  |j                  j                         j                  ddd      |t        j                  j                         t        j                  j                         |d	}t        d
|      S | j                   rd }	 t"        j                  j%                  | j                   j                  d      | j                   j                  d      | j                   j                  d      j'                  dd      j'                  dd      dz   | j                   j                  d      j'                  dd      j'                  dd      z   | j                   j                  d      | j                   j                  d      | j                   j                  d            }t        j                  j%                  | j                   j                  d      | j                   j                  d      | j                   j                  d      | j                   j                  d      | j                   j                  d      | j                   j                  d      | j                   j                  d      |      }t7        j8                  | j                   j                  d            }t;        | j                   j                  d             | j                   j                  d       rot        j                  j%                  | j                   j                  d      | j                   j                  d       || j                   j                  d!      |"      }t7        j8                  | j                   j                  d#            }d}|D ]  }|dz   }t<        j                  j?                  d$%      jA                         }	t<        j                  j%                  ||d&   |d'   |d(   |d   d$d)      }
t;        |d&   |d'   |d(   |d           ||_!        |j5                          | j                   j                  d       r4|D ]/  }tD        j                  j%                  |d*   d|d+   |d,   -      }1 t;        |       t;        |       tG        |jH                        S tG        d.      S #  Y 8xY w#  t"        j                  j                  | j                   j                  d            }| j                   j                  d      |_        | j                   j                  d      |_        | j                   j                  d      |_        | j                   j                  d      |_        | j                   j                  d      dz   | j                   j                  d      z   |_        | j                   j                  d      |_        |j5                          Y 9xY w)/Nn)numero)orden         r   )daymonthyearhourminutesecond)
ultimo_diarG   	consultas
documentosnota_creditozfacturacion/reporte.html)template_srccontext_dictidentificacioncedulanombresz',)r   z(' 	apellidos	direcciontelefonoemail)rW   numero_identificacionrazon_socialr\   r]   r^   )r_   placar&   r'   r(   )ra   r&   r'   rX   rY   r[   r(   clientedetallenotandatennnvl)r=   rF   rb   valorrG   detallesT)electronicor1   cantidadprecio)rG   items_idrj   r$   r(   ri   n_comprobantecodigodetallerg   )rn   notarj   r#   rg   zRegistro de ordenes de pago)%r,   r   r*   r-   r   r>   calendar
monthranger=   r@   rM   rL   r	   allr   r   POSTr   createreplacer_   rW   r\   r]   r`   r^   saver4   loadsr.   r   r+   countnumero_itemsr   r   rF   )r6   rp   rG   rA   rb   detallenotasrh   contadordetndetdtdnotadetns                r:   registrar_ordenr   Y   s   {{!!%%W[[__S-A%B	$$((u(5D #++''(8(8(:(?(?AQAQASAYAYZ[\]kk&&(..U[[5E5E5G5L5LSU^`ijl  ,,.'//335
 *DS[\\||	&&--&||//0@A&-ll&6&6x&@$\\--i8@@rJRRSWXZ[^aadkdpdpdtdt  vA  eB  eJ  eJ  KP  QS  eT  e\  e\  ]a  bd  ee  e!,,**;7 ))*5ll&&w/ . G" !!((,,""7+<<##H-\\%%j1<<##H-LL$$Y/ll&&{3,,""7+ ) 	
 zz',,"2"2="ABgllw'(<<D!$$++ll&&w/||''-ll&&u- , D ::gll..z:; 	KC!|H''..4.@FFHD%%,,TZ(m'l   - B #d)S_c(mS\J	K &

<<D!% '//66 ? "'	"2!'N 7  	geELL))9::i	,	&&**AQAQRZA[*\G,3LL,<,<X,FG)%,\\%5%56F%GG" ' 0 0 =G&||//
;G#*<<#3#3I#>#CgllFVFVWbFc#cG #LL,,W5GMLLNs   
 V ?DV% V"%D*[c                     d x}}| j                   j                  d      rEt        | j                   j                  d            }t        j                  j	                  |d      }n,t        j                  j                         j                         }| j                   j                  d      rEt        | j                   j                  d            }t        j                  j	                  |d      }n,t        j                  j                         j                         }t        j                  j                  dd||g      j                  d      }| j                   j                  d	      rt        j                  j                  | j                   j                  d	      
      }t        |j                  |      }t        j                  | t        j                  dt        |      z          |||d}| j                   j                  d      rft         j                  j                  d      t        j                  j                  | j                   j                  d      
      d}t#        d|      S t%        | d|      S )Nf1%Y-%m-%df2FT)orden__eliminarorden__estadoorden__fecha__rangezServicios administrativos)items__descripcionrE   r1   u@   El registro se envió, esperando la respuesta por parte del SRI )rh   r   r   rider   )configuracionro   zfacturacion/ride.htmlz0facturacion/listado_facturacion_electronica.html)r,   r-   strr>   strptimer?   r@   r   r*   r+   excluder   rG   r   add_messageSUCCESSr   r   r   )r6   r   r   rh   r   contrA   s          r:   autorizar_facturasr      s   NB {{t&'''J7 ""$))+{{t&'''J7 ""$))+##**5PT@BBx + IIP6 JQ J8  {{s!!%%)=%>288R(Wh&6&6_befjbkk	m H
 {{v*2266d6C#++//7;;??63J/K
 4h??'MxXXrC   c                    | j                   rd}t        | j                   j                  d             | j                   j                  d      dk(  rd}t        j                  j                  | j                   j                  d            }d|_        | j                   j                  d      |_        ||_        |j                          t        j                  | t        j                  d       | j                  j                  d	      rt        j                  j                  | j                  j                  d	            }d|_        d|_        |j                          t        j                  | t        j                  d
       t        d      S t        j                  j!                         j#                  d      dd t$        j                  j!                         t&        j                  j!                         d}t)        | d|      S )NFfponTr1   r   r=   zSe ha verificado el pago ..!delzLa Orden se elimino..!z/fact/listaz-fechar   i  )ordenesrR   rS   zfacturacion/lista.html)rt   r.   r-   r   r*   r   r=   pago_electronicorw   r   r   r   r,   eliminarERRORr   rs   order_byr	   r   r   )r6   r   rG   rA   s       r:   lista_ordenesr      s~   ||gllt$%<<D!4'B!!%%)9)9$)?%@ll&&w/!#

Wh&6&68VW{{u!!%%)?%@

Whnn6NO#M22$$((*33H=aE__((*#++//1H
 '3X>>rC   c           
         d}| j                   j                  d      rrt        j                  j                  | j                   j                  d      |      }t        j                  |j                  |j
                  |j                  dd      }nVt        j                  j                         }t        j                  |j                  |j
                  |j                  dd      }| j                   j                  d      rst        j                  j                  | j                   j                  d      |      }t        j                  |j                  |j
                  |j                  dd      }nt        j                  t        j                  j                         j                  t        j                  j                         j
                  t        j                  t        j                  j                         j                  t        j                  j                         j
                        d   	      j                         }t        j                  |j                  |j
                  |j                  dd      }t        j                  j                  ||g
      }|}t        j                  j                  ||gd      }|j                  d      }|j                  d      }|j                  d      j!                  t#        d            }	|j%                  t#        d            }
|j                  d      j!                  t#        d            }|j%                  t#        d            }t&        j                  j                  ||g      }i dt(        j                  j+                         dt,        j                  j+                         d|d|j/                         d|j/                         d|j%                  t#        d            d|d|d|j1                  d      j%                  t#        d            d|j                  d      j1                  d      j%                  t#        d            dt        j                  j                  ||gd      j                  dddd d!d"      j3                  d#      j!                  t#        d      $      d%|j                  d&d'      j!                  t#        d(      )      d*t        j                  j                  ||gd      j                  d      j!                  t#        d            d+|	d,|
d-|d.|t        j                  j                         | j4                  j7                         |j                  d(      j%                  t#        d(      )      d/}| j                   j                  d0      rt9        d1|      S t;        | d2|      S )3Nr   r   r   )rM   rL   rK   rN   rO   r      ;   rH   )rM   rL   rK   )fecha__rangeT)r   r   F)orden__pago_electronicoitems__codigor(   )nota__orden__fecha__rangerR   rS   r   nordenesanuladastotal_anuladas)r(   total_general)r   total_verificador   total_rubrosr   items__avaluo__desdeitems__avaluo__hastaitems__tonelaje__desdeitems__tonelaje__hastarl   )r   total_rubros_notas_creditorn   r#   rg   )rg   	agrupadosefectivototal_efectivori   total_electronico)r=   usuariototal_notas_creditoimpzfacturacion/resumen.htmlz$facturacion/reporte_recaudacion.html)r,   r-   r>   r   rM   rL   rK   r?   rq   rr   r@   r   r*   r+   r   valuesannotater   	aggregater   r	   rs   r   ry   r   r   userget_full_namer   r   )r6   formator   r   r   r   pagospagos_e
pagos_elecr   r   ri   r   notas_creditorA   s                  r:   reporte_facturacionr      s	   G{{t''(=wGBGG288aXYZ""$BGG288aXYZ{{t''(=wGBGG288bY[\H$5$5$9$9$;$@$@HYHYH]H]H_HeHe#+#6#6x7H7H7L7L7N7S7SU]UfUfUjUjUlUrUr#s#$$&''+tv 	 BGG288bY[\&&RH&=GH



%
%2r(RV
%
WELLL7G||D|9J^^O,55c'lCH$$S\2N##O4==c'lKK",,S\:$,,33rSUh3WMW__((*m++//1 	7 	GMMO	
 	HNN$ 	(,,3w<,@ 	b 	b 	$7AAGAU 	GNN$N7???NXX_bcj_kXl 	,,33R`d3e	!57MOe((
* 
*		s7|	,!" 	%m&:&:8M&R&[&[befmbn&[&o#$ 	\))00b"X]a0bii%XL
', 	8-. 	/0 	{12 	.34 ""&&(<<--/+227;EECPWLEY9H< {{u7BBgExPPrC   )%r>   r4   django.contribr   django.db.modelsr   django.httpr   r   django.shortcutsr   django.views.decorators.csrfr   Consultas.modelsr	   Facturacion.modelsr
   r   r   r   r   r   Oficios.modelsr   TransitoApp.snnipersr   rq   
sri.modelsr   	sri.viewsr   r;   rB   r   r   r   r    rC   r:   <module>r      sh      #   : # 4 $ o o ( .  $ !
9KxD Z; Z;z(YV?6=QrC   