vg)`dZddlZddlmZddlmZddlmZddlm Z ddl m Z m Z ddlmZdd lmZdd lmZdd lmZmZmZmZd Zeed dZeed dZeed dZeed dZdZeed dZy)zD dashboard.py This module is used to write dashboard related views N) serializers) 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/horilla/recruitment/views/dashboard.pystage_type_candidate_countrs\]]))Z)@ +c  # # * *T * :/    zrecruitment.view_recruitment)permc 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 d}%t|}&t|%}'d}(d})d}*d}+|&dk7r |'|&z dzd}(|#dk7r|'|#z dzd})|&|#z dzd}*|'dk7r ||'z dzd}+t,jj d},t/|did|d|*d|'d|(d|+d|%j dd|d|#d|d|)d|d |d!|d"|d#|&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!T) start_onboard)r*dz.1frzdashboard/dashboard.htmlongoing_recruitmentstotal_candidate_ratiototal_hired_candidatesconversion_ratioacceptance_ratioonboard_candidatesjob_data total_vacancyrecruitment_manager_mapping hired_ratiojoining dep_vacancystage_chart_countonboarding_counttotal_candidates skill_zone)r objectsallr rexistsr date_joiningappendr job_positioncountlistziprr stage_typesrtitlerecruitment_managers get_full_namevacancyrr)-request candidatesr; vacancy_chartr: employee_info joining_listrr9jobsall_jobjobjobposr%inir(tesr)interr*hirer+cancelled_candidatesr5recruitment_objr/typedatair<r7recruitment_titlemanagersmanagernamer6openingshired_candidatesr=r1r2r8r0r3r>s- r dashboardre!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  "  #  ! !  "!((//d/C'--/"$BII//335 "G((*D OOD ! ":B#$56BM#.   t #  X-- -M . "((t(4: !12K1 69I ISPRUV1MASH#N %5 %E$Lc"R" 03I ISPRUV""))D)9J " "$8 #%:  %&<   0   0  !"2"9"9"9"M     ]  *+F  ;  w  ;  !2   0   0 *!  [Xs5Q+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 labelr]z#No records available at the moment.)dataSetlabelsmessage)r r?rrrHr candidater@rCrIr& start_dater_)rMr[data_setr\rjrr]s rdashboard_pipelinerps "))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))rhr]backgroundColorrirj) GETgetr r?r isinstancerBdatetimedatemonthrnr)rM selected_yearrPemployee_count_per_monthinfo month_indexrjros 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 Openingsrg)job_position_id__department_idrr]r) r r?rrr@rnrLrC departmentintsumr) _requestr[rrhrodepvacancies_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)rrjson) openPositionsrecruitmentInfo) rr r?ropen_positionsr@r serializer)rMrec_idr[querysetjob_inforec_infos rget_open_positionrsv[[ !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_sent)offer_letter_statussentacceptedrejectedjoined)zNot SentSentAcceptedRejectedJoinedrgr)r r?rrErangerrCr) rnot_sent_candidatessent_candidatesaccepted_candidatesrejected_candidatesjoined_candidatesrorjr]r^s rcandidate_statusr(s,$++22&3 eg ''..6.JPPRO#++22&3 eg$++22&3 eg"))00X0NTTVH CF  D3t9 ?&)T!W=>? H? @@r) __doc__r django.corer django.httprdjango.shortcutsrdjango.utils.translationrrn base.modelsrremployee.modelsr horilla.decoratorsr recruitment.decoratorsr recruitment.modelsr r rrrrerprrrrrrrs #$#6/3-4GG 67C8CL678<67-A8-A`67@8@8 R67)A8)Ar