hi<dZddlZddlmZmZmZmZddlmZddl m Z m Z m Z m Z ddlmZddlmZddlmZmZej(eZGd d ZeZy) z- Service de recherche et matching de profils N)ListDictOptionalTuple)Session)or_and_funcString)datetime)User)ProfileSearchRequestProfileMatchScorec eZdZdZdededeeee ffdZ de dedefdZ de fdZd ed ed ee d edeeee ff d Zde fdZd ed ededeeee ee ffdZd ed ededefdZdeedee fdZde de fdZy)ProfileSearchServicez.Service pour rechercher et matcher des profilsdbcriteriareturnc |jtjtjdk(}|jr<|jtjj d|jd}|j }tjdt|dg}|D];} |j||}|d|jk\r|j||d=|j!d d t|} ||j"|j"|j$z} tjd | d t| d| | fS#t$r/}tjd|jd|Yd }~d }~wwxYw#t$r }tjd|dd }~wwxYw)u Recherche des profils selon les critères Retourne: (liste de profils avec scores, nombre total) T%u🔍 Recherche sur z profils overall_score)user match_scoreu❌ Erreur scoring profil z: Nc|ddS)Nrr)xs K/home/www/therecruiter.miabetepe.com/app/services/profile_search_service.pyz6ProfileSearchService.search_profiles..@sa .?)keyreverseu✅ u profils trouvés, u retournésu❌ Erreur recherche profils: )exc_info)queryr filterregistration_completedlocationilikeallloggerinfolencalculate_match_scorematch_thresholdappend Exceptionerroridsortoffsetlimit) selfrrr# all_usersscored_profilesr score_dataetotal paginateds rsearch_profilesz$ProfileSearchService.search_profiless2 HHTN))++t3E    MM''!H,=,=+>a(@A  I KK-c)n-=XF G!O!  !%!;!;D(!KJ"/2h6N6NN'..$(+50   ? !  (E((..8XYI KK$ug%8Y8H T Ue# ##!LL#=dggYb!LM&  LL9!=L M  sCB6F98E!1A/F! F*%FFFF G%GGrcdddggdd}dddd}|jxsi}|jdi}|jxsi}|jd i}|jr2|j |||j|j \|d <|d <nd |d <|j s$|js|js |jr!|j|||\|d <|d<|d<nd |d <|js |jr|j||||d<nd |d<|d |d z|d |d zz|d|dzz} t| dt|d dt|d dt|dd|d |d|ddS)u Calcule le score de matching pour un utilisateur Retourne un dict avec les scores détaillés N)skills experience educationmatched_skillsmatched_companiestotal_years_experienceg?gffffff?g?)r?r@rAparsed_content scraped_datar?rB?r@rCrDrA)r skills_scoreexperience_scoreeducation_scorerBrCrD)cv_datagetlinkedin_profiler? _score_skillsmatch_all_skillsmin_years_experiencemax_years_experience companies positions_score_experienceeducation_degreeseducation_institutions_score_educationround) r5rrscoresweightsrL parsed_cv linkedin_datascraped_linkedinrs rr,z*ProfileSearchService.calculate_match_scoreQs !#&*   ,,$"KK 0"5 --3 (,,^R@ ??9=9K9K )) : 6F8 f%56 #F8   ( (H,I,IXM_M_ckcucubfbxbx c _F< &)<"=vF^?_ $'F<   % %)H)H"&"7"7 #F;  #&F;  8 wx0 0 < 7<#8 8 9 ; '+"6 6 7 #=!4!&"2A6 %f\&:A >$VK%8!<$%56!'(;!<&,-E&F  rct|tr_t|jddxs&|jddxs|jddj j St|tr|j j St|j j S)u2Normalise une compétence (peut être str ou dict)nameskilltitle) isinstancedictstrrMlowerstrip)r5rbs r_normalize_skillz%ProfileSearchService._normalize_skills eT "uyy,` '20F`%))T[]_J`aggiooq q s #;;=&&( (u:##%++- -rr\r^required_skills match_allc |jdg}|jdg}|Dcgc]}|s|j|}}|Dcgc]}|s|j|} }|Dcgc]}|s| }}| Dcgc]}|s| } }t|| z} |Dcgc] }|jj "} }g} | D]$} | D]}| |vs|| vs | j | $&t t| } |r|rt| t|z nd}n| rdnd}|| fScc}wcc}wcc}wcc}wcc}w#t$r&}tjd|dgfcYd}~Sd}~wwxYw)uScore les compétencesr?r>rGu❌ Erreur _score_skills: N) rMrisetrgrhr.listr+r/r)r0)r5r\r^rjrk cv_skills_rawlinkedin_skills_raws cv_skillslinkedin_skills all_skillsrequired_skills_lowermatched req_skill user_skillscorer9s rrOz"ProfileSearchService._score_skillss' %MM(B7M"2"6"6x"D  !;OZ4? %Q*  LL5aS9 :7N s|(ED,D,E D1D1&E,D64D68E>D;D; E%EEAE,E E4E/)E4/E4c|yt|tr>dD]8}||vs||st||jj cSyt|jj S)u*Normalise un texte (gère str, dict, None)ra) r`rccompany companyNamepositiondegree institutionschool schoolName)rdrerfrgrh)r5textr s r_normalize_textz$ProfileSearchService._normalize_textso < dD ! :$;49tCy>//17799 :4y &&((rc   d}g}|jdg}|jdg}||z}|j|} g} |j |j|jxsd} |jxsd} | f| | cxkr| krnn| j dnW| | kr/| j t dd| | z t | dz z n#| j dn| j d|j r|j D cgc] } | jj"}} |D]}|j|jd xs|jd s9tfd |DsN|j |jd xs|jd d |j r!t|t|j z nd}| j ||jr|jDcgc] }|jj"}}d }|D]P}|j|jdxs|jds9tfd|DsNd}n| j |rdnd| rt| t| z nd}||| fScc} wcc}w#t$r'}tj!d|dgdfcYd}~Sd}~wwxYw)u#Score l'expérience professionneller>r@NrdrGg?r{r|c32K|]}|vxs|vywNr).0targetr{s r z9ProfileSearchService._score_experience..s$&lRXv'8'MGv.s$'oU[((:(Ph&>P(P'orTu❌ Erreur _score_experience: )rM_calculate_total_experiencerQrRr.maxrSrgrhranyr+rTsumr/r)r0)r5r\r^rryrCcv_exp linkedin_expall_exp total_years sub_scores min_years max_yearsccompanies_lowerexp company_scoreppositions_lowerposition_matchr9r{r}s @@rrUz&ProfileSearchService._score_experiences= !E " ]]<4F+// bAL|+G::7CKJ,,8HQ $99@S * K<9<"))#.'2&--c#si+>UY\]fhiYj=j7j.kl&--c2%%c*!!>F>P>P"Q1779??#4"Q"Q"cC"2237793E3_Q^I_`G3&l\k&l#l)001C1asww}^`Gabc U]TfTf$5 6X=O=O9P Plo !!-0!!>F>P>P"Q1779??#4"Q"Q!&"C#33CGGJ4G4[377SZK[\HC'o_n'o$o)-  !!#SA:DC Oc*o5E+[8 81#R#R ! LL9!= >D=  !sUD K%K 4K:K9K K LK>8L>Lc |jdg}|jdg}||z}g}|jr|jDcgc] }|jj"} }d} |D]P} |j | jdxs| jds9t fd| DsNd} n|j | rdnd|jr|jD cgc] } | jj"} } d}|D]c} |j | jd xs$| jd xs| jd sLt fd | Dsad}n|j |rdnd|rt|t|z }|Sd}|Scc}wcc} w#t$r"}tjd |Yd}~yd}~wwxYw)zScore la formationrAFr~ degreeNamec32K|]}|vxs|vywrr)rrr~s rrz8ProfileSearchService._score_education..As#%gvf&6&J&F:J&J%grTrGr>rrrc32K|]}|vxs|vywrr)rrrs rrz8ProfileSearchService._score_education..Ms%*{^d6[+@+YKSYDY+Y*{ru❌ Erreur _score_education: N) rMrVrgrhrrr.rWrr+r/r)r0)r5r\r^rcv_edu linkedin_eduall_edurd degrees_lower degree_matcheduiinstitutions_lowerinstitution_matchryr9r~rs @@rrXz%ProfileSearchService._score_education-s$ ]];3F+// R@L|+GJ))G-G4G6%GAG-G4G7G; G G0G++G0 experiencesc|syd}|D]3}t|jdd}|j|}||z }5|dkDr|SdS)u/Calcule le nombre total d'années d'expérienceNrdurationra)rfrM_parse_duration)r5rrr duration_stryearss rrz0ProfileSearchService._calculate_total_experienceZs`  !Cswwz267L((6E 5 K  !*Ao{747rrc< tjj}|jdt |}|jdt |}|jdt |}ddl}|j d|}t|dk\r+t|d}t|d}td||z St|d k(rt|d}td||z S y#t$r%}tjd |d |Yd}~yd}~wwxYw) u0Parse une durée et retourne le nombre d'annéesPresentpresentuPrésentrNz\d{4}ru⚠️ Erreur parsing durée 'z': ) r utcnowyearreplacerfrefindallr+intrr/r)warning)r5r current_yearrrstartendr9s rrz$ProfileSearchService._parse_durationis S#??,11L'// 3|;LML'// 3|;LML'// C rsQ.."..?   8 $qqj ./r