IBjT ddlmZmZmZddlmZddlZddlmZddl m Z ddl m Z eddg Z d d d d ddddddddd Zdddddddddd d!d"d# Zd$ed%ed&efd'Zd(ZdBd)Zd*Zd+Zd,Zd-Zd.Zd/Zd0Zd1Zd2ZdCd3Zd4Zd5Z d6Z!d7Z"d8Z#dCd9Z$d:Z%d;Z&d<Z'd=Z(d>efd?Z)e jUd@ee fdAZ+y)D) APIRouterDepends HTTPException)datetimeN)get_db_connection)get_current_user)calculate_planetsz/userzUser Horoscope)prefixtagsu♈u♉u♊u♋u♌u♍u♎u♏u♐u♑u♒u♓) AriesTaurusGeminiCancerLeoVirgoLibraScorpio Sagittarius CapricornAquariusPiscesJanuaryFebruaryMarchAprilMayJuneJulyAugust SeptemberOctoberNovemberDecember  hourminuteampmct|}t|}|r|jjnd}|dk(r|dk(rd}|dk(r |dk7r|dz }||fS)NPMAMr0r)intupperstrip)r1r2r3hm ampm_uppers ?/var/www/html/Astrologybackend/backend/user_horoscope_router.pyconvert_to_24_hourr>+s_ D A F A)-##%4JTa2g Ta2g R a4Kc||dk(ryt|ttfr t|St|j }dddddd}||vr||S t|S#t $rt d|dYywxYw)Ng@g)z Asia/Kolkataz Asia/CalcuttaISTUTCzEtc/UTCzInvalid timezone value 'z', using default 5.5) isinstancer7floatstrr9 Exceptionprint)timezone_value timezone_text timezone_maps r=normalize_timezonerL9s2!5.3,/^$$'--/M L $M**]##  ((88LMNs A A;:A;c< t|S#t$r|cYSwxYwN)r7rG)valuedefaults r=safe_intrQTs%5z s ct|dzS)Nh)rE)rOs r=normalize_degreerT[s <# r?ct|}t|}t|}||kr||cxkxr|kScS||k\xs||kSrN)rT) planet_lon start_cuspend_cusps r=longitude_in_houserY_sS!*-J!*-J)HXZ2(2222  # zlKn or?c|j|i}|jd}||jdSt||}|xs|jdS)N longituders)rrr_)transit_planets planet_name natal_cuspsplanetrrss r= planet_housersW  b 1F ;'Izz'"" K 8E  'FJJw''r?c Rtdtdtt|S)N_)maxminr7roundscores r= clamp_scorers r3r3uU|,- ..r?c<|xsg}t|d}||vry||vryy)Nrr-r)rQ)rs good_houses medium_housess r=score_by_house_focusrs1!'RM UA E   r?c,|jdi}t|d|}t|d|}t|d|}d}|t|gdddgz }|t|gdd dgz }|t|gdd dgz }t|d d vr|d z }t |S)Nplanetsvenusmarsmoon7)r)r+r,r%r/r'r(r)r)r+r)rrrrrQr)transitrr venus_house mars_houser~rs r=calculate_love_scorerskk)R0OEKov{CJov{CJ E !+y1b' BBE !*i!R AAE !*i!R AAE Q6)   u r?c|jdi}t|d|}t|d|}t|d|}t|d|}t|d|}d}|t|gdd d gz }|t|gdd d gz }|t|gdd d gz }|t|gdd d gz }|t|gdd d gz }t|ddvr|dz }t |S)Nrsunmercuryrjupitersaturn4)r&r*r.r'r/r-r%r,rr)r) rrr sun_house mercury_houser jupiter_house saturn_housers r=calculate_career_scorerskk)R0O_e[AI )[IMov{CJ )[IM;GL E !)Z!R AAE !-aV DDE !*j1a& AAE !-aW EEE !, QF CCE q!Z/   u r?cL|jdi}t|d|}t|d|}t|d|}d}|t|gddgz }|t|dd gd gz }|t|d d gdgz }t|d d vr|d z}t|d d vr|d z}t |S)Nrrrr:)r%r*r0r(r%r*r'r0r)r*r0r)rrrr~rrrs r=calculate_health_scorer skk)R0Oov{CJov{CJ;GL E !*j1# >>E !*q!fqc ::E !,B! ==E A')   a G+   u r?c*t||z|zdz S)Nr')r) love_score career_score health_scores r=calculate_general_scorer"s  \1L@AE FFr?c4t|d}|dkry|dkryy)NrrlowKmediumgoodrrs r= score_levelr&s% UA E rz rz r?c|jdi}|jdi}|jdi}|jdi}|jdi}|jdi} |jdi} |jdi} t|d|} t|d|} t|d|}t|d|}t|d|}|jdd}|jdd}|jdd}| jdd}| jdd}| jdd}d | d |d |d t| d | d |d|d|d|d|d|d|d|dS)NrrrrrrsignrAzWith the Sun transiting your z house in , , your focus turns toward z. The Moon moving through your z_ highlights your emotional needs and helps you understand what requires care today. Mercury in  activates your zK house, supporting clearer thinking, planning, and communication. Venus in z brings harmony to your zJ house, helping you connect with comfort, affection, and balance. Mars in z energizes your zg house, encouraging you to take practical action where effort is needed. Because your natal Moon is in z, emotional stability comes from staying grounded and responding thoughtfully instead of rushing. Overall, this is a day to move with awareness, protect your energy, and take steady steps toward peace and progress.rrrrv)namenatalrrr natal_planetsrrrrr natal_moonrr~rrrsun_signr} mercury_sign venus_sign mars_signnatal_moon_signs r=build_general_horoscoper2skk)R0OIIi,M   eR (C   vr *D!!)R0G    ,E   vr *D""62.J_e[AIov{CJ )[IMEKov{CJwwvr"H$I;;vr*L62&J$I nnVR0O ( {*XJbNh Y ' ((G |S]^g]hi"^#3M?C''1l2J;-X99B CST^S_`^^m]no  r?cd|d|d|dS)Nz#Embrace balance and clarity today, z; your z Moon energy and zG Sun focus can guide you toward calm decisions and meaningful progress.rx)rr}rs r= build_mantrarYs* -dV79+EVW_V`aG Hr?c||jdi}|jdi}|jdi}|jdi}|jdd}|jdd}|jdd} t|d|} t|d|} t|d|} d|d| d |d |d | d | d| d S)NrrrrrrAzTransiting Venus is in  moving through your  house, z^. This highlights affection, attraction, and the way you connect emotionally in love. Mars in rzS house, adding desire, confidence, and action to relationship matters. The Moon in z house shows where your emotional needs are strongest today. If you are in a relationship, this is a good day to communicate with patience and warmth. If you are single, focus on genuine connection instead of rushing attraction.rrr) rrrrrrrrrr}rrr~s r=build_love_horoscoper`skk)R0O    ,E   vr *D   vr *D62&J$I$IEKov{CJov{CJ "*-B;-xX\W]^+-j\: k!6zlCX Yr?c|jdi}|jdi}|jdi}|jdi}|jdi}|jdd}|jdd} |jdd} |jdd} t|d|} t|d|} t|d|}t|d|}d|d | d |d t| d | d | d| d|d| d |dS)NrrrrrrrAzWith the Sun in z transiting your rrz . Mercury in rzV house supports planning, learning, messages, and professional communication. Mars in rzG house, giving you drive to complete tasks and take action. Jupiter in z house shows where growth and opportunity can open with patience. Career-wise, today favors steady effort, clear communication, and practical decisions over impulsive moves.r)rrrrrrrrrrr jupiter_signrrrrs r=build_career_horoscoperys?kk)R0O   eR (C!!)R0G   vr *D!!)R0Gwwvr"H;;vr*L$I;;vr*L_e[AI )[IMov{CJ )[IM 8*$5i[Nh Y ' ( l^CXYfXghZZcYddt ,]^j]klv  wr?c||jdi}|jdi}|jdi}|jdi}|jdd}|jdd}|jdd} t|d|} t|d|} t|d|} d|d| d |d |d | d | d| d S)NrrrrrrAz The Moon in rz7 house affects your emotional rhythm and daily energy, z . Mars in z activating your zd house can increase motivation, but it may also create restlessness if you push too hard. Saturn in a  house asks for discipline, balance, and better boundaries around your body and routine. Health-wise, today supports simple habits: steady meals, hydration, light movement, and enough rest. Avoid overthinking or forcing progress; consistency will help you feel better.r) rrrrrrrr}r saturn_signr~rrs r=build_health_horoscoperskk)R0O   vr *D   vr *D  2 .F$I$I**VR(Kov{CJov{CJ;GL yk!6zlByz~y@+.zl;++6-7L\N[z {r?user_idc t}|jd} |jd|f|j|j |j S#|j |j wxYw)NT) dictionarya SELECT ubd.id, ubd.user_id, ubd.name, ubd.birth_year, ubd.birth_month, ubd.birth_day, ubd.birth_hour, ubd.birth_minute, ubd.birth_ampm, ubd.unknown_birth_time, ubd.birth_place, ubd.birth_lat, ubd.birth_lon, ubd.timezone, u.email FROM user_birth_details ubd LEFT JOIN users u ON u.id = ubd.user_id WHERE ubd.user_id = %s ORDER BY ubd.id DESC LIMIT 1 )rcursorexecutefetchoneclose)rconnrs r=get_birth_details_for_userrsm  D [[D[ )F  .J1 6       s "A!!"Bz/daily-horoscopec T t|d}|s tdd|jd|jd tdd |jd xsd }|jd xsd }|jd xsd}|jdxsd}|jdrd }d}d}t|||\}}t |d}t |d} t |jd} t t|dt|dt|d||d|| |  } tt|dt|dt|d|||| | } tj} t | j| j| jd dd|| |  }| jdi}|jdi}|jdi}|jdi}| jdi}|jd}|jd}|jd}|jdi}|jdi}|jdd}|jdd}||z dz}t|}tj| j| jd| jd | j}|dd!t!|dj#d"d!t!|dj#d"}|d#t!|j#d"d|}t%|| } | s|jd$} |jd%d&}!|jdd&}"t'|| }#t)|| }$t+|| }%t-|#|$|%}&t/||xsd&|xsd&}'t1|| || }(t3||"| })t5||| }*t7||| }+t9||| },id'd(d |d)|d*|d+|d,|jd-xsd&d.d/d|t:j|d0|r|d1nd2d3d|t:j|d4|r|d5nd6d3d7|t:j|d8|r|d9nd:d3d;||"| |!|)d<d=|'d>|&d?t=|&d@|(dA|#dBt=|#|*|$t=|$|+|%t=|%|,dCS#t$rt>$r*}-tAdD|-tdEdFt!|-d}-~-wwxYw)GNidizBirth details not found.) status_codedetail birth_lat birth_lonizZBirth latitude and longitude are missing. Please update your birth location from settings.rUser birth_hourr0 birth_minuter birth_ampmr5unknown_birth_timerk birth_year birth_month birth_day) rfrgrhr1r2secondlatitudertz)rfrgrhr1r2rirjrkrrr ascendantrrrS r-r&:rsdegreerAsuccessT today_date birthdate birth_timelocation birth_place house_systemPlacidusu☉z SunSun)rsymbollabelu☽z MoonMoonrisingu↑z RisingRising moon_phase)rrrsrtextmantra general_scoregeneral_score_levelgeneral_horoscoperlove_score_level)love_horoscopercareer_score_levelcareer_horoscoperhealth_score_levelhealth_horoscopez!Daily horoscope generation error:iz#Daily horoscope generation failed: )!rrrrr>rErLr r7rprnowrfrgrhrz MONTH_NAMESrFzfillr_rrrrrrrrrrZODIAC_SYMBOLSrrGrH). current_userdetails user_namerrr calc_hour calc_minuterirjrkrrtodayrrr natal_sunrrrr} rising_sign transit_sun transit_moonsun_lonmoon_lon phase_angler|rbirthdate_textbirth_time_textr~ moon_degreemoon_sign_todayrrrrrgeneral moon_textr r res. r=get_daily_horoscoper(s(d);27a [[.6$ ;;+ ,JLJ!3   "  ; GK()GK()%gkk*&=>!W\*+gm,-GK()  ,W\*+gm,-GK()   #++    )R0 !++i4!%%eR0 "&&vr2 IIk2. ==(NN6* mmF+ %))%4 &**626 //+q1##K3')S0 $[1 # U[[AB!EII;bQVQ[Q[P\] |$%Q7=)*0034A7;'(..q12 4  (L#l*;*A*A!*D)EQzlS)(K@ %))'2J"&&x4 &**626)';? -g{C -g{C / L,W ib(.bI))UG[Q#JL -i+N1)WkR1)WkR+ t+ I+  *+   + / +  M28b +  J+   (,,Xu=.6H:T*E+  !(,,Y>09I;e,v+ $ #(,,[%@4?K=0X%+ . "'#%! /+ < f=+ > ]?+ @ ";}#=A+ B C+ D *E+ F  J 7G+ H-("-l"; 0("-l"; 0U+ + Z    1158QA   sRS++T'=%T""T')r%rN),fastapirrrrswissephrbdbr auth_routesr astrologyr routerrrr7rFr>rLrQrTrYr_rprvrzrrrrrrrrrrrrrrrrrr(rxr?r=r/sE55 (' ')9(: ;          S # S 6= *I*"$(/  *22G $N280$$N %,-=%>n  n r?