si*ldZddlZddlmZddlmZddlmZddlm Z ddl m Z ddl mZmZdd lmZdd lmZdd lmZdd lmZmZmZmZd ZeeddZeeddZeeddZeeddZdZ eeddZ!y)zD dashboard.py This module is used to write dashboard related views N) serializers)Q) JsonResponse)render) gettext_lazy) Department JobPosition)EmployeeWorkInformation)login_required)manager_can_enter) Candidate Recruitment SkillZoneStagecd}|jj|D]*}|t|jjdz},|S)zH This method is used find the count of candidate in recruitment r) stage_typeT is_active) stage_setfilterlen candidate_set)recrcandidates_count stage_objs ?/var/www/python-projects/worksol/recruitment/views/dashboard.pystage_type_candidate_countrs\]]))Z)@ +c  # # * *T * :/    zrecruitment.view_recruitment)permc d tjj}d}tjj dd}|j rd}nd}t jj}g}|D]#}|jdk7s|jd%|gk7rd}nd}tjj} g} | D]} | j} | j| !g} | D]B} tjj | d}| j|jDg}| D]B} tjj | d }|j|jDg}| D]B} tjj | d }|j|jDg}| D]B} tjj | d }|j|jDg}| D]B} tjj | d }|j|jDtt| | ||||}tjj d }t|}|D]@}tj Dcgc]}t#||d}}|D]}||z } |dk\s?d}Btjj d}|j}i}|D]U}|j$} g}!|j&jD]#}"|"j)}#|!j|#%|!|| <Wd}$|D]!}%|%j*dk(r|$|%j*z }$#|j t-dt-d zj/}&t|}'t|&}(d})d}*d}+d},|'dk7r |(|'z dzd})|$dk7r|(|$z dzd}*|'|$z dzd}+|(dk7r ||(z dzd},t0jj d}-t3|did|d|+d|(d|)d|,d|&j dd|d|$d |d!|*d"|d#|d$|d%|&j djd&|'d'|-Scc}w)(zH This method is used to render dashboard for recruitment module rFclosedis_event_basedNOKinitial)job_position_idstage_id__stage_typetest interviewhired cancelledr"acceptedoffer_letter_statusT)r+)r(dz.1frzdashboard/dashboard.htmlongoing_recruitmentstotal_candidate_ratiototal_hired_candidatesconversion_ratioacceptance_ratioonboard_candidates)onboarding_stage__isnulljob_data total_vacancyrecruitment_manager_mapping hired_ratiojoining dep_vacancystage_chart_countonboarding_counttotal_candidates skill_zone)r objectsallrrexistsr date_joiningappendr job_positioncountlistziprr stage_typesrtitlerecruitment_managers get_full_namevacancyrdistinctrr).request candidatesr? vacancy_chartr> employee_info joining_listrr=jobsall_jobjobjobposr&inir)tesr*interr+hirer,cancelled_candidatesr9recruitment_objr2typedatair.accepted_countr;recruitment_titlemanagersmanagernamer:openingshired_candidatesrAr4r5r<r3r6rBs. r dashboardrk"s ""&&(J''..eE.RM  +33779ML&   t #    %&r    " " $DG!!vG$&&i'  syy{# $ D!&&sQW&X CIIK !I(!!((k)  ' ( E#  ''g(   TZZ\" # I7(0077k 8  -3356 7 C$ 5)LMH!))000>O/"EJEVEVWT*3Q8WW #A  "  #  ! !  "  ''J'GH^^%N"$BII//335 "G((*D OOD ! ":B#$56BM#.   t #  X-- -M . "((  w77hj: !12K1 69I ISPRUV1MASH#N %5 %E$Lc"R" .1G G3NPST""))D)9J " "$8 #%:  %&<   0   0  !"2"9"9).#:#     ]  *+F  ;  w  ;  !2  0 7 7).!8!eg% &  0' ( *)  _Xs5R-c tjjd}g}tjDcgc]}|d }}|D]}tjDcgc]}t ||d}}|j jsH|j|j |jn|jd|j|dt||tddScc}wcc}w) zL This method is used generate recruitment dataset for the dashboard Fr-r$rz labelrbz#No records available at the moment.)dataSetlabelsmessage)rrCrrrLr candidaterDrGrMr' start_dater_)rRr`data_setrarprrbs rdashboard_pipelinervs "))000>OH"'"3"3 4$d1g 4F 4 EJEVEVWT*3Q8WW ==    OO990 "%"5"5!67^^$(!   >?  5Ws C,C1cb|jjd}tjj |}dgdz}|D]M}t |j tjs(|j jdz }||xxdz cc<Otdtdtdtd td td td td tdtdtdtdg }tdd|iz|ddg}t||dS)zP This method is used generate employee joining status for the dashboard id)date_joining__yearr r$JanuaryFebruaryMarchAprilMayJuneJulyAugust SeptemberOctoberNovemberDecemberzEmployees joined in %(year)syearzrgba(236, 131, 25))rnrbbackgroundColorrorp) GETgetr rCr isinstancerFdatetimedatemonthrtr)rR selected_yearrUemployee_count_per_monthinfo month_indexrprus rdashboard_hiringrs+KKOOD)M+33::(;M !"sRx d'' 7++11A5K $    )  *  '  '  % &  &  (  + )  *  *  F"56&-9PP,3 H H? @@rctjjdd}tjj }g}t dgdg}|D]}|j|}|D]*}|j |j|j,|Dcgc]%}|j t|j nd'}}|ddjt|gt||dScc}w) zW This method is used to generate a recruitment vacancy chart for the dashboard Fr!Openingsrm)job_position_id__department_idrrbr) rrCrrrDrtrPrG departmentintsumr) _requestr`rrnrudepvacancies_for_departmentr vacanciess rdashboard_vacancyrs "))00e0TO##'')J EJ-45H 5#2#9#9+.$:$  , -C{{& S^^, - 0 !$ 7C Q >   F""C N#34 5 H> ?? s*C8c |jd}tjj|}|jj }t jd|}t jd|g}t||dS)z This is an ajax method to render the open position to the recruitment Returns: obj: it returns the list of job positions recId)rxjson) openPositionsrecruitmentInfo) rrrCropen_positionsrDr serializer)rRrec_idr`querysetjob_inforec_infos rget_open_positionr sv[[ !F!))---8O--113H$$VX6H$$Vo->?H (xP QQrcjtjjdj}tjjdj}tjjdj}tjjdj}tjjdj}g}gd}|||||g}t t |D]} |j || || dt||d S) zT This method is used to generate a CAndidate status chart for the dashboard not_sentr/sentr.rejectedjoined)zNot SentSentAcceptedRejectedJoinedrmr)r rCrrIrangerrGr) rnot_sent_candidatessent_candidatesaccepted_candidatesrejected_candidatesjoined_candidatesrurprbrcs rcandidate_statusr/s,$++22&3 eg ''..6.JPPRO#++22&3 eg$++22&3 eg"))00X0NTTVH CF  D3t9 ?&)T!W=>? H? @@r)"__doc__r django.corerdjango.db.modelsr django.httprdjango.shortcutsrdjango.utils.translationrrt base.modelsrr employee.modelsr horilla.decoratorsr recruitment.decoratorsr recruitment.modelsr rrrrrkrvrrrrrrrs #$#6/3-4GG 67I8IX678<67-A8-A`67@8@8 R67)A8)Ar