-Uc@sddlTddlTddlmZddlmZddlTddlmZddl Tddl m Z ddl m Z ddlmZddlmZdd lmZdd lmZdd ljZdd lZdd lZdd lmZdd lmZdd lZddlm Z m!Z!m"Z"ddl#m$Z$ddl%m&Z&ddl'm(Z(ddl)m*Z*ddl+m,Z,ddl-m.Z.m/Z/e0dddZ1e0dddZ2e0dddZ3e0dddZ4e0dddZ5e0dddZ6edZ7edZ8e0dddZ9e0ddd Z:e0ddd!Z;e0ddd"Z<ed#Z=e0ddd$Z>e0ddd%Z?e0ddd&Z@e0ddd'ZAe0ddd(ZBe0ddd)ZCd*ZDe0ddd+ZEe0ddd,ZFd-ZGe0ddd.ZHe0ddd/ZId0ZJe0ddd1ZKe0ddd2ZLe0ddd3ZMe0ddd4ZNed5ZOd6ZPe0ddd7ZQe0ddd8ZRd9ZSe0ddd:ZTe0ddd;ZUe0ddd<ZVe0ddd=ZWe0ddd>ZXe0ddd?ZYd@ZZedAZ[e0dddBZ\e0dddCZ]e0dddDZ^e0dddEZ_edFZ`e0dddGZae0dddHZbe0dddIZce0dddJZde0dddKZedLZfe0dddMZgdNZhdOZidPZjdQZkdRZldSe(fdTYZme0dddUZnedVZoe0dddWZpe0dddXZqe0dddYZne0dddZZre0ddd[Zse0ddd\Ztd]efd^YZud_e(fd`YZvdaZwdbZxdcZye0ddddZzd_e(fdeYZvdfZwdgZxdhZydiZ{djZ|d S(ki(t*(t simplejson(t TemplateView(tmessages(tQ(tUserCreationForm(tGroup(thttp(t get_template(tContextN(tdatetime(t csrf_exempt(t Paginatort EmptyPagetPageNotAnInteger(t smart_str(t serializers(t ListAPIView(tResponse(tAPIView(tCatEscuelaSerializertEscuelaSerializert login_urls/logincCs-idd6dd6}td|dt|S(NsEste es la vista principaltmsjtactivet principalsprincipal.htmltcontext_instance(trender_to_responsetRequestContext(trequesttcontexto((s(/home/paco/insumos/apps/control/views.pyR(sc Cs|j}d}d}y.tjjd|}|j}|jj}Wntjk rYnX|dkr|dkrt jj d|}nt jj }d}d|j kr|j jd}nt ||}|j jd}y|j|}WnBtk r|jd}n#tk r;|j|j}nX|jdkr:t|j|j} | jr!y_tj|jjd d } t jjd | d |jjd } d } tj|| Wnt jk rd} nX| dkr7| jd } tj|| tdSqd} tj|| nd|dkr|dkrtj dddt!dt"jj dt#d|dtj$didd6tj%d d}nX|dkr|jd t} | jd }tj||td Sqgd }tj||n|dkr|dkrtjd ddtdtjj ddd|dtjdidd6t jdtRegistroAbastoR@RARDtRegistroAbastoFormR$RGRRIRJRPRKRLRMRNRORSRTRR( RRR2RURVtabastoR4RXRtaR((s(/home/paco/insumos/apps/control/views.pytregistro_abastosH   E    SM cCstjj}d}|j}d}d} |jjdrN|jjdnd} y.tjjd|} | j}| j j } Wntj k rnX|dkr| dkr|dkrvt jj d|d|jdd } | dkr| j td | td | Btd | Btd | Btd| Btd| Btd| Btd| Btd| B} qq|dkr;t jj d|d|jdd } | dkr| j td | td | Btd | Btd | Btd| Btd| Btd| Btd| Btd| B} qqt jj d|jdd } | dkr| j td | td | Btd | Btd | Btd| Btd| Btd| Btd| Btd| B} qnd}|dkrt jj d|jdd } | dkr| j td | td| Btd | Btd | Btd | Btd| Btd| Btd| Btd| Btd| B} qn|dkrt jj d|jdd } | dkr| j td | td| Btd | Btd | Btd | Btd| Btd| Btd| Btd| Btd| B} qnO|dkrXt jj d|jdd } | dkr| j td | td| Btd | Btd | Btd | Btd| Btd| Btd| Btd| Btd| B} qn|dkr$t jj d|jdd } | dkr| j td | td| Btd | Btd | Btd | Btd| Btd| Btd| Btd| Btd| B} qnt jjjdd } | dkr| j td | td| Btd | Btd | Btd | Btd| Btd| Btd| Btd| Btd| B} n|jjdrt|jjdnd} t| | }|jjd}y|j|} WnBtk ra|jd} n#tk r|j|j} nXi| d6|d6|d6dd6| d6| d6}td|d t|S(!NttbscrRR t0R!Rcs-mess-anotescuela__nombre__icontainstpromotor__nombre__icontainst$promotor__apellidoPaterno__icontainst$promotor__apellidoMaterno__icontainstano__icontainstmes__icontainst%escuela__localidad__nombre__icontainstescuela__grado__icontainstescuela__clave__icontainsRbtadministraciont0escuela__localidad__municipio__nombre__icontainst!escuela__localidad__municipio__idtrppi R#it municipiosRR5Rgsconsultas_abasto.htmlR(t MunicipioR:RAR7R8RBR;R9R2R<R=R>ReR@R]RtintR R#RR RCRR(RRcRbt municipio_idtgradoRzRvRR2RURkRVRgRyRWR#R((s(/home/paco/insumos/apps/control/views.pytconsultas_abastos *  ' g ' g! g ! t ! t ! t ! t t0  0cCs|jr|jd}|dk rtjjd|}|GHg}|jit|jj d6t|j d6t|j d6t|j d6t|j d6t|jd6tj|}|GHqnt|d d S( NtqRZR&tninastninost total_ninost ninos_lechet total_madrestmimetypesapplication/javascript(tis_ajaxR$R8ReR:R;tappendtstrR&tnombreRRt totalNinosttotalNinosLechet totalMadrestjsontdumpst HttpResponse(RRRgtlisttrecipe_list_json((s(/home/paco/insumos/apps/control/views.pytconsulta_detalle_abasto^s      c Cs|jr|jd}|dk rgtjjtd|td|Btd|Btd|Btd|BD]Z}td|jdt |j d t |j d t |j d t |j ^qu}ttj|d d SndS( NRtnombre__icontainstfolio__icontainstclave__icontainstlocalidad__nombre__icontainst'localidad__municipio__nombre__icontainstidttexts - t content_typesapplication/json(RRBR8RQR:R@RtdictRZRtlocalidad__municipio__nombretlocalidad__nombreRR=RRR(RtparamRtctresp((s(/home/paco/insumos/apps/control/views.pyt escuela_ajaxws    3qcCs tjjjdd }tjjd|}|jdkrRtd|}n||jdkrt|jd|}|jr|j d}t j ||t dSd }t j ||n t}i|d 6d d 6|d 6|d6}td|dt|S(Ns-idi RZRBR[R$s!EL ABASTO SE EDITO CORRECTAMENTE.s/consultas_abasto/0/0/0/0R'R4RR5tabasRgsregistro_abasto.htmlR(ReR:RAR]R;RDRfR$RGRJRRKRLRMRR(Rt id_abastoRgRR4RR((s(/home/paco/insumos/apps/control/views.pyt editar_abastos     "cCs)tjjd|}|jtdS(NRZs/consultas_abasto/0/0/0/0(ReR:R;R`RL(RRRg((s(/home/paco/insumos/apps/control/views.pyt borrar_abastos cCs)|jdkrt|j}|jryZtjjtd|jjdtd|jjdB}d}tj ||Wntj k rd}nX|dkr|j d}tj ||tdSqd}tj||n t}i|d 6d d 6}td |d t|S(NR$R=RtfoliosLA ESCUELA YA EXISTEs2EL REGISTRO DE LA ESCUELA SE REALIZO CORRECTAMENTEs/registro_escuela/R'R4Rt reg_escuelasregistro_escuela.htmlR(RDtRegistroEscuelaFormR$RGRQR:R;RRRIR>R8RJRKRLRMRR(RR4RXRR((s(/home/paco/insumos/apps/control/views.pytregistro_escuelas& @     c Cs |jjdr$|jjdnd}tjj}|dkrtjjd|}|dkr"|jtd|td|Btd|Btd|Btd |B}q"njtjj}|dkr"|jtd|td|Btd|Btd|Btd |B}n|jjd rLt|jjd nd }t ||}|jjd }y|j |}WnBt k r|j d }n#t k r|j |j }nXi|d6|d6dd6|d6|d 6}td|dt|S(NRkRjRltlocalidad__municipio__idRRRRRRyi R#iRzRRR&sconsultas_escuelas.htmlR(RBR;R{R:RARQR@RR|R R#RR RCRR( RR}RkRzR&RyRWR#R((s(/home/paco/insumos/apps/control/views.pytconsultas_escuelass0*  3 30  )cCs|jr|jd}|dk rtjjd|}g}|jit|jd6t|j d6t|j d6t|j d6t|j d6t j|}|GHqnt|dd S( NRRZt localidadR=RRt observacionRsapplication/javascript(RR$R8RQR:R;RRRR=RRRRRR(RRR&RR((s(/home/paco/insumos/apps/control/views.pytconsulta_detalle_escuelas     cCs tjjjdd }tjjd|}|jdkrRtd|}n||jdkrt|jd|}|jr|j d}t j ||t dSd }t j ||n t}i|d 6d d 6|d 6|d6}td|dt|S(Ns-idiRZRBR[R$s"LA ESCUELA SE EDITO CORRECTAMENTE.s/consultas_escuelas/0R'R4RRtultimostescuela_sregistro_escuela.htmlR(RQR:RAR]R;RDRR$RGRJRRKRLRMRR(Rt id_escuelaRR&R4RR((s(/home/paco/insumos/apps/control/views.pyteditar_escuela s     "cCs2tjjd|}t|_|jtdS(NRZs/registro_escuela/(RQR:R;RPR+RJRL(RRR&((s(/home/paco/insumos/apps/control/views.pytbloquear_escuela&s  cCs2tjjd|}t|_|jtdS(NRZs/registro_escuela/(RQR:R;RRR+RJRL(RRR&((s(/home/paco/insumos/apps/control/views.pytdesbloquear_escuela.s  cCs?tjj}|jdkrt|j}|jryZtjjtd|jjdtd|jjdB}d}t j ||Wntj k rd}nX|dkr|j d}t j||tdSq d}t j||n t}i|d6d d 6|d 6}td |d t|S(NR$R=RsLA OBSERVACION YA EXISTEs6EL REGISTRO DE LA OBSERVACION SE REALIZO CORRECTAMENTEs/registro_observaciones/R'R4RRt observacionessregistro_observaciones.htmlR(tCatObservacionesR:RARDtRegistroObservacionesFormR$RGR;RRRIR>R8RJRKRLRMRR(RRR4RXRR((s(/home/paco/insumos/apps/control/views.pytregistro_observaciones6s( @     cCstjj}tjjd|}|jdkrEtd|}n||jdkrt|jd|}|jr|jd}t j ||t dSd}t j ||n t}i|d6d d 6|d 6|d 6}t d |dt|S(NRZRBR[R$s&LA OBSERVACION SE EDITO CORRECTAMENTE.s/registro_observaciones/R'R4RRRRsregistro_observaciones.htmlR(RR:RAR;RDRR$RGRJRRKRLRMRR(Rtid_observacionRRR4RR((s(/home/paco/insumos/apps/control/views.pyteditar_observacionVs     "cCs)tjjd|}|jtdS(NRZs/registro_observaciones/(RR:R;R`RL(RRR((s(/home/paco/insumos/apps/control/views.pytborrar_observacionps cCs?tjj}|jdkrt|j}|jryZtjjtd|jjdtd|jjdB}d}t j ||Wntj k rd}nX|dkr|j d}t j||tdSq d}t j||n t}i|d6d d 6|d 6}td |d t|S(NR$tnumeroProyectoR2sEL PROYECTO YA EXISTEs1EL REGISTRO DEL PROYECTO SE REALIZO CORRECTAMENTEs/registro_proyectos/R'R4Rt reg_proyectost proyectossregistro_proyectos.htmlR(t CatProyectoR:RARDtRegistroProyectosFormR$RGR;RRRIR>R8RJRKRLRMRR(RRR4RXRR((s(/home/paco/insumos/apps/control/views.pytregistro_proyectosws( @     cCstjj}tjjd|}|jdkrEtd|}n||jdkrt|jd|}|jr|jd}t j ||t dSd}t j ||n t}i|d6d d 6|d 6|d 6}t d |dt|S(NRZRBR[R$s#EL PROYECTO SE EDITO CORRECTAMENTE.s/registro_proyectos/R'R4RRRtproyectosregistro_proyectos.htmlR(RR:RAR;RDRR$RGRJRRKRLRMRR(Rt id_proyectoRRR4RR((s(/home/paco/insumos/apps/control/views.pyteditar_proyectos     "cCs)tjjd|}|jtdS(NRZs/registro_proyectos/(RR:R;R`RL(RRR((s(/home/paco/insumos/apps/control/views.pytborrar_proyectos cCs tjj}|jdkrt|j}|jry;tjjd|jjd}d}tj ||Wntj k rd}nX|dkr|j d}tj ||tdSqd}tj||n t}i|d6dd 6|d 6}td |d t|S( NR$tnumPlacasLA VEHICULO YA EXISTEs1EL REGISTRO DEL VEHICULO SE REALIZO CORRECTAMENTEs/registro_vehiculos/R'R4Rt reg_vehiculost vehiculossregistro_vehiculos.htmlR(t CatVehiculoR:RARDtRegistroVehiculosFormR$RGR;RRIR>R8RJRKRLRMRR(RRR4RXRR((s(/home/paco/insumos/apps/control/views.pytregistro_vehiculoss( !     cCstjj}tjjd|}|jdkrEtd|}n||jdkrt|jd|}|jr|jd}t j ||t dSd}t j ||n t}i|d6d d 6|d 6|d 6}t d |dt|S(NRZRBR[R$s#EL VEHICULO SE EDITO CORRECTAMENTE.s/registro_vehiculos/R'R4RRRtvehiculosregistro_vehiculos.htmlR(RR:RAR;RDRR$RGRJRRKRLRMRR(Rt id_vehiculoRRR4RR((s(/home/paco/insumos/apps/control/views.pyteditar_vehiculos     "cCs)tjjd|}|jtdS(NRZs/registro_vehiculos/(RR:R;R`RL(RRR((s(/home/paco/insumos/apps/control/views.pytborrar_vehiculos c Cs|jdkrt|j}t|j}|jrytjjd|jjdd|jjdd|jjdd|jjdd|jjd}d}tj ||Wntj k rd}nX|dkr|jjd}|jjd }|r|r|jr|j }|jjd}t jjd |} | jd krtjjd d } | jj|q| jdkrtjjd d} | jj|q| jdkrtjjd d} | jj|q| jdkr0tjjd d} | jj|q| jdkrgtjjd d} | jj|q| jdkrtjjd d} | jj|qqntjjd |jjd} t jjd |jjd} t} |jjd| _|jjd| _|jjd| _| | _| | _t| _|ra|ra|| _n| j d}tj||tdSqd}tj||nt}t}i|d6|d6dd6}td|d t|S(!NR$RtapellidoPaternotapellidoMaternoR2R<sLA PERSONA YA EXISTEtusernamet password1RZR tnamet ADMINISTRADORtCORMsCOORDINADOR MUNICIPALtATCsAPOYO TEC. DEL COORDINADORtJATsJEFATURA DE APOYO TECNICOtABTOtABASTOtSUBOPsSUBDIRECCION OPERATIVAs2EL REGISTRO DE LA PERSONA SE REALIZO CORRECTAMENTEs/registro_personas/R'tformulario_userR4Rt reg_personassregistro_personas.htmlR( RDtRegistroPersonasFormR$RRGR9R:R;RRIR>R8RJtCatTipoPersonaR=Rtuser_settaddR{RRRR2R<RRR+RRKRLRMRR(RR4RRXRRtpasswordtuser_idt tip_personRUtgrupoR2R<RVR((s(/home/paco/insumos/apps/control/views.pytregistro_personassr i     !!          c Cs|jjdr$|jjdnd}tjj}|dkrtjjd|}|dkr"|jtd|td|Btd|Btd|Btd |B}q"njtjj}|dkr"|jtd|td|Btd|Btd|Btd |B}n|jjd rLt|jjd nd }t ||}|jjd }y|j |}WnBt k r|j d }n#t k r|j |j }nXi|d6dd6|d6|d 6}td|dt|S(NRkRjRlttipoPersona__idRtapellidoPaterno__icontainstapellidoMaterno__icontainstmunicipio__nombrettipoPersona__nombreRyi R#iRURRtpersonassconsultas_personas.htmlR(RBR;RR:RAR9R@RR|R R#RR RCRR( Rttipo_persona_idRkRURRyRWR#R((s(/home/paco/insumos/apps/control/views.pytconsultas_personasKs0*  3 30  "cCstjj}tjjd|}|jdkrEtd|}n||jdkrt|jd|}|jr|jd}t j ||t dSd}t j ||n t}i|d6d d 6|d 6|d 6}t d |dt|S(NRZRBR[R$s"LA PERSONA SE EDITO CORRECTAMENTE.s/registro_personas/R'R4RRRRVsregistro_personas.htmlR(R9R:RAR;RDRR$RGRJRRKRLRIRR(Rt id_personaRRVR4RR((s(/home/paco/insumos/apps/control/views.pyteditar_personaxs     "cCs]tjjd|}t|_|jdkrIt|j_|jjn|jt dS(NRZs/registro_personas/( R9R:R;RPR+RR8t is_activeRJRL(RRRV((s(/home/paco/insumos/apps/control/views.pytbloquear_personas   cCs]tjjd|}t|_|jdkrIt|j_|jjn|jt dS(NRZs/registro_personas/( R9R:R;RRR+RR8RRJRL(RRRV((s(/home/paco/insumos/apps/control/views.pytdesbloquear_personas   cCsod}|jrO|jd}|dk rOtjjd|jd}qOntdi|d6dt|S(NRjRRsvalidar_usuario.htmltresultsR( RR$R8tUserR:R@R]RR(RRR((s(/home/paco/insumos/apps/control/views.pytvalidar_usuarios    $cCs?tjj}|jdkrt|j}|jryZtjjtd|jjdtd|jjdB}d}t j ||Wntj k rd}nX|dkr|j d}t j||tdSq d}t j||n t}i|d6d d 6|d 6}td |d t|S(NR$R=RsLA CLAVE O EL NOMBRE YA EXISTEs8EL REGISTRO DEL TIPO DE PERSONA SE REALIZO CORRECTAMENTEs/registro_tipo_persona/R'R4RRt tipo_personassregistro_tipo_personas.htmlR(RR:RARDtRegistroTipoPersonaFormR$RGR;RRRIR>R8RJRKRLRMRR(RRR4RXRR((s(/home/paco/insumos/apps/control/views.pytregistro_tipo_personas( @     cCstjj}tjjd|}|jdkrEtd|}n||jdkrt|jd|}|jr|jd}t j ||t dSd}t j ||n t}i|d6d d 6|d 6|d 6}t d |dt|S(NRZRBR[R$s*EL TIPO DE PERSONA SE EDITO CORRECTAMENTE.s/registro_tipo_persona/R'R4RRRRUsregistro_tipo_personas.htmlR(RR:RAR;RDRR$RGRJRRKRLRMRR(Rtid_tipo_personaRRUR4RR((s(/home/paco/insumos/apps/control/views.pyteditar_tipo_personas     "cCs)tjjd|}|jtdS(NRZs/registro_tipo_persona/(RR:R;R`RL(RRRU((s(/home/paco/insumos/apps/control/views.pytborrar_tipo_personas cCs tjj}|jdkrt|j}|jry;tjjd|jjd}d}tj ||Wqtj k r|j d}tj ||t dSXqd}tj||n t}i|d6dd 6|d 6}td |d t|S( NR$tnombreProveedors EL PROVEEDOR YA EXISTEs.EL REGISTRO PROVEEDOR SE REALIZO CORRECTAMENTEs/registro_proveedor/R'R4Rt reg_productost proveedoressregistro_proveedor.htmlR(t CatProveedorR:RARDtRegistroProveedorFormR$RGR;RRIR>RJRKRLRMRR(RRR4RXRR((s(/home/paco/insumos/apps/control/views.pytregistro_proveedors$ !  cCstjj}tjjd|}|jdkrEtd|}n||jdkrt|jd|}|jr|jd}t j ||t dSd}t j ||n t}i|d6d d 6|d 6|d 6}t d |dt|S(NRZRBR[R$s$EL PROVEEDOR SE EDITO CORRECTAMENTE.s/registro_proveedor/R'R4RRRt proveedorsregistro_proveedor.htmlR(RR:RAR;RDRR$RGRJRRKRLRMRR(Rt id_proveedorRRR4RR((s(/home/paco/insumos/apps/control/views.pyteditar_proveedors     "cCsktjjd|}t|_|jtjjdt}x!|D]}t|_|jqDWt dS(NRZR+s/registro_proveedor/( RR:R;RPR+RJt CatPaqueteR@RRRL(RRRtpaquetestp((s(/home/paco/insumos/apps/control/views.pytbloquear_proveedor;s    cCs2tjjd|}t|_|jtdS(NRZs/registro_proveedor/(RR:R;RRR+RJRL(RRR((s(/home/paco/insumos/apps/control/views.pytdesbloquear_proveedorHs  cCs tjj}|jdkrt|j}|jry;tjjd|jjd}d}tj ||Wntj k rd}nX|dkr|j d}tj ||tdSqd}tj||n t}i|d6dd 6|d 6}td |d t|S( NR$t presentacions&LA PRESENTACION DEL PRODUCTO YA EXISTEsDEL REGISTRO DE LA PRESENTACION DEL PRODUCTO SE REALIZO CORRECTAMENTEs /registro_presentacion_producto/R'R4RRtpresentacioness#registro_presentacion_producto.htmlR(tCatPresentacionProductoR:RARDt RegistroPresentacionProductoFormR$RGR;RRIR>R8RJRKRLRMRR(RR R4RXRR((s(/home/paco/insumos/apps/control/views.pytregistro_presentacion_productoSs( !     cCstjj}tjjd|}|jdkrEtd|}n||jdkrt|jd|}|jr|jd}t j ||t dSd}t j ||n t}i|d6d d 6|d 6|d 6}t d |dt|S(NRZRBR[R$s4LA PRESENTACION DEL PRODUCTO SE EDITO CORRECTAMENTE.s /registro_presentacion_producto/R'R4RRR R s#registro_presentacion_producto.htmlR(RR:RAR;RDRR$RGRJRRKRLRMRR(Rtid_presentacion_productoR R R4RR((s(/home/paco/insumos/apps/control/views.pyteditar_presentacion_productoss     "cCs)tjjd|}|jtdS(NRZs /registro_presentacion_producto/(RR:R;R`RL(RRR ((s(/home/paco/insumos/apps/control/views.pytborrar_presentacion_productos cCs tjj}|jdkrt|j}|jry;tjjd|jjd}d}tj ||Wntj k rd}nX|dkr|j d}tj ||tdSqd}tj||n t}i|d6dd 6|d 6}td |d t|S( NR$Rs EL PRODUCTO YA EXISTEs1EL REGISTRO DEL PRODUCTO SE REALIZO CORRECTAMENTEs/registro_productos/R'R4RRt productossregistro_productos.htmlR(t CatProductosR:RARDtRegistroProductosFormR$RGR;RRIR>R8RJRKRLRMRR(RRR4RXRR((s(/home/paco/insumos/apps/control/views.pytregistro_productoss( !     cCs|jr|jd}|dk rtjjd|}g}|jit|jd6t|j d6t|j d6t|j d6t|j d6t j|}|GHqnt|dd S( NRRZRtcantidadR tmarcat descripcionRsapplication/javascript(RR$R8RR:R;RRRRR RRRRR(RRtproductoRR((s(/home/paco/insumos/apps/control/views.pytconsulta_detalle_productos     cCstjj}tjjd|}|jdkrEtd|}n||jdkrt|jd|}|jr|jd}t j ||t dSd}t j ||n t}i|d6d d 6|d 6|d 6}t d |dt|S(NRZRBR[R$s#EL PRODUCTO SE EDITO CORRECTAMENTE.s/registro_productos/R'R4RRRRsregistro_productos.htmlR(RR:RAR;RDRR$RGRJRRKRLRMRR(Rt id_productoRRR4RR((s(/home/paco/insumos/apps/control/views.pyteditar_productos     "cCs2tjjd|}t|_|jtdS(NRZs/registro_productos/(RR:R;RPR+RJRL(RRR((s(/home/paco/insumos/apps/control/views.pytbloquear_productos  cCs2tjjd|}t|_|jtdS(NRZs/registro_productos/(RR:R;RRR+RJRL(RRR((s(/home/paco/insumos/apps/control/views.pytdesbloquear_productos  cCs?tjjjdd }|jdkrt|j}|jryMtjjd|jjdd|jjd}d}t j ||Wntj k rd}nX|dkr|j d}t j||tdSq d }t j||n t}i|d 6d d 6|d 6}td|dt|S(Ns-idi R$Rt tipoPaquetes EL PAQUETE YA EXISTEs0EL REGISTRO DEL PAQUETE SE REALIZO CORRECTAMENTEs/registro_paquetes/R'R4RRRsregistro_paquetes.htmlR(RR:RAR]RDtRegistroPaqueteFormR$RGR;RRIR>R8RJRKRLRMRR(RRR4RXRR((s(/home/paco/insumos/apps/control/views.pytregistro_paquetess( 3     cCs|jr|jd}|dk rtjjd|}|GHg}x.|jjD]}|ji|j d6qUWt j |}|GHqnt |ddS(NRRZRRsapplication/javascript( RR$R8RR:R;RRARRRRR(RRtpaqueteRR R((s(/home/paco/insumos/apps/control/views.pytconsulta_detalle_paquete s     cCs tjjjdd }tjjd|}|jdkrRtd|}n||jdkrt|jd|}|jr|j d}t j ||t dSd }t j ||n t}i|d 6d d 6|d 6|d6}td|dt|S(Ns-idi RZRBR[R$s"EL PAQUETE SE EDITO CORRECTAMENTE.s/registro_paquetes/R'R4RRRR$sregistro_paquetes.htmlR(RR:RAR]R;RDR"R$RGRJRRKRLRMRR(Rt id_paqueteRR$R4RR((s(/home/paco/insumos/apps/control/views.pyteditar_paquete4s     "cCs2tjjd|}t|_|jtdS(NRZs/registro_paquetes/(RR:R;RPR+RJRL(RR&R$((s(/home/paco/insumos/apps/control/views.pytbloquear_paqueteQs  cCs2tjjd|}t|_|jtdS(NRZs/registro_paquetes/(RR:R;RRR+RJRL(RR&R$((s(/home/paco/insumos/apps/control/views.pytdesbloquear_paqueteZs  cCs<tjj}i|d6dd6}td|dt|S(NRzRR5slista_municipio_abasto.htmlR(R{R:RARR(RRzR((s(/home/paco/insumos/apps/control/views.pytlista_municipio_abastodsc$Csd}d}d}tjjd|d|d|}tjjd|d|d|}y%tjjd|d|d|}Wntjk rnXtjjd |} t jjd |j } i} i} i} i}i}i}i}xW| D]O}g}d}d}d}d}x.|j j D]}|j j| jkr%x|jj D]}|j|jjkrP|jtkr;x|jj D]}||jkr||jkr|j}||j}||j}tjjd |jjdkr|d ks|d ks|dkr3|t|jd}n|t|jd}|jdkrq|jdkrqd}ne|jd}|dkr|jd}n<|dkr|jdd}n|dkr|jd}n||}q$tjjd |j}|j}|j}||}||}qqW|j|q;qPqPWq%q%W|dkrht|| |jR{tCatRutatdistinctt LocalidadRAR2Rtcatescuela_settrutaR+RRtregistroabasto_setRbRcRRRtcountR|RtlechesRtlenRRtfloattpesoRR($RR2RbRcR?R@ttonelajeR7R6RzRAR8R9R:R;R=R<R>RHt totalescuelast totalninosttotalninoslechet totallechet totalpaquetetlocR&Rt resultadotdotaciont resultado2tlecheR$t pesoporlechet tonelajelechettonelajepaqueteR((s(/home/paco/insumos/apps/control/views.pyt cuadro_abastoms!!%    $$             $6   vcCsjtjjd|}t}||_||_||_t|_|jt d|d|d|S(NRZs/cuadro_abasto/s and ( R{R:R;RCRbRcRRR+RJRL(Rt id_municipioRbRcR2R?((s(/home/paco/insumos/apps/control/views.pytvalidar_cuadros      cCsXtjjdt}tjj}i|d6dd6|d6}td|dt|S(NR+R$RR5tfirmasrequerimientos.htmlR(RR:R@RRR9RARR(RR$R`R((s(/home/paco/insumos/apps/control/views.pytrequerimientosscCst|}t|}|j|}tj}tjtj|jd|dd}|jstj |j ddStj dt j |S(NsUTF-8tencodingRsapplication/pdfsWe had some errors
%s
( RR trendertStringIOtpisat pisaDocumenttencodeterrRRtgetvaluetcgitescape(t template_srct context_dictttemplatetcontextthtmltresulttpdf((s(/home/paco/insumos/apps/control/views.pyt render_to_pdfs   * c0 Cs:d}d}d}tjjd|d|d|}tjjd|d|d|dd}d} d} d} d} d} d}x|D]}|jjdkr| d} q|jjdkr| d} q|jjd kr| d} q|jjd kr| d} q|jjd kr&| d} q|jjd kr|d}qqWy%tjjd |d|d|}Wntjk rnXt jjd|}t jjd|j }i}i}i}i}i}i}i}d}d}d}d}xU|D]M}g}d}d} d}!d}"x.|j j D]}#|#jj|jkr2x|#jj D]}$|j|$jjkr]|$jtkrHx|$jj D]}%||%jkr||%jkr|%j}||%j}| |%j} tjjd|%jjdkr|dks&|dks&|dkr@|!t|%jd}!n|!t|%jd}!|%jdkr~|%jdkr~d}&ne|%jd}&|&dkr|%jd}&n<|&dkr|%jdd}&n|&dkr|%jd}&n|"|&}"q1tjjd|%j}'|'j}&|'j}(|!|(}!|"|&}"qqW|j|$qHq]q]Wq2q2W|dkrut|||jNiR!RbRctobservacion_id__gteiiiii iiR{RZR.R/R0R1R2iiii i s paquete(s)s paquete(s) y s pieza(s)R+R3R4R5R2ttipoPersona__pkt Vespertinast Fucionadast DotacionExtratDotacionFusionadatDisminucionPaquetest BajaTemporaltA4tpagesizeR7R8R9R:R;R<R=R>R@R?RzRARR5t globalninostglobalninoslechet globallechet globalpaqueteR`sreporte_cuadro_abasto_pdf.html(%R8ReR:R@RRRCR;R>R{RDRERFRAR2RRGRHR+RRRIRbRcRRRBRJR|RRKRRLRRRNR9Rs(0RR2RbRcR?R@ROR7RRvRwRxRyRzR{RhRzRAR8R9R:R;R=R<R>R~RRRRHRPRQRRRSRTRUR&RRVRWRXRYR$RZR[R\R`R((s(/home/paco/insumos/apps/control/views.pytcuadro_abasto_pdfs!'       %    $$                $6       lWcCs\tjjd|}tjjd|j}tjjdddt}x|D]}|jj }qRWd} d} i} i} x|D]|} xs| j j D]b}|j j |j krxD|jj D]0}| j |jj kr|jtkrx|jj D]}||jkr||jkr|j} tjjd|jjdkr&|jdkr}|jd kr}d }ne|jd }|dkr|jd }n<|dkr|jd d }n|dkr|jd }n|d ks|d ks|d kr|jd}qP|jd}n*tjjd|j}|j}|j}|dkr|ddkrt|dd| t|jt jjd |j}|j}||}t|j|}||}||}q|j j dkrt jj d |jjdkr|jdkrP|jdkrPd}ne|jd}|dkry|jd}n<|dkr|jdd}n|dkr|jd}n||}n+t jjd |j}|j}||}t|j|}qqW|dkrHt|| t|jscCs|jdkrzt|j}|jrayctjjd|jjd}|jtkrvd}t j ||nd}t j ||Wntj k rd}nX|dkrw|jjd}|dkr^|jjd}t jjdt|jjd }|jd t}||_||_|jd }t j||td Sqwqd }t j||n t}i|d6}td|dt|S(NR$Rs9LA CURP INGRESADA YA EXISTE, EL ALUMNO ESTA DADO DE BAJA.sLA CURP INGRESADA YA EXISTE.RRjt curp_hiddenRt escuela_bRds4El alumno y su tutor se han registrado correctamentes/registro_nino/sError campos vaciosR4sregistro_ninos.htmlR(RDtRegistroNinosFormR$RGRR:R;R+RPRRIR>R8RQR|RJR&RRKRLRMRR(RR4RXRt curp_tutorRRhR((s(/home/paco/insumos/apps/control/views.pyt registro_ninoIs: !   '     cCsRtjjd|}t|_|jd}tj||td|j j S(NRZs+El Alumno se ha dado de baja correctamente.s/consulta_padron/%s( RR:R;RPR+RJRRKRLR&R(RRVR((s(/home/paco/insumos/apps/control/views.pyt bloquear_ninoos   c Cstjjd|}|jdkrP|jj}t|jd|}|jr7|jjd}|dkr|jjd}nt jjdt |jjd}|j d t }||_||_ |j tjjd|}d |jjjj|jj|jjf} tj|| td |Sd } tj|| n|jj}td|}i|d 6|d6|d6} td| dt|S(NRZR$R[RRjRRRRdsGEl Alumno se edito correctamente y pertenece a la Escuela: %s, %s , %ss/consulta_padron/%ssError al editar el AlumnoR4R&tninosregistro_ninos.htmlR(RR:R;RDR&RRR$RGRQR|RJRPRRR2Rt domicilioRRKRLRMRR( RRVRR&R4RRRhtescuela2RR((s(/home/paco/insumos/apps/control/views.pyt editar_ninos.   '   + tBusquedaAjaxEscuelaNinoViewcBseZdZRS(cOsO|jd}tjjd|dt}tjd|}|GHt|ddS(NR&RR+RRsapplication/json(RBRR:R@RRRt serializeR(RRtargstkwargsR&Rtdata((s(/home/paco/insumos/apps/control/views.pyR;s  (RRR;(((s(/home/paco/insumos/apps/control/views.pyRstEscuelaAPIViewcBs&eZeZejjZdZRS(cCs|jjjd}|jjjd}|rr|jtd|td|Btd|Btd|B}n|r|jd|}n|S(NRRRRRR(RRR;R@R(RR*RR((s(/home/paco/insumos/apps/control/views.pytfilter_querysets&( RRRRRQR:RAR*R(((s(/home/paco/insumos/apps/control/views.pyRscCs;tjjdt}i|d6}td|dt|S(NR+talumnossalumnos_baja.htmlR(RR:R@RPRR(RRR((s(/home/paco/insumos/apps/control/views.pytConsultarAlumnosBajas c Cstjjd|}|jdkrU|jj}t|jd|}|jr<|jjd}|dkr|jjd}nt jjdt |jjd}|j d t }||_||_ t|_|j tjjd|}d |jj|jj|jjjjf} tj|| td Sd } tj|| n|jj}td|}i|d 6|d6|d6} td| dt|S(NRZR$R[RRjRRRRds`El Alumno se ha dado de Alta correctamente y pertenece a la Escuela: %s, %s del Municipio de %ss/alumnos_baja/sError al editar el AlumnoR4R&Rsregistro_ninos.htmlR(RR:R;RDR&RRR$RGRQR|RJRPRRRR+RRRR2RRKRLRMRR( RRVRR&R4RRRhRRR((s(/home/paco/insumos/apps/control/views.pyteditar_nino_baja_news0   '    +  cCsmtjjd|}t|_|jd|jj|jj|jj j jf}t j ||t dS(NRZs`El Alumno se ha dado de Alta correctamente y pertenece a la Escuela: %s, %s del Municipio de %ss/alumnos_baja/(RR:R;RRR+RJR&RRRR2RRKRL(RRVRR((s(/home/paco/insumos/apps/control/views.pytdesbloquear_alumnos   +cCs^|jdkr+t|j}|jr|jd}|jd}|jd}d}tjjdd}tjj d|dt }t jj d |d|d|j }|d krx|D]} yt jjd | d|d|}tjj d | jd d dt j } tjj d | jd ddt j } | | } tjj d | jdt jdj } t d|jd | d|d|d| d| d| d| d| d|dt }|jWnt jk rd}nX|dkrtjj d | jd d dt j } tjj d | jd ddt j } | | } tjj d | jdt jdj } t jjd | d|d|d| d| d| d| d| d|dt }qqWd}tj||tdSd}tj||tdSqZtj|dn/t}i|d6}td|dt|SdS(NR$R2RbRcRi`R,R+R{iR&RtHtMRRRRRRR3tenviados#REGISTRO ABASTO CAPTURADO CON EXITOs/consulta_registroabasto/sGEL REGISTRO DE ABASTO DE ESTE MUNICIPIO, MES Y AÑO YA FUERON VALIDADOSscorrija los siguientes erroresRsregistroabastobusqueda.htmlR(RDtRegistroAbastoAutomaticoFormR$RGR8R9R:R;RQR@RRRCRJReRRRERPRJR>tcreateRRKRLRIRMRR(RRR2RbRctexisteR3t listaescuelasR?RRRt totalniniost totalpadrestAbastotregistroabastoRR((s(/home/paco/insumos/apps/control/views.pytregistro_abasto_automaticosv    '  !** -    ** -     cBs&eZeZejjZdZRS(cCs|jjjd}|jjjd}|rr|jtd|td|Btd|Btd|B}n|r|jd|}n|S(NRRRRRR(RRR;R@R(RR*RR((s(/home/paco/insumos/apps/control/views.pyRW s&( RRRRRQR:RAR*R(((s(/home/paco/insumos/apps/control/views.pyRS scCs;tjjdt}i|d6}td|dt|S(NR+Rsalumnos_baja.htmlR(RR:R@RPRR(RRR((s(/home/paco/insumos/apps/control/views.pyRn s c Cstjjd|}|jdkrU|jj}t|jd|}|jr<|jjd}|dkr|jjd}nt jjdt |jjd}|j d t }||_||_ t|_|j tjjd|}d |jj|jj|jjjjf} tj|| td Sd } tj|| n|jj}td|}i|d 6|d6|d6} td| dt|S(NRZR$R[RRjRRRRds`El Alumno se ha dado de Alta correctamente y pertenece a la Escuela: %s, %s del Municipio de %ss/alumnos_baja/sError al editar el AlumnoR4R&Rsregistro_ninos.htmlR(RR:R;RDR&RRR$RGRQR|RJRPRRRR+RRRR2RRKRLRMRR( RRVRR&R4RRRhRRR((s(/home/paco/insumos/apps/control/views.pyRt s0   '    +  cCsmtjjd|}t|_|jd|jj|jj|jj j jf}t j ||t dS(NRZs`El Alumno se ha dado de Alta correctamente y pertenece a la Escuela: %s, %s del Municipio de %ss/alumnos_baja/(RR:R;RRR+RJR&RRRR2RRKRL(RRVRR((s(/home/paco/insumos/apps/control/views.pyR s   +cCs6t}idd6|d6}td|dt|S(NRR5Rsrepo_alumnos_escuela.htmlR(tRepoEscuelaAlumnosFormRR(RRR((s(/home/paco/insumos/apps/control/views.pytrepo_alumnos_escuela s cACs# |jdkrt|j}|jr|jjd}|jjd}tjjdt}t jj }t jj }tjjdtj }tjjdtddj }tjjdtddj } tjjdtddj } tjjdtdd j } tjjdtdd j } tjjdtd d d dj } tjjdtd dd dj }tjjdtd dd dj }tjjdtd d d dj }tjjdtd dj }tjjdtd dj }i}i}i}i}i}i}i}i}i}i}i}i}i}i} i}!i}"i}#i}$d}%d}&d}'d}(d})d}*x|D]}+g},g}-g}.g}/g}0g}1g}2g}3g}4g}5g}6g}7x|D]}8|8j j|+jkr |,j|8d|8jkrR|-j|8nd|8jkrq|.j|8n|8jd krd|8jkr|/j|8n|8jdkrd|8jkr|0j|8n|8jd krd|8jkr|1j|8n|8jdkr)d|8jkr)|2j|8n|8jdkrH|3j|8n|8jdkrg|4j|8n|8jdkr|5j|8n|8jd kr|6j|8n|8jd kr|7j|8qq q W|,dkrt|,||+jxQ|D]I}8|8j j|+jkrx+|D] }?|8j|?jkr||?jkr<||?jkr<|;|?j};t|;||+j<|:|?j7}:t|:| |+j<|<|?j7}<t|<|!|+j<|9|?j7}9t|9|$|+j|?j7}>t|>|#|+js       D9 +    R-    '      #     J h   &#   " Z  "