cc@sddlmZmZddlmZmZmZddlmZddl m Z ddl m Z ddl mZddlTddlTddlTddlTddlmZdd lZed d Zed d Zed d Zed dZed dZed dZed dZed dZed dZed dZed dZ ed dZ!ed dZ"ed dZ#ed dZ$ed dZ%ed dZ&ed dZ'ed dZ(ed dZ)ed dZ*ed d Z+ed d!Z,ed d"Z-ed d#Z.d S($i(trendertget_object_or_404(tHttpResponseRedirecttHttp404t HttpResponse(treverse(tmessages(tslugify(tpermission_required(t*(t serve_fileNs(admin_users.can_access_exam_applicationscCsHtjjdt}tjjdt}t|di|d6|d6S(Ntenableds'admin/exam_applications/exam-forms.htmltenabled_exam_formstdisabled_exam_forms(tExamFormtobjectstfiltertTruetFalseR(trequestR R ((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pyt exam_formsscCst}|jrt|j}|jr|jdt}t|jt|_|jt j |dt t dSnt |di|d6S(NtcommitsExam Form has been Createdtadmin_exam_formss*admin/exam_applications/add-exam-form.htmltexam_form_form(t ExamFormFormtPOSTtis_validtsaveRtslugify_uniquetnameRtslugRtsuccessRRR(RRt exam_form((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pyt add_exam_forms    cCsttd|}td|}|jrt|jd|}|jry.|jtj|dtt dSWqtj |dqXqnt |di|d6|d6S( NtidtinstancesExam Form has been UpdatedRsCould not update Exam Forms*admin/exam_applications/add-exam-form.htmlR R( RRRRRRRRRRterrorR(Rtexam_idR R((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytedit_exam_form4s   cCsZttd|}y|jtj|dWntj|dnXttdS(NR"sExam form has been deletedsCould not delete Exam FormR(RRtdeleteRRR$RR(RR%R ((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytdelete_exam_formIs c Csqttd|}td|}|jrSt|j}|jrS|jdt}t|jt|_ |jx|j D]}t d|d|j d|j d|jd|jd |j}|jxZ|jD]L}td |jd |d |jd|jd |jd|j}|jqWqWtj|dttdSnt|di|d6|d6S(NR"R#RR ttitletsubtitletordert minimum_scanstupload_disabledRtcategoryttypetminimumtmaximumsExam Form has been DuplicatedRs0admin/exam_applications/duplicate-exam-form.htmltinitial_exam_formR(RRRRRRRRRRtget_modality_categoriestModalityCategoryR)R*R+R,R-t get_itemst ModalityItemR/R0R1RRRRR( RR%R2RR tmctnew_mctmc_itemtnew_mi((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytduplicate_exam_formWs:              cCscttd|}y't|_|jtj|dWntj|dnXtt dS(NR"sExam form has been enabledsCould not enable Exam FormR( RRRR RRRR$RR(RR%R ((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytenable_exam_forms  cCscttd|}y't|_|jtj|dWntj|dnXtt dS(NR"sExam form has been disabledsCould not disable Exam FormR( RRRR RRRR$RR(RR%R ((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytdisable_exam_forms  cCsEttd|}tjjd|}t|di|d6|d6S(NR"R s2admin/exam_applications/modalities/modalities.htmltmodality_categories(RRR4RRR(RR%R R>((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pyt modalitiesscCsttd|}t}|jrt|j}|jryU|jdt}||_|jtj |dt t dd|j gSWqtj |dqXqnt|di|d6|d 6S( NR"Rs"Modality Category has been Createdtadmin_exam_forms_modalitiestargss"Could not create Modality Categorys=admin/exam_applications/modalities/add-modality-category.htmlR tmodality_category_form(RRtModalityCategoryFormRRRRR RRRRR"R$R(RR%R RBtmodality_category((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytadd_modality_categorys      cCsttd|}ttd|}td|}|jrt|jd|}|jry:|jtj|dt t dd|j gSWqtj |dqXqnt |di|d6|d 6|d 6S( NR"R#s"Modality Category has been updatedR@RAs"Could not update Modality Categorys>admin/exam_applications/modalities/edit-modality-category.htmlR RDRB(RRR4RCRRRRRRRR"R$R(RR%tmodality_cat_idR RDRB((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytedit_modality_categorys    cCsxttd|}ttd|}y|jtj|dWntj|dnXttdd|j gS(NR"s"Modality Category has been deleteds"Could not delete Modality CategoryR@RA( RRR4R'RRR$RRR"(RR%RFR RD((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytdelete_modality_categorys cCsttd|}t}tjjd|}||jd_|jrt|j}||jd_|j ryL|j dt }|j t j |dttdd|jgSWqt j|dqXqnt|d i|d6|d 6S( NR"R R.RsModality Item has been CreatedR@RAsCould not create Modality Items9admin/exam_applications/modalities/add-modality-item.htmltmodality_item_form(RRtModalityItemFormR4RRtfieldstquerysetRRRRRRRRR"R$R(RR%R RIR>t modality_item((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytadd_modality_items      cCs#ttd|}ttd|}td|}tjjd|}||jd_|j rt|j d|}||jd_|j ryL|j dt }|j t j|dttdd|jgSWqt j|d qXqnt|d i|d6|d 6|d 6S( NR"R#R R.RsModality Item has been UpdatedR@RAsCould not Update Modality Items9admin/exam_applications/modalities/add-modality-item.htmlRIRM(RRR6RJR4RRRKRLRRRRRRRRR"R$R(RR%tmodality_item_idR RMRIR>((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytedit_modality_items"    cCsxttd|}ttd|}y|jtj|dWntj|dnXttdd|j gS(NR"sModality Item has been deletedsCould not delete Modality ItemR@RA( RRR6R'RRR$RRR"(RR%ROR RM((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytdelete_modality_items cCsttd|}tjjd|dtdtjd}tjjd|dtdt}tjjd|dt}t|di|d6|d6|d 6|d 6S( NR"texamtcompletetpaids-completed_times2admin/exam_applications/applicants/applicants.htmlR tcomplete_applicantstunpaid_applicantstincomplete_applicants( RRtExamApplicationRRRtorder_byRR(RR%R RURVRW((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytexam_applicants&s*! c3Cs@ttd|}tjjd|dtdt}ddddd d d d d ddddddddddddddddddd d!d"dd!g }x%|jD]}|jd#|qWx%|jD]}|jd$|qWx%|jD]}|jd%|qW|jd&kr x|j D]}|jd'|x6|j D](}|jd(||jd)|qQWx6|j D](}|jd(||jd)|qW|jd*|q-W|d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d1d2d3d4d5d6d7d8d:g7}nO|d,d-d.d/d0d1d2d3d4d5d6d7d8d9d1d2d3d4d5d6d7d8d:g7}t d;d<}d=|d>| j?| j@| jAg2}|jd&krxV|j D]H}| jB|} | r6|j| jCjDd?n |jd@xl|j D]^}| jE|} | r| jFr|jdAn |jdBn|jd@|jd@qPWxl|j D]^}| jE|} | r| jFr|jdAn |jdBn|jd@|jd@qW| r:|j| jGn |jd@qW|| jH| jIdC| jJ| jKf| jL| jMg7}n/|| jIdC| jJ| jKf| jL| jMg7}xT| jND]F} || jO| jP| jQ| jR| jS| jT| jU| jV| jWg 7}qW| jg|D]}tX|jYdD^qqW|S(ENR"RRRSRTt SubmittedtTitles First NametSurnames Email AddresssContact NumbertDOBs Job TitlesCurrent EmployersEmployment Start DatesWork Address 1sWork Address 2s Work Towns Work Countys Work Postcodes Work CountrysMailing Address 1sMailing Address 2s Mailing TownsMailing CountysMailing PostcodesMailing CountrysModaility 1 ScanssModality 2 ScanssModality 3 ScanssUndergraduate Universitys Degree Titles Degree Classs Year AwardedsPostgraduate Universitys Physics %ssVascular Tech %ss CPD Points %ss re-validations%s Date Training Starteds %s Actuals %s Eligibles%s Total Eligible sThree Years ExperiencesExaminer Titles Examiner NamesExaminer EmailsExaminer Unable ReasonsReference 1 Names Address 1s Address 2tTowntCountytPostcodetCountrytEmailt TelephonesReference 2 NamesOther Referencest content_typestext/csvs(attachment; filename=exam_applicants.csvsContent-Dispositions%m/%YttYestNos%s %ssutf-8(ZRRRXRRRt get_yearstappendR/R3tget_compulsory_itemstget_optional_itemsRtcsvtwritertwriterowtcompleted_timeR)t first_nametsurnamet email_addresstcontact_numbertdobt job_titletcurrent_employertemployment_start_datetwork_address_1twork_address_2t work_townt work_countyt work_postcodet work_countrytmailing_address_1tmailing_address_2t mailing_towntmailing_countytmailing_postcodetmailing_countrytmodality_1_scanstmodality_2_scanstmodality_3_scanstuniversity_namet degree_titlet degree_classt year_awardedtpg_university_nametpg_degree_titletpg_year_awardedtphi_y1tphi_y2tphi_y3tphi_y4tphi_y5tphi_y6tvt_y1tvt_y2tvt_y3tvt_y4tvt_y5tvt_y6tcpd_y1tcpd_y2tcpd_y3tcpd_y4tcpd_y5tcpd_y6tget_app_categoryttraining_begantstrftimet get_app_itemRSt total_scanstthree_years_experiencetexaminer_titletexaminer_first_nametexaminer_surnametexaminer_emailtexaminer_unable_reasontget_referencesRt address_1t address_2ttowntcountytpostcodetcountrytemailt telephonetunicodetencode(RR%R RURKtyearRDtitemtresponseRnt applicantt sub_categorytsub_itemt referencets((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytdownload_applicants6sv!fUO   3     8/D3cCsBttd|}ttd|}t|di|d6|d6S(NR"s8admin/exam_applications/applicants/view-application.htmlR t application(RRRXR(RR%tapplication_idR R((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytview_applicationscCsxttd|}ttd|}y|jtj|dWntj|dnXttdd|j gS(NR"sApplication has been deleted.sCould not delete application.tadmin_exam_applicantsRA( RRRXR'RRR$RRR"(RR%RR R((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytdelete_applications cCspttd|}ttd|}t|_|jt||tj|dt t dd|j gS(NR"s#Application has been marked as paidRRA( RRRXRRTRtapplication_form_paidRRRRR"(RR%RR R((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytmark_paid_applications   cCsottd|}ttd|}|jrCt||jdtStj|dtt dd||gS(NR"tsave_ass9Sorry this application does not have a Degree Certificatetadmin_exam_view_applicationRA( RRRXtdegree_certificateR RRR$RR(RR%RR R((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytdownload_degree_certificates  cCsottd|}ttd|}|jrCt||jdtStj|dtt dd||gS(NR"Rs8Sorry this application does not have Non Degree EvidenceRRA( RRRXtnon_degree_evidenceR RRR$RR(RR%RR R((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytdownload_non_degree_evidences  cCsottd|}ttd|}|jrCt||jdtStj|dtt dd||gS(NR"Rs;Sorry this application does not have an Exam Results LetterRRA( RRRXtexam_results_letterR RRR$RR(RR%RR R((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytdownload_results_letters  cCsottd|}ttd|}|jrCt||jdtStj|dtt dd||gS(NR"Rs7Sorry this application does not have a Reference UploadRRA( RRRXtreference_uploadR RRR$RR(RR%RR R((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytdownload_referencess  cCsttd|}ttd|}ttd|}|jrUt||jdtStj|dt t dd||gS(NR"RsDSorry this application does not have an Scans file for this ModalityRRA( RRRXtExamApplicationModalityCategoryt scans_fileR RRR$RR(RR%Rtsubcategory_idR RR((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytadmin_exam_download_scans_files cCsttd|}ttd|}tjjd|}x!|D]}d|_|jq@Wtj |dt t dd||gS(NR"texam_applicationRfsScan Files ClearedRRA( RRRXRRRRRRRRR(RR%RR Rt subcategoriesR((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pyt clear_filess  (/tdjango.shortcutsRRt django.httpRRRtdjango.core.urlresolversRtdjango.contribRtdjango.template.defaultfiltersRtdjango.contrib.auth.decoratorsRtmodules.core.functionstformstmodelstemailstfiletransfers.apiR RmRR!R&R(R;R<R=R?RERGRHRNRPRQRZRRRRRRRRRR(((sA/var/www/svtgbi.org/svtgbi/modules/exam_application/adminviews.pytsH     + V