!5Zc!@soddklZddklZddkZddkTddkTddklZddk l Z l Z l Z ddk lZddkTddklZddkTdd klZdd klZdd klZdd klZdd klZddklZddki Z ddk!Z"ddk#Z#ddk$l$Z$ddk%l&Z&ddk'Z'ddk(l)Z)l*Z*l+Z+ddk,l-Z-ddk.l/Z/ddk0l1Z1ddk2l3Z3ddk4l5Z5l6Z6ddk7l8Z8l9Z9de:fdYZ;e<dddZ=e<dddZ>e<dddZ?e<dddZ@e<ddd ZAe<ddd!ZBe&d"ZCe&d#ZDe<ddd$ZEe<ddd%ZFe<ddd&ZGe<ddd'ZHe&d(ZIe<ddd)ZJe<ddd*ZKe<ddd+ZLe<ddd,ZMe<ddd-ZNe<ddd.ZOd/ZPe<ddd0ZQe<ddd1ZRd2ZSe<ddd3ZTe<ddd4ZUd5ZVe<ddd6ZWe<ddd7ZXe<ddd8ZYe<ddd9ZZe&d:Z[d;Z\e<ddd<Z]e<ddd=Z^d>Z_e<ddd?Z`e<ddd@Zae<dddAZbe<dddBZce<dddCZde<dddDZedEZfe&dFZge<dddGZhe<dddHZie<dddIZje<dddJZke&dKZle<dddLZme<dddMZne<dddNZoe<dddOZpe<dddPZqdQZre<dddRZsdSZtdTZudUZvdVZwdWZxdXe1fdYYZye<dddZZze&d[Z{e<ddd\Z|e<ddd]Z}e<ddd^Zze<ddd_Z~e<ddd`Ze<dddaZdbe fdcYZdde1fdeYZdfZdgZdhZe<dddiZdde1fdjYZdkZdlZdmZdnZdoe e;fdpYZdqe fdrYZdse e;fdtYZdue fdvYZdS(wi(tBytesIO(tcanvasN(t*(t simplejson(t TemplateViewtFormViewtView(t JasperClient(tmessages(tQ(tUserCreationForm(tGroup(thttp(t get_template(tContext(tdatetime(t csrf_exempt(t Paginatort EmptyPagetPageNotAnInteger(t smart_str(t serializers(t ListAPIView(tResponse(tAPIViewtstatus(tCatEscuelaSerializertEscuelaSerializert JasperMixcBs)eZdZdZdZhddZRS(s6http://10.2.8.36/jasperserver/services/repository?wsdlt jasperadmincCslt|i|i|i}|i||pdn||}t|d}|i|d|idS(s Gennara reportes atravez del jasperserver :param path: :param namefile: :param params: :param tipo: default is PDF tPDFtwtdataN(Rturltusernametpasswordt runReporttfiletwritetclose(tselftpathtnamefiletparamsttipotjtrettf((s3/opt/public_html/insumos_test/apps/control/views.pytgenerateReport.s #N(t__name__t __module__R!R"R#tNoneR0(((s3/opt/public_html/insumos_test/apps/control/views.pyR)st login_urls/logincCs-hdd6dd6}td|dt|S(NsEste es la vista principaltmsjtactivet principalsprincipal.htmltcontext_instance(trender_to_responsetRequestContext(trequesttcontexto((s3/opt/public_html/insumos_test/apps/control/views.pyR7BscCs|i}d}d}y.tiid|}|i}|ii}Wntij onX|djo&|djot ii d|}nt ii }d}d|i jo|i id}nt ||}|i id}y|i|}WnFtj o|id}n&tj o|i|i}nX|idjot|i|i} | ioy_ti|iid d } t iid | d |iid } d } ti|| Wnt ij o d} nX| djo+| id } ti|| tdSqd} ti|| nh|djo|djoti dddt!dt"ii dt#d|dti$dhdd6ti%d R?RBRDtmestanosEL REGISTRO DE ABASTO YA EXISTEtcommits.EL REGISTRO DE ABASTO SE REALIZO CORRECTAMENTEs/registro_abasto/RERFsSeleccione un promotorRGRHRMRNRORJRKsrequired span6 select2-selectRLRPsrequired span7 select2-selectR6RRRQsregistro_abasto.htmlR8(RTR3RURVRWRORXRYRZtRegistroAbastoR\R]R`tRegistroAbastoFormRBRcRReRfRlRgRhRiRjRkRoRpR9R:( R;R=RORqRrtabastoRQRtR5taR<((s3/opt/public_html/insumos_test/apps/control/views.pytregistro_abastosH   E   SM c Cstii}d}|i}d}d} |iido|iidnd} y.tiid|} | i}| i i } Wnti j onX|djoU| djoH|djot ii d|d|idd } | djo| i td | td | Btd | Btd | Btd| Btd| Btd| Btd| Btd| B} qq|djot ii d|d|idd } | djo| i td | td | Btd | Btd | Btd| Btd| Btd| Btd| Btd| B} qqt ii d|idd } | djo| i td | td | Btd | Btd | Btd| Btd| Btd| Btd| Btd| B} qnd}|djot ii d|idd } | djo| i td | td| Btd | Btd | Btd | Btd| Btd| Btd| Btd| Btd| B} qn*|djot ii d|idd } | djo| i td | td| Btd | Btd | Btd | Btd| Btd| Btd| Btd| Btd| B} qnZ|djot ii d|idd } | djo| i td | td| Btd | Btd | Btd | Btd| Btd| Btd| Btd| Btd| B} qn|djot ii d|idd } | djo| i td | td| Btd | Btd | Btd | Btd| Btd| Btd| Btd| Btd| B} qnt iiidd } | djo| i td | td| Btd | Btd | Btd | Btd| Btd| Btd| Btd| Btd| B} n|iidot|iidnd} t| | }|iid}y|i|} WnFtj o|id} n&tj o|i|i} nXh| d6|d6|d6dd6| d6| d6}td|d t|S(!NttbscrR=R>t0R?Rs-mess-anotescuela__nombre__icontainstpromotor__nombre__icontainst$promotor__apellidoPaterno__icontainst$promotor__apellidoMaterno__icontainstano__icontainstmes__icontainst%escuela__localidad__nombre__icontainstescuela__grado__icontainstescuela__clave__icontainsR~tadministraciont0escuela__localidad__municipio__nombre__icontainst!escuela__localidad__municipio__idtrppi RAit municipiosR6RRRsconsultas_abasto.htmlR8(t MunicipioRVR]RTR3R^RWRURORXRYRZRR\RyR tintRRARRR_R9R:(R;RR~t municipio_idtgradoRRR=RORqRRrRRRsRAR<((s3/opt/public_html/insumos_test/apps/control/views.pytconsultas_abastos ,  ' g ' g! g ! t ! t ! t ! t t20cCs|io|id}|dj otiid|}g}|iht|ii d6t|i d6t|i d6t|i d6t|i d6t|id6ti|}qnt|d d S( NtqRvRDtninastninost total_ninost ninos_lechet total_madrestmimetypesapplication/javascript(tis_ajaxRBR3RRVRWtappendtstrRDtnombreRRt totalNinosttotalNinosLechet totalMadrestjsontdumpst HttpResponse(R;RRtlisttrecipe_list_json((s3/opt/public_html/insumos_test/apps/control/views.pytconsulta_detalle_abastoxs    c Cs|io|id}|dj og}tiitd|td|Btd|Btd|Btd|BD][}|td|idt |i d t |i d t |i d t |i q{~}tti|d d SndS( NRtnombre__icontainstfolio__icontainstclave__icontainstlocalidad__nombre__icontainst'localidad__municipio__nombre__icontainstidttexts - t content_typesapplication/json(RR^R3RmRVR\R tdictRvRtlocalidad__municipio__nombretlocalidad__nombreRRYRRR(R;tparamRt_[1]tctresp((s3/opt/public_html/insumos_test/apps/control/views.pyt escuela_ajaxs   3ucCstiiidd }tiid|}|idjotd|}n|idjogt|id|}|io+|i d}t i ||t dSd }t i ||n t}h|d 6d d 6|d 6|d6}td|dt|S(Ns-idi RvR^RwRBs!EL ABASTO SE EDITO CORRECTAMENTE.s/consultas_abasto/0/0/0/0RERQR6RRtabasRsregistro_abasto.htmlR8(RRVR]RyRWR`RRBRcRfRRgRhRiR9R:(R;t id_abastoRRRQR5R<((s3/opt/public_html/insumos_test/apps/control/views.pyt editar_abastos     "cCs)tiid|}|itdS(NRvs/consultas_abasto/0/0/0/0(RRVRWR|Rh(R;RR((s3/opt/public_html/insumos_test/apps/control/views.pyt borrar_abastos c Cs1|idjot|i}|ioyZtiitd|iidtd|iidB}d}ti ||Wnti j o d}nX|djo+|i d}ti ||tdSqd}ti||n t}h|d 6d d 6}td |d t|S(NRBRYRtfoliosLA ESCUELA YA EXISTEs2EL REGISTRO DE LA ESCUELA SE REALIZO CORRECTAMENTEs/registro_escuela/RERQR6t reg_escuelasregistro_escuela.htmlR8(R`tRegistroEscuelaFormRBRcRmRVRWR RReRZR3RfRgRhRiR9R:(R;RQRtR5R<((s3/opt/public_html/insumos_test/apps/control/views.pytregistro_escuelas& @    c Cs|iido|iidnd}tii}|djovtiid|}|djoP|itd|td|Btd|Btd|Btd |B}q*nmtii}|djoP|itd|td|Btd|Btd|Btd |B}n|iid ot|iid nd }t ||}|iid }y|i |}WnFt j o|i d }n&t j o|i |i }nXh|d6|d6dd6|d6|d 6}td|dt|S(NRRRtlocalidad__municipio__idRRRRRRi RAiRR6RRDsconsultas_escuelas.htmlR8(R^RWRRVR]RmR\R RRRARRR_R9R:( R;RRRRDRRsRAR<((s3/opt/public_html/insumos_test/apps/control/views.pytconsultas_escuelass0,  3 32)cCs|io|id}|dj otiid|}g}|iht|id6t|i d6t|i d6t|i d6t|i d6t i|}qnt|dd S( NRRvt localidadRYRRt observacionRsapplication/javascript(RRBR3RmRVRWRRRRYRRRRRR(R;RRDRR((s3/opt/public_html/insumos_test/apps/control/views.pytconsulta_detalle_escuelas    cCstiiidd }tiid|}|idjotd|}n|idjogt|id|}|io+|i d}t i ||t dSd }t i ||n t}h|d 6d d 6|d 6|d6}td|dt|S(Ns-idiRvR^RwRBs"LA ESCUELA SE EDITO CORRECTAMENTE.s/consultas_escuelas/0RERQR6Rtultimostescuela_sregistro_escuela.htmlR8(RmRVR]RyRWR`RRBRcRfRRgRhRiR9R:(R;t id_escuelaRRDRQR5R<((s3/opt/public_html/insumos_test/apps/control/views.pyteditar_escuela&s     "cCs2tiid|}t|_|itdS(NRvs/registro_escuela/(RmRVRWRlRRfRh(R;RRD((s3/opt/public_html/insumos_test/apps/control/views.pytbloquear_escuela@s  cCs2tiid|}t|_|itdS(NRvs/registro_escuela/(RmRVRWRnRRfRh(R;RRD((s3/opt/public_html/insumos_test/apps/control/views.pytdesbloquear_escuelaHs  c CsGtii}|idjot|i}|ioyZtiitd|iidtd|iidB}d}t i ||Wnti j o d}nX|djo+|i d}t i||tdSqd}t i||n t}h|d6d d 6|d 6}td |d t|S(NRBRYRsLA OBSERVACION YA EXISTEs6EL REGISTRO DE LA OBSERVACION SE REALIZO CORRECTAMENTEs/registro_observaciones/RERQR6Rt observacionessregistro_observaciones.htmlR8(tCatObservacionesRVR]R`tRegistroObservacionesFormRBRcRWR RReRZR3RfRgRhRiR9R:(R;RRQRtR5R<((s3/opt/public_html/insumos_test/apps/control/views.pytregistro_observacionesPs( @    cCstii}tiid|}|idjotd|}n|idjogt|id|}|io+|id}t i ||t dSd}t i ||n t}h|d6d d 6|d 6|d 6}t d |dt|S(NRvR^RwRBs&LA OBSERVACION SE EDITO CORRECTAMENTE.s/registro_observaciones/RERQR6RRRsregistro_observaciones.htmlR8(RRVR]RWR`RRBRcRfRRgRhRiR9R:(R;tid_observacionRRRQR5R<((s3/opt/public_html/insumos_test/apps/control/views.pyteditar_observacionps     "cCs)tiid|}|itdS(NRvs/registro_observaciones/(RRVRWR|Rh(R;RR((s3/opt/public_html/insumos_test/apps/control/views.pytborrar_observacions c CsGtii}|idjot|i}|ioyZtiitd|iidtd|iidB}d}t i ||Wnti j o d}nX|djo+|i d}t i||tdSqd}t i||n t}h|d6d d 6|d 6}td |d t|S(NRBtnumeroProyectoROsEL PROYECTO YA EXISTEs1EL REGISTRO DEL PROYECTO SE REALIZO CORRECTAMENTEs/registro_proyectos/RERQR6t reg_proyectost proyectossregistro_proyectos.htmlR8(t CatProyectoRVR]R`tRegistroProyectosFormRBRcRWR RReRZR3RfRgRhRiR9R:(R;RRQRtR5R<((s3/opt/public_html/insumos_test/apps/control/views.pytregistro_proyectoss( @    cCstii}tiid|}|idjotd|}n|idjogt|id|}|io+|id}t i ||t dSd}t i ||n t}h|d6d d 6|d 6|d 6}t d |dt|S(NRvR^RwRBs#EL PROYECTO SE EDITO CORRECTAMENTE.s/registro_proyectos/RERQR6RRtproyectosregistro_proyectos.htmlR8(RRVR]RWR`RRBRcRfRRgRhRiR9R:(R;t id_proyectoRRRQR5R<((s3/opt/public_html/insumos_test/apps/control/views.pyteditar_proyectos     "cCs)tiid|}|itdS(NRvs/registro_proyectos/(RRVRWR|Rh(R;RR((s3/opt/public_html/insumos_test/apps/control/views.pytborrar_proyectos c Cs(tii}|idjot|i}|ioy;tiid|iid}d}ti ||Wnti j o d}nX|djo+|i d}ti ||tdSqd}ti||n t}h|d6dd 6|d 6}td |d t|S( NRBtnumPlacasLA VEHICULO YA EXISTEs1EL REGISTRO DEL VEHICULO SE REALIZO CORRECTAMENTEs/registro_vehiculos/RERQR6t reg_vehiculost vehiculossregistro_vehiculos.htmlR8(t CatVehiculoRVR]R`tRegistroVehiculosFormRBRcRWRReRZR3RfRgRhRiR9R:(R;RRQRtR5R<((s3/opt/public_html/insumos_test/apps/control/views.pytregistro_vehiculoss( !    cCstii}tiid|}|idjotd|}n|idjogt|id|}|io+|id}t i ||t dSd}t i ||n t}h|d6d d 6|d 6|d 6}t d |dt|S(NRvR^RwRBs#EL VEHICULO SE EDITO CORRECTAMENTE.s/registro_vehiculos/RERQR6RRtvehiculosregistro_vehiculos.htmlR8(RRVR]RWR`RRBRcRfRRgRhRiR9R:(R;t id_vehiculoRRRQR5R<((s3/opt/public_html/insumos_test/apps/control/views.pyteditar_vehiculos     "cCs)tiid|}|itdS(NRvs/registro_vehiculos/(RRVRWR|Rh(R;RR((s3/opt/public_html/insumos_test/apps/control/views.pytborrar_vehiculo s cCs |idjot|i}t|i}|ionytiid|iidd|iidd|iidd|iidd|iid}d}ti ||Wnti j o d}nX|djo|iid}|iid }|o|o|io|i }|iid}t iid |} | id jo)tiid d } | ii|q| idjo)tiid d} | ii|q| idjo)tiid d} | ii|q| idjo)tiid d} | ii|q| idjo)tiid d} | ii|q| idjo)tiid d} | ii|qqntiid |iid} t iid |iid} t} |iid| _|iid| _|iid| _| | _| | _t| _|o|o || _n| i d}ti||tdSqd}ti||nt}t}h|d6|d6dd6}td|d t|S(!NRBRtapellidoPaternotapellidoMaternoRORXsLA PERSONA YA EXISTER"t password1RvR>tnamet ADMINISTRADORtCORMsCOORDINADOR MUNICIPALtATCsAPOYO TEC. DEL COORDINADORtJATsJEFATURA DE APOYO TECNICOtABTOtABASTOtSUBOPsSUBDIRECCION OPERATIVAs2EL REGISTRO DE LA PERSONA SE REALIZO CORRECTAMENTEs/registro_personas/REtformulario_userRQR6t reg_personassregistro_personas.htmlR8( R`tRegistroPersonasFormRBR RcRURVRWRReRZR3RftCatTipoPersonaRYR tuser_settaddRRRRRORXRnRR=RgRhRiR9R:(R;RQRRtR5R"R#tuser_idt tip_personRqtgrupoRORXRrR<((s3/opt/public_html/insumos_test/apps/control/views.pytregistro_personassr i    !!        c Cs|iido|iidnd}tii}|djovtiid|}|djoP|itd|td|Btd|Btd|Btd |B}q*nmtii}|djoP|itd|td|Btd|Btd|Btd |B}n|iid ot|iid nd }t ||}|iid }y|i |}WnFt j o|i d }n&t j o|i |i }nXh|d6dd6|d6|d 6}td|dt|S(NRRRttipoPersona__idRtapellidoPaterno__icontainstapellidoMaterno__icontainstmunicipio__nombrettipoPersona__nombreRi RAiRqR6Rtpersonassconsultas_personas.htmlR8(R^RWRRVR]RUR\R RRRARRR_R9R:( R;ttipo_persona_idRRqRRRsRAR<((s3/opt/public_html/insumos_test/apps/control/views.pytconsultas_personases0,  3 32"cCstii}tiid|}|idjotd|}n|idjogt|id|}|io+|id}t i ||t dSd}t i ||n t}h|d6d d 6|d 6|d 6}t d |dt|S(NRvR^RwRBs"LA PERSONA SE EDITO CORRECTAMENTE.s/registro_personas/RERQR6RRRrsregistro_personas.htmlR8(RURVR]RWR`RRBRcRfRRgRhReR9R:(R;t id_personaRRrRQR5R<((s3/opt/public_html/insumos_test/apps/control/views.pyteditar_personas     "cCs_tiid|}t|_|idjot|i_|iin|it dS(NRvs/registro_personas/( RURVRWRlRR=R3t is_activeRfRh(R;R Rr((s3/opt/public_html/insumos_test/apps/control/views.pytbloquear_personas   cCs_tiid|}t|_|idjot|i_|iin|it dS(NRvs/registro_personas/( RURVRWRnRR=R3R RfRh(R;R Rr((s3/opt/public_html/insumos_test/apps/control/views.pytdesbloquear_personas   cCssd}|io@|id}|dj o"tiid|id}qSntdh|d6dt|S(NRRR"svalidar_usuario.htmltresultsR8( RRBR3tUserRVR\RyR9R:(R;RR((s3/opt/public_html/insumos_test/apps/control/views.pytvalidar_usuarios    &c CsGtii}|idjot|i}|ioyZtiitd|iidtd|iidB}d}t i ||Wnti j o d}nX|djo+|i d}t i||tdSqd}t i||n t}h|d6d d 6|d 6}td |d t|S(NRBRYRsLA CLAVE O EL NOMBRE YA EXISTEs8EL REGISTRO DEL TIPO DE PERSONA SE REALIZO CORRECTAMENTEs/registro_tipo_persona/RERQR6Rt tipo_personassregistro_tipo_personas.htmlR8(RRVR]R`tRegistroTipoPersonaFormRBRcRWR RReRZR3RfRgRhRiR9R:(R;RRQRtR5R<((s3/opt/public_html/insumos_test/apps/control/views.pytregistro_tipo_personas( @    cCstii}tiid|}|idjotd|}n|idjogt|id|}|io+|id}t i ||t dSd}t i ||n t}h|d6d d 6|d 6|d 6}t d |dt|S(NRvR^RwRBs*EL TIPO DE PERSONA SE EDITO CORRECTAMENTE.s/registro_tipo_persona/RERQR6RRRqsregistro_tipo_personas.htmlR8(RRVR]RWR`RRBRcRfRRgRhRiR9R:(R;tid_tipo_personaRRqRQR5R<((s3/opt/public_html/insumos_test/apps/control/views.pyteditar_tipo_personas     "cCs)tiid|}|itdS(NRvs/registro_tipo_persona/(RRVRWR|Rh(R;RRq((s3/opt/public_html/insumos_test/apps/control/views.pytborrar_tipo_persona s c Cstii}|idjot|i}|ioy;tiid|iid}d}ti ||Wqti j o.|i d}ti ||t dSXqd}ti||n t}h|d6dd 6|d 6}td |d t|S( NRBtnombreProveedors EL PROVEEDOR YA EXISTEs.EL REGISTRO PROVEEDOR SE REALIZO CORRECTAMENTEs/registro_proveedor/RERQR6t reg_productost proveedoressregistro_proveedor.htmlR8(t CatProveedorRVR]R`tRegistroProveedorFormRBRcRWRReRZRfRgRhRiR9R:(R;RRQRtR5R<((s3/opt/public_html/insumos_test/apps/control/views.pytregistro_proveedors$ !  cCstii}tiid|}|idjotd|}n|idjogt|id|}|io+|id}t i ||t dSd}t i ||n t}h|d6d d 6|d 6|d 6}t d |dt|S(NRvR^RwRBs$EL PROVEEDOR SE EDITO CORRECTAMENTE.s/registro_proveedor/RERQR6RRt proveedorsregistro_proveedor.htmlR8(RRVR]RWR`RRBRcRfRRgRhRiR9R:(R;t id_proveedorRRRQR5R<((s3/opt/public_html/insumos_test/apps/control/views.pyteditar_proveedor9s     "cCsktiid|}t|_|itiidt}x!|D]}t|_|iqDWt dS(NRvRs/registro_proveedor/( RRVRWRlRRft CatPaqueteR\RnRh(R;R Rtpaquetestp((s3/opt/public_html/insumos_test/apps/control/views.pytbloquear_proveedorUs   cCs2tiid|}t|_|itdS(NRvs/registro_proveedor/(RRVRWRnRRfRh(R;R R((s3/opt/public_html/insumos_test/apps/control/views.pytdesbloquear_proveedorbs  c Cs(tii}|idjot|i}|ioy;tiid|iid}d}ti ||Wnti j o d}nX|djo+|i d}ti ||tdSqd}ti||n t}h|d6dd 6|d 6}td |d t|S( NRBt presentacions&LA PRESENTACION DEL PRODUCTO YA EXISTEsDEL REGISTRO DE LA PRESENTACION DEL PRODUCTO SE REALIZO CORRECTAMENTEs /registro_presentacion_producto/RERQR6Rtpresentacioness#registro_presentacion_producto.htmlR8(tCatPresentacionProductoRVR]R`t RegistroPresentacionProductoFormRBRcRWRReRZR3RfRgRhRiR9R:(R;R(RQRtR5R<((s3/opt/public_html/insumos_test/apps/control/views.pytregistro_presentacion_productoms( !    cCstii}tiid|}|idjotd|}n|idjogt|id|}|io+|id}t i ||t dSd}t i ||n t}h|d6d d 6|d 6|d 6}t d |dt|S(NRvR^RwRBs4LA PRESENTACION DEL PRODUCTO SE EDITO CORRECTAMENTE.s /registro_presentacion_producto/RERQR6RR(R's#registro_presentacion_producto.htmlR8(R)RVR]RWR`R*RBRcRfRRgRhRiR9R:(R;tid_presentacion_productoR(R'RQR5R<((s3/opt/public_html/insumos_test/apps/control/views.pyteditar_presentacion_productos     "cCs)tiid|}|itdS(NRvs /registro_presentacion_producto/(R)RVRWR|Rh(R;R,R'((s3/opt/public_html/insumos_test/apps/control/views.pytborrar_presentacion_productos c Cs(tii}|idjot|i}|ioy;tiid|iid}d}ti ||Wnti j o d}nX|djo+|i d}ti ||tdSqd}ti||n t}h|d6dd 6|d 6}td |d t|S( NRBRs EL PRODUCTO YA EXISTEs1EL REGISTRO DEL PRODUCTO SE REALIZO CORRECTAMENTEs/registro_productos/RERQR6Rt productossregistro_productos.htmlR8(t CatProductosRVR]R`tRegistroProductosFormRBRcRWRReRZR3RfRgRhRiR9R:(R;R/RQRtR5R<((s3/opt/public_html/insumos_test/apps/control/views.pytregistro_productoss( !    cCs|io|id}|dj otiid|}g}|iht|id6t|i d6t|i d6t|i d6t|i d6t i|}qnt|dd S( NRRvRtcantidadR'tmarcat descripcionRsapplication/javascript(RRBR3R0RVRWRRRR3R'R4R5RRR(R;RtproductoRR((s3/opt/public_html/insumos_test/apps/control/views.pytconsulta_detalle_productos    cCstii}tiid|}|idjotd|}n|idjogt|id|}|io+|id}t i ||t dSd}t i ||n t}h|d6d d 6|d 6|d 6}t d |dt|S(NRvR^RwRBs#EL PRODUCTO SE EDITO CORRECTAMENTE.s/registro_productos/RERQR6RR/R6sregistro_productos.htmlR8(R0RVR]RWR`R1RBRcRfRRgRhRiR9R:(R;t id_productoR/R6RQR5R<((s3/opt/public_html/insumos_test/apps/control/views.pyteditar_productos     "cCs2tiid|}t|_|itdS(NRvs/registro_productos/(R0RVRWRlRRfRh(R;R8R6((s3/opt/public_html/insumos_test/apps/control/views.pytbloquear_productos  cCs2tiid|}t|_|itdS(NRvs/registro_productos/(R0RVRWRnRRfRh(R;R8R6((s3/opt/public_html/insumos_test/apps/control/views.pytdesbloquear_producto s  c CsGtiiidd }|idjot|i}|ioyMtiid|iidd|iid}d}t i ||Wnti j o d}nX|djo+|i d}t i||tdSqd }t i||n t}h|d 6d d 6|d 6}td|dt|S(Ns-idi RBRt tipoPaquetes EL PAQUETE YA EXISTEs0EL REGISTRO DEL PAQUETE SE REALIZO CORRECTAMENTEs/registro_paquetes/RERQR6RR#sregistro_paquetes.htmlR8(R"RVR]RyR`tRegistroPaqueteFormRBRcRWRReRZR3RfRgRhRiR9R:(R;R#RQRtR5R<((s3/opt/public_html/insumos_test/apps/control/views.pytregistro_paquetess( 3    cCs|io}|id}|dj o_tiid|}g}x.|iiD]}|ih|i d6qRWt i |}qnt |ddS(NRRvR5Rsapplication/javascript( RRBR3R"RVRWR6R]RR5RRR(R;RtpaqueteRR$R((s3/opt/public_html/insumos_test/apps/control/views.pytconsulta_detalle_paquete:s    cCstiiidd }tiid|}|idjotd|}n|idjogt|id|}|io+|i d}t i ||t dSd }t i ||n t}h|d 6d d 6|d 6|d6}td|dt|S(Ns-idi RvR^RwRBs"EL PAQUETE SE EDITO CORRECTAMENTE.s/registro_paquetes/RERQR6RR#R?sregistro_paquetes.htmlR8(R"RVR]RyRWR`R=RBRcRfRRgRhRiR9R:(R;t id_paqueteR#R?RQR5R<((s3/opt/public_html/insumos_test/apps/control/views.pyteditar_paqueteNs     "cCs2tiid|}t|_|itdS(NRvs/registro_paquetes/(R"RVRWRlRRfRh(R;RAR?((s3/opt/public_html/insumos_test/apps/control/views.pytbloquear_paqueteks  cCs2tiid|}t|_|itdS(NRvs/registro_paquetes/(R"RVRWRnRRfRh(R;RAR?((s3/opt/public_html/insumos_test/apps/control/views.pytdesbloquear_paquetets  cCs<tii}h|d6dd6}td|dt|S(NRR6RRslista_municipio_abasto.htmlR8(RRVR]R9R:(R;RR<((s3/opt/public_html/insumos_test/apps/control/views.pytlista_municipio_abasto~sc&Csd}d}d}tiid|d|d|}tiid|d|d|} y%tiid|d|d|}Wntij onXtiid |} t iid |i } h} h} h}h}h}h}h}| id |}x|D]w}g}d}d}d}d}xF|i i D]5}|i i| ijox|ii D]}|i|iijo|itjox|ii D]}||ijo||ijo|i}||i}||i}tiid |iidjo|d jp|d jp |djo|t|id}n|t|id}|idjo|idjo d}nl|id}|djo|id}nA|djo|idd}n|djo|id}n||}qMtiid |i}|i}|i}||}||}qqW|i|qfqeqeWq9q9W|djot|| |i%s( R RtrendertStringIOtpisat pisaDocumenttencodeterrR Rtgetvaluetcgitescape(t template_srct context_dictttemplatetcontextthtmltresulttpdf((s3/opt/public_html/insumos_test/apps/control/views.pyt render_to_pdfs   * c0Cspd}d}d}tiid|d|d|}tiid|d|d|dd}d} d} d} d} d} d}x|D]}|iidjo| d} q|iidjo| d} q|iid jo| d} q|iid jo| d} q|iid jo| d} q|iid jo|d}qqWy%tiid |d|d|}Wntij onXt iid|}t iid|i }h}h}h}h}h}h}h}d}d}d}d}x}|D]u}g}d}d} d}!d}"xF|i i D]5}#|#ii|ijox|#ii D]}$|i|$iijo|$itjox|$ii D]}%||%ijo||%ijo|%i}||%i}| |%i} tiid|%iidjo|djp|djp |djo|!t|%id}!n|!t|%id}!|%idjo|%idjo d}&nl|%id}&|&djo|%id}&nA|&djo|%idd}&n|&djo|%id}&n|"|&}"qTtiid|%i}'|'i}&|'i}(|!|(}!|"|&}"qqW|i|$qmqlqlWq@q@W|djot|||iNiR?R~Rtobservacion_id__gteiiiii iiRRvRIRJRKRLRMiiii i s paquete(s)s paquete(s) y s pieza(s)RRNRORPROttipoPersona__pkt Vespertinast Fucionadast DotacionExtratDotacionFusionadatDisminucionPaquetest BajaTemporaltA4tpagesizeRSRTRURVRWRXRYRZR\R[RR]R6RRt globalninostglobalninoslechet globallechet globalpaqueteR~sreporte_cuadro_abasto_pdf.html(%R3RRVR\RRR`RWRZRRaRbRcR]RORRdReRRnRfR~RRRR_RgRR#RhRRiRR"RkRUR(0R;ROR~RR[R\RmRSRRRRRRRRRR]RTRURVRWRYRXRZRRRRReRnRoRpRqRrRsRDRRtRuRvRwR?RxRyRzR~R<((s3/opt/public_html/insumos_test/apps/control/views.pytcuadro_abasto_pdf+s!'%    %'         !     %7     !lWc Csztiid|}tiid|i}tiidddt}x|D]}|ii }qRWd} d} h} h} x|D]} x| i i D]}|i i |i jodxa|ii D]L}| i |ii jo0|itjox|ii D]}||ijo||ijo|i} tiid|iidjo|idjo|id jo d }nl|id }|djo|id }nA|djo|id d }n|djo|id }n|d jp|d jp |d jo|id}qd|id}n+tiid|i}|i}|i}|djom|ddjo%t|dd| t|ix\|D]T}8|8i i|+ijo8x5|D])}?|8i|?ijo||?ijo||?ijo|;|?i};t|;||+i<|:|?i7}:t|:| |+i<|<|?i7}<t|<|!|+i<|9|?i7}9t|9|$|+i|?i7}>t|>|#|+iR@RBRCRDRER{R}RRRRRRuRRRRRRRRRRRRRR RRRRSRdReRf(((s3/opt/public_html/insumos_test/apps/control/views.pyts        D9 +    R-    '      #     J h   &#  ! " Z "  E