[c2@s ddkZddkTddkTddklZddkTddklZddkTddk TddklZddk l Z ddk Tddk TddklZddkTddklZlZlZddklZdd klZdd klZdd klZddkZddkZddkZdd klZddkZddk Z ddk!Z!ddk"Z"ddk#Z#dd k$l%Z%ddk&l'Z'ddk(l)Z)ddk*l+Z+l,Z,l-Z-ddk.l/Z/l0Z0l1Z1l2Z2ddk3l4Z4l5Z5l6Z6l7Z7ddk8l9Z9l:Z:l;Z;l<Z<l=Z=l>Z>l?Z?ddk@lAZAddkBlCZClDZDddklZlZlEZEddkFlGZGeGdZHeGdZIdZJdZKddkZddkLlMZMddkNlOZOddkPlQZQdeRfdYZSd ZTd!ZUd"ZVd#ZWd$ZXd%ZYd&ZZd'Z[d(Z\d)Z]d*Z^e_d+d,d-Z`e_d+d,d.Zae_d+d,d/Zbe_d+d,d0Zce_d+d,d1Zde_d+d,d2Zee_d+d,d3Zfe_d+d,d4Zge_d+d,d5Zhe_d+d,d6Zie_d+d,d7Zje_d+d,d8Zke_d+d,d9Zldd:klmZme_d+d,d;Zne_d+d,d<Zoe_d+d,d=Zpe_d+d,d>Zqe_d+d,d?Zre_d+d,d@Zse_d+d,dAZte_d+d,dBZue_d+d,dCZvdDZwe_d+d,dEZxe_d+d,dFZye_d+d,dGZze_d+d,dHZ{e_d+d,dIZ|e_d+d,dJZ}e_d+d,dKZ~e_d+d,dLZe_d+d,dMZe_d+d,dNZe_d+d,dOZe_d+d,dPZe_d+d,dQZe_d+d,dRZe_d+d,dSZe_d+d,dTZe_d+d,dUZe_d+d,dVZdWZe_d+d,dXZe_d+d,dYZeQdZZeQd[ZddkZddkLlMZMddkNlOZOeQd\ZeQd]ZeQd^ZeQd_Zd`ZdaZdbZdceeSfddYZdeeeSfdfYZdgefdhYZdiZe_d+d,djZe_d+d,dkZe_d+d,dlZe_d+d,dmZe_d+d,dnZe_d+d,doZe_d+d,dpZe_d+d,dqZe_d+d,drZe_d+d,dsZe_d+d,dtZe_d+d,duZe_d+d,dvZe_d+d,dwZe_d+d,dxZe_d+d,dyZe_d+d,dzZe_d+d,d{Ze_d+d,d|Ze_d+d,d}Ze_d+d,d~Ze_d+d,dZe_d+d,dZe_d+d,dZe_d+d,dZe_d+d,dZe_d+d,dZe_d+d,dZe_d+d,dZe_d+d,dZe_d+d,dZe_d+d,dZe_d+d,dZdZdZe_d+d,dZdS(iN(t*(tmessages(tView(tUser(tQ(t Paginatort EmptyPagetPageNotAnInteger(tSum(tEmailMultiAlternatives(trender_to_string(t strip_tags(tdate(t JasperClient(tcanvas(tCanvas(tlettert landscapetA4(tcmtmmtinchtpica(t TA_JUSTIFYtTA_RIGHTtTA_LEFTt TA_CENTER(tTablet TableStyletSimpleDocTemplatet PageTemplatet ParagraphtSpacertImage(tcolors(tgetSampleStyleSheettParagraphStyle(RRt InvalidPage(tdefaultPageSizeiit(t simplejson(t serializers(t csrf_exemptt JasperMixcBs,eZeiZdZdZhddZRS(t 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(R turltusernametpasswordt runReporttfiletwritetclose(tselftpathtnamefiletparamsttipotjtrettf((s%/opt/public_html/CCYTET/snct/views.pytgenerateReport>s #N( t__name__t __module__tsettingst JASPERSERVERR0R1R2tNoneR?(((s%/opt/public_html/CCYTET/snct/views.pyR+:s cCstii}tiidtid}tiidtid}tiidtid}t ii}t iidtid}t |dh|d6|d6|d6|d6|d6|d 6|d 6S( Ntactivotidsdashboard_base.htmltrequesttconvocat publicaciontenlacestprogtlista_graficostbanner( t convocatoriastobjectstalltPublicacionIniciotfiltertTruetorder_bytSitiosDeInteresIniciotProgramaSedeEstatalt BannerIniciotgraficostTemplateResponse(RGRHRIRJRKRMRL((s%/opt/public_html/CCYTET/snct/views.pytindexMscCs tdh|d6dt|S(Ns snct.htmlRGtcontext_instance(trender_to_responsetRequestContext(RG((s%/opt/public_html/CCYTET/snct/views.pytsnct]scCsBtiid}hdt|d6}tti|ddS(NRFs/media/timgt content_typesapplication/json(tLogotipoInicioROtlatesttstrt HttpResponsetjsontdumps(RGt imagen_inicioR/((s%/opt/public_html/CCYTET/snct/views.pytweb_service_jsonascCs tdh|d6dt|S(Nsfrecuentes.htmlRGR[(R\R](RG((s%/opt/public_html/CCYTET/snct/views.pyt frecuentesgscCs tdh|d6dt|S(Ns dudas.htmlRGR[(R\R](RG((s%/opt/public_html/CCYTET/snct/views.pytdudaskscCs tdh|d6dt|S(Nsprograma_sede_estatal.htmlRGR[(R\R](RG((s%/opt/public_html/CCYTET/snct/views.pytprograma_sede_estataloscCsEtiidtid}tdh|d6|d6dt|S(NRERFsconvocatoria.htmlRGRHR[(RNRORRRSRTR\R](RGRH((s%/opt/public_html/CCYTET/snct/views.pytconvocatorias_tsc Csad}d}y{h|d6|d6}td|}t|}td|ti|g}|i|dtid|id}Wnt i j od}d }nt i j od}d }nt i j od}d }nkt i j od}d }nJt j od}d }n,tj o} d}t| d}nX||fS(NR't finalidadt cuerpo_avisosmaquetado_correos.htmlsAINFORMACION CONSEJO DE CIENCIA Y TECNOLOGIA DEL ESTADO DE TABASCOs text/htmlisEnvío completamente exitosos/SMTP Recipient Refused, destinatarios denegadoss6SMTP Helo Error, acceso denegado al servicio de correos+SMTP Sender Refused, correo origen denegadosISMTP Data Error, probablemente ha llegado al límite de envío de correossDSMTP Error, probablemente ha llegado al límite de envío de correoss:, probablemente ha llegado al límite de envío de correos(R R R RBtEMAIL_HOST_USERtattach_alternativettimetsleeptsendtsmtplibtSMTPRecipientsRefusedt SMTPHeloErrortSMTPSenderRefusedt SMTPDataErrort ExceptionRc( temailRmRnterrortresultt email_contextt email_htmlt email_texttcorreotError((s%/opt/public_html/CCYTET/snct/views.pytsourceSendMailzsH           c1 Cs|idjo4t|i}t|i}t}|io|io|id}|id}|id}|id}|id}|id} |id} |id } |id } |id } |id }|id }|id}|id}|id}|id}|id}|id}t}||_||_ ||_ ||_ ||_ ||_ ||_t|_|id}|id}|id}|id}|id}t}||_ ||_ ||_ ||_ ||_ ||_t|_tiid|}|idd}d}d} x |D]}!|!i}|!i} qOWt|t|joF| tjo9d}"t|"id}#ti||#t|iS|i|i|}$|}%td}&|id}t||&jo4td|d |d!t}'t|id"|'}n+td|d |}'t|id"|'}|io|i}(|(|_|it}!||!_ ||!_||!_||!_ ||!_ | |!_!| |!_ | |!_ | |!_"| |!_#||!_$||!_%|$|!_|(|!_|!it&d#|!})|)it'd$|)d%|%}*|*i|}+|ii(d&},|ii(d'}-td(d)t|,d*t|-}#t|+}.y<t)d |.d+d,d-|#}/ti*|d.t|iSWq&t+j o}0td/SXq@q_d0}#ti,||#nt}t}t}t-d1h|d26|d36|d46|d56d6t.|S(7NtPOSTtnombretsiglast direcciont poblaciont municipiot codigo_postalttelefonot extenciont pagina_webtfecha_registrotfaxttipo_instituciont participaciontnombre_responsablettelefono_responsabletextencion_responsabletcelulartcorreo_responsabletnombre_suplentettelefono_suplentetextension_suplentetcelular_suplentetcorreo_suplentetparticipacion__nombres-Coordinador del Comité Organizador MunicipalR'sjEl municipio ya cuenta con un Coordinador Municipal registrado. Favor de elegir la otra opcion disponible.sutf-8s)Miembro del Comité Organizador Municipalt first_nameRztis_stafftinstancet instituciontsuplentetpersonaR1t password1sTGracias por participar en la Semana Nacional de Ciencia y Tecnología en Tabasco: s Usuario: s Contrasenia: RmiRnsZLos datos se guardaron correctamente. Su usuario y contraseña fueron enviados a su correos/index/s&Por favor, corrija el siguiente error.sregistro_institucion.htmlRGtformt formulario1t formulario2R[(/tmethodtRegistroResponsableRtRegistroInsticiontUserCreationFormtis_validt cleaned_datat cat_personasRRRRRRRRStadmin_municipiotFalseRORRRctencodeRtwarningtHttpResponseRedirectR8tsaveRtusuarioRRRRRRRRRtSuplentetSuplentePersonastgetRtsuccessRyR{R\R](1RGRRRRRRRRRRRRRRRRRRRRRtqRRRRRtstconsultatparticitpartiRtptmssjtmsjtiditodot administradortitcdtsuptsptcorreo_R1R2t var_emailt resultadote((s%/opt/public_html/CCYTET/snct/views.pytregistro_institucions                                           &                          %    cCst|dh|d6S(Ns login1.htmlRG(RY(RG((s%/opt/public_html/CCYTET/snct/views.pytlogin_AscCs|id}|id}td|d|}d}|dj o]|ioEt|||io tdS|io tdStdSq|d}n |d}t|dh|d6S( NR1R2R's/registro_de_actividad/sCuenta desactivadas-Usuario no valido, Verifique sus credencialess login1.htmlR( Rt authenticateRDt is_activetlogint is_superuserRRRY(RGR1R2tusertmensaje((s%/opt/public_html/CCYTET/snct/views.pytvalidarEs          t login_urlt/cCstii}tii}tiiidt}tiiidt}tiiidtdt}tii}tdh|d6|d6|d6|d6|d6|d 6|d 6d t |S( Ntbanderat generar_foliosprincipal.htmlt municipiosttotal_actividadestactividades_confirmadastactividades_no_confirmadastinstituciones_tfolios_generadosRGR[( t cat_municipioRORPtregistro_actividadRRRSRRR\R](RGRRRRRR((s%/opt/public_html/CCYTET/snct/views.pytprincipal_administrador[s!cCsutii}tiid|}tiid|}tdh|d6|d6|d6|d6dd6d t|S( NtpkRsinstitucion.htmlRt institucionesRGtactiveRR[(RRORPRRRRR\R](RGt id_municipioRRR((s%/opt/public_html/CCYTET/snct/views.pyRns /cCstii}tiiid}tiiid}tiiid}tdh|d6|d6|d6|d6|d6dt|S( Nttipo_actividad_idsreporte_actividades.htmlRtlista_actividadestlista_publico_actividadest$lista_publico_actividades_realizadasRGR[( RRORPtReporteActividades1RTtReporteActividades2tReporteActividades3R\R](RGRRRR((s%/opt/public_html/CCYTET/snct/views.pytreporte_actividadesys c Cstiid|iig}tii}tiid|}d}x|D]}|ii}qOWtiid|}d}d|i job|i i d}|it d|t d|Bt d|Bt d |Bt d |B}nd } d |i jo|i i d } nt || } |i i d } y| i | } WnFtj o| i d} n&tj o| i | i} nXtdh |d6| d6| d 6|d6|d6|d6dd6|d6|d6|d6dt|S(Nt usuario__inRR'Rtbscrttitulo__icontainst!tipo_actividad__nombre__icontainsttema__icontainst(responsable_actividad__nombre__icontainstexpositor__nombre__icontainsi trpptpageis mun_actividades_institucion.htmltnombre_instituciontcontactsRRRRtlista_actividadtid_institucionRGR[(RRORRRRFRRPRRtGETRRRRRRt num_pagesR\R]( RGRRRRtxRRRRt paginatorRR((s%/opt/public_html/CCYTET/snct/views.pytmun_actividades_institucions<3cCstiiid|iig}tiid|iig}|idt}tdh|d6|d6|d6|d6dt |S( NRRsprincipal.htmlRtact_realizadasRRGR[( RRORPRRRRFRRSR\R](RGRRR((s%/opt/public_html/CCYTET/snct/views.pyt principals $cCs0tiid|iig}tiid|iig}tiididi d}t ii }tii }tii idt }tii idt }tii itd}|d}tii itd} | d} tii idt dt } tii } d} d|ijoU|iid} |itd | td | Btd | Btd | B}nd } d|ijo|iid} nt|| }|iid}y|i|}WnFtj o|id}n&tj o|i|i}nX|idjo?t|i}tiid|i}|io|io|d i}|idt }|i|_ |ii|_!|i|i"d}xI|D]A}td|d|d|i|i#i$dd}|iqWx|iD]}tiid|i%}t}|i||_#|i%|_&|i'do!|i|i(i)|iqC|i'do!|i|i*i)|iqC|i'do!|i|i+i)|iqC|i'do!|i|i,i)|iqCqCWd}t-i.||t/dSd}t-i0||t/dSqn t}t1d h|d!6d"d#6|d$6|d%6|d&6|d'6| d(6| d)6| d*6|d+6| d6| d6|d6|d,6|d-6|d.6|d/6d0t2|S(1NRRRtcantidadt cantidad__sumRR'RRRRRi RRiRRtcommitt tipo_publicot actividadt t_Rt expositort organizadort participantet patrocinadors%Los datos se guardaron correctamente.s/registro_de_actividad/sFNo se logro localizar los datos del usuario en el catalogo de nombres.sregistro_actividad.htmlRRt m_actividadesRRRtasistentes_esperadostasistentes_confirmadosRRRGt formularioRRtlista_responsablesR[(3RRORRRRFRRtvaluestdistinctRTRRPRSRtpaso_tipo_publicot aggregateRtPaso_Tipo_Publico_FinalRRRRRRRRRtRegistroActividadRRtexistsRtresponsable_actividad_idt usuario_idRRtreplaceRtactividad_relacionada_idt startswithRtaddt organizadorest participantestpatrocinadoresRRRR{R\R](RGRRRRRRRR RRRRRRRRRtresponsable_objecttpruebatatytpasoRRRR((s%/opt/public_html/CCYTET/snct/views.pytregistro_de_actividads$  !&               cCstiid|iig}tiid|iig}|id|}tiid|}tii}t iid|}d}d|i job|i i d}|it d|t d|Bt d |Bt d |Bt d |B}nd }d |i jo|i i d }nt ||} |i i d} y| i| } WnFtj o| id} n&tj o| i| i} nX|idjotii d|} tdh | id6| id6| id6| id6| id6| id6| id6| id6| id6| id6| id6d| } n|idjot|i|i } | i!otii d|} | i"d| _| i"d| _| i"d| _| i"d| _| i"d| _| i"d| _| i"d| _| i"d| _| i"d| _| i"d| _| i"d| _| i#x<|i i$dD](}td| }||_%|i#qhW| i"d }xI|D]A}t d |d| d!|i|i&i'd"d#}|i#qWd$}t(i)||t*|i+Sd%}t(i,||n t} t-d&h|d'6|d(6|d)6|d*6|d6| d+6| d,6|d-6d.t.|S(/NRRRRR'RRRRRRi RRiRtinitialttitulottipo_actividadtespecificar_actividadttematfechathoratlugarRRtcupot descripcionRRtimagenesRRRRs(Los datos se actualizaron correctamente.s&Por favor, corrija el siguiente error.sedit_actividad.htmltcantidad_publicoRRRGRRtimgsR[(/RRORRRRFRtimagen_registro_actividadRRPRRRRRRRRRRRR(R)R*R+R,R-R.RRR/R0RtFILESRRRtgetlistR1RRRRRR8R{R\R](RGt id_actividadRRR3RR2RRRRRtdRR>timagR#R$R%R((s%/opt/public_html/CCYTET/snct/views.pytedit_actividadAs3    1 c Cstii}tiid|iig}tiiid|iig}d}d|ijoU|ii d}|it d|t d|Bt d|Bt d|B}nd}d |ijo|ii d }nt ||}|ii d }y|i |}WnFt j o|i d }n&tj o|i |i}nXtiiid|iig}td h |d 6|d6|d 6|d6|d 6|d6|d6|d6dd6dt|S(NRR'RRRRRi RRisprograma_actividad.htmlRRRRRGRR R[(RRORPRRRRRFRRRRRRRRRR\R]( RGRRRRRRRR((s%/opt/public_html/CCYTET/snct/views.pytprograma_actividads2$&$c Cstii}tiid|iig}tiiid|iigdtdt}t}x|D]}|i }qjWd}d|i joU|i i d}|it d|t d|Bt d|Bt d |B}nd }d |i jo|i i d }nt ||}|i i d } y|i| } WnFtj o|id } n&tj o|i|i} nXtiiid|iig}tdh |d6|d6|d6|d 6|d6| d 6|d6| d6dd6|d6dt|S(NRRRR'RRRRRi RRisreconocimiento.htmlRRRRRtreconocimientosRGR[(RRORPRRRRRFRRSRRRRRRRRRR\R]( RGRRRRRRRRRR((s%/opt/public_html/CCYTET/snct/views.pytgenerar_reconocimientos:0 &$c Cstii}tiid|iig}tiid|iig}xS|D]K}tiid|i}|i o t |_ n t |_ |i qRWd}d|ijoU|iid}|itd|td|Btd|Btd|B}nd }d |ijo|iid }nt||}|iid } y|i| } WnFtj o|id } n&tj o|i|i} nXtd h|d6dd6|d 6|d6| d 6|d6| d6|d6dt|S(NRRR'RRRRRidRRiscofirmar_actividad.htmlRRtconfirmar_genararRRRGR[(RRORPRRRRRFRR4RRSR1RRRRRRRRRRR\R]( RGRRRRtimagenes_actividadRRRRR((s%/opt/public_html/CCYTET/snct/views.pytconfirmar_actividads>   &c Cstiid|}tiid|}tiiid|}|idjot|i }|i o|i d}x|D]}|i |i i dd}y2tiid|d|} || _| iWqtij o5t} || _|| _|| _| iqXqWx@|iidD](} td|} | | _| iq7Wqtn t}td h|d 6|d 6|d 6|d 6dt|S(NRRRRRRRR1ssubir_imagen_actividad.htmlRGR3RR2R[(R4RORRRRRRPRtPasoTipoPublicoFinalFormRRRRRRRt DoesNotExistRRR5R6R1R\R]( RGR7R1Rtcantidad_publico_finalRtpublicostpublicoR2tcombinacion_actividadtnueva_combinaciontimagenR9((s%/opt/public_html/CCYTET/snct/views.pytsubir_imagen_actividad3sB            cCsVtiid|}|o0tiid|}|i |_|intdS(NRRs/confirmar_actividad/(R4RORRRRRRR(RGR7R?tactividad_confirmada((s%/opt/public_html/CCYTET/snct/views.pytfolios_actividades  cCs@tiid|}|iot|_|intdS(NRs/confirmar_actividad/(RRORRRSRRR(RGtid_actividad_confirmadaR((s%/opt/public_html/CCYTET/snct/views.pytgenerar_folios_actividados   (tCountcsntiiid|iig}|idtdt}ti}|i }d}t dd}t }g}t |dt tdd td d td d td dt}g} |d} |itdd|d} t| _d| _d| _|itdd|d} t| _d| _d| _dddgg} d} x|D]z}xq|iiD]`}| idt|dt|idt|it|i| t|i| gqpWqZWt| d tdtdtdtgdddd d7d8d#ti fd$d9d:dfd%d;d<d&fd%d=d>d&fd%d?d@d)fd%dAdBd&fd%dCdDd)fd%dEdFd&fd%dGdHd&fd%dIdJd)fd%dKdLd&fg }d&|_!|i|d"dk"}|i#i$|i#i%|i#i&t'd1|i#i$|i#i%|i#i&t'd2fd3}d4}|i(|d5|d6||S(MNRRRR'tmimetypesapplication/pdftpagesizet rightMarginit leftMargint topMarging@t bottomMarginith1tnametCentradot Helveticai t JustificadoitFOLIOt EXPOSITORESt ACTIVIDADESsTAB-AI-t-g@g @t repeatRowsitstyletGRIDiig?tFONTSIZEtALIGNtCENTERiitLEFTiiiiiiisstatic/logo.pngsstatic/logo-dgtic.pngcs|i|idtddd|idd|idtdd d |id td td |i|idS(Niiii2RXi gffffff,@iiPi(ig?s Página %d(t saveStatet drawImageRtsetFontt drawStringRRt restoreState(Rtdoc(RHtimagen2(s%/opt/public_html/CCYTET/snct/views.pyt myFirstPages  "cSsP|i|idd|idtdtd|itf|idS(NRXi ig?s Página %d %s(ReRgRhRRRtpageinfoRi(RRj((s%/opt/public_html/CCYTET/snct/views.pyt myLaterPagess (t onFirstPaget onLaterPages(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(i i(ii()RRORPRRRRFRSR ttodaytyearRdR#RRRRRRR$Rt alignmenttfontNametfontSizeRRtappendRcRRR(RR"tgreythAligntosR8tjointdirnametabspatht__file__tbuild(RGRR8RrRtresponsetestilotelementsRjR/RURWRYtauxRtexptt_datosRyRlRn((RHRks%/opt/public_html/CCYTET/snct/views.pytfolios_expositores{sr$   )          /"   -- csntiiid|iig}|idtdt}ti}|i }d}t dd}t }g}t |dt tdd td d td d td dt}g} |d} |itdd|d} t| _d| _d| _|itdd|d} t| _d| _d| _dddgg} d} x|D]z}xq|iiD]`}| idt|dt|idt|it|i| t|i| gqpWqZWt| d tdtdtdtgdddd d7d8d#ti fd$d9d:dfd%d;d<d&fd%d=d>d&fd%d?d@d)fd%dAdBd&fd%dCdDd)fd%dEdFd&fd%dGdHd&fd%dIdJd)fd%dKdLd&fg }d&|_!|i|d"dk"}|i#i$|i#i%|i#i&t'd1|i#i$|i#i%|i#i&t'd2fd3}d4}|i(|d5|d6||S(MNRRRR'ROsapplication/pdfRPRQiRRRSg@RTiRURVRWRXi RYiRZt PARTICIPANTESR\sTAB-AI-R]g@g @R^iR_R`iig?RaRbRciiRdiiiiiiisstatic/logo.pngsstatic/logo-dgtic.pngcs|i|idtddd|idd|idtdd d |id td td |i|idS(Niiii2RXi gffffff,@iiPi(ig?s Página %d(ReRfRRgRhRRRi(RRj(RHRk(s%/opt/public_html/CCYTET/snct/views.pyRl's  "cSsP|i|idd|idtdtd|itf|idS(NRXi ig?s Página %d %s(ReRgRhRRRRmRi(RRj((s%/opt/public_html/CCYTET/snct/views.pyRn0s (RoRp(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(i i(ii()RRORPRRRRFRSR RqRrRdR#RRRRRRR$RRsRtRuRRRvRcRRR(RR"RwRxRyR8RzR{R|R}R~(RGRR8RrRRRRRjR/RURWRYRRRRRyRlRn((RHRks%/opt/public_html/CCYTET/snct/views.pytfolios_participantessr$   )          /"   -- cstiiid|ii}|idtdt}ti}|i }d}t dd}t }g}t |dt tdd td d td d td dt}g} |d} |itdd|d} t| _d| _d| _|itdd|d} t| _d| _d| _dddgg} d} x|D]}d}d}|idjod}d}n|ii}|ii}xq|iiD]`}| idt|dt|idt|it|i| t|i| gqWqWWt | d td tdtdtgdd d!d"d8d9d$t!i"fd%d:d;dfd&d<d=d'fd&d>d?d'fd&d@dAd*fd&dBdCd'fd&dDdEd*fd&dFdGd'fd&dHdId'fd&dJdKd*fd&dLdMd'fg }d'|_#|i|d#dk$}|i%i&|i%i'|i%i(t)d2|i%i&|i%i'|i%i(t)d3fd4}d5}|i*|d6|d7||S(NNt usuario__pkRRR'ROsapplication/pdfRPRQiRRRSg@RTiRURVRWRXi RYiRZt ORGANIZADORESR\issin responsablesTAB-OI-R]g@g @R^iR_R`ig?RaRbRciiRdiiiiiiisstatic/logo.pngsstatic/logo-dgtic.pngcs|i|idtddd|idd|idtdd d |id td td |i|idS(Niiii2RXi gffffff,@iiPi(ig?s Página %d(ReRfRRgRhRRRi(RRj(RHRk(s%/opt/public_html/CCYTET/snct/views.pyRls  "cSsP|i|idd|idtdtd|itf|idS(NRXi ig?s Página %d %s(ReRgRhRRRRmRi(RRj((s%/opt/public_html/CCYTET/snct/views.pyRns (RoRp(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(i i(ii(+RRORPRRRRFRSR RqRrRdR#RRRRRRR$RRsRtRuRtresponsable_actividadRDRRRvRcRR(RR"RwRxRyR8RzR{R|R}R~(RGRR8RrRRRRRjR/RURWRYRRt responsableidtresponsablenombretparRRyRlRn((RHRks%/opt/public_html/CCYTET/snct/views.pytfolios_organizadoresAs!   )             /"   -- cshtiiid|iig}|idtdt}ti}|i }d}t dd}t }g}t |dt tdd td d td d td dt}g} |d} |itdd|d} t| _d| _d| _|itdd|d} t| _d| _d| _dddgg} x|D]z} xq| iiD]`}| idt|dt|idt| it|i| t| i| gqjWqTWt| d td tdtdtgdddd d7d8d#ti fd$d9d:dfd%d;d<d&fd%d=d>d&fd%d?d@d)fd%dAdBd&fd%dCdDd)fd%dEdFd&fd%dGdHd&fd%dIdJd)fd%dKdLd&fg }d&|_!|i|d"dk"}|i#i$|i#i%|i#i&t'd1|i#i$|i#i%|i#i&t'd2fd3}d4}|i(|d5|d6||S(MNRRRR'ROsapplication/pdfRPRQiRRRSg@RTiRURVRWRXi RYiRZtPATROCINADORESR\sTAB-PI-R]g@g @R^iR_R`iig?RaRbRciiRdiiiiiiisstatic/logo.pngsstatic/logo-dgtic.pngcs|i|idtddd|idd|idtdd d |id td td |i|idS(Niiii2RXi gffffff,@iiPi(ig?s Página %d(ReRfRRgRhRRRi(RRj(RHRk(s%/opt/public_html/CCYTET/snct/views.pyRls  "cSsP|i|idd|idtdtd|itf|idS(NRXi ig?s Página %d %s(ReRgRhRRRRmRi(RRj((s%/opt/public_html/CCYTET/snct/views.pyRns (RoRp(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(i i(ii()RRORPRRRRFRSR RqRrRdR#RRRRRRR$RRsRtRuRR RvRcRRR(RR"RwRxRyR8RzR{R|R}R~(RGRR8RrRRRRRjR/RURWRYRRRRyRlRn((RHRks%/opt/public_html/CCYTET/snct/views.pytfolios_patrocinadoressp$   )          /"   -- csytiiid|iigdtdt}ti}|i }t ii d|ii}t dd}t }g}t|dttdd td d td d td dt}g} |d} |itdd|d} t| _d| _d| _|itdd|d} t| _d| _d| _dddgg} |od} x|D]}| |id7} qjW| idt|dt|idt|it|i| t| | gnt | d td tdtdtgdd d!d"d9d:d%t!i"fd&d;d<dfd'd=d>d(fd'd?d@d(fd'dAdBd+fd'dCdDd(fd'dEdFd+fd'dGdHd(fd'dIdJd(fd'dKdLd+fd'dMdNd(fg }d(|_#|i|d$dk$}|i%i&|i%i'|i%i(t)d3|i%i&|i%i'|i%i(t)d4fd5}d6}|i*|d7|d8||S(ONRRRRFROsapplication/pdfRPRQiRRRSg@RTiRURVRWRXi RYiRZt RESPONSABLER\R's sTAB-RI-R]g@g @R^iR_R`iig?RaRbRciiRdiiiiiiisstatic/logo.pngsstatic/logo-dgtic.pngcs|i|idtddd|idd|idtdd d |id td td |i|idS(Niiii2RXi gffffff,@iiPi(ig?s Página %d(ReRfRRgRhRRRi(RRj(RHRk(s%/opt/public_html/CCYTET/snct/views.pyRlls  "cSsP|i|idd|idtdtd|itf|idS(NRXi ig?s Página %d %s(ReRgRhRRRRmRi(RRj((s%/opt/public_html/CCYTET/snct/views.pyRnus (RoRp(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(i i(ii(+RRORPRRRRFRSR RqRrRRRdR#RRRRRRR$RRsRtRuRR(RvRctcountRRRR"RwRxRyR8RzR{R|R}R~(RGRR8Rrtusuario_responsableRRRRjR/RURWRYtactividades_responsableRRRyRlRn((RHRks%/opt/public_html/CCYTET/snct/views.pytfolio_responsablest!    )          2 "   -- cshtiiid|iig}|idtdt}ti}|i }d}t dd}t }g}t |dt tdd td d td d td dt}g} |d} |itdd|d} t| _d| _d| _|itdd|d} t| _d| _d| _dddgg} x|D]z} xq| iiD]`}| idt|dt|idt| it|i| t| i| gqjWqTWt| d tdtdtdtgdddd d7d8d#ti fd$d9d:dfd%d;d<d&fd%d=d>d&fd%d?d@d)fd%dAdBd&fd%dCdDd)fd%dEdFd&fd%dGdHd&fd%dIdJd)fd%dKdLd&fg }d&|_!|i|d"dk"}|i#i$|i#i%|i#i&t'd1|i#i$|i#i%|i#i&t'd2fd3}d4}|i(|d5|d6||S(MNRRRR'ROsapplication/pdfRPRQiRRRSg@RTiRURVRWRXi RYiRZR[R\sTAB-AE-R]g@g @R^iR_R`iig?RaRbRciiRdiiiiiiisstatic/logo.pngsstatic/logo-dgtic.pngcs|i|idtddd|idd|idtdd d |id td td |i|idS(Niiii2RXi gffffff,@iiPi(ig?s Página %d(ReRfRRgRhRRRi(RRj(RHRk(s%/opt/public_html/CCYTET/snct/views.pyRls  "cSsP|i|idd|idtdtd|itf|idS(NRXi ig?s Página %d %s(ReRgRhRRRRmRi(RRj((s%/opt/public_html/CCYTET/snct/views.pyRns (RoRp(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(i i(ii()RRORPRRRRFRSR RqRrRdR#RRRRRRR$RRsRtRuRRRvRcRRR(RR"RwRxRyR8RzR{R|R}R~(RGRR8RrRRRRRjR/RURWRYRRRRyRlRn((RHRks%/opt/public_html/CCYTET/snct/views.pytfolios_expositores1sp$   )          /"   -- cshtiiid|iig}|idtdt}ti}|i }d}t dd}t }g}t |dt tdd td d td d td dt}g} |d} |itdd|d} t| _d| _d| _|itdd|d} t| _d| _d| _dddgg} x|D]z} xq| iiD]`}| idt|dt|idt| it|i| t| i| gqjWqTWt| d tdtdtdtgdddd d7d8d#ti fd$d9d:dfd%d;d<d&fd%d=d>d&fd%d?d@d)fd%dAdBd&fd%dCdDd)fd%dEdFd&fd%dGdHd&fd%dIdJd)fd%dKdLd&fg }d&|_!|i|d"dk"}|i#i$|i#i%|i#i&t'd1|i#i$|i#i%|i#i&t'd2fd3}d4}|i(|d5|d6||S(MNRRRR'ROsapplication/pdfRPRQiRRRSg@RTiRURVRWRXi RYiRZRR\sTAB-AE-R]g@g @R^iR_R`iig?RaRbRciiRdiiiiiiisstatic/logo.pngsstatic/logo-dgtic.pngcs|i|idtddd|idd|idtdd d |id td td |i|idS(Niiii2RXi gffffff,@iiPi(ig?s Página %d(ReRfRRgRhRRRi(RRj(RHRk(s%/opt/public_html/CCYTET/snct/views.pyRl0s  "cSsP|i|idd|idtdtd|itf|idS(NRXi ig?s Página %d %s(ReRgRhRRRRmRi(RRj((s%/opt/public_html/CCYTET/snct/views.pyRn9s (RoRp(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(i i(ii()RRORPRRRRFRSR RqRrRdR#RRRRRRR$RRsRtRuRRRvRcRRR(RR"RwRxRyR8RzR{R|R}R~(RGRR8RrRRRRRjR/RURWRYRRRRyRlRn((RHRks%/opt/public_html/CCYTET/snct/views.pytfolios_participantes1sp$   )          /"   -- cstiiid|ii}|idtdt}ti}|i }d}t dd}t }g}t |dt tdd td d td d td dt}g} |d} |itdd|d} t| _d| _d| _|itdd|d} t| _d| _d| _dddgg} d} x|D]}d}d}|idjod}d}n|ii}|ii}| idt|dt|dt|it|| t|i| gxq|iiD]`}| idt|dt|idt|it|i| t|i| gqWqWWt | d td tdtdtgdd d!d"d8d9d$t!i"fd%d:d;dfd&d<d=d'fd&d>d?d'fd&d@dAd*fd&dBdCd'fd&dDdEd*fd&dFdGd'fd&dHdId'fd&dJdKd*fd&dLdMd'fg }d'|_#|i|d#dk$}|i%i&|i%i'|i%i(t)d2|i%i&|i%i'|i%i(t)d3fd4}d5}|i*|d6|d7||S(NNRRRR'ROsapplication/pdfRPRQiRRRSg@RTiRURVRWRXi RYiRZRR\issin responsablesTAB-OI-R]g@g @R^iR_R`ig?RaRbRciiRdiiiiiiisstatic/logo.pngsstatic/logo-dgtic.pngcs|i|idtddd|idd|idtdd d |id td td |i|idS(Niiii2RXi gffffff,@iiPi(ig?s Página %d(ReRfRRgRhRRRi(RRj(RHRk(s%/opt/public_html/CCYTET/snct/views.pyRls  "cSsP|i|idd|idtdtd|itf|idS(NRXi ig?s Página %d %s(ReRgRhRRRRmRi(RRj((s%/opt/public_html/CCYTET/snct/views.pyRns (RoRp(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(i i(ii(+RRORPRRRRFRSR RqRrRdR#RRRRRRR$RRsRtRuRRRDRRvRcRR(RRR"RwRxRyR8RzR{R|R}R~(RGRR8RrRRRRRjR/RURWRYRRRtresponablenombreRRRyRlRn((RHRks%/opt/public_html/CCYTET/snct/views.pytfolios_organizadores1Js!   )             , /"   -- csntiiid|iig}|idtdt}ti}|i }d}t dd}t }g}t |dt tdd td d td d td dt}g} |d} |itdd|d} t| _d| _d| _|itdd|d} t| _d| _d| _dddgg} d} x|D]z}xq|iiD]`}| idt|dt|idt|it|i| t|i| gqpWqZWt| d td tdtdtgdddd d7d8d#ti fd$d9d:dfd%d;d<d&fd%d=d>d&fd%d?d@d)fd%dAdBd&fd%dCdDd)fd%dEdFd&fd%dGdHd&fd%dIdJd)fd%dKdLd&fg }d&|_!|i|d"dk"}|i#i$|i#i%|i#i&t'd1|i#i$|i#i%|i#i&t'd2fd3}d4}|i(|d5|d6||S(MNRRRR'ROsapplication/pdfRPRQiRRRSg@RTiRURVRWRXi RYiRZRR\sTAB-PE-R]g@g @R^iR_R`iig?RaRbRciiRdiiiiiiisstatic/logo.pngsstatic/logo-dgtic.pngcs|i|idtddd|idd|idtdd d |id td td |i|idS(Niiii2RXi gffffff,@iiPi(ig?s Página %d(ReRfRRgRhRRRi(RRj(RHRk(s%/opt/public_html/CCYTET/snct/views.pyRls  "cSsP|i|idd|idtdtd|itf|idS(NRXi ig?s Página %d %s(ReRgRhRRRRmRi(RRj((s%/opt/public_html/CCYTET/snct/views.pyRns (RoRp(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(i i(ii()RRORPRRRRFRSR RqRrRdR#RRRRRRR$RRsRtRuRR RvRcRRR(RR"RwRxRyR8RzR{R|R}R~(RGRR8RrRRRRRjR/RURWRYRRtpatRRyRlRn((RHRks%/opt/public_html/CCYTET/snct/views.pytfolios_patrocinadores1sr$   )          /"   -- cstiiid|iig}ti}|i}d}t dd}t }g}t |dt t ddtddtd d td d t}g} |d } |itdd|d} t| _d| _d| _|itdd|d} t| _d| _d| _ddddddddgg} d} x|D]}| it|i| t|ii| t|i| ttdt|iidt|i| t|i | t|i!i| t|i"| t|i#| gqQWt$| d td td td td td td td td tg ddd d!d8d9d$t%i&fd%d:d;dfd&d<d=d'fd&d>d?d'fd&d@dAd*fd&dBdCd'fd&dDdEd*fd&dFdGd'fd&dHdId'fd&dJdKd*fd&dLdMd'fg }d'|_'|i|d#dk(}|i)i*|i)i+|i)i,t-d2|i)i*|i)i+|i)i,t-d3fd4}d5}|i.|d6|d7||S(NNRR'ROsapplication/pdfRPRQiRRRSg@RTiRURVRWRXi RYit ActividadsTipo de ActividadtTemas Fecha y HoratLugart Municipiot Direccions DescripciónsFecha:s Hora:R^iR_R`iig?RaRbRciiRdiiiiiiisstatic/logo.pngsstatic/logo-dgtic.pngcs|i|idtddd|idd|idtdd d |id td td |i|idS(Niiii2RXi gffffff,@iiPi(ig?s Página %d(ReRfRRgRhRRRi(RRj(RHRk(s%/opt/public_html/CCYTET/snct/views.pyRlus  "cSsP|i|idd|idtdtd|itf|idS(NRXi ig?s Página %d %s(ReRgRhRRRRmRi(RRj((s%/opt/public_html/CCYTET/snct/views.pyRn~s (RoRp(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(i i(ii(/RRORPRRRRFR RqRrRdR#RRRRRRR$RRsRtRuRRvRR(R)RR+RcR,R-R.RRR0RR"RwRxRyR8RzR{R|R}R~(RGRR8RrRRRRRjR/RURWRYRRRRyRlRn((RHRks%/opt/public_html/CCYTET/snct/views.pytreportes"s$   )          3E   -- c Csytiid|ii}|iiidjotiid|i}ntiid|iig}tdh|d6|d6dt |SWn)ti j otddt |SXdS( NRiRRsinstitucion.htmlRRR[( RRORRRFRRRRR\R]RB(RGtinsR((s%/opt/public_html/CCYTET/snct/views.pyt institucion_s+cCsXtii}tiid|iig}tiid|}d}|idjotiid|}t dh |i d6|i d6|i d 6|i d 6|id 6|id 6|id 6|id6|id6|id6|id6|id6}n|idjot |i}|iotiid|}|id|_ |id|_ |id |_ |id |_ |id |_|id |_|id |_|id|_|id|_|id|_|id|_|itdSn t }tdh|d6|d6dd6|d6|d6|d6|id6dt|S(NRRFR'RRR'RRRRRRRRRRRRRs/registro_de_actividad/sedit_institucion.htmlRtinstitucion_adminRRRRRGR[(RRORPRRRRRFRRRRRRRRRRRRRRRRRRRRR\R](RGRRRRR>R8R((s%/opt/public_html/CCYTET/snct/views.pytedit_institucionsB+   c Cstii}tiid|ii}tiid|d|iii}d}d|i job|i i d}|it d|t d|Bt d|Bt d|Bt d |B}nd }d |i jo|i i d }nt ||}|i i d }y|i |} WnFtj o|i d } n&tj o|i |i} nXd} d} tdh |d6| d6| d6|d 6|d6| d6|d6|d6dd6dt|S(NRRFR'RRRRRRi RRit Conferenciasregistro_expositor.htmlRR#RRRGRR R[(RRORPRRRRRFRRRRRRRRRRR\R]( RGR7RRRRRRRRRR#((s%/opt/public_html/CCYTET/snct/views.pytagregar_expositors4'3&cCs;tii}tiididid}|idjot|i }|i o|i i d}tii ddi |i}d}d}x |D]} | i}| i}qWtd|}td|}||joXtii d|} | ii|| iti|d td t|d S|i i d}t} || _| i| i} tii d|} | i} | ii| | iti|d td t|d Sqti|d n t}tdh|d6|d6|d6|d6|d6dt|S(NRRtnombre__icontainsRR'ittextoRs2EL EXPOSITOR ASOCIADO CORRECTAMENTE A LA ACTIVIDADs/agregar_expositor/Rs<EXPOSITOR REGISTRADO CORRECTAMENTE Y ASOCIADO A LA ACTIVIDADsFALTAN DATOS EN EL FORMULARIOsadd_expositor.htmlRR7RGRtlista_expositoresR[(RRORPRRRRTRtRegistroExpositorRRRRRRztsplitRRFttextNormalizedRRRRRRRRcR{R\R](RGR7RRRt expositor_t consulta_expotvartexp_idtepRRR#t actividad_id((s%/opt/public_html/CCYTET/snct/views.pyt add_expositorsH$ $           %cCst|id}d|idd}tiid|}|ii||i|o tdStd|SdS(Nt HTTP_REFERERshttp://t HTTP_HOSTs/registro_de_actividad/RFs/agregar_expositor/(tMETARRORRtremoveRR(RGR7t id_expositorR0t url_registrotconsul_expositor((s%/opt/public_html/CCYTET/snct/views.pytborrar_expositor's  cCsyVtiid|}|itihdd6t|d6}t|ddSWn7tihdd6t|d6}t|ddSXdS(NRFRtstatusR`sapplication/jsonR{(R4RORtdeleteR(RftintRd(RGRFt consul_imagenR#((s%/opt/public_html/CCYTET/snct/views.pyt borrar_imagen3s ##c Cstii}tiid|ii}tiid|d|iii}d}d|i job|i i d}|it d|t d|Bt d|Bt d|Bt d |B}nd }d |i jo|i i d }nt ||}|i i d }y|i |} WnFtj o|i d } n&tj o|i |i} nXtdh|d6|d 6|d6| d6|d6|d6dd6dt|S(NRRFR'RRRRRRi RRisregistro_participantes.htmlRRRRGRR R[(RRORPRRRRRFRRRRRRRRRRR\R]( RGR7RRRRRRRR((s%/opt/public_html/CCYTET/snct/views.pytagregar_participantes?s,'3%cCs;tii}tiididid}|idjot|i }|i o|i i d}tii ddi |i}d}d}x |D]} | i}| i}qWtd|}td|}||joXtii d|} | ii|| iti|d td t|d S|i i d}t} || _| i| i} tii d|} | i} | ii| | iti|d td t|d Sqti|d n t}tdh|d6|d6|d6|d6|d6dt|S(NRRRRR'iRRs5EL PARTICIPANTE ASOCIADO CORRECTAMENTE A LA ACTIVIDADs/agregar_participantes/Rs?PARTICIPANTE REGISTRADO CORRECTAMENTE Y ASOCIADO A LA ACTIVIDADsFALTAN DATOS EN EL FORMULARIOsadd_participantes.htmlRR7RRRGR[(RRORPRRRRTRtRegistroParticipantesRRRRRRzRRRFRRRRRRRRRcR{R\R](RGR7RRRtparticipantes_tconsulta_participantesRtpart_idRRtpartR#R((s%/opt/public_html/CCYTET/snct/views.pytadd_participantescsJ$ $           cCst|id}d|idd}tiid|}|ii||i|o tdStd|SdS(NRshttp://Rs/registro_de_actividad/RFs/agregar_participantes/(RRRORRRRR(RGR7tid_participanteR0Rtconsul_participante((s%/opt/public_html/CCYTET/snct/views.pytborrar_participantes  c Cstii}tiid|ii}tiid|d|iii}d}d|i job|i i d}|it d|t d|Bt d|Bt d|Bt d |B}nd }d |i jo|i i d }nt ||}|i i d }y|i |} WnFtj o|i d } n&tj o|i |i} nXtdh|d6|d 6|d6| d6|d6|d6dd6dt|S(NRRFR'RRRRRRi RRisregistro_organizadores.htmlRRRRGRR R[(RRORPRRRRRFRRRRRRRRRRR\R]( RGR7RRRRRRRR((s%/opt/public_html/CCYTET/snct/views.pytagregar_organizadoress0'3cCs;tii}tiididid}|idjot|i }|i o|i i d}tii ddi |i}d}d}x |D]} | i}| i}qWtd|}td|}||joXtii d|} | ii|| iti|d td t|d S|i i d}t} || _| i| i} tii d|} | i} | ii| | iti|d td t|d Sqti|d n t}tdh|d6|d6|d6|d6|d6dt|S(NRRRRR'iRRs4EL ORGANIZADOR ASOCIADO CORRECTAMENTE A LA ACTIVIDADs/agregar_organizadores/Rs>ORGANIZADOR REGISTRADO CORRECTAMENTE Y ASOCIADO A LA ACTIVIDADsFALTAN DATOS EN EL FORMULARIOsadd_organizadores.htmlRRR7RRGR[(RRORPRRRRTRtRegistroOrganizadorRRRRRRzRRRFRRRRRRRRRcR{R\R](RGR7RRRt organizador_tconsulta_organizadorRtorg_idRRtorgR#R((s%/opt/public_html/CCYTET/snct/views.pytadd_organizadoressJ$ $           cCst|id}d|idd}tiid|}|ii||i|o tdStd|SdS(NRshttp://Rs/registro_de_actividad/RFs/agregar_organizadores/(RRRORRRRR(RGR7tid_organizadorR0Rtconsul_organizadores((s%/opt/public_html/CCYTET/snct/views.pytborrar_organizadors  c Cstii}tiid|ii}tiid|d|iii}d}d|i job|i i d}|it d|t d|Bt d|Bt d|Bt d |B}nd }d |i jo|i i d }nt ||}|i i d }y|i |} WnFtj o|i d } n&tj o|i |i} nXtdh|d6|d 6|d6| d6|d6|d6dd6dt|S(NRRFR'RRRRRRi RRisregistro_patrosinador.htmlRRRRGRR R[(RRORPRRRRRFRRRRRRRRRRR\R]( RGR7RRRRRRRR((s%/opt/public_html/CCYTET/snct/views.pytagregar_patrocinadores s0'3cCsAtii}tiididid}|idjot|i }|i o|i i d}tii ddi |i}d}d}x |D]} | i}| i}qWtd|}td|}||jo^tiii d|} | ii|| iti|d td t|d S|i i d}t} || _| i| i} tii d|} | i} | ii| | iti|d td t|d Sqti|d n t}tdh|d6|d6|d6|d6|d6dt|S(NRRRRR'iRRs5EL PATROCINADOR ASOCIADO CORRECTAMENTE A LA ACTIVIDADs/agregar_patrocinadores/Rs?PATROCINADOR REGISTRADO CORRECTAMENTE Y ASOCIADO A LA ACTIVIDADsFALTAN DATOS EN EL FORMULARIOsadd_patrosinador.htmlRR7RRRGR[(RRORPRRRRTRtRegistroPatrosinadorRRRRRRzRRRFRRR RRRRRRcR{R\R](RGR7RRRt patrocinador_RRtpatr_idRRtpatrR#R((s%/opt/public_html/CCYTET/snct/views.pytadd_patrocinadores* sJ$ $           cCst|id}d|idd}tiid|}|ii||i|o tdStd|SdS(NRshttp://Rs/registro_de_actividad/RFs/agregar_patrocinadores/(RRRORR RRR(RGR7tid_patrocinadorR0Rtconsul_patrocinadores((s%/opt/public_html/CCYTET/snct/views.pytborrar_patrocinadores[ s  cCs#tiid|itdS(NRFs/registro_de_actividad/(RRORRRR(RGt id_borrar((s%/opt/public_html/CCYTET/snct/views.pytborrarh scCs#tiid|itdS(NRFs/principal_administrador/(RRORRRR(RGtborrar_institucion((s%/opt/public_html/CCYTET/snct/views.pyRn scCst|}tdS(Ns/index(tlogoutR(RGR((s%/opt/public_html/CCYTET/snct/views.pyt logout_usert s c Csg|iid}tiid|}tiidd}d}d}d}x)|D]!}|i}|i}|i}qUWytiid|}Wn&ti j ot dSt nX|i ||i td |d |d } t|} yItd| d d d| } ti|| dd| d tdSWntj o} tdSXdS(Ns wizard[email]Rztlengthi iR'Rs>El correo no existe, o Verifique que lo escribio correctamentesTu cuenta de usuario es:s. Su nueva contrasenia es: sF. Por su seguridad se recomienda cambiarla, una vez que haya accedido.RmiRnt.s/login_/s/index/(RRRRORRtmake_random_passwordRFR1RzRBRdtHttp404t set_passwordRRcRRRRRy( RGRt consulta_usert new_passwordRRVRzRRRRRR((s%/opt/public_html/CCYTET/snct/views.pyt send_emailz s4         c Cstiid|iig}|ii}tiid|}|i}tiid|}d}d|ijo+|iid}tiid|}nd}d|ijo|iid}nt||}|iid } y|i | } WnFt j o|i d } n&t j o|i |i } nXt d h|d 6|d 6|d6|d6| d6|d6dt|S(NRRtmunicipio__nombreR'RRi RRislista_instituciones.htmlRGRRRR[(RRORRRRFRRRRRRRRR\R]( RGRRtmun_insRRRRRRR((s%/opt/public_html/CCYTET/snct/views.pytlist_instituciones s0  cstiid|i}itiid|}|idtdt}tii }|id|i d}|id|i d}|id|i d}|id|i d }|id|i d } t i } | i } d } td d } t}g}t| dttddtddtddtddt}g}|d}|itdd|d}t|_d|_d|_|itdd|d}t|_d|_d|_ddgg}x?|D]7}|idt| d t|i|igqWxK|i d|D]7}|idt| d t|i|igqMWxK|i d|D]7}|id!t| d t|i|igqWxK|i d|D]7}|id!t| d t|i|igqWxK| i d|D]7}|id"t| d t|i|igq7Wt!|dtdtd#td$tgd%d&d'd(d?d@d+t"i#fd,dAdBdfd-dCdDd.fd-dEdFd.fd-dGdHd1fd-dIdJd.fd-dKdLd1fd-dMdNd.fd-dOdPd.fd-dQdRd1fd-dSdTd.fg }d.|_$|i|d*dk%}|i&i'|i&i(|i&i)t*d9|i&i'|i&i(|i&i)t*d:fd;}d<}|i+|d=|d>|| S(UNRRRRtid__inRRRRR R'ROsapplication/pdfRPRQiRRRSg@RTiRURVRWRXi RYitFOLIOStNombresTAB-AI-R]sTAB-OI-sTAB-PI-g@g @R^iR_R`iig?RaRbRciiRdiiiiiiisstatic/logo.pngsstatic/logo-dgtic.pngcs|i|idtddd|idd|idtdtd t|id tdtd t|id td dd|idtdtd|i|idS(Niiii2RXi g@g3@s Institucion: g2@s Municipio: gffffff,@iiPi(ig?s Página %d( ReRfRRgRhRcRRRi(RRj(t institutoRHt municipio_Rk(s%/opt/public_html/CCYTET/snct/views.pyRl s %%"cSsP|i|idd|idtdtd|itf|idS(NRXi ig?s Página %d %s(ReRgRhRRRRmRi(RRj((s%/opt/public_html/CCYTET/snct/views.pyRn+ s (RoRp(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(ii(i i(ii(,RRORRRRRRRSRRPt values_listR RqRrRdR#RRRRRRR$RRsRtRuRRvRcRFRtexcludeRR"RwRxRyR8RzR{R|R}R~(RGRRRtpersonast expositores_Rtresponsable_actividad_Rtpatrocinadores_R8RrRRRRRjR/RURWRYRRRyRlRn((RHRRkRs%/opt/public_html/CCYTET/snct/views.pytfolios_institucionales s     )          "   -- cCssd}|io@|id}|dj o"tiid|id}qSntdh|d6dt|S(NR'RR1s results.htmltresultsR[( tis_ajaxRRDRRORRRTR\R](RGRR((s%/opt/public_html/CCYTET/snct/views.pytajax_user_search? s    &cCssd}|io@|id}|dj o"tiid|id}qSntdh|d6dt|S(NR'RRsresults_instituto.htmlRR[( RRRDRRORRRTR\R](RGRR((s%/opt/public_html/CCYTET/snct/views.pytajax_institucionK s   &cCs|iod}|idjo d}q|idjoY|id}tiiid|}tidtiii d|dd }qnt |d d S( NR'Rseste se envio via getRtid_participacionRFRetfieldsRROsapplication/javascript(RFsnombre( RRRtcat_tipo_participacionRORPRR)t serializeRRRd(RGtparticipacion_trespuestRR;R/((s%/opt/public_html/CCYTET/snct/views.pytajax_participacion] s   $cCs|io|idjol|id}tiid|}g}x|D]}|i|iqLWti d|}t |ddSndS(NRtinvtid_tipo_actividadReR`sapplicacion/json( RRRttipo_actividad_involucradosRORRRvtid_involucradoR)RRd(RGRR;tlistaRR((s%/opt/public_html/CCYTET/snct/views.pytajax__roles_involucradosn s  cCs;|io*tih|id6}t|ddSdS(NR8R`sapplicacion/json(RR(RfR8Rd(RGR#((s%/opt/public_html/CCYTET/snct/views.pyt ajax__path s c Cs|io|id}tiid|}|ii}g}xE|D]=}h}|i|d<|i|dRARERGRJRMRPRRRURXR[R]R`RbReRhRkRnRqRtRwRyR|RRRRRRRRRRRR(((s%/opt/public_html/CCYTET/snct/views.pyts6                 ""4           *    / np'-.2  ccpfobbse m 2(1  $2 &1 &1  "  D  '