ZXUc@sddlmZddlTddlTddlmZddlTddlTddlTddl m Z ddl m Z ddl mZddljZddlZddlmZddlZdd lmZed d d Zed d d ZedZed d dZdZdZed d dZdZ dZ!dZ"dZ#dZ$ed d dZ%ed d dZ&dZ'dZ(dZ)dZ*dZ+dS(i(treverse(t*(tmessages(thttp(t get_template(tContextN(t smart_str(t csrf_exemptt login_urls/logincCs[tjj}tjjjd}idd6|d6|d6}td|dt|S(Ntmarcatactivetreg_programaciont municipiost vehiculossprogramacion_entrega.htmltcontext_instance(t Municipiotobjectstallt CatVehiculotorder_bytrender_to_responsetRequestContext(trequestR R tcontexto((s8/home/paco/insumos/apps/programacion_de_entrega/views.pytprogramacion_entregasc' Cs5d}d}d}d}tjjddjd} tjjdd} tjjd|}t|jd} t jjdt dd } y%t jjd |d |d |}Wnt j k rnXy%t jjd |d |d |}Wnt j k rnXy:tjjdt d d} tjjdt d d}Wntj k rVnXtjjd|}tjjd|j}i}i}x|D]}g}d}d}d}x|jjD]}|jj|jkrx|jjD]}|j|jjkr|jt krx{|jjD]g}||jkr||jkr|j}|dks~|dks~|dkr|t|jd}n|t|jd}tjjd|jjdkrl|j dkr|j dkrd}ne|j d}|dkr#|j d}n<|dkrC|j dd}n|dkr_|j d}n||}n>tjjd|j}|j!}|j"}||}||}|dks|dks|dkr|jd}n |jd}| j#}|j#}t|d} t|t| }!t||}"|!|"}t$t|||j<|ddkr}t$|dd}#n&t$|ddt$|dd}#|dkr|#||jtjjd|%j}|j!}|j"}||}||}|%jdks|%jdks|%jdkr|%jd}n |%jd}| j#}|j#}t|d} t|t| }!t||}"|!|"}t$t|||%j<|ddkrDt$|dd}#n&t$|ddt$|dd}#|dkr|#||j%s( RRtrendertStringIOtpisat pisaDocumenttencodeterrRRutgetvaluetcgitescape(t template_srct context_dictttemplatetcontextthtmltresulttpdf((s8/home/paco/insumos/apps/programacion_de_entrega/views.pyt render_to_pdf2s   * cCs_dGHtjjd|d|}tjjddd|d|jd}tjjd |}tjjd |}tjjdd}d }d } d } i} i} i} x:|D]2}tjjd|jdd}x |D]}tjjd |j }t jjd |j j d kr|j d krH|j dkrHd}ne|j d}|d krq|j d}n<|d kr|j dd}n|d kr|j d}n|jdks|jdks|jdkr|jd}q$|jd}n*t jjd |j }|j}|j}|d kr|dd krWt|dd}qt|ddt|dd}n| |d} ||d}| |} t|| |j |jtkr|j|jkr|jdkr| j|qq>q>Wq1WqqW| d krt| | | jR?R6texcludet NivelaciontprogramacionentregaRLRkRRGttotal_paquetest total_lechesRTRRRIRR=RHRRmRKRMt litros_lechetpaquete_alimentarioRORPRAR:RQRR(*RRR R!tmunRDR4R3RRRRRRRRRGtglobal_total_paquetetglobal_total_lechestglobal_tonelajeRt total_lecheRtnttotal_paquete_nivelacionttotal_paquete_lechettotal_tonelajeRtlechettotal_leche_escuela_rutat leche_totaltescuelaentregaRtregistroR^R]R_t pesoporlechet tonelajelechettonelajepaqueteRTR((s8/home/paco/insumos/apps/programacion_de_entrega/views.pytbusqueda_nivelacions %6!          &)  # $           &&  $a c<Cstjjd|}tjjd|j}i}i}i}yMtjjdtdd}tjjdtdd} t|j d} Wntj k rnXt jjd|d |d |d d jd } x|D] } d} d}d}xL| D]D}| j |j jj kr'| d} nt| |t| j R R!R=RRrR(RRvR R!RDR3((s8/home/paco/insumos/apps/programacion_de_entrega/views.pyR*Vs      c- Cs|jdkrt|j}|jr|jjd}|jjd}tjj}i}i}i}i}i} i} i} i} i} i}d}d}d}d}d}d}d}d}d}d}x=|D]5}d}d}d}d}d}d}d} d}!d}"d}#tjj d|d|d|dd }$t jj d |d|d|}%xJ|%D]B}&||&j }||&j }xC|$D];}'|&j |'jkr||&j }||&j }qqW|&jdkr ||&j }||&j }ntjj d |&j jdkrmtjjd |&j }(|d ksk|d ksk|dkrt|&jd})n |&jd})|(j|)kr| |(j|)} n#|(j|)kr|!|)|(j}!n|&jdkr|&jdkrd}*ne|&jd}*|*dkr$|&jd}*n<|*dkrD|&jdd}*n|*dkr`|&jd}*n|*}+|(j|+kr|"|(j|+}"q|(j|+kr|#|+|(j}#qqmqmWt||t|j sB       S  H e  #   I ?