o ނi~@sJ ddlZddlZddlmZddlZddlZddlZddlZddlZddlZddl m Z ddl Z ddl m Z mZddlmZmZddlmZddlmZmZddlmZmZmZdd l mZm Z mZdd lmZdd lm Z dd l!m"Z#dd l$m%Z%m&Z&m'Z'ddl(m)Z)ddl*m+Z+m,Z,ddl-m.Z.m/Z/m0Z0m1Z1m2Z2m3Z3m4Z4m5Z5m6Z6m7Z7m8Z8m9Z9m:Z:m;Z;mZ>m?Z?m@Z@mAZAmBZBmCZCmDZDmEZEm@Z@mFZFmGZGmHZHmIZImJZJmKZKmLZLmMZMmNZNmOZOmPZPmQZQmRZRmSZSmTZTmUZUmVZVmWZWmXZXddlYmZZZm[Z[m\Z\m]Z]m^Z^m_Z_m`Z`maZambZbmcZcmdZdmeZemfZfmgZgmhZhmiZimjZjmkZkmlZlmmZmmnZnmoZompZpmqZqddlrmsZsmtZtmuZumvZvmwZwmxZxmyZymzZzm{Z{m|Z|m}Z}m~Z~mZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZddlmZmZddlmZddlmZddlmZeedgegegddZeedgegegddZeedgegegddZeedgegegdd Zedgd!dZedgd"d#Zedgd$d%Zedgd&d'Zedgd(d)Zed*gd+d,Zed*dgd-d.Zedgd/d0Zedgd1d2Zed*gd3d4Zedgd5d6Zd7d8Zedgd9d:Zedgd;d<Zeedgegegd=d>Zed*dgd?d@ZedgegegdAdBZed*dgegegdCdDZedgdEdFZedgdGdHZedgdIdJZedgdKdLZedgdMdNZedgdOdPZed*gegegdQdRZedgdSdTZedgdUdVZedgegegdWdXZed*gdYdZZed*dgd[d\Zd]d^Zedgd_d`ZedgdadbZedgegegdcddZedgdedfZedgegegdgdhZedgdidjZedgdkdlZedgdmdnZeedgegegdodpZeedgegegdqdrZedgdsdtZedgdudvZed*gdwdxZedgdydzZedgd{d|Zedgd}d~ZedgddZedgddZedgddZedgddZed*gegegddZddZed*gddZedgddZedgddZedgddZedgddZedgddZedgddZedgddZedgddZedgddZedgddZedgddZedgddZeedgegegddZed*gddZedgddZedgddZedgddZedgddZedgddZedgddZedgddZedgegegddZedgddZedgddZedgddZed*gddZedgdd„ZedgddĄZedgddƄZed*gddȄZed*gddʄZedgdd̄Zedgdd΄ZedgddЄZedgdd҄Zed*gddԄZed*gddքZed*gdd؄ZedgddڄZedgdd܄ZedgddބZedgddZddlZedgddZedgddZdS)N)datetime)urljoin) JsonResponse FileResponse) decrypt_code encrypt_code) compareVoices)BASE_DIR MEDIA_ROOT)api_viewauthentication_classespermission_classes) HttpResponserHttpResponseForbidden) csrf_exempt) perform_login) app_settings) auth_user getCompanyIdgetUserCompany)Q) getConfigcheck_referrer),addCompanyDataServicecandidateRegistrationServicedeductCreditsServiceregisterUserServiceauthentication_servicegetJdWorkflowServiceinterviewSchedulingServicejdPublishServicechangeUserstatusServiceupdateJdDataService1skillsWithTopicsWithSubtopicsWithQuestionsService jdTestAdd addJdServicesupdateJdServicesworkFlowDataServiceinterviewCompletionServicequestionsResponseServicegetInterviewStatusServicegenerateCandidateReportaddNewUserServicenotifyCandidateServicecheckTestHasPaperServicedeleteTestInJdServicesaveInterviewersServicer,demoUserServiceupdateCandidateWorkflowServicedashBoardGraphDataServicemapUploadedCandidateFieldsprocessAddCandidateService#checkJdCandidateRegistrationServicedownloadUploadReportService getResumeDatasoftDeleteResumegenerateBrandedProfilegetRecritmentDashboardDatagetJdProfileDatashortlistProfileServicedashBoardDataServiceaddNewClientServicechangeClientstatusServiceRecruitersPerformanceServicejobBoardConfigServiceSourcePerformanceService)AccountBranding CandidateCompanyCreditsJobDesc Lookupmaster RegistrationUser User_dataWorkflowInterviewMedia CallScheduleBrulesProfileProfileExperienceSource ProfileSkillsEmail_templateCompany ResumeFileResumeProfileActivityWorkCal jdlibrary)#addCandidateDBscheduleInterviewDBinterviewResponseDBaddInterviewFeedbackDBupdateEmailtempDBinterviewRemarkSaveDBupdateCompanyDBsaveStarQuestion demoRequestDBdeleteCandidateDBupdateSourcesDataDBupdateCandidateInfoDBupdateDashboardDisplayFlagDB addProfileDBaddResumeProfileDBupdateProfileDetailsDBupdateProfileEducationDBupdateProfileExperienceDBupdateProfileProjectsDBupdateProfileAwardsDBupdateProfileCertificatesDBupdateProfileSkillsDBupdateProfileActivityDB saveWorkCalDB scheduleCandidateInterviewLinkDBscheduleCandidateInterviewDBjdRecruiterAssignDBupdateFullProfileDBaddWorkspaceDBaddProfileActivityDBupdateWorkspaceDBupdateProfileCompletionsaveJobBoardConfigDBsaveJDJobBoardsDB addResumeDB)hirelines_registration_scriptconst_profile_status)fetch_gmail_attachments)r)convert_word_binary_to_pdfPOSTc Csdddd}z"|jdkr$t|jd}t|}t||d<Wt |SWt |StyG}zd|d<t||d<WYd}~t |Sd}~wwN dataerror statusCoderrrzError in adding company datar methodjsonloadsrgetrint ExceptionstrrrequestresponsedataObjsdata_add_statuser&/home/acert/hirelines/app_api/views.pyaddCompanyData,s$ rc Cs~dddd}z!|jdkr#t|j}t|d|d<d|d<Wt|SWt|Sty>}z d|d<t||d <d}~ww) NrrrzDetails Saved SucessfullyrrrzError in Registrationr)rrrbodyrrrrrrrrrrraddJDCandidateAs&     rc Cdddd}z"|jdkr$t|jd}t|}t||d<Wt |SWt |Sty?}z d|d<t||d<d}~wwr) rrrrrrrrrrrrrr registerUserXs$  rc Csdddd}zY|jdkr[t|jd}t|}|ddkrJtjj|dd }t |j |t j dddd t|}d |d <|j|d<|d|d <nd |d <d|d<d|d<Wt|SWt|Styv}z d|d<t||d<d}~ww)Nrrrrremail) usr_emailF)signup redirect_url signal_kwargstoken_generatedtoken login_type AnonymousUserz login failedrzError in Sign-inr)rrrrrrrMobjectsfilterfirstr_requestallauth_settingsEMAIL_VERIFICATIONrrolerrr)rrr auth_tokenusruserrrrr loginUserns:     rc Crrrrrrrrs$  c Cdddd}z*|jdkr,t|jd}t|j}t||}||d<d|d<Wt |SWt |StyG}z d|d<t ||d<d}~ww) Nrrrrrrz!Error in adding Test in Work flowr) rrrrrrrr%rrr)rrr companyIDtestDatarrrr jdAddTests(      rc Csdddd}z,|jdkr.t|jd}t|j}t|||j}||d<d|d<Wt |SWt |StyI}z d|d<t ||d<d}~ww) NrrrrrrzError in Saving JD Datar) rrrrrrrr&rrr)rrrrjdDatarrrraddJDs(     rc Csdddd}z)|jdkr+t|jd}t|j}t|}||d<d|d<Wt |SWt |StyF}z d|d<t ||d<d}~ww) NrrrrrrzError in getting JD datar) rrrrrrrr#rrr)rrrr jdDataDictrrrr jdUpdateDatas(     rc Csdddd}z(|jdkr*t|jd}t|j}t|||jd|d<Wt |SWt |StyE}z d|d<t ||d<d}~ww) NrrrrrrzError in JD Updata datar) rrrrrrrr'rrr)rrrrrrrrupdateJDs&     rGETc Csdddd}z'|jdkr)|jd}t|j}t||}||d<d|d<Wt|SWt|StyD}z d|d<t||d <d}~ww) NrrrjidrrrzError in getting jd worflowr) rrrrrrrrr)rrjobid company_id workflow_datarrrr getJdWorkflows(       rc Csdddd}z|jdkrt|j}|j}tdd}d}t||}t|j d}t j j |d|d  d d d d }g} t|d } | D]} d| } | | qH| |d <d} tj j |dd} | r| D]}|r|j|dkr|jdkr|jr|j} qj|r| |d<|d|d<||d<td|tj||dd}|j}|rt|d}|d}|}|ddkr||d<d|d<Wt|SWt|SWt|SWt|Sty}zd|d<t||d<tt|WYd}~t|Sd}~ww)NrrrDOMAINacertz/api/jd-screening-questionsrjd_id)id companyidskillsetlocationexpminexpmaxz, )rtest_idSscreeningPaperrjd_dataFrverifyutf-8rrzError in getJdQuestionsViewr) rrrrrrrrrrrIrrvalueslastast literal_evaljoinkeysappendrNr papertypepaperidprintrequestspostcontentdecoderrr)rrr user_company acert_domainendpointurlrr skills_list skill_setskillr workFlowData workFlow_get_evaluation_submissionsresponse_content json_data acert_data jd_questionsrrrrgetJdQuestionsView sp   $     6  rc Csdddd}z5|jdkr2t|jd}|j}t|j}t|}t||d|j }||d<d|d<nt dWSWt |St yR}z d|d<t ||d <d}~ww NrrrrrrRequest BlockedError in saving Job Descriptionr)rrrrrrrrr]rrrrr)rrr user_emailrrc_datarrrr addCandidateMs,      rc Csdddd}z-|jdkr*t|jd}|j}t|}t||}||d<d|d<ntdWSWt |St yJ}z d|d<t ||d <d}~wwr) rrrrrrrr(rrrr)rrrrr workflowDatarrrrrs*      rc Csdddd}z't|j}|jdkr)|jd}t||}||d<d|d<Wt|SWt|StyD}z d|d<t||d <d}~ww) Nrrrint_idrrrzError in Call Scheduling viewr) rrrrrr rrr)rcidrrrinterview_schedule_datarrrrinterviewSchedulings(       rc Csdddd}z+|jdkr-t|j}t|jd}t|j|}||d<d|d<Wt |SWt |St yP}zd|d<t ||d<WYd}~t |Sd}~ww) Nrrrrrrz"Error in Scheduling Interview viewr) rrrrrrrr^rrrr)rrrrresrrrrscheduleInterviewViews(     rcCs&zttddWStdddYS)Nzapplication/javascript content_typez"console.error("Script not found");)rr)renc_jdidrrrcandidateRegistrationCDNForms rc Cdddd}z$|jdkr&t|jd}t|}||d<d|d<Wt|SWt|StyI}zd|d<t||d<WYd}~t|Sd}~ww) NrrrrrrzError in Meeting Response viewr) rrrrrr_rrrrrrrrrrrinterviewResponseViews&   rc Cr) NrrrrrrzError in questios Response viewr) rrrrrr*rrrrrrrquestionsResponseViews&   rc CsRdddd}z|jdkrt|j}t|d}tjj|d}td}|d}|dkr/d}n t jj |j |j |d d }|rB|d kr|j d kr{tjj |dd }|rv|j } ||d<|j|d<|j } t|| |} | dkrqd|d<nd|d<nd|d<n d|d<nd|d<d|d<Wt|SWt|Sty} z d|d<t| |d<d} ~ ww)Nrrrencjdidr APP_CONFIGregister_candidate_once_per_jdYr)rrrNA)rorderjdz begin-frominsufficient_creditszInsufficient Creditsrz#Registration completed successfullyzWorkflow not definedz JD inactivezCandidate already registeredrrzError in registerCandidater)rrrrrrIrrrrGrrrstatusrNrrr]rrr) rrrrjob_description app_configr check_candidate_registeredrradd_resperrrrrregisterCandidatesT              ) rc Cs$dddd}zd|jdkrbt|j}|j}t|}tdd}d}t||}ttj j |dj dd d }d ||d } t j || d d} | j} | rbt| d} | d} | ddkrb| |d<d|d<|jdkr]t|j}|j}t|}tdd}d}t||}ttj j |dj dd d }t|jd}|ddkr||d<||d<t j ||d d}|j} | rt| d} | d} | }| ddkr||d<d|d<|ddkr||d<||d<t j ||d d}|j} | rt| d} | d} | d}d|d<| ddkr||d<d|d<|ddkrb||d<||d<|d|vrPt j ||d d}|j} | rOt| d}|d} |ddkrO| |d<d|d<nd|d<d|d<Wt|SWt|SWt|SWt|Sty}zd|d<t||d<tt|WYd}~t|Sd}~ww) Nrrrrrz/api/evaluate-papersrrTflatget_evaluation_papers) request_forenc_company_idcompany_paper_idsFrrrrrrr submissionsrr update_marks answer_datazMarks Updated successfullysend_evaluation_resultpaper_idzQuery Not Foundz Error in evaluationquestionsViewr)rrrrrrrlistrNrr values_listrrrrrrrrrrrr)rrrrrrrrrcompany_papersrrrrrrevaluationquestionsr r!resprrrrevaluationViewHs           P r)c Cr) NrrrrrrzError in getCallStatusr) rrrrrr+rrrrrrrgetInterviewStatusViews&   r*c Cst|jd}t|ddd}t|ddddd}tjj|d }t |d |j d  t jj|d  }d |_| tjtd d}tj|rxt|D]}||drwtj||}tj|rwt|q[tddiS)Nrreg_code_r.r) candidateidvideoid)recordedr/rr uploadscandidate_audiorsuccess)rrrrrsplitrGrrrrOrsaverP callendflagospathrr existslistdir startswithisfileremover) rrc_codeschidcandidate_details call_details profiling_dirfilename file_pathrrr interviewFiles"     rFc Csdddd}z+|jdkr-t|jd}t|j}t||jd|d<d|d<Wt |SWt |St yP}zd|d<t ||d <WYd}~t |Sd}~ww) NrrrrSavedrrz#Error in Saving Meeting Status viewr) rrrrrrrr)rrrr)rrrrrrrrinterviewCompletions(    rHc Csdddd}z*|jdkr,t|j}t|jd}t||d|d<d|d<Wt |SWt |StyO}zd|d<t ||d <WYd}~t |Sd}~ww) NrrrrzFeedback given successfullyrrzError in feedback viewr) rrrrrrrr`rrrrrrrrrrrinterviewFeedback(     rJc Csdddd}z5|jdkr2t|j}t|jd}t||}||d<|ddkr7d|d<Wt |SWt |SWt |StyR}z d |d<t ||d <d}~ww) NrrrrmsgzDeleted-successfullyrrz$Error in Deleting Test from workflowr) rrrrrrrr0rrr)rrrr testDetailsrrrrdeleteTestinJs%s.       rNc Csdddd}z*|jdkr,t|j}t|jd}t||}||d<d|d<Wt |SWt |StyG}z d|d<t ||d<d}~ww) NrrrrrrzError in saving interviewersr) rrrrrrrr1rrr)rrrrinterviwersDatarrrrsaveInterviewersForJd<s(      rPc Csdddd}z*|jdkr,t|j}t|jd}t||}||d<d|d<Wt |SWt |StyO}zd|d<t ||d<WYd}~t |Sd}~ww) NrrrrrrzError in Test has paper idr) rrrrrrrr/rrr)rrrrtestaaPaperDetailsrrrrcheckTestHasPaperRrKrRc Csdddd}z.|jdkr0t|j}t|jd}|j}t|||d|d<d|d<Wt |SWt |St yS}zd|d<t ||d <WYd}~t |Sd}~ww) Nrrrrz#Email Template updated successfullyrrzError in updateEmailtempr) rrrrrrrFILESrarrr)rrrrfileObjsrrrrupdateEmailtempgs*     rUc Csdddd}z;|jd}t|}t|dd}t|dd}d|d d |d <|WdWS1s8wYWt|Sty`}zd |d <t||d<WYd}~t|Sd}~ww)NrrrrErbapplication/pdfrattachment; filename=" file_name.pdf"Content-DispositionzError in downloading reportrr) rrr,openrreadrrr)rr candidate_idpdf_pathpdf_filerrrrcandidateReport~s  $ rac Csdddd}z/|jdkr1t|j}t|jd}t|j}t||}||d<d|d<Wt |SWt |St yL}z d|d<t ||d<d}~ww) NrrrrrrzError in Jd Publishr) rrrrrrrrr!rrr)rrrr companyDatarrrrr jdPublishs*      rcc Cdddd}z*|jdkr,t|j}t|jd}t||d|d<d|d<Wt |SWt |StyO}zd|d<t ||d <WYd}~t |Sd}~ww) NrrrrzCandidate Notified SuccessfullyrrzError in Candidate Notify viewr) rrrrrrrr.rrrrIrrrnotifyCandidaterKrec Csdddd}z|jdkr|j}t|d}|ddkr|d}tjj|d}tjj||d }d }|j|jkr?d }|j|j}nd }|j}t d } t | d } t | d} || kr\d } n || krcd} nd} d } | d kso| dkr}|j d kr}d } d |_ | d}t tjj||ddjddd}||| ||| d|d<|ddkr|d}|d}t|||d|d<Wt|SWt|Sty}zd|d<t||d<WYd}~t|Sd}~ww)Nrrrr request_type check_credits paper_typer)r transtyper r r lowcredits_warningreg_stop_warningLr zHR-Admin)rrole__containsrrTr)rcredit_availablity_statcredits_statushradmin_emails_listcurrent_creditssend_lowcredits_notificationrdeduct_creditsr#rr$Error in getUpdateCompanyCreditsViewr)rrrrErrrHbalancecreditsrrlowcreditsnotificationr6r$rLrr%rrrr)rrrrrhcompany_accountcompany_creditsrnrqrrjrkrorrhr_admin_labelrpr#rrrrgetUpdateCompanyCreditsViewsn            8r{c Csdddd}zO|jdkrQt|j}|j}tjj|d}td}t|d}t|d}|j |kr4d}n |j |kr        rc Csdddd}z|jdkrt|j}|j}t|}t|jd}|ddkr|j }t j j |d\}}|d|_ |d |_|d } d } |D]3} | d|_|t|j} |jd |jd d |j} | |_|td | } dt| di} qI||d<tdd} d}t| |}tj||| dd}|j }|rt|d}|d}|dkrd|d<d|d<Wt|SWt|SWt|SWt|SWt|Sty}zd|d<t||d<tdt|WYd}~t|Sd}~ww)Nrrrrrfupdate_brandingr css_contentrrz:// HTTP_HOSTz/media/logorVrrrz/api/company-brandingF)rfilesrrrrzBranding updated successfullyz"Error in updateCompanyBrandingViewrz%Error in updateCompanyBrandingView : ) rrrrrrrrrrSrFr get_or_createrrr6itemslogourlrschemeMETAr r\rrrrrrloggingrr)rrrrrrrTcompany_brandingcompany_branding_flaglogo_file_path logo_filefile logo_fullpathrrrupdate_responserrresp_status_coderrrrupdateCompanyBrandingView/sn           -(   rcCs&t|j}t|j}t|j|jdS)N)name companyname)rrrrrr)rrcompanyrrr getUserNamehs  rc Cdddd}z#t|j}t|jd}}t|j|}||d<d|d<Wt |Sty@}z d|d<t ||d<d}~wwNrrrrrzError in Creating New Userr) rrrrrrr-rrrrrrrruserDatarrrr addNewUsersn"    rc Crr) rrrrrrr"rrrrrrrrchangeUserStatusrrc Csdddd}z|jdkr|j}t|d}|ddkrRtjjt|d|d}tjj||j|j |d t|d d  }t |_ |d |_|d |d<d|d<|ddkrutjjt|d|d}|d |_|d|d<d|d<|ddkrtjjt|d|d}t|d }t||j|j |d |t dd}||d dkrtjj|j d}t|j|j|d|jd}||jr|d dkrt|jddn |d dkrt|jddd|d<d|d<Wt|SWt|SWt|Sty } z d |d<t| |d!<d} ~ ww)"Nrrrr update_type reg_statusparticipant_refidr/rrhr#)rr/rrr update_valuez(Registration status updated successfullyrrrcandidate_statusz%candidate status updated successfullyadd_registrationI)rr/rrrregistrationdaterrr )r/hridr#rrrSCzScreening SentECTzCoding Test SentzRegistered successfullyrtr)rrrrGrrrKrrrrrnowcompletiondaterr6rIrP createdbyr profileidrzrrr) rrrr candidate registrationr#job_desc call_schedulerrrrupdateHirelinesDatas              C) rc Cr) Nrrrrrrz#Error in save interview remark viewr) rrrrrrbrrrrrrrinterviewRemarkSaves&   rc Csdddd}z8|jdkr:|j}t|d}|d}tjj||d}tjj|jd }||d<d |d <Wt |SWt |St y]}zd |d<t ||d <WYd}~t |Sd}~ww) Nrrrr cand_refidrrrrrzError in getJDDatar)rrrrGrrrIrrrrrrr)rrrrrrrrrrr getJDDatas,    rc Cdddd}z$|jdkr&t|jd}t|d|d<d|d<Wt|SWt|StyI}zd|d<t||d <WYd}~t|Sd}~ww) Nrrrrzmake a star questionrrError in update emailsr) rrrrrrdrrrrrrrmakeAstarQuestion&   rc Cr) Nrrrrrrz)error while getting the topics for skillsr) rrrrrr$rrr)rrr skillsDatarrrrskillsWithTopicwithSubtopics.rrc Cr) Nrrrrz$Company details updated successfullyrrrr) rrrrrrcrrrrrrr updateCompanyCrrc Cr) NrrrrrrzError in adding demo userr) rrrrrr2rrr)rrrdemo_idrrrrdemoUserY&  rc Cr) NrrrrzDemo requestedrrzError in requesting demor) rrrrrrerrrrrrr demoRequestprrc Cr) NrrrrzCandidate deletedrrz Error in deleting the candidatesr) rrrrrrfrrrrrrrdeleteCandidaterrc Csdddd}z&|jdkr(t|jd}t|}t||d<d|d<Wt |SWt |StyK}zd|d<t||d<WYd}~t |Sd}~ww) Nrrrrrrz)Error in updating candidate workflow datar) rrrrrr3rrrr)rrr updated_datarrrrupdateCandidateWorkflows&    rc Csdddd}z |jdkr"t|j}t|}||d<d|d<Wt|SWt|StyE}zd|d<t||d<WYd}~t|Sd}~ww) NrrrrrrError in getting dashboard datar)rrrr4rrr)rrrdashboard_datarrrrgetDashboardGraphDatas&    rc Crd) NrrrrzSources Data Updatedrrrr) rrrrrrrrgrrrrrrrrrrrupdateSourceData(     rc Crd) NrrrrzCandidate info Updatedrrz Error in updating candidate infor) rrrrrrrrhrrrrrrrupdateCandidateInforrc Csdddd}z+|jdkr-t|j}t|j}|j}t||j|}||d<d|d<Wt |SWt |StyH}z d|d<t||d<d}~ww) Nrrrrrrz$Error in excel mapping response datar) rrrrrSr5rrrr)rrrrrTmapping_responserrrrcandidateUploadFiles*      rc Csdddd}z8|jdkr:t|j}t|jd}t|j}tj t |||j fd}d|_ | d|d<Wt|SWt|StyU}z d |d<t||d <d}~ww) Nrrrr)targetargsTrrz)Error in confirmed candidate data servicer)rrrrrrrr threadingThreadr6rdaemonstartrrr)rrrrrthreadrrrrconfirmedCandidateDatas,     rc Crd) Nrrrrz Data Updatedrrz(Error in updating dashboard display datar) rrrrrrrrirrrrrrrupdateDashboardDisplayFlag+rrc Csdddd}z$|jdkr&t|jd}t|}||d<d|d<Wt|SWt|StyA}z d|d<t||d<d}~ww) Nrrrrrrz-Error in checking candidate registration datar) rrrrrr7rrr)rrrregistration_flagrrrrcheckJdCandidateRegistrationBs&    rc Csdddd}z*|jdkr,t|j}t|}tt|dddd}d|d |d <|WSWt|StyG}z d |d <t||d <d}~ww)Nrrrreport_file_pathrVzAapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheetrzattachment; filename=report_file_namer[z"Error in downloading Upload Reportrr) rrrr8rr\rrr)rrrreport_file_datarrrrdownloadUploadReportXs,    rc Csddd}z5|jd}|sd|d<t|ddWStjj|d}|r*|j|d<n d ||d<Wt|SWt|StyU}zt ||d<WYd}~t|Sd}~ww) N)r#rrzMissing test_idrir) workflowidr#zNo paper found for test_id ) rrrrQrrrrrr)rrrbrulerrrr get_paperidus$   rcCs@t|jdd}|dd}|dd}|dd}|dd}|dd}|d d}|d d}|d d} |r@t|nd}|rHt|nd}|j} tjj| d j} t jj | d  d} |rg| j |d} |dur|durg} t j D] }|jr|jr|j|j}||kr|krnqv| |jqv| j | d} |rtjj |d}|r| j |jd} n| } |rtjj |djddd}| j |d} |r| j |dd} |r| rt|d}t| djdddd}| j ||d} ddd d!d"}g}| D]}t jj |jd#}|r|jr|jr|j|jnd}tjj |jdjd$ddp,d}t|d%dp5d}tjj |jd#d&d'}|rX|d&pNd}|d'pVd}nd}d}||j|jd(|j rl|j nd|j!rt|j!nd)|j"r||j"nd)|j#r|j#nd)|d*|t$|j%|j%|||d+ qt&d|d,S)-Nr{}titlerexp_fromexp_tosourceskillsr date_fromdate_torrz-dateofcreationtitle__icontains)id__inr)sourceid)primaryskills__icontainsrTrrrz%Y-%m-%d;)hourminutesecond)dateofcreation__gtedateofcreation__lteDraftRejectedOfferedEmployee)DROr)rlabelstrength primaryskillssecondaryskillsz%d-%b-%Y %I:%M %p z Years) rdatecoder firstnamelastname experiencerrprimaryskills_namesecondaryskills_nameprofilestrength)rr)'rrrrrrrLrrrRrorder_byrSallyearfromyeartorrrTrrnonerUr%rstrptimereplacergetattrrdateofcreationstrftime profilecoderrrrrr)rrrrr source_coderrrr login_userrfiltered_profiles matched_idsexpyears source_objskill_profile_idsstart_datetime end_datetime status_map final_outputprofile source_value strength_val skills_data primary_sk secondary_skrrrfilter_profiles_apis                 &  r(cCs2tjj|d}t|jd}tdd|iS)N)resumeidrpdf_datazdata:application/pdf;base64,)rXrrbase64 b64encode filecontentrr)rrid resume_file file_base64rrr getResumeFiles  r1c Csdddd}z*|jdkr,t|jd}t|j}t||}||d<d|d<Wt |SWt |StyG}z d|d<t ||d<d}~ww) Nrrrrrrz%Error in getting filtered resume datar) rrrrrrrr9rrr)rrr user_data resumes_datarrrrgetFilterResumess(     r4c Csdddd}z&|jdkr(t|jd}t|dd|d<d|d<Wt|SWt|StyC}z d |d<t||d <d}~ww) Nrrrr resume_idr4rrError in deleting Resumer) rrrrrr:rrrrrrr deleteResume-s&     r7c Cr) Nrrrrrrr6r) rrrrrrrrkrrr)rrrr2 add_profilerrrraddResumeProfileEs(     r9c Cdddd}z1|jdkr3t|jd}|jd}t|j}t|||d|d<d|d<Wt |SWt |St yN}z d |d<t ||d <d}~ww) Nrrrr attachmentr4rrzError in saving Profile Detailsr) rrrrrrSrrrjrrrrrrrTr2rrrr addProfile_*      r=c Cdddd}z+|jdkr-t|jd}t|t|ddd|d<d|d <Wt |SWt |StyH}z d |d<t||d <d}~ww) Nrrrrr profile_idr4rrz!Error in updating Profile Detailsr) rrrrrrlr|rrrrrrrupdateProfileDetailsz(   rBc Cr?) NrrrrrAr@r4rrz+Error in updating Profile Education Detailsr) rrrrrrmr|rrrrrrrupdateProfileEducationrCrDc Cr?) NrrrrrAr@r4rrz,Error in updating Profile Experience Detailsr) rrrrrrnr|rrrrrrrupdateProfileExperiencerCrEc Cr?) NrrrrrAr@r4rrz*Error in updating Profile Projects Detailsr) rrrrrror|rrrrrrrupdateProfileProjectsrCrFc Cr?) NrrrrrAr@r4rrz(Error in updating Profile Awards Detailsr) rrrrrrpr|rrrrrrrupdateProfileAwardsrCrGc Cr?) NrrrrrAr@r4rrz-Error in updating Profile Certificate Detailsr) rrrrrrqr|rrrrrrrupdateProfileCertificates(    rHc Cr?) NrrrrrAr@r4rrz(Error in updating Profile Skills Detailsr) rrrrrrrr|rrrrrrrupdateProfileSkillsrIrJc Csdddd}z-|jdkr/t|j}|j}t|jd}t||d|d<d|d<Wt |SWt |St yJ}z d|d<t ||d <d}~ww) Nrrrrr4rrz(Error in adding Profile Activity Detailsr) rrrrrrrrrsrrr)rrruseridrrrrraddProfileActivity's*     rLc Csdddd}z|jdkr|j}|jd}t|d}tjj|dj}|rY| }t j |j d}|dvrHzt|}Wn|}Yn |dkrO|}ntd |j } |} nd} d} d } d |vrtjj||d d } | ru| j} nt||d |d d } | | j} t| | d|dd}|| rt|j| | d}|d|d<d|d<Wt|SWt|Sty}z d|d<t||d<d}~ww)Nrrrr;rr)z.docz.docxz.pdfzUnsupported file formatrz source-code)rr)rrrP)rrDmailidrr)r)rDr-zResume uploaded successfullyrrrzError in candidateProfiler)rrdictrSrrrIrrr]r8r9splitextrlowerrrrTrrrr6rYrXrr)rrrfileObjrr file_binaryext pdf_binaryrD file_datarr new_source new_resumer/rrrrcandidateProfileAs~      S rYc Cspdddd}z|jdkrtd|d<d|d<Wt|SWt|Sty7}z d|d<t||d <d}~ww) Nrrrr4rrrz#Error in getting resume from emailsr)rrrrr)rrrrrrgetMailResumess$    rZc CsNdddd}z~|jd}|stdd|d<t|WStjj|d}|j}|j}|j}t jj|d}t dd }d } t || } ||||j d } t j| | d d id} | ddkrdtdd|d<d|d<d|i|d<|j} tjj| dj}t|dd|Wt|Sty}ztdt|t||d<WYd}~t|Sd}~ww)NrrrAz Missing profile_idprofile_id missingrrrrz/api/get-welcome-mail) companyIdtoEmail first_name companyName Content-Typeapplication/jsonrheadersrrz ACERT email process failedzACERT email process failedrrrE1zThank you notez Exception in sendwelcomemail():)rrrrrRrrrrrWrrrrrrrrLrrzrr)rrrAr"r^to_emailrrrrrpayload acert_resr acvityuseridrrrrsendwelcomemailsZ     ric Csddd}z(|jd}|sd|d<t|WStjj|dd}||d <d |d <t|WStyI}zt||d<t|WYd}~Sd}~ww) NFr) email_sentrrAr[rrd)r activitycoderjrr) rrrrZrrr:rr)rrrAr:rrrrcheck_welcome_mail_status s(     rlc CsFdddd}d}zz[|jdkrc|jd}t|j}t||}tj|d}t |dd-}t | dd}d |d d |d <|WdWW|rYtj |rZt |SSS1s^wYWnty}zd |d<t||d<WYd}~nd}~wwW|rtj |rt |t|S|rtj |rt |www)NrrrpidrErVrWrrXrYrZr[zError in downloading profilerr)rrrrrr;r8r9normpathr\rr]r:r>rrr)rr pdf_file_pathrAr2r_r`rrrrdownloadBrandedProfile sF           rpc Csdddd}zht|jd}|d}|d}tjj||d}|s3g|d<d|d<t|WSg}|D]}| |j |j |j |j |jrL|jd nd|jd q7|}|j|d <|j|d <||d<d|d<t|WSty} zt| |d <t|WYd} ~ Sd} ~ ww)Nrrruser_idr)rKrrrz%H:%M:%S)rrKrstartday starttimehoursweekoff1weekoff2r)rrrrr[rrr:rrrrKrrrrsrrtrrurvrr) rrrrqrrowsrrrrrrr getworkcal< sD        ryc Cr) Nrrrrr4rrzError in saving Detailsr) rrrrrrtrrrrrrr saveworkcalt s&  rzc Csdddd}ztjj|d}|d|d<d|d<Wt|Stjy3d|d <d|d<Yt|StyQ}zt||d <d|d<WYd}~t|Sd}~ww) NrrrrrzDeleted SuccessfullyrzRecord not foundr)r[rrdelete DoesNotExistrrr)rrrobjrrrrdelete_work_cal s(    r~c CsXddd}zt|jd}|d}|d}|d}|dd}tjj|d }|d kr2||_||_||_| |d krt jj|j d }t jj|d } t d d } d } t | | } |j| j| j|j|j|jd} tj| | ddid}|ddkrd|d<t|WSd|d<Wt|Sty}zt||d<WYd}~t|Sd}~ww)Nr)rrrJdIDrhiring_manager_idcommentsrrFrrz/api/get-approval-mail)r\r]r^jdTitlehrNamejdIdr`rarbrrzACERT approval mail failedr)rrrrrIrhiringmanager_idapproval_statusrr6rLrrrrrrrrrrrrr)rrrrrrrrhr hiringmanagerrrrrfrgrrrrupdate_jd_status sV         rc Csdddd}tdz$|jdkr*t|jd}t|}||d<d|d<Wt |SWt |StyM}zd|d<t||d <WYd}~t |Sd}~ww) NrrscheduleCandidateInterviewrrrrzError in Scheduling Interviewr) rrrrrrrvrrrrrrrr s(   rc Csdddd}z3|jdkr0t|jd}|d}t|}t|j}t||}||d<d|d<nt dWSWt |St yP}z d |d<t ||d <d}~ww) Nrrrrr^rrrrr) rrrrrrrrrurrrr)rrrr^enc_candidate_idr2rrrrrscheduleCandidateInterviewLink s,       rc Cr) Nrrrrr4rrz"Error in assigning Recruiter to JDr) rrrrrrwrrrrrrrjdRecruiterAssign9 &   rc Csdddd}z$|jdkr&t|jd}t|d|d<d|d<Wt|SWt|StyA}z d|d<t||d <d}~ww) Nrrrrr4rrzError in updating full profiler) rrrrrrxrrrrrrrauto_fill_profileR s&    rc Csdddd}z2t|j}t|j}|j}|j}|jd}|jd}t|||||d}||d<d|d<Wt |StyS} zt | |d <WYd} ~ t |Sd} ~ ww) Nrrrr recruitermonthr user_rolelogged_recruiter_idselected_recruiter month_valuerrrr) rrrrrrrr<rrr rrrr2rrrrrrrrrrecruiter_dashboard_filterj s4     rc Csdddd}z*|jdkr,t|jd}t|j}t||d|d<d|d<Wt |SWt |StyO}zd|d<t ||d <WYd}~t |Sd}~ww) Nrrrrr4rrzError in add new workspacer) rrrrrrrryrrr)rrrr2rrrr addWorkspace s(    rc Cdddd}z*|jdkr,t|jd}t|j}t||}||d<d|d<Wt |SWt |StyO}zd|d<t ||d<WYd}~t |Sd}~ww) Nrrrrrrz Error in getting jd Profile Datar) rrrrrrrr=rrr)rrrr2jd_profiles_datarrrr jdProfileData s(    rc Cr) Nrrrrrrz!Error in shortlisting the Profiler) rrrrrrrr>rrr)rrrr2 shortlistrrrrshortlistProfile s(     rc Csdddd}zA|jdkrCt|j}t|j}|j}|j}|jd}|jd}td|t |||||d}||d<d |d <Wt |SWt |St yf} zd |d<t | |d <WYd} ~ t |Sd} ~ ww) Nrrrrrrrrrrz%Error in getDashBoardDataService viewr) rrrrrrrrrr?rrrrrrr dashBoardView s:       rc CszB|jd}tjj|d}|r:|jpd|jpd|jpd|j p"d|j p&d|j p*d|j p.dd}t d|ddWSt ddddWSty^}zt ddt|dWYd}~Sd}~ww)NrArr)reducationscore awardsscorecertificatesscoreexperiencescore projectsscore skillsscorerrzProfile not found)rrrRrrrrrrrrrrrrr)rrAr"statsrrrrget_profile_strength s$   rc Cr) Nrrrrr4rrzError in updating workspacer) rrrrrr{rrrrrrrupdateWorkspace2 rrc Crr) rrrrrrr@rrrrrrrr addNewClientsM rrc Crr) rrrrrrrArrrrrrrrchangeClientStatusf rrc CzG|jdkr?t|j}t|jdd}|d}|d}|j||d}td|t |}t d|d |d |dd WSt d gd dWSt yc}zt d gt |dWYd}~Sd}~wwNrrrrr)r from_dateto_daterrrr)rrrrrzInvalid request methodr) rrrrrrrrrrBrrrrrrrrrresultrrrrrecruiters_performance| >       rc Cs|z#|jdd}tjj|ddddd}t|}t|ddWSt y=}ztd t |iWYd}~Sd}~ww) Nqrrrr F)safer) rrstripr\rrrr$rrr)rqueryqsrrrrrsearch_jd_library src Csz<|jd}tjj|d}|j|jpd|jpd|jpd|jp d|j p$d|j r*|j ng|j r1|j ngd}t d|dWStj yMt ddd YStyg}zt dt|d WYd}~Sd}~ww) Nrrr)r descriptionrmin_expmax_exp work_locationprimary_skillssecondary_skillsr)rrrz JD not found)rmessagerr)rrr\rrrrrrrrrrr|rr)rrrrrrrrjd_library_detail s8    rc Csz|jdd}|jdd}|jdd}|jdd}|jdd}|jd}t|j}td|d }d } d } d} d} d} |rktjj||d }|r\|j |d }|}|rkd } t |j d d d} |rtjj||d}|r}|j |d }|}|rd } t |j d d d} |s|s|rtjj|dt |||dt |||dB}|r|j |d }|}|rd }t |j d d d} t || | | | | dWSty}zt dt|dWYd}~Sd}~ww)Nrr middlenamerrmobilerArF) email__iexactrrTrr)rrr)firstname__iexactmiddlename__iexactlastname__iexact) name_exists email_exists mobile_existsname_profile_codeemail_profile_codemobile_profile_coderr)rrrrrrrRrrexcluder$r%rrrr)rrmiddlerrrrArrrrrrr email_obj mobile_objname_objrrrrvalidate_profile s              rc Csdddd}z+|jdkr-t|j}t|jd}t||j}||d<d|d<Wt |SWt |St yP}zd|d<t ||d<WYd}~t |Sd}~ww) Nrrrrrrz!Error in getting Job Board Configr) rrrrrrrrCrrrr)rrrr config_datarrrrjobBoardConfig> (    rc Csdddd}z+|jdkr-t|j}t|jd}t||jd|d<d|d<Wt |SWt |St yP}zd|d<t ||d <WYd}~t |Sd}~ww) Nrrrrr4rrz(Error in getting saving Job Board Configr) rrrrrrrr}rrrrrIrrrsaveJobBoardConfigY rrc Crd) Nrrrrr4rrzError in saving JD Job Boardsr) rrrrrrrr~rrrrIrrrsaveJDJobBoardst s(    rc Cr:) Nrrrr resumefiler4rrzError in adding Resumer) rrrrrrSrrrrrrr<rrr addResume r>rc Csdddd}z|jd}tjtdd}tj|ddtj|jd}| d d}|d }tj||}t j d d d ddddddd|g t j t j t j d}|D]} |dur]n|j| qS|j||jdkr}|j} t| tjtdd|d} tj| rt| |} | rtt| d} d} | dkrd} n| dkrd} nd} nd} d} tjj|d}| |_| |_ |!| |d<d|d <n d!|d<d|d <Wt#|SWt#|Sty}zt"||d"<WYd}~t#|Sd}~ww)#Nrr speaker_audior2r3T)exist_okrr,z.wavffmpegz-yz-fwebmz-izpipe:0z-ac1z-ar16000)stdinstdoutstderrz_profileaudio.wavr-rUrlZMHrrrzProfile audio not foundr)$rSrr8r9rr makedirsrPrr5 subprocessPopenPIPEDEVNULLchunkspollrwriteclosewait returncoderr]rrr:rroundfloatrPr audioscore audiolevelr6rr)rr audio_file folder_path base_name scheduleid wav_filenamewav_pathprocesschunkrprofile_file_path result_scorelevelcall_schrrrruploadAudioFile s           rc Crr) rrrrrrrrrrDrrrrrrrsource_performance rr(rr8rrrtimerrer+ urllib.parserr django.httprrapp_api.functions.enc_decrr#app_api.functions.voice_comparisionrhirelines.settingsr r rest_framework.decoratorsr r r rrdjango.views.decorators.csrfrallauth.account.utilsrallauth.accountrrapp_api.functions.masterdatarrrdjango.db.modelsrhirelines.metadatarrfunctions.servicesrrrrrrr r!r"r#r$r%r&r'r(r)r*r+r,r-r.r/r0r1r2r3r4r5r6r7r8r9r:r;r<r=r>r?r@rArBrCrDmodelsrErFrGrHrIrJrKrLrMrNrOrPrQrRrSrTrUrVrWrXrYrZr[r\functions.databaser]r^r_r`rarbrcrdrerfrgrhrirjrkrlrmrnrorprqrrrsrtrurvrwrxryrzr{r|r}r~rapp_api.functions.constantsrrapp_api.functions.email_resumerfunctions.doc2pdfrrrrrrrrrrrrrrrrrrrr)r*rFrHrJrNrPrRrUrarcrer{rrrrrrrrrrrrrrrrrrrrrrrrr(r1r4r7r9r=rBrDrErFrGrHrJrLrYrZrirlrpryrzr~rrrrrrrrrrrrrrrrrrrrrrrrrrrrrs        h           @ 4      3 y         C  # 8  M              {             ]  K   7  6 @    #    7     *  # _      Y