!5Zc@sddklZddkTddkTddklZddkTddklZddk l Z ddk l Z ddk TddkTddklZddklZdd klZdd klZdd kiZdd kZdd klZdd kZdd klZe dddZ!e dddZ"ee dddZ#e dddZ$e dddZ%dZ&e dddZ'e dddZ(e dddZ)e dddZ*edge dddZ+dZ,dZ-dZ.e dddZ/e ddd Z0e ddd!Z1e ddd"Z2e ddd#Z3e ddd$Z4e ddd%Z5d S(&i(treverse(t*(tmessages(tapi_view(tResponse(tstatus(t transaction(thttp(t get_template(tContextN(t smart_str(t csrf_exemptt login_urls/logincCs[tii}tiiid}hdd6|d6|d6}td|dt|S(Ntmarcatactivetreg_programaciont municipiost vehiculossprogramacion_entrega.htmltcontext_instance(t Municipiotobjectstallt CatVehiculotorder_bytrender_to_responsetRequestContext(trequestRRtcontexto((sC/opt/public_html/insumos_test/apps/programacion_de_entrega/views.pytprogramacion_entregasc)Csd}d}d}d} tiiddid} tiidd} tiiidd} tiidt dd } y%t ii d |d |d |}Wnt i j onXy%t ii d |d |d |}Wnt i j onXy:tii dt d d}tii dt d d}Wnti j onXtii d|}tiid|i}|id|}h}h}xR|D]J}g}d}d}d}x)|iiD]}|ii|ijox|iiD]}|i|iijo|it jox|iiD]}||ijo||ijo|i}|djp|djp |djo|t|id}n|t|id}tiid|iidjo|idjo|idjo d}nl|id}|djo|id}nA|djo|idd}n|djo|id}n||}n?tii d|i}|i }|i!}||}||}|djp|djp |djo|id}n|id}|i"} |i"}!t#| d}"t#|t#|"}#t#|!|}$|#|$}t$t|||i<|ddjot$|dd}%n't$|ddt$|dd}%|djo|%||i%s( RR trendertStringIOtpisat pisaDocumenttencodeterrRR{tgetvaluetcgitescape(t template_srct context_dictttemplatetcontextthtmltresulttpdf((sC/opt/public_html/insumos_test/apps/programacion_de_entrega/views.pyt render_to_pdf:s   * c% CsStiid|d|d|}tiiddd|d|d|id }tiid |}tiid |}tiiddd|d|d|}d } d } d } h} h} h}x`|D]X}tiid |iddd|d|d|}x|D]}tiid |i }t iid |i i d jod|i jo djno d}nl|i d}|d jo|i d}nA|djo|i dd}n|djo|i d}n|idjp |idjp|idjo|id}q_|id}n+t iid |i }|i}|i}|d joS|dd jot|dd}qt|ddt|dd}n| |d} | |d} | |} t|| |i R?RBRqRyRsRORPRQRRR$RNRSRTRWtpromotorR(%RR$R%RRRRRRtgloballechesueltatgloballechepaquetet globalpaqueteRRRtptentregaescuelaRRRcR^RdRktentregaaRRRtdiccionariopaqalimentariootdiccionariolecheetentregaescuelaatescuelaatabastoot resultadoott_lecheet dotacionnttot_ent_lecheeR((sC/opt/public_html/insumos_test/apps/programacion_de_entrega/views.pytprogramacion_mes_pdfDs!    %!     0   *  %      0   * & cCs\|idjot|i}|io|iid}|iid}|iid}|iid}tiid|dd}|iid }|iid }|iid } |iid } |iid } |djo d}ntiid | } tiid|i }t iid|i i } t iid| } t iid|d|d| i}d}d}d}d}d}xv|D]n}|iidjoKtiid|iidjo|djp|djp |djod|i}nd|i}|t|}|ddjot|dd}qt|ddt|dd}qtiid|i}|i}||}|ddjot|dd}qt|ddt|dd}q|iidjotiid|iidjo|idjo|idjo d }nl|id}|djo|id}nA|djo|idd }n|djo|id}n||}qtiid|i}|i}||}qqW|djod}d}nxt|ddjo.t|d}tt|dd}n3tt|ddtt|dd}h| d!6|d6|d 6|d6|d6| d"6|d#6|d$6|d%6|d&6|d 6|d'6| d 6| d 6}td(|Sn t}hd)d)6|d*6}td+|d,t|S(-NtPOSTtfolioR%R$tproductot tipoPaqueteRtTRUEtcantidadtnopedidoRHt licitaciont nocontratotR)t%escuela__localidad__municipio__nombreiR'R.R+R,R-iii tPAQUETESs PAQUETES y s BOTES SUELTOSR(ii it proveedortproyectotpaquetettotal_litros_lechet paq_lechet total_paquetet cant_prodsreporte_vales_salida_pdf.htmlRRsvales_salida.htmlR(tmethodRRtis_validRBRERR;t CatProyectoR)t CatProveedorRRRyR=RIRtclaveRORPRQRNRMRWRTRRRSRR(RRRR%R$tpaqRRRRHRRRRRt total_ninosRRRtimporte_total_paquete_estadoRbRdRcRtaR((sC/opt/public_html/insumos_test/apps/programacion_de_entrega/views.pytreporte_vales_salida_pdfs   $%' *  *%         2& c Cs,|idjot|i}|io|id}|id}|id}d}tiiddd|d|d |d d }tiid |i}t d h|d6|d6|d6|d6|d6|d6dt |St i |dn0t}h|d6}t d|dt |SdS(NRRHR$R%itescuela__ruta__pktprogramacion__municipioRRRRrR*smostrardevolucion.htmlRYR/t resguardosRsCorrija los siguientes erroresRsdevolucionbusqueda.html( RtDevolucionFormRRR<RR=RFR>RRRterror( RRRHR$R%RYRR/t diccionario((sC/opt/public_html/insumos_test/apps/programacion_de_entrega/views.pyt devolucion6s    -D  c Cstiid|i}tiid|d|d|d|dd}tdh|d 6|d 6|d 6|d 6|d 6|d6dt|S(NR*RRRRRRrsmostrardevolucion.htmlRYR/R%R$RRHR(RFRR=R>R<RR(RRHR$R%RYR/R((sC/opt/public_html/insumos_test/apps/programacion_de_entrega/views.pytestatus_abastoMs-Ruc CsA|iid}|iid}|iid}|iid}|iid}d}yxq|D]i}|id}tiid|d } |d jod| _d }nn|d jo@| i|jo| i |jo t | _n d| _d }n!|djot | _d}n| i t iid|ddd} |d jo d| _nb|d jo:| i|jo| i |jo d| _qd| _n|djo d| _n| i qjWti} hdd6|d6|d6} Wn2tj o&} hdd6dd6} ti} nXt| d| S(Ns check_lista[]R$R%RYtaccionRt-R)it1s"Se marco el abasto como resguardo t2sSe devolvio el abastot3s"Se marco el abasto como entregado iRRrRt DEVOLUCIONt ENTREGADORtmensajeisocurrio un error(RuRvRBtsplitRyRR;RXR$R%tFalseR@RxR<RRt HTTP_200_OKt ExceptiontHTTP_500_INTERNAL_SERVER_ERRORR(Rt check_listaR$R%RYRRtcRtinstanciaregistroabastotinstanciaprogramaciontstRte((sC/opt/public_html/insumos_test/apps/programacion_de_entrega/views.pytcrear_estatus_abastoTsN                     c Cstiid|}|i|jo|i|jot|_|itiid|}d|_ |itii d|i i d|d|dd}t i|dtd h|d 6|d 6|d 6d t|Sd|_|itiid|}d|_ |itii d|i i d|d|dd}t i|dtd h|d 6|d 6|d 6d t|SdS(NR)RRRRRRrsSe devolvio el abastosmostrardevolucion.htmlR%R$RRR(RyRRBR$R%RRXRxR<RR=RqRHRRRRR;(RtidratprotmRRtinstanciadevolucionR((sC/opt/public_html/insumos_test/apps/programacion_de_entrega/views.pytdevolvers$     -/    -c Cstiid|}t|_|itiid|dd}d|_|itiid|i i d|d|dd}t i |dt d h|d 6|d 6|d 6d t|S(NR)RRrRRRRs!Se marco el abasto como entregadosmostrardevolucion.htmlR%R$RR(RyRRBR@RXRxR<RR=RqRHRtinfoRR(RRRRRRRR((sC/opt/public_html/insumos_test/apps/programacion_de_entrega/views.pyt entregados    -c Cstiid|}d|_|itiid|dd}d|_|itiid|i i d|d|dd}t i |dt d h|d 6|d 6|d 6d t|S(NR)RRrRRRRs!Se marco el abasto como resguardosmostrardevolucion.htmlR%R$RR(RyRRBR;RXRxR<RR=RqRHRtwarningRR(RRRRRRRR((sC/opt/public_html/insumos_test/apps/programacion_de_entrega/views.pyt resguardos    -cCs5tii}h|d6}td|dt|S(NRsbuscar_e_programacion.htmlR(RRRRR(RRR((sC/opt/public_html/insumos_test/apps/programacion_de_entrega/views.pytprogramacion_buscar_es cCstiid|}tiid|i}|idt|}tiitddtddBd|d|d|i d }|idd} |idd} t iitd d td dBd |d |} h} h} xc|D][}g}g}x|i i D]}|ii|ijox|ii D]}x|D]}|i|iijo|itjo4|i|ijo!|idjo|i|q|itjo4|i|ijo!|idjo|i|qqQqQWqDWqqW|djot|| |iRMR<tQRRyR;RGRRHRIRJRKRR@RPR}RtappendtlenRR(RRHR$R%RYRR/R:RRRRR R RKttotalescuelasentregadottotalescuelasresguardoRaRtprogR((sC/opt/public_html/insumos_test/apps/programacion_de_entrega/views.pyt estatus_progsN  33  I c*Cs|idjoat|i}|ioA|iid}|iid}|iid}tiid|}tiid|i }d}h}h} h} h} h} h} y%t iid|d|d|}Wnt i j onXt iid|d |d |i d id d }tiid|d|d|}x|D]}d}d}d}x{|D]s}d}d}|oxW|D]}|ii|iijod}d}d}|iii|ijow|i}|i}||}||}||i}|djo||}|ddjot|dd}n't|ddt|dd}|ddjot|dd}qt|ddt|dd}nt|| t|iiR;RARCR<texcludet NivelaciontprogramacionentregaRPRqRRKttotal_paquetest total_lechesRZRWRMRR@RLRRsRORQt litros_lechetpaquete_alimentarioRSRTRERVRURR(*RRR$R%tmunRHR:R9RRRR RRRRRKtglobal_total_paquetetglobal_total_lechestglobal_tonelajeRt total_lecheRtnttotal_paquete_nivelacionttotal_paquete_lechettotal_tonelajeRtlechettotal_leche_escuela_rutat leche_totaltescuelaentregaRtregistroRdRcRet pesoporlechet tonelajelechettonelajepaqueteRZR((sC/opt/public_html/insumos_test/apps/programacion_de_entrega/views.pytbusqueda_nivelacion s %6!       &*  %%         &&!  %a c<Cs tiid|}tiid|i}h}h}h}yMtiidtdd}tiidtdd} t|i d} Wnti j onXt iid|d |d |d d id } x#|D]} d} d}d}xN| D]F}| i |i ii jo| d} nt| |t| i RER@RVRURCR<RPRRKRMRqRIRRLRRsRORQR'R(RSRTt iteritemsR#R7R R tcreateRWRZR$R&R%RxRRtHttpResponseRedirect(<RRHR$R%R:RR tdiccionariocarroxrutat leche_pesot paquete_pesoR7RRKt carroxrutaR*R+RR-RR5RR6R2RRdRcRetleche_total_excedenteRR;R@R4t leche_nivelart leche_residuotleche_redondeadot leche_sueltatleche_tonelajetpaquete_nivelartpaquete_residuotpaquete_redondeadotpaquete_tonelajeRZtleche_total_antiguatexcesotleche_divisiontleche_division_residuotleche_division_totaltleche_total_restatleche_total_sueltat carro_rutatnivelarR3Rttontcarro_leche_viejotcarro_tonelaje_viejot carro_lechetcarro_leche_tonelajetcarro_paquete_tonelajetcarro_tonelaje((sC/opt/public_html/insumos_test/apps/programacion_de_entrega/views.pyRsB0!%        !    7                   4             &             *           (   -c CsUtiid|}tiid|d|d|id}h}h}h}h}h} tiid|d|d|d d id } tiid |d |d|} x8|D]0} d} d}x| D]}d}d}tiid |ii}| ox| D]}d}|i i|iijod}d}|i i i| i ijoc|i }|i }||}||}|djo||}|ddjot|dd}n't|ddt|dd}|ddjot|dd}q5t|ddt|dd}nt||t|iiR<RqRPR$RRKR%R&RWRMRZRR(RRHR$R%R:RRRR RcRRRKR*R+RR-RR5R.RR/R0R2R3R4R((sC/opt/public_html/insumos_test/apps/programacion_de_entrega/views.pytimprimir_nivelacions\*0!      &*  0ScCsjtiid|}t}||_||_||_t|_|it d|d|d|S(NR)s/programacion_entrega/s and ( RRRBRAR$R%R@RRxRC(RR|R$R%RHR9((sC/opt/public_html/insumos_test/apps/programacion_de_entrega/views.pyR1s      c- Cs4|idjot|i}|io|iid}|iid}tii}h}h}h}h}h} h} h} h} h} h}d}d}d}d}d}d}d}d}d}d}xX|D]P}d}d}d}d}d}d}d} d}!d}"d}#tii d|d|d|dd }$t ii d |d|d|}%xe|%D]]}&||&i }||&i }xE|$D]=}'|&i |'ijo$||&i }||&i }qqW|&idjo$||&i }||&i }ntii d |&i idjotiid |&i }(|d jp|d jp |djot|&id})n|&id})|(i|)jo| |(i|)} n&|(i|)jo|!|)|(i}!n|&idjo|&idjo d}*nl|&id}*|*djo|&id}*nA|*djo|&idd}*n|*djo|&id}*n|*}+|(i|+jo|"|(i|+}"q|(i|+jo|#|+|(i}#qqoqoWt||t|i sR       S  f / #   5@