sildZddlZddlZddlZddlmZmZddlmZddlm Z ddl Z ddl Z ddl m Z ddl mZddlmZdd lmZdd lmZdd lmZmZdd lmZdd lmZmZddlmZddlm Z ddl!m"Z"ddl#m$Z%ddl&m'Z'ddl(m)Z)m*Z*ddl+m,Z,ddl-m.Z.ddl/m0Z0m1Z1ddl2m3Z3ddl4m5Z5m6Z6ddl7m8Z8dZ9dZ:dZ;dZ<Gdde0Z=Gd d!e0Z>Gd"d#e0Z?Gd$d%e0Z@d&ZAGd'd(e0ZBGd)d*e0ZCGd+d,e0ZDGd-d.e0ZEGd/d0e0ZFGd1d2e0ZGGd3d4e0ZHGd5d6e0ZIGd7d8e0ZJGd9d:e0ZKGd;de0ZMGd?d@e0ZNGdAdBejZPgdCZQgdDZRGdEdFe0ZSGdGdHe0ZTGdIdJe0ZUy)KzH models.py This module is used to register models for recruitment app N)datetimetimezone) urlencode)uuid4)forms)settings)User)ValidationError)default_storage)MaxValueValidatorMinValueValidator)models)reverse reverse_lazy)r) format_html)slugify) gettext_lazy)HorillaCompanyManager)Company JobPosition)Employee)_thread_locals) HorillaModel upload_pathget_diff)HorillaAuditInfoHorillaAuditLogrender_templatecd}tj||.d|vrtjdtjdy)zT This method is used to validate the mobile number using regular expression z^\+[0-9 ]+$|^[0-9 ]+$N+zvInvalid input: Plus symbol (+) should only appear at the beginning or no other characters allowed.z2Invalid input: Only digits and spaces are allowed.)rematchrr )valuepatterns 6/var/www/python-projects/worksol/recruitment/models.pyvalidate_mobiler(*sV'G xx' %<''5 ## @  (ctjj|jd}|j dk7rt t dy)z- This method is used to validate pdf z.pdfzFile must be a PDF.N)ospathsplitextnamelowerr _)r%exts r' validate_pdfr3;sE ''  5:: &q )C yy{fa 5677r)c|S)z3 This method is used to validate the image )r%s r'validate_imager6Ds  Lr)c|jdd}|jjddd|dtd|}tj j d|S)N. r1zrecruitment/profile/)splitr/replacerr,r-join)instancefilenamer2s r'candidate_photo_upload_pathr@Ks[ .. b !C--''S12!H:QuwiqNH 77<<. 99r)c eZdZdZej ddZejddZejddZ eje ejdded Zed Zd efd ZGd dZy)SurveyTemplatez SurveyTemplate Model 2T max_lengthunique)nullblankF)defaulteditabler on_deleterGrH verbose_name company_idreturnc|jSNtitleselfs r'__str__zSurveyTemplate.__str__b zzr)c,eZdZedZedZy)SurveyTemplate.MetazSurvey TemplateSurvey TemplatesN__name__ __module__ __qualname__r1rMverbose_name_pluralr5r)r'MetarYes*+  23r)r`N)r\r]r^__doc__r CharFieldrS TextField description BooleanFieldis_general_template ForeignKeyrCASCADEr1rNrobjectsstrrVr`r5r)r'rBrBQs F  4 8E"&""D9K-&--eeL""".. y\ J$L1G44r)rBceZdZejdZdZfdZdZdZ dZ dZ d e fd ZGd d Z xZS) SkilldrEc|jSrQrRrTs r'rVz Skill.__str__mrWr)cf|j}|j|_t| |i|yrQ)rS capitalizesupersave)rUargskwargsrS __class__s r'rsz Skill.saveps- %%'   d%f%r)c~ttjjd}|j |dz}|S)z$ for get serial nos idr+)listrlriorder_byindex)rU all_instancessinos r'get_sinozSkill.get_sinous7U]]33D9: ""4(1, r)c8tdd|ji}|S)/ This method to get update url zsettings-update-skillspkrurrrUurls r'get_update_urlzSkill.get_update_url}s3T477OL r)cBtd}|j}|d|}|S)/ This method to get delete url z delete-skillsz?ids=r)rUbase_urlskill_idrs r'get_delete_urlzSkill.get_delete_urls, 077 %z* r)c|jS)z, to get instance for delete rrTs r'get_delete_instancezSkill.get_delete_instances wwr)rOc|jSrQrRrTs r'rVz Skill.__str__s**r)c,eZdZedZedZy) Skill.MetarlSkillsNr[r5r)r'r`rsz kr)r`)r\r]r^rrbrSrVrsr~rrrrjr` __classcell__rvs@r'rlrljsI F   ,E& **r)rlc eZdZdZej dddedZejdedZ ejded  Z ejded ed  Z ejdeded Z ejeddedZej"eej$ddddeddZej(ddedZejeedZejededZej"eej$ddedZej8ej<j>j@edZ!ej8dded !Z"eje#ded"Z$ej"d#ej$dded$Z%ej d%dd&Z&ejded'ed( Z'e(Z)ejTjWZ,ejded)ed* Z-ejded+ed, Z.Gd-d.Z/d/Z0d0Z1fd1Z2fd2Z3d3Z4d4Z5d5Z6d6Z7d7Z8d8Z9d9Z:d:Z;d;Zd>Z?d?Z@d@ZAxZBS)A Recruitmentz Recruitment model rCTTitlerErGrHrM Description)rGrMFz/To start recruitment for multiple job positions)rI help_textzFTo close the recruitment, If closed then not visible on pipeline view.Closed)rIrrMzkTo publish a recruitment in website, if false then it will not appear on open recruitment page.z Is Publishedopen_positions Job Position) related_namerHrM recruitment)rLrGrH db_constraintrrMrJrVacancy)rIrGrMManagersrMrZ)rHrMrrKz Start DaterIrMzEnd DaterHrGrMrzrecruitment.LinkedInAccountLinkedIn Account)rErGrHzgTo publish a recruitment in Linkedin, if active is false then it will not post on LinkedIn.zPost on LinkedInz2Profile image not mandatory for candidate creationzOptional Profile Imagez+Resume not mandatory for candidate creationzOptional Resumec<eZdZdZddgZdZedZedZy)Recruitment.Meta7 Meta class to add the additional info )job_position_id start_date)rrrN))archive_recruitmentzArchive Recruitmentr RecruitmentsN) r\r]r^raunique_together permissionsr1rMr_r5r)r'r`rs5   <  H ' /r)r`cV|jjdjS)zR This method is used to get the count of hired candidates T)hired) candidatefiltercountrTs r' total_hireszRecruitment.total_hiress% ~~$$4$06688r)c$|j1|jr%|jjd|jn |j}|js1|j%|j j |jt|S)Nr:)rSr job_positionris_event_basedraddrj)rUrSs r'rVzRecruitment.__str__ s~zz!d&:&:##0014??2C D  ""t';';'G    # #D$8$8 95zr)cP|jtdtdi|jr#|jdkrttd|j ;|j /|j |j kDrtdtdit|!S)NrSThis field is requiredrzCVacancy must be greater than zero if the recruitment is publishing.end_datez(End date cannot be less than start date.) rSr r1 is_publishedvacancyrrrrclean)rUrvs r'rzRecruitment.cleans :: !7A.F,G"HI I   ||q %] == $ OO 'DOOdmm,K!QIJK w}r)c|jsd|_d|_t||i||j r#|j tdtdiyy)Nrr) publish_in_linkedinlinkedin_account_idlinkedin_post_idrrrsrrr r1)rUrtrurvs r'rszRecruitment.save,s`'''+D $$(D !  d%f%   4#6#6#>!#3Q7O5P"QR R$? r)c8|jjdS)zf This method will returns all the stage respectively to the ascending order of stages sequence) stage_setrzrTs r'ordered_stageszRecruitment.ordered_stages4s~~&&z22r)c tdd|iS)zD This method for get custom column for recruitment. z$cbv/recruitment/recruitment_col.htmlr>r-contextrrTs r'recruitment_columnzRecruitment.recruitment_column:s 7&  r)c8tdd|ji}|S) detail view zrecruitment-detail-viewrrrrrs r'recruitment_detail_viewz#Recruitment.recruitment_detail_viewDs/twwH r)c tdd|iS)A This method for get custom column for managers. z!cbv/recruitment/managers_col.htmlr>rrrTs r'managers_columnzRecruitment.managers_columnKs 4&  r)c|jj}|r.dj|Dcgc] }t|c}}d|dSycc}w)z( manager in detail view 
+)recruitment_managersallr=rjrU employeesemployeeemployee_names_strings r'managers_detailzRecruitment.managers_detailUsY--113 $*KK/898X9% !AAV@WW^_ _ :A c |jj}t|Dcgc]\}}d|dzd|d}}}dj|Scc}}w)Nz
r+z. 
r)rr enumerater=)rU manager_listimanagerformatted_managerss r'managerszRecruitment.managersbsd00446 ?H?V 1;GeAE7"WIV ,  ww)** sAc tdd|iS)rz"cbv/recruitment/detail_action.htmlr>rrrTs r'detail_actionszRecruitment.detail_actionsis 5&  r)c tdd|iS)zB This method for get custom column for open jobs. zcbv/recruitment/open_jobs.htmlr>rrrTs r' open_job_colzRecruitment.open_job_colss 1&  r)c|jj}|r.dj|Dcgc] }t|c}}d|dSycc}w)z* open jobs in detail view rrrr)rrr=rj)rUjobsjobjobs_names_strings r'open_job_detailzRecruitment.open_job_detail}sX""&&(  & ,F#SX,F G =>O=PPWX  -Grc tdd|iS)zD This method for get custom column for Total hires. z cbv/recruitment/total_hires.htmlr>rrrTs r' tot_hireszRecruitment.tot_hiress 3&  r)c|jryy)NrOpen)closedrTs r' status_colzRecruitment.status_cols ;;r)c tdd|iS)z@ This method for get custom column for actions. zcbv/recruitment/actions.htmlr>rrrTs r' rec_actionszRecruitment.rec_actionss /&  r)c&d|jd}|SzV Method will retun the api to the avatar or path to the profile image !https://ui-avatars.com/api/?name=&background=randomrRrs r' get_avatarzRecruitment.get_avatar2$**=OP r)ctjj|dj}|rD|jj j d}t||jk\ryyy)zj This method is used to check wether the vaccancy for the recruitment is completed or not rrecruitment_id stage_typeT)canceledN) Stagerirfirst candidate_setrexcludelenr)rU hired_stagehired_candidates r'is_vacancy_filledzRecruitment.is_vacancy_filledsqmm**G+ %'  )77;;=EEtETO?#t||34 r))Cr\r]r^rarrbr1rSrcrdrerrrManyToManyFieldrrrgPROTECTr IntegerFieldrrrrBsurvey_templatesrrN DateFielddjangoutilsrnowrrrlskillsrrrrrirManagerrIoptional_profile_imageoptional_resumer`rrVrrsrrrrrrrrrrrrrr rrs@r'rrs= F  D1W: E#&""1];KLK(V((EFN!V  T x[ F'6&& 7 ~& L,V++%~& N (f''.. "~& O"f!!!$Qy\RG1611(:W-v--d3E1F#"".. y\ J"!! %%)),J vdAjMRH #V # #EAhK PF+&++%.. )* (v''3TN-&-- ( )* $%Gnn$$&G0V00HI/0 *f))AB()O 00 9 &S3    +       r)rc eZdZdZdedfdedfdedfded fd ed fd ed fgZejeejdedZ eje edZ ejdedZejdededZej"ddZedZGddZdZd Zd!Zd"Zd#Zd$Zd%Zd&Zd'Zd(Zd)Z d*Z!d+Z"d,Z#y-).rz Stage model initialInitialappliedAppliedtestTest interview Interview cancelled CancelledrHiredrr)rLrrMStage ManagersrrCrErMz Stage Type)rEchoicesrIrMTrrGrIrecruitment_id__company_idrelated_company_fieldcBeZdZdZdZddgZdgZedZedZ y) Stage.Metar)) archive_Stagez Archive StagerstagerrStagesN) r\r]r^rarrorderingr1rMr_r5r)r'r`r.s2 < +W5<z kr)r`cN|jd|jjdS)Nz - ())r0rrSrTs r'rVz Stage.__str__s&**T$"5"5";";!>r)cJdtjj|ddiS)zZ This method is used to get all the active candidate like related objects rFT)stage_idr is_active) CandidaterirrTs r'active_candidateszStage.active_candidatess0 9$$++,  r)c8tdd|ji}|S)rzstage-detail-viewrrrrs r'stage_detail_viewzStage.stage_detail_views)4/B r)c tdd|iS)z2 For answerable employees column zcbv/stages/detail_action.htmlr>rrrTs r' detail_actionzStage.detail_actions 0&  r)c tdd|iS)z@ This method for get custome coloumn for title. zcbv/stages/title.htmlr>rrrTs r' title_colzStage.title_cols(&  r)c tdd|iS)zC This method for get custome coloumn for managers. zcbv/stages/managers.htmlr>rrrTs r' managers_colzStage.managers_cols +&  r)c&d|jd}|Srrrs r'rzStage.get_avatars$ 00C0C/DDV W  r)c|jj}dj|Dcgc] }t|c}}|Scc}wz( Manager in detail view r)stage_managersrr=rjrs r'detail_managers_colzStage.detail_managers_colsB''++- & 9,UxS],U V$$-VAc tdd|iS)zB This method for get custome coloumn for actions. zcbv/stages/actions.htmlr>rrrTs r' actions_colzStage.actions_col#s *&  r)cdtdfdtdfdtdfdtdfd td fg}t|j|jS) z Display type rrrrr r!r"r#rr$)r1dictgetr)rU stage_typess r'get_typezStage.get_type-sc ) % QvY  !K. ) !K. ) aj !  K $$T__55r)c4tdd|jiS)rzstage-update-pipelinerr)rrxrTs r'get_stage_update_urlzStage.get_stage_update_url;s.dggGGr)c6tdd|jS)z6 This method to get add candidate url zadd-candidate-to-stage ?stage_id=rrxrTs r'get_add_candidate_urlzStage.get_add_candidate_urlAs 789DGG9MMr)c6tdd|jS)z3 This method to get send email url send-mailrSrTrTs r'get_send_email_urlzStage.get_send_email_urlGs{+,Jtwwi@@r)c6tdd|jS)rgeneric-deletez?model=recruitment.Stage&pk=rrTs r'rzStage.get_delete_urlMs!/011MdggYWWr)N)$r\r]r^rar1rNrrgrrhrr rrFrbr0rrrrrir`rVr9r;r=r?rArrGrJrOrQrUrXrr5r)r'rrsL AiL! AiL! 6 a n% a n% !G* K'V&&.. }% N ,V++H1EUCVWN F  7 DE!!!|_ J #v""a8H#:VWG * *?    %  6H N A Xr)rc|jdd}t|jxsd}|dtjddd|}d|d|S) zN Generates a unique file path for candidate profile & resume uploads. r8r9r-Nz recruitment//)r;rr/rhex)r>r?r2 name_slugunique_filenames r'candidate_upload_pathrbTsa .. b !C &5+I" 1UW[[!_$5Qse?Z.ejd@eddedABZ/ej`dCedDEZ1ej`dCedFEZ2ej`dCedGEZ3ej`dCedHEZ4ejRddedI(Z5e6dJe7gKZ8ejrddLMZ:ejRddCNZ;ejdOeddCedPQZ<e=dRSZ>ejRddTZ?de_@dUdVgZAejRdddCWZBdXZCdYZDdZZEd[ZFd\ZGd]ZHd^ZId_ZJd`ZKdaZLdbZMdcZNddZOdeZPdfZQdgZRdhZSdiZTdjZUdkZVdlZWdmZXdnZYdoZZdpZ[dqZ\drZ]dsZ^dtZ_duZ`dvZadwZbdxZcdyZddzZed{Zfd|Zgd}Zhd~ZidZjdZkdZldZmdZndZodZpfdZqdZrdZsdZtdZudZvdZwGddZxxZyS)r8z Candidate model maleMalefemaleFemaleotherOthernot_sentzNot SentsentSentacceptedAcceptedrejectedRejectedjoinedJoined applicationzApplication FormsoftwarezInside softwarermTName)rErGrM upload_torG)rErHrrrLrGrrMrrKrrLrGrM candidate_getr)rLrHrGrrMz Schedule daterEmail)rErFrMMobile)rErH validatorsrMrwrcandidate_referralReferral)rLrGrHrrMAddress)rGrHrMrECountryrz Date of Birth)rGrHrMStateCityzZip CodeGender)rEr(rGrIrMr'Source)rEr(rGrHrMFz Start Onboardrr$Canceled Convertedz Joining Date history_setrbasesrr))rGrJ zOffer Letter Status)rEr(rIrJrMr*r+)rGauto_now)"stage_id__stage_managers__get_mailr%).recruitment_id__recruitment_managers__get_mailzRecruitment Managers)rGrHrJc|jSrQ)r/rTs r'rVzCandidate.__str__s))r)cttdd}t|di}|j|jjj ^t jj|jj}|||jjj <||_ td||j|jjj dS)z! Stage drop down requestNall_rec_stagesrCz!cbv/pipeline/stage_drop_down.html)r>stagesr) getattrrrMr6rrrrirrr )rUrrrs r'stage_drop_downzCandidate.stage_drop_downs.)T: *:B?   dmm::== > F]]))9U9U)VF>DN4==77:: ;%3G "4 !001M1M1P1PQ  r)c tdd|iS) Rating bar zcbv/pipeline/rating.htmlr>rrrTs r' rating_barzCandidate.rating_bars+j$5G  r)c tdd|iS)z, Scheduled interviews count z%cbv/pipeline/count_of_interviews.htmlr>rrrTs r'get_interview_countzCandidate.get_interview_counts8:tBT  r)c tdd|iS)rzcbv/pipeline/mail_status.htmlr>rrrTs r'mail_indicationzCandidate.mail_indication s0:t:L  r)cJtj}td||dS)rz"cbv/pipeline/candidate_column.htmlr>rr)tzrr rUrs r'candidate_namezCandidate.candidate_names'ffh5!%c2  r)c|jS)z1 to get contact no of candidates mobilerTs r' get_contactzCandidate.get_contacts{{r)c.|jjSrQ)resumerrTs r'get_resume_urlzCandidate.get_resume_url%s{{r)cBtd|jjS)NzJ
{}/4
)ronboarding_portalrrTs r'onboarding_portal_htmlz Candidate.onboarding_portal_html(s! X  " " ( (  r)c tdd|iS)zA This method for get custome coloumn for rating. zcbv/candidates/rating.htmlr>rrrTs r'ratingzCandidate.rating. -&  r)c tdd|iS)zA This method for get custome coloumn for status. zcbv/onboarding_view/status.htmlr>rrrTs r'onboarding_status_colzCandidate.onboarding_status_col8s 2&  r)cddlm}m}|jj}|j j |}|j}td|||ddS)z@ This method for get custome coloumn for tasks. r)CandidateStage CandidateTaskrxzcbv/onboarding_view/task.htmlT)r>rr( single_viewr) onboarding.modelsrronboarding_stagerxrirMchoicer )rUrr cand_stagecand_stage_objr(s r'onboarding_task_colzCandidate.onboarding_task_colBs^ D**-- '//33z3B&&0 +"#   r)c|jryy)z archive status Archivez Un-Archive)r7rTs r'archive_statuszCandidate.archive_statusVs >>r)c tdd|iS)zA This method for get custome coloumn for resume. zcbv/candidates/resume.htmlr>rrrTs r' resume_pdfzCandidate.resume_pdf_rr)c2ttdd}t|dd}|s7ttjj dd}t |d|tjj|j dd}td||d  S) zA This method for get custom coloumn for options. rNmailsemailTflat) username__inzcbv/candidates/option.html)r>emp_listr) rrryr8ri values_listsetattrr rr )rUrrrs r'optionszCandidate.optionsis .)T:$/**66wT6JKE GWe ,<<&&E&:FF $G -!%8<  r)c8tdd|ji}|S)z0 This method to get profile url zcandidate-viewrrrrs r'get_profile_urlzCandidate.get_profile_url~s+T477OD r)c8tdd|ji}|S)rzrec-candidate-updatecand_idrrrs r'rzCandidate.get_update_url19dgg:NO r)c8tdd|ji}|S)r to-skill-zonerrrrs r'get_skill_zone_urlzCandidate.get_skill_zone_url?Itww3GH r)cTtd}td|ji}|d|S)V This method to get the update URL with cand_id as a query parameter. add-to-rejected-candidates candidate_id?rrrrUr query_paramss r'get_rejected_candidate_urlz$Candidate.get_rejected_candidate_url3 <= .$''!:; 1\N++r)cTtd}td|ji}|d|S)rcandidate-document-requestrrrrs r'get_document_requestzCandidate.get_document_requestrr)c8tdd|ji}|S)rz view-noterrrrs r'get_view_note_urlzCandidate.get_view_note_url; 477/CD r)c8tdd|ji}|Srzcandidate-view-individualrrrrs r'get_individual_urlzCandidate.get_individual_url6 477?ST r)c8tdd|ji}|Srrrs r' get_push_urlzCandidate.get_push_urlrr)c8tdd|ji}|S)z; This method to get covert to employee url zcandidate-conversionrrrrs r'get_convert_to_empzCandidate.get_convert_to_emprr)c8tdd|ji}|S)zC This method to get add to skill zone employee url rrrrrs r'get_add_to_skillzCandidate.get_add_to_skillrr)c:td}|d|jS)zD This method to get add to reject zone employee url r?candidate_id=rrs r'get_add_to_rejectzCandidate.get_add_to_rejects$78nTWWI..r)ct|jrd}nd}d|d}tdd|ji}d|d |dS) z1 This method to get archive url archivez un-archivezDo you want to z this candidate?zrec-candidate-archiverr'z',')r7rr)rUactionmessagers r'get_archive_urlzCandidate.get_archive_urlsO >>F!F#F8+;<2Itww;OP3%s7)1%%r)ctd}|S)rrZ)rrs r'rzCandidate.get_delete_urls+, r)c8tdd|ji}|S)z6 This method to get self tracking url zcandidate-self-status-trackingrrrrs r'get_self_tracking_urlzCandidate.get_self_tracking_urls# ,i5I  r)c<tdd|jz}|S)z9 This method to get document request url rrrrs r'get_document_request_docz"Candidate.get_document_request_docs$78^DGG9;UU r)cttdd}t|dds#tjj |_|j j |jjryy)z6 The method to get converted employee rNrrz"style="background-color: #f1ffd5;") rrrrirrrrexists)rUrs r'is_employee_convertedzCandidate.is_employee_convertedsa.)T:w T2 ( 0 0 4 4 6G     # #$** # 5 < < >7 ?r)c8tdd|ji}|S)" Candidate detail zcandidate-detailrrrrs r'get_details_candidatezCandidate.get_details_candidates-tTWWoF r)c8tdd|ji}|S)rrWrrrrs r' get_send_mailzCandidate.get_send_mailrr)ctjj|j}|r|jj dkDS|S)z3 Is offer rejected checking method rr)RejectedCandidaterirrreject_reason_idr)rUrs r'is_offer_rejectedzCandidate.is_offer_rejected sH"))00d0CIIK ))//1A5 5 r)c,t|jS)z7 Method will return employee full name )rjr/rTs r' get_full_namezCandidate.get_full_names499~r)cd|jd}|jrA|jj}tj|r|jj }|S)zV Method will rerun the api to the avatar or path to the profile image rr)rprofiler/r rr)rUr full_filenames r'rzCandidate.get_avatarsZ 00B0B0D/EEW X  << LL--M%%m4ll&& r)c Httt|ddddddS)z; This method is used to return the company rNrNcompany)rrTs r' get_companyzCandidate.get_company*s- GD"2D9< N    r)c.|jjS)zQ This method is used to return the job position of the candidate )rrrTs r'get_job_positionzCandidate.get_job_position4s##000r)c|jS)z Return email rrTs r' get_emailzCandidate.get_email:szzr)c"|jS)r:)rrTs r'get_mailzCandidate.get_mail@s~~r)c|jSrQrrTs r'phonezCandidate.phoneDs {{r)ct|S)zS This method is used to return the tracked history of the instance rrTs r'trackingzCandidate.trackingGs~r)cddlm}|jj|jj dj S)z; This method is used to get last send mail r)EmailLog) to__icontainsz -created_at) base.modelsr#rirrrzr)rUr#s r'get_last_sent_mailzCandidate.get_last_sent_mailMs: )    # #$** # = Xm $ UW r)c8tdd|ji}|S)Nzinterview-schedulerrrrs r'get_schedule_interviewz Candidate.get_schedule_interviewYs/DGG8LM r)c.tjj|j}|rid}|dz }t |dD]K\}}|d|dz }|d|j dz }|d |j dz }|d |jrd nd d z }M|dz }|Sy)z{ This method is used to get the interview dates and times for the candidate for the mail templates r zzGr+)startzzz
Sl No.DateTimeIs Completed
zzzYesNoz
r)InterviewSchedulerirrxrinterview_dateinterview_time completed)rU interviewsinterview_infor{r s r' get_interviewzCandidate.get_interview]s '..554775K &N g gN$-j$B  yHUG5"995i6N6N5OuU5i6N6N5OuUI$7$75TB*M  j (N! !r)cvtjj|j}t d||dS)Nr z$cbv/pipeline/interview_template.html)r>r1r)r-rirrr )rUr1s r'candidate_interview_viewz"Candidate.candidate_interview_viewws7&..554775K 7!%Z@  r)cT|j|jjdk(|_|jjs'|j |jj |_|j |jj jvrtdtdi|jjr"|j tdtdi|jr |jjdk(rd|_ |jrotjj|jdj}|s-tjj|jddd }||_|j rft"jj|j j%|j& j)rttd |j*rd|_d|_ t-|\|i|y)NrrzChoose valid choicezThis field is required.r"TrzCancelled CandidatesrC)rr0rr)converted_employee_idrz!Employee is uniques for candidateF)r6rrrrrrrr r1rrrirrcreater7r8rrxr convertedrrrs)rUrtrucancelled_stagervs r'rszCandidate.save~s == $11W>DJ!DM  d%f%r)c tdd|iS)z, for last send mail column z)cbv/onboarding_candidates/cand_email.htmlr>rrrTs r' last_emailzCandidate.last_emails <&  r)c tdd|iS)z* for joining date column z.cbv/onboarding_candidates/date_of_joining.htmlr>rrrTs r'date_of_joiningzCandidate.date_of_joinings A&  r)c tdd|iS)z, for probation date column z-cbv/onboarding_candidates/probation_date.htmlr>rrrTs r'probation_datezCandidate.probation_dates @&  r)c tdd|iS)z+ for offer letter column z+cbv/onboarding_candidates/offer_letter.htmlr>rrrTs r' offer_letterzCandidate.offer_letters >&  r)c^|jrdtddSdtddS)z] Returns the appropriate style and title attributes for rejected candidates. z?style="background: #ff4500a3 !important; color: white;" title="zAdded In Rejected Candidates"ztitle="zAdd To Rejected Candidates)rr1rTs r'rejected_candidate_classz"Candidate.rejected_candidate_classs>  ! ! #TUVWuUvTwwxy yQ;<=Q? ?r)c tdd|iS)z& for actions column z&cbv/onboarding_candidates/actions.htmlr>rrrTs r'actionszCandidate.actionss 9&  r)c>eZdZdZdZdZdgZedZedZ y)Candidate.Metar)rr)) view_historyzView Candidate History)archive_candidatezArchive Candidaterr8 CandidatesN) r\r]r^rarrr2r1rMr_r5r)r'r`rIs1   <~  or)r`)zr\r]r^rar1r(offer_letter_statusessource_choicesrrbr/ ImageFieldrrURLField portfoliorgrrrrrrr6rSET_NULLr7 DateTimeField schedule_date EmailFieldrr(r FileFieldr3rrhreferralrcaddresscountryrdobstatecityzipgendersourcere start_onboardrrr9 joining_daterrhistoryrr probation_endoffer_letter_statusrri last_updatedexclude_from_automationmail_to_related_fields hired_daterVrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr rrrrrrrrr!r&r(r3r5rsr<r>r@rBrErGr`rrs@r'r8r8^s& "Xq{$;gqz=RSG Qz]# 6 Qz]# Qz]# 1X;  ,-. Q()* !G*N 6  sAfI NDf+DAG3d;I&V&&..  }% N(f''.. ~& O!v   .. wZ H .F--// $z] )F((Ao,>M F  T' SE V    x[ FV    F !v  .. )z] Hf AiLSGfD1Y<G &  Dq?Q RC F  D1W: E 6  D1V9 D &  D1Z= CV   x[ FV   x[ F(F''AoDVWM F  AgJ GE"v""5q}MH###E+OI#6##An,=L"  G #v""a8H$F$$$?M*&**%,- $:VWG#6##=L481@R"!!t4%HJ $         (   *,,/ & 8  1     4 &&P        @  ..r)r8c eZdZdZej dZejdddZeje ejdde dZ eZd efd Zd Zd Zd ZGddZy) RejectReasonz RejectReason rCrnTr)rGrHrErrKrOc|jSrQrRrTs r'rVzRejectReason.__str__ rWr)c8tdd|ji}|S)rzupdate-reject-reason-viewrrrrs r'rzRejectReason.get_update_url s 6dggO r)cBtd}|j}|d|}|S)rzdelete-reject-reasonsz?id=r)rUrrej_idrs r'rzRejectReason.get_delete_urls- 78 $vh' r)c|jSrQrrTs r'get_instance_idzRejectReason.get_instance_ids wwr)c,eZdZedZedZy)RejectReason.Metaz Reject ReasonzReject ReasonsNr[r5r)r'r`rr!s)  01r)r`N)r\r]r^rarrbrSrcrdrgrrhr1rNrrirjrVrrrpr`r5r)r'rjrjs F   E#&""DSIK""".. y\ J$%G22r)rjceZdZdZej eejddZeje ddZ ejd Z ed Zed eg ZdefdZy)r z RejectedCandidate r8rejected_candidate)rLrMrz Reject reasonTrMrHrrn(candidate_id__recruitment_id__company_idr+rrrOcdj|jjdd}|jd|r|SdS)N, rSTr - z No Reason)r=rrr)rUreasonss r'rVzRejectedCandidate.__str__?sL))D11==gD=QR##$C7'LMM 'LMMr)N)r\r]r^rar OneToOneFieldr8rrr rjrrcrdrrirrrbrjrVr5r)r'r r &s(6''.. ) L .v--?$#&""c2K#HG"  GNNr)r c<eZdZejeddZdZy) StageFilesT)rwrHrGcR|jjjddS)Nr^r9)filesr/r;rTs r'rVzStageFiles.__str__Gs zz$$S)"--r)N)r\r]r^rrVrrrVr5r)r'r}r}Ds F  {$T JE.r)r}cleZdZdZej eejZeje dZ ej e ejZ ejedZej eejddZej&d Zed Zd efd ZdZy) StageNotez StageNote model rLrrT)rH)rLrGrHFrIrvr+rOc|jSrQ)rdrTs r'rVzStageNote.__str__\s""#$r)cJ|jr |jS|jSrQ) updated_byrrTs r' updated_userzStageNote.updated_user_s ???? "$$ $r)N)r\r]r^rarrgr8rhrrcr1rdrr6r r} stage_filesrrrecandidate_can_viewrrirjrVrr5r)r'rrKs%6$$Y&..IL"&""-0@AK v  &..AH(&((4@K"""FNNTJ-,,U;#HG%%%r)rc eZdZdZdedfdedfdedfded fd ed fd ed fdedfdedfdedfdedfg ZejddZeje ddZ ejdZ ejeedZejdZejeed d!Zej$dd"#Zej(d$e%Zejdd&ed'd(Zed)*Zd+efd,Zd-Zd.Zd/Zd0Zd1Zd2Z fd3Z!Gd4d5Z"xZ#S)6RecruitmentSurveyz! RecruitmentSurvey model checkboxzYes/NorChoicesmultiplezMultiple ChoicetextTextnumberNumber percentage PercentagedateDatetextareaTextareafilez File UploadrRatingFr)rGrETemplateTrurrr)rGz Job Positions)rMrJrr)r~)rEr(rzSeparate choices by ', ')rGrIrrErecruitment_ids__company_idr+rOc,t|jSrQ)rjquestionrTs r'rVzRecruitmentSurvey.__str__4==!!r)c||jdk(s|jdk(r|jrd|jdSdSy)Nrrz<
Options
rr)typerrTs r' options_colzRecruitmentSurvey.options_colsJ 99 !TYY*%<<<Ot||n\bc   r)c8tdd|ji}|S)Nz)recruitment-survey-question-template-editrrrrs r' get_edit_urlzRecruitmentSurvey.get_edit_urls  7tww  r)c8tdd|ji}|S)Nz+recruitment-survey-question-template-delete survey_idrrrs r'rz RecruitmentSurvey.get_delete_urls$ 9;PTPWPWBX  r)c|jj}dj|Dcgc] }t|c}}|Scc}wrE)recruitment_idsrr=rj)rUrrecrecruitment_strings r'recruitment_colz!RecruitmentSurvey.recruitment_colsB**..0 #[[k)Js#c()JK!!*KrHc^t|jj|jSrQ)rLquestion_typesrMrrTs r'get_question_typez#RecruitmentSurvey.get_question_types"D''(,,TYY77r)c8|jjdS)z+ Used to split the choices rx)rr;rTs r'r(zRecruitmentSurvey.choicess||!!$''r)ct||i||j\tjj dj }|r+|jj|t||i|yyy)NT)rf)rrrs template_idrBrirrr)rUrtrugeneral_templatervs r'rszRecruitmentSurvey.saves}  d%f%    #-55<<$( = eg    $$%56 d-f- $r)ceZdZdgZy)RecruitmentSurvey.MetarN)r\r]r^r2r5r)r'r`rs  r)r`)$r\r]r^rar1rrrcrr rBrre is_mandatoryrrrjob_position_idsrrrbrrrrirjrVrrrrrr(rsr`rrs@r'rrfs Qx[! AiL! Q()* 6 1X; q' 6 Qz]# =!" 1X; N vUs;H(&((ZtK'6&&u5L,f,,}%O vU+H-v--!O"4u#v""a8H 6   Df 2+F)GTWG$:WXG"""8( .  r)rceZdZdZej eejZej e ejZ ejdZ e dZy)QuestionOrderingz Survey Template model rrrrr+N)r\r]r^rarrgrrh question_idrrrrrrir5r)r'rrsW$&##$5PK&V&&{fnnMN"v""1-H#:WXGr)rc^eZdZdZej eejZej e eje ddZ ej e eje ddZejZej"eddZed Zed Zd efd Zy )RecruitmentSurveyAnswerz! RecruitmentSurveyAnswer rrT)rLrMrGr)rwrGrHr*r+cx tj|jS#tj$ricYSwxYw)z2 Used to convert the json to dict )jsonloads answer_jsonJSONDecodeErrorrTs r'answerzRecruitmentSurveyAnswer.answers6  ::d../ /## I s !99rOcL|jjd|jS)Nr\)rr/rrTs r'rVzRecruitmentSurveyAnswer.__str__s'##(()4+>+>*?@@r)N)r\r]r^rarrgr8rhrrrr1rrr JSONFieldrrVr attachmentrripropertyrrjrVr5r)r'rrs%6$$Y&..IL&V&&..}%  N (f''..~&  O #&""$K!!!Kd$OJ#:VWG AAr)rc eZdZdZej ddZejeddZ eje ddejed  Z eZGd d Zd ZdefdZdZdZdZy) SkillZonez! " Model for talent pool rC Skill Zoner&rr)rMrETr)rGrHrLrMc,eZdZedZedZy)SkillZone.Metarz Skill ZonesNr[r5r)r'r`r s  .r)r`cDtjjd|S)NT)r7 skill_zone_id)SkillZoneCandidaterirrTs r' get_activezSkillZone.get_active s!))004t0TTr)rOc|jSrQrRrTs r'rVzSkillZone.__str__rWr)c&d|jd}|SrrRrs r'rzSkillZone.get_avatarrr)c|jj}|dk7r|dtdS|dtdS)Nr+r:rLr8)skillzonecandidate_setrr1)rUrs r'candidate_count_displayz!SkillZone.candidate_count_displaysI++113 A:WAq01 1WAq~/0 0r)cTtd}td|ji}|d|S)z] This method returns the skill zone URL with the title as a query parameter. zskill-zone-viewsearchr)rrrS)rUr query_strings r'rzSkillZone.get_skill_zone_url!s3,- (DJJ!78 1\N++r)N)r\r]r^rarrbrSrcr1rdrgrrhrNrrir`rrjrVrrrr5r)r'rrs F   FE"&""-0@SQK""" ..y\ J$%G//U1,r)rc 6eZdZdZej eeddejdZ ej e ejddedZ ejded  Z ejd Zed ZfdZdefdZxZS)rzB Model for saving candidate data's for future recruitment rrT)rMrrLrGr8ryrxReasonr&) auto_now_addrvr+c >tjj|j|jj |j j}|r/ttd|jd|jdt|-y)N)rrrz Candidate z already exists in Skill Zone r8) rrirrrrrrr r1rrr)rUduplicate_existsrvs r'rzSkillZoneCandidate.cleanKs  & & - -!..d>P>P . WW VX  ! !2!2 33QRVRdRdQeefg   r)rOcHt|jjSrQ)rjrrrTs r'rVzSkillZoneCandidate.__str__^s4$$22455r))r\r]r^rarrgrr1rrr8rrbreasonradded_onrrirrjrVrrs@r'rr*s&F%%|_-..  M%6$$.. -{^ LV  1X; GFvT2H#HG&66r)rceZdZejeej dZejeej dZ eje de dgZ GddZdefd Zy ) CandidateRatingcandidate_ratingrLrr)rceZdZddgZy)CandidateRating.Meta employee_idrN)r\r]r^rr5r)r'r`rms (.9r)r`rOcR|jd|jd|jS)Nryz rating )rrrrTs r'rVzCandidateRating.__str__ps+""#3t'8'8&9$++OOr)N)r\r]r^rrgrrrr8rrr r rr`rjrVr5r)r'rrbs#&##FNN9KK%6$$V^^:LL!V %a(*;A*>?F::PPr)rceZdZdZej dZej dZeje ejdZ y)RecruitmentGeneralSettingz* RecruitmentGeneralSettings model FrTrLrGN) r\r]r^rarrecandidate_self_trackingshow_overall_ratingrgrrhrNr5r)r'rrtsI2f11%@-&--e<"""7fnn4PJr)rceZdZdZej eeddejZ eje edZ ejedZejedZej"ed d Zej&d ed ZedZdefdZdZdZdZdZdZdZdZdZ dZ!dZ"GddZ#y)r-z$ Interview Scheduling Model r8candidate_interview)rMrrL InterviewerrzInterview DatezInterview TimerTruFzIs Interview CompletedrrvrOc |jdS)Nz -Interview.r rTs r'rVzInterviewSchedule.__str__s##$L11r)c tdd|iS)z. method for candidate coloumn z'cbv/interview/candidate_custom_col.htmlr>rrrTs r'candidate_custom_colz&InterviewSchedule.candidate_custom_cols:&  r)c tdd|iS)z0 method for interviewer coloumn z)cbv/interview/interviewer_custom_col.htmlr>rrrTs r'interviewer_custom_colz(InterviewSchedule.interviewer_custom_cols<&  r)cttdd}t|dds||_|j}|j|j j vrd}d}d|d|d|dSy) zH Custom background color for all rows with hover effect rNzrgba(255, 166, 0, 0.158)whitezstyle="background-color: z,;" onmouseover="this.style.backgroundColor='z,';" onmouseout="this.style.backgroundColor='z';")rrruser employee_getrr)rUrrcolorhoverings r' custom_colorzInterviewSchedule.custom_colors.)T:tY-"DL||    0 0 4 4 6 6.EH,E73==EJG<rrrTs r'custom_action_colz#InterviewSchedule.custom_action_cols7&  r)c8tdd|ji}|S)z! for detail view zinterview-detail-viewrrrrs r' detail_viewzInterviewSchedule.detail_views -tTWWoF r)c tdd|iS)z% detail view actions z&cbv/interview/detail_view_actions.htmlr>rrrTs r'detail_view_actionsz%InterviewSchedule.detail_view_actionss9&  r)c,eZdZedZedZy)InterviewSchedule.MetazSchedule InterviewzSchedule InterviewsNr[r5r)r'r`rs-.  56r)r`N)$r\r]r^rarrgr8r1rhrr rrrr. TimeFieldr/rcrdrer0rrirjrVrrrrrrrrr r r`r5r)r'r-r-~s %6$${^*.. L )&((-@PQK%V%%15E3FGN%V%%15E3FGN"&""}%K$##A&>$?I$$NOG22  *%    77r)r-ceZdZejeegZeje ejdZ ejdZ dZy)ResumerrrFrc8|jd|jS)Nz - Resume )rrrTs r'rVzResume.__str__ s%%&j ::r)N)r\r]r^rrVrr3rrgrrhrre is_candidaterVr5r)r'rrsW 6     D 'V&&v~~HN'6&&u5L;r)r)) requested Requested)approvedApproved)rorp))anyAny)pdfPDF)txtTXT)docxDOCX)xlsxXLSX)jpgJPG)pngPNG)jpegJPEGceZdZejdZej eZeje dZ ejddZ ejdddZed Zd Zy ) CandidateDocumentRequestrmrnr)r(rET)rHrGrrHrGrE+employee_id__employee_work_info__company_idr+c|jSrQrRrTs r'rVz CandidateDocumentRequest.__str__-rWr)N)r\r]r^rrbrSr r8rFORMATSformatrmax_sizercrdrrirVr5r)r'r)r)#sv F   ,E)6)))4L V  g" =F"v""D9H"&""DSIK#KGr)r)cBeZdZejdZej eejdZ ej e ejdZ eje dZejedd Zej"ddd Zd ZfdZxZS)CandidateDocumentrnr8)rLrMTrrvrr)r(rErIrr*c8|jd|jS)Nry)rrSrTs r'rVzCandidateDocument.__str__=s##$C |44r)c"t||i||j}t|jdkrt dt di|r|jr|jj}|jj}|r+|j|dzdzkDrt dt di|jjddj}|d k(ry||k7r%t dt d j|iyyy) NrSz#Title must be at least 3 charactersidocumentzFile size exceeds the limitr8r+rzPlease upload {} file only.)rrrr6r rSr r1document_request_idr.r/sizer/r;r0)rUrtrurr.r/r2rvs r'rzCandidateDocument.clean@s  t&v&}} tzz?Q !7A.S,T"UV V D,,--44F//88H99x$55)#Q'D%EF))//#&q)//1C%#@!A!H!H!PQ-4r))r\r]r^rrbrSrgr8rrr)r7rVrr6STATUSstatusrc reject_reasonrVrrrs@r'r1r11s F   ,E$6$$V^^+L,&++ FNN v+DAH V  f[ QF$F$$4dsKM5r)r1cTeZdZejdedZejdedZejdedZ ejdd Z eje ejded  ZGd d ZdZfdZdZdZxZS)LinkedInAccountr2zApp Namer&r|r}iz API TokenTrDrrzc,eZdZedZedZy)LinkedInAccount.MetarzLinkedIn AccountsNr[r5r)r'r`r?bs+,  34r)r`c,t|jSrQ)rjusernamerTs r'rVzLinkedInAccount.__str__frr)c^t||i|d}dd|ji}tj||}|j dk(rQ|j }|d|jk(stdtdi|j d|_ yttd ) Nz$https://api.linkedin.com/v2/userinfo AuthorizationzBearer )headersrxrzEmail mismatched.subzCheck the credentials) rrr api_tokenrequestsrM status_coderrr r1sub_id)rUrtrurrDresponsedatarvs r'rzLinkedInAccount.cleanis  t&v&4"gdnn-=$>?<<W5   3 &==?D=DJJ.%w2E0F&GHH"--/%0DK!!$;"<= =r)c tdd|iS)rzlinkedin/linkedin_action.htmlr>rrrTs r'action_templatezLinkedInAccount.action_templatexs0&  r)c@d|j}td||dS)z, For toggle is_active field z!update-isactive-linkedin-account/zis_active_toggle.html)r>rr)rxr rs r'is_active_togglez LinkedInAccount.is_active_toggles,2$'';(!%c2  r))r\r]r^rrbr1rArUrrFrIrgrrhrNr`rVrrMrOrrs@r'r=r=Ysv3Qz]KH F  1W: FE   Ca nMI V  T :F"""6>>1Y<J55" >  r)r=)Vrarr,r#rr urllib.parseruuidrrrGr django.confrdjango.contrib.auth.modelsr django.core.exceptionsr django.core.files.storager django.core.validatorsr r django.dbr django.urlsrr django.utilsrdjango.utils.htmlrdjango.utils.textrdjango.utils.translationrr1base.horilla_company_managerrr%rremployee.modelsrhorilla.horilla_middlewaresrhorilla.modelsrrhorilla_audit.methodsrhorilla_audit.modelsrrhorilla_views.cbv_methodsr r(r3r6r@rBrlrrrbr8rjr r}rrrrrrrrr-Modelrr9r-r)r1r=r5r)r'res '"  +25G-')%6>,$64*B5  "8: 4\42/*L/*dY,YxYXLYXx8W . W .t+2<+2\N N<..% %6` ` FY|Y"Al"AJ., .,b5656pPlP$Q Q@7 @7F ;V\\ ;    | % %P0 l0 r)