6QXc@sddklZddkZddklZddklZlZddkl Z ddk l Z l Z l Z lZlZddkTddklZlZddklZlZdd klZlZlZlZdd klZlZdd klZdd klZdd k l!Z!ddk"l#Z#dd klZddk"l$Z$ddk%l&Z&ddk'l(Z(ddk)l)Z)ddk*l+Z+l,Z,l-Z-ddk.l/Z/l0Z0l1Z1ddk2l3Z3ddk4l5Z5l6Z6l7Z7l8Z8ddk9l:Z:dZ;e&dddZ<e&dddZ=dZ>dZ?e&ddd Z@e&ddd!ZAe&ddd"ZBe&ddd#ZCe&ddd$ZDe&ddd%ZEe&ddd&ZFe&ddd'ZGe&ddd(ZHe&ddd)ZIe&ddd*ZJe&ddd+ZKe&ddd,ZLe&ddd-ZMe&ddd.ZNe&ddd/ZOe&ddd0ZPe&ddd1ZQe&ddd2ZRe&ddd3ZSe&ddd4ZTe&ddd5ZUe&ddd6ZVe&ddd7ZWdd8kXlYZYeYd9ZZe&ddd:Z[e&ddd;Z\e&ddd<Z]e&ddd=Z^e&ddd>Z_e&ddd?Z`d@ZadAZbdBZce&ddCdDZde&ddCdEZee&dddFZfe&dddGZge&dddHZhe&dddIZidJdKZjdLekfdMYZldNe8elfdOYZmdS(Pi(tcanvasN(t JasperClient(tHttpResponseRedirectt HttpResponse(t smart_str(tAlumnotAreatPreguntat Resultadot Respuesta(t*(tRequestContexttloader(tget_object_or_404trendertrender_to_responsetredirect(treverset reverse_lazy(t ModelForm(tformset_factory(tCount(tmessages(tauth(tlogin_required(tTemplateResponse(tdatetime(t Paginatort InvalidPaget EmptyPage(t send_mailtBadHeaderErrortEmailMultiAlternatives(tsettings(tListViewt DetailViewt CreateViewtView(tBytesIOcCs|idjo|id}|id}tid|d|}d}|dj o%|ioti||tdSti |dt |dh|d6Std SdS( NtPOSTtusernametpasswordts/areas/administrador/serror de autenticacions index.htmltmsjs/areas/acceder/( tmethodR'Rt authenticatetNonet is_activetloginRRterrorR(trequestR(R)tusertmensaje((s3/opt/public_html/pandora_reloaded/servicio/views.pyR0s   t login_urls/areas/acceder/cCsd}t|dh|d6S(NR*sdashboard_base.htmlR+(R(R2R4((s3/opt/public_html/pandora_reloaded/servicio/views.pyt administrador8ss/areas/cCs>ti|tid}t|h}t|i|S(Nsprincipal.html(RtlogoutR t get_templateR RR(R2ttemplatetcontext((s3/opt/public_html/pandora_reloaded/servicio/views.pyR7>s cCstddt|S(Ns index.htmltcontext_instance(RR (R2((s3/opt/public_html/pandora_reloaded/servicio/views.pytaccederMscCs1tid}t|h}t|i|S(Nsprincipal.html(R R8R RR(R2R9R:((s3/opt/public_html/pandora_reloaded/servicio/views.pyt principalQscCs t|dS(Ns perfil.html(R(R2tuser_id((s3/opt/public_html/pandora_reloaded/servicio/views.pytperfilXsc Cs|idjoTt|i}|io4|itii}ti |dt dSn t}d}d}d}d}d}d}t dh|d6|d6|d 6|d 6|d 6|d 6d t |S(NR'sCuestionario registradas/areas/mostrarcuestionario/tclosedtactivescuestionarioform.htmltformt area_sidet menu_alumnot menu_preguntatmenu_respuestatmenu_resultadoR;( R,tCuestionarioFormR'tis_validtsavet CuestionariotobjectstallRtsuccessRRR ( R2RBtdatosRCRDRERFRGtmenu_cuestionario((s3/opt/public_html/pandora_reloaded/servicio/views.pytcrearcuestionariocs$   cCsd}d}d}d}d}d}tiiid}tdh|d6|d6|d6|d6|d 6|d 6d t|S( NR@RAtidsmostrarcuestionario.htmlRORCRDRERFRGR;(RKRLRMtorder_byRR (R2RCRDRERFRGRPRO((s3/opt/public_html/pandora_reloaded/servicio/views.pytmostrarcuestionariosc Csd}d}d}d}d}d}tiid|}|idjoZt|id|} | io4| itii} t i |dt dSntd|} t dh| d 6|d 6|d 6|d 6|d 6|d6|d6dt |S(NR@RAtpkR'tinstancesSe actualizo el cuestionarios/areas/mostrarcuestionario/scuestionarioform.htmlRBt cuestionarioRCRDRERFRGR;(RKRLtgetR,RHR'RIRJRMRRNRRR ( R2tcuestionario_idRCRDRERFRGRPRWRBRO((s3/opt/public_html/pandora_reloaded/servicio/views.pyteditarcuestionarios(  cCsHtiid|}|itii}ti|dtdS(NRUsSe elimino el cuestionarios/areas/mostrarcuestionario/(RKRLRXtdeleteRMRtwarningR(R2RYRWRO((s3/opt/public_html/pandora_reloaded/servicio/views.pytborrarcuestionarios  c Cs|idjoTt|i}|io4|itii}ti |dt dSn t}d}d}d}d}d}d}t dh|d6|d6|d 6|d 6|d 6|d 6d t |S(NR'sÁrea registradas/areas/mostrararea/RAR@s areaform.htmlRBRCRDRERFRGR;( R,tAreaFormR'RIRJRRLRMRRNRRR ( R2RBRORCRDRERFRGRP((s3/opt/public_html/pandora_reloaded/servicio/views.pyt crearareas$    cCsd}d}d}d}d}d}tiiid}tdh|d6|d6|d6|d6|d 6|d 6d t|S( NRAR@RRsmostrararea.htmlRORCRDRERFRGR;(RRLRMRSRR (R2RCRDRERFRGRPRO((s3/opt/public_html/pandora_reloaded/servicio/views.pyt mostrarareas c Csd}d}d}d}d}d}tiid|}|idjoZt|id|} | io4| itii} t i |dt dSntd|} t dh| d 6|d 6|d 6|d 6|d 6|d6|d6dt |S(NRAR@RUR'RVsSe actualizo el áreas/areas/mostrararea/s areaform.htmlRBtareaRCRDRERFRGR;(RRLRXR,R^R'RIRJRMRRNRRR ( R2tarea_idRCRDRERFRGRPRaRBRO((s3/opt/public_html/pandora_reloaded/servicio/views.pyt editarareas&  cCsHtiid|}|itii}ti|dtdS(NRUsSe elimino el áreas/areas/mostrararea/(RRLRXR[RMRR\R(R2RbRaRO((s3/opt/public_html/pandora_reloaded/servicio/views.pyt borrarareas  c Cs|idjo]t|i}|io=|itiiid}t i |dt dSn t}d}d}d}d}d}d}t dh|d6|d 6|d 6|d 6|d 6|d 6dt |S(NR'tnombresDirectivo registrados/areas/mostrardirectivo/RAR@sdirectivoform.htmlRBRCRDRERFRGR;(R,t DirectivoFormR'RIRJt DirectivoRLRMRSRRNRRR ( R2RBRORCRDRERFRGRP((s3/opt/public_html/pandora_reloaded/servicio/views.pytcreardirectivo"s$    cCsd}d}d}d}d}d}tiiid}tdh|d6|d6|d6|d6|d 6|d 6d t|S( NRAR@RRsmostrardirectivo.htmlRORCRDRERFRGR;(RgRLRMRSRR (R2RCRDRERFRGRPRO((s3/opt/public_html/pandora_reloaded/servicio/views.pytmostrardirectivo@s c Csd}d}d}d}d}d}tiid|}|idjoZt|id|} | io4| itii} t i |dt dSntd|} t dh| d 6|d 6|d 6|d 6|d 6|d6|d6dt |S(NRAR@RUR'RVsSe actualizo el Directivos/areas/mostrardirectivo/sdirectivoform.htmlRBt directivoRCRDRERFRGR;(RgRLRXR,RfR'RIRJRMRRNRRR ( R2t directivo_idRCRDRERFRGRPRjRBRO((s3/opt/public_html/pandora_reloaded/servicio/views.pyteditardirectivoWs&  cCsHtiid|}|itii}ti|dtdS(NRUsSe elimino el directivos/areas/mostrardirectivo/(RgRLRXR[RMRR\R(R2RkRjRO((s3/opt/public_html/pandora_reloaded/servicio/views.pytborrardirectivous  c Cs |idjot|i}|io|iid}|iid}|djo t}n|i}td|d|d|}|it i |dt d|i Sn t}d}d }d }d } d } d } t d h|d 6d t|S( NR't respuestataciertotpreguntat nom_respuestasPregunta registradas/areas/%s/editarpreguntasres/RAR@screarpreguntaform.htmlRBR;(R,tCrearPreguntaFormR'RIRXR.tFalseRJR RRNRRRRR ( R2RBRnRoRptrest pregunta_sideRDt menu_areaRFRGRP((s3/opt/public_html/pandora_reloaded/servicio/views.pyt crearpreguntas*      cCsd}d}d}d}d}d}tiiid}tdh|d6|d6|d6|d6|d 6|d 6d t|S( NRAR@Rasmostrarpregunta.htmlRORuRDRvRFRGR;(RRLRMRSRR (R2RuRDRvRFRGRPRO((s3/opt/public_html/pandora_reloaded/servicio/views.pytmostrarpreguntascCs%tiid|}|idjot|id|}|io|iid}|iid}|djo t}n|i }t d|d|d|}|i t i |dt d |iSd }t i ||ntd|}td h|d 6|d6d t|S(NRUR'RVRnRoRpRqsPregunta registradas/areas/%s/editarpreguntasres/s%Favor de llenar los campos requeridosscrearpreguntaform.htmlRBR;(RRLRXR,RrR'RIR.RsRJR RRNRRRRR (R2t pregunta_idRpRBRnRoRtR+((s3/opt/public_html/pandora_reloaded/servicio/views.pyteditarpreguntasress$     cCsgtiid|}tiid|}tii}tdh|d6|d6|d6dt|S(NRyRUspreguntaform.htmlt listaareastlistarespuestaRpR;( R RLtfilterRRXRRMRR (R2RyR|RpR{((s3/opt/public_html/pandora_reloaded/servicio/views.pyteditarpreguntassc Cs|iid}|iid}tiid|}|iid}|idjo\td|d|d|}|itii d|}x|D]}|d fGH|iid |i d o|iid |i } |iid |} | d fGH| d fGH| djo2td|i d|d| dt } | iqtd|i d|d| dt } | iqqWt i|dtiiid} tdStd|} tdh| d6dt|S(NRptareasRURoR'tnombre_preguntaRaRytru%sR*te1te2t1RqsDatos Actualizadoss/areas/mostrarpregunta/RVspreguntaform.htmlRBR;(R'RXRRLtgetlistR,RRJR R}RRtTrueRsRRNRMRSRt PreguntaFormRR (R2RyRpRataRotpreRtRRRtreRORB((s3/opt/public_html/pandora_reloaded/servicio/views.pyteditarpreguntarespuestass6     $$ cCsQtiid|}|itiiid}ti|dtdS(NRURasSe elimino la preguntas/areas/mostrarpregunta/( RRLRXR[RMRSRR\R(R2RyRpRO((s3/opt/public_html/pandora_reloaded/servicio/views.pytborrarpregunta&s  c Cs|idjo]t|i}|io=|itiiid}t i |dt dSn t}d}d}d}d}d}d}t dh|d 6|d 6|d 6|d 6|d 6|d6|d6dt |S(NR'RpsRespuesta registradas/areas/mostrarrespuesta/RAR@tActivesrespuestaform.htmlRBtrespuesta_sideRDRvRERGRPR;(R,t RespuestaFormR'RIRJR RLRMRSRRNRRR ( R2RBRORRDRvRPRERG((s3/opt/public_html/pandora_reloaded/servicio/views.pytcrearrespuesta5s$   cCstiiid}d}d}d}d}d}d}tdh|d6|d6|d6|d6|d 6|d 6d t|S( NRpRAR@smostrarrespuesta.htmlRORRDRvRERGR;(R RLRMRSRR (R2RORRDRvRERGRP((s3/opt/public_html/pandora_reloaded/servicio/views.pytmostrarrespuestaOscCstiid|}tiid|ii}tiid|}tii}t dh|d6|d6|d6dt |S(NRURyspreguntaform.htmlR{R|RpR;( R RLRXRRpRRR}RRMRR (R2t respuesta_idRnRpR|R{((s3/opt/public_html/pandora_reloaded/servicio/views.pyteditarrespuestaes cCsQtiid|}|itiiid}ti|dtdS(NRURpsSe elimino la respuestas/areas/mostrarrespuesta/( R RLRXR[RMRSRR\R(R2RRnRO((s3/opt/public_html/pandora_reloaded/servicio/views.pytborrarrespuestays  cCsQtiid|}|itiiid}ti|dtdS(NRURpsSe elimino la respuestas/areas/mostrarpregunta/( R RLRXR[RMRSRR\R(R2RRnRO((s3/opt/public_html/pandora_reloaded/servicio/views.pyteliminarrespuestass  (t csrf_exemptc CsN|idjot|i}|io|id}|id}|id}|iid}|id}|iid}|id}tiid|i} t ii d |i d } t |h| d 6|d6|d6|d6|d6|d6| d6} t d | d t |Sn t}t dh|d6d t |S(NR't nombre_alumnotappattapmaRat dependenciaRWRUtarea__cuestionario_idt?tlista_preguntassCuestionario.htmlR;salumnoform.htmlRB(R,t AlumnoFormR'RIt cleaned_dataRXRKRLRRRR}RSR R( R2RBRRRRaRtdtcRWRtpaqueteP((s3/opt/public_html/pandora_reloaded/servicio/views.pyt nuevoalumnos"      % cCstiid|}tiid|ii}tiid|}tiid|i d|}t dh|d6|d6|d 6|d 6d t |S( NRRRt alumno_idt pregunta__int resultado__insdetalle_cuestionario.htmltlista_resultadosRORtlista_respuestasR;( RRLRXRR}RWRRRR texcludeRR (R2RRORRR((s3/opt/public_html/pandora_reloaded/servicio/views.pytdetallecuestionarios!cCstiiid}d}d}d}d}d}d}tdh|d6|d6|d6|d6|d 6|d 6d t|S( NRRRAR@smostraralumno.htmlROt alumno_sideRvRERFRGR;(RRLRMRSRR (R2RORRvRERFRGRP((s3/opt/public_html/pandora_reloaded/servicio/views.pyt mostraralumnos cCstiid|}t|i}tiid|ii}tiid|}xs|D]k}t iid|d|}xG|D]?}|i djo)t iid|d|i ddqqWq[Wxw|D]o}t iid|dt } t iid|d t d|} | i| ijo| i ddqqWtiid |} g} g} h}h}h}x`| D]X}t iidid |id |dd idtd} | i||isNOMBRE: sAPELLIDO PATERNO: sAPELLIDO MATERNO: sEXAMEN: sAREAS DEL EXAMEN: RRRRiRRas aciertos s de s preguntas tsubjectsResultado de examentmessaget from_emailsdgtic@tabasco.gob.mxsExamen asignado (%s)s text/htmlsSe ha enviado la informacion tpacos/areas/mostraralumno/(!RRLRXRKR}RWRRRgRtjointcorreoRRRRtnombre_cuestionarioRRRRRRMRRt nombre_areaR'R tattach_alternativetsendRRNRR(R2RRRtdirecRt_[1]tsRt text_contentR+RRttres2RtbRRRt var_emailttotmsgtpass__author__((s3/opt/public_html/pandora_reloaded/servicio/views.pytenviosH5$  2 !  t 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(RturlR(R)t runReporttfiletwritetclose(tselftpathtnamefiletparamsttipotjtrettf((s3/opt/public_html/pandora_reloaded/servicio/views.pytgenerateReports #N( t__name__t __module__R!t JASPERSERVERRR(R)R.R(((s3/opt/public_html/pandora_reloaded/servicio/views.pyRs timprimircBseZdZRS(cOs tdS(Ns/areas/mostrarcuestionario/(R(RR2targstkwargs((s3/opt/public_html/pandora_reloaded/servicio/views.pyRXs(RRRX(((s3/opt/public_html/pandora_reloaded/servicio/views.pyRs(ntreportlab.pdfgenRtrequeststpyjasperclientRt django.httpRRtdjango.utils.encodingRtservicio.modelsRRRRR tservicio.formstdjango.templateR R tdjango.shortcutsR RRRtdjango.core.urlresolversRRt django.formsRtdjango.forms.formsetsRtdjango.db.modelsRtdjango.contribRRtdjango.contrib.auth.decoratorsRtdjango.template.responseRRtdjango.core.paginatorRRRtdjango.core.mailRRR t django.confR!tdjango.views.genericR"R#R$R%tioR&R0R6R7R<R=R?RQRTRZR]R_R`RcRdRhRiRlRmRwRxRzR~RRRRRRRtdjango.views.decorators.csrfRRRRRRRRRRRRRRRRRRtobjectRR(((s3/opt/public_html/pandora_reloaded/servicio/views.pyts ( ""    )"1 '@;  1 /''6' N