o |^j @sdZddlmZddlZddlmZmZmZdZd&d d Z d'd dZ d(ddZ d(ddZ d)ddZ d*ddZd(ddZd+dd Zd!d"d,d$d%ZdS)-z6Shared Mcube phone validation helpers (Classic + 2.0).) annotationsN)AnyDictOptionalz^[+]?[0-9]{6,}$exprstrreturnc Cs*d|d}d|d|dtd|d S)zDSQL expression: return trimmed phone only when 6+ digits, else NULL.z TRIM(CAST(z AS CHAR))z CASE WHEN z IS NOT NULL AND z REGEXP 'z' THEN z ELSE NULL END)VALID_PHONE_SQL_PATTERN)rtrimmedr ;/home/aiteam/pcaa-dev/dashboard-backend/mcube_phone_util.pyvalid_phone_sql s r valuercCsdddt|p dDS)Ncss|] }|r|VqdS)N)isdigit).0chr r r szphone_digits..)joinrrr r r phone_digitssrboolcCstt|dkS)N)lenrrr r r is_plausible_phonesrcCs,t|pd}t|o|ot|dkS)zETrue when value looks like a Mcube eid/extension, not a display name.rr)rstriprrr)rtextr r r is_numeric_agent_tokensr agent_nameagent_callinfocCs8t|pd}t|p d}|r|St|rdS|S)zNDrop bare numeric agent ids from agent_callinfo when no agent name is present.r)rrr)rrnameliner r r sanitize_agent_callinfo"sr"callidcCs$t|}t|dkr dS|ddS)N r)rr)r#digitsr r r phone_from_callid-s  r&cCs8t|}t|dkr dS|drdS|drdSdS)zJTrue for toll-free / virtual numbers that must not be used as lead phones.r$F080T1800)rr startswith)rr%r r r is_likely_trunk_did4s   r*rowDict[str, Any]cCspt|dp |dp d}t|rt|s|St|dp!d}t|dp.d}t|dp9d}t|d}d}|d kr\t|rQ|}n.tt|d kr[|}n#t|rgt |sg|}nt|rrt|sr|}n t|ry|}nt|r|}|s||fD]}|rt|rt|s|}nq|rt|rt|s|rt|r|S|rt|rt|r|SdS|S) a Resolve customer phone from a Mcube source/raw row. Mcube Classic inbound: callfrom is usually the customer. Mcube 2.0 inbound: callfrom is often an agent extension (e.g. 421) and callto holds the customer number. clicktocalldid is a virtual DID / click-to-call bridge number. It must not be used as the customer phone or unrelated outbound calls collapse under one lead. customer_callinfocustomer_phoner directioninboundcalltocallfromr#outboundr$) rgetrrr*lowerr&rrr)r+explicitr/r1r2 callid_phoneresolvedrr r r pick_mcube_customer_phone@sD    r9r)defaultr:cCstdD]}t||p d}t|r|Sqt|}t|r"|SdD]}t||p-d}|r7|Sq$|S)z0Best-effort customer phone for display/backfill.) lead_phoner)r-r.r;)rr4rrr9)r+r:keyrr8r r r resolve_customer_phonetsr=)rrrr)rrrr)rrrr)rrrrrr)r#rrr)r+r,rr)r+r,r:rrr)__doc__ __future__rretypingrrrr r rrrr"r&r*r9r=r r r r s       7