h!PSSKJr SSKJrJr SSKrSSKrSSKJr "SS5rg))get_db_connection)datetime timedeltaN)Configc\rSrSr\S5r\S Sj5r\S5r\S5r\S5r \S5r \S 5r S r g) RegistrationTokencX[5nU(d [S5eUR5nSnURU5 URS5 UR 5(dSnURU5 [ S5 UR 5 UR5(a!WR5 UR5 gg![an[ SU35 SnANTSnAff=f!UR5(a!WR5 UR5 ff=f)zKEnsures the registration_tokens table exists and has the email_sent column.z"Could not connect to the database.ai CREATE TABLE IF NOT EXISTS `registration_tokens` ( `code` VARCHAR(255) PRIMARY KEY, `pid` INT NOT NULL, `team` INT NULL, `expires_at` DATETIME NOT NULL, `email_sent` TINYINT(1) NOT NULL DEFAULT 0, INDEX (`pid`) ) ENGINE=InnoDB; z9SHOW COLUMNS FROM `registration_tokens` LIKE 'email_sent'zWALTER TABLE `registration_tokens` ADD COLUMN `email_sent` TINYINT(1) NOT NULL DEFAULT 0z9Column 'email_sent' added to 'registration_tokens' table.z"Error creating or altering table: N) r Exceptioncursorexecutefetchoneprintcommit is_connectedclose)connr create_query alter_queryes */var/www/fran/franai/models/token_model.pycreate_table_if_not_exists,RegistrationToken.create_table_if_not_existss!"@A A [[]F L NN< ( NNV W??$$w {+QR KKM  ""  # < 6qc: ; ; <  ""  #s*A7C C.C)$C1)C..C118D)Nc[5nU(dgURSS9nSnURX@45 UR5n[R "S5n[ [RRSS55n[R"5nU[US9-n U(aS n URXXU45 OS n URXXU 45 UR5 UUR5(a!UR5 UR5 $$![ a^n [#S U 35 UR%5 Sn A UR5(a!WR5 UR5 ggSn A ff=f!UR5(a!WR5 UR5 ff=f) z Checks for a token for a user based on PID. If one exists, it updates it with a new code and expiry, and resets the email_sent flag. If not, it creates a new token. This ensures only one token record exists per user. NT dictionaryz;SELECT code FROM registration_tokens WHERE pid = %s LIMIT 1!REGISTRATION_TOKEN_EXPIRY_MINUTES)minutesz UPDATE registration_tokens SET code = %s, expires_at = %s, team = %s, email_sent = 0 WHERE pid = %s zUINSERT INTO registration_tokens (code, pid, team, expires_at) VALUES (%s, %s, %s, %s)z"Error creating or updating token: )rr rrsecrets token_urlsafeintosenvirongetr get_ph_timerrrrr rrollback) pidteamrr select_queryexisting_tokennew_codeexpiry_minutesph_timenew_expires_at update_query insert_queryrs rcreateRegistrationToken.create.s~!"& [[D[1FYL NN< 0#__.N,,R0H 0SUV!WXN((*G$y'HHN  |c-RS w |>-RS KKM   ""  #   6qc: ; MMO  ""  #     ""  #s*CD## F -F FF  F8Gc[5nU(dgURSS9nSnURX045 UR5nU(aTUS[R "5:a8UUR 5(a!UR5 UR5 $$UR 5(a!UR5 UR5 gg![aNn[SU35 SnAUR 5(a!WR5 UR5 ggSnAff=f!UR 5(a!WR5 UR5 ff=f)zCFinds a token by its code and checks if it's valid and not expired.NTrz1SELECT * FROM registration_tokens WHERE code = %s expires_atzError finding token: ) rr rrrnowrrr r)coderr querytokenrs r find_by_codeRegistrationToken.find_by_codeas'!" [[D[1FGE NN5' *OO%E|,x||~=  ""  #    ""  #   )!- .  ""  #    ""  #s*AC D2$D-2D5-D22D558E-c,[5nU(dgUR5nSnURX045 UR5 UR 5(a!UR 5 UR 5 gg![ aNn[SU35 SnAUR 5(a!WR 5 UR 5 ggSnAff=f!UR 5(a!WR 5 UR 5 ff=f)z9Deletes a token from the database after it has been used.Fz/DELETE FROM registration_tokens WHERE code = %sTzError deleting token: Nrr rrrrr rr9rr r:rs rdeleteRegistrationToken.deletezs!" [[]FEE NN5' * KKM   ""  #   *1#. /  ""  #    ""  #)4B C CCCC8Dc([5nU(dgURSS9nSnURU5 UR5nUUR 5(a!UR 5 UR 5 $$![ aNn[SU35 SnAUR 5(a!WR 5 UR 5 ggSnAff=f!UR 5(a!WR 5 UR 5 ff=f)zIFetches all non-expired tokens with associated user and team information.NTrar SELECT rt.code, rt.pid, rt.expires_at, CONCAT(e.first_name, ' ', e.last_name) as staff_name, ug.group_name as team_name FROM registration_tokens rt JOIN hris_core.employee_information_tbl e ON rt.pid = e.pid LEFT JOIN intra.user_group ug ON rt.team = ug.GID WHERE rt.expires_at > NOW() ORDER BY rt.expires_at ASC zError fetching active tokens: rr rfetchallrrr rrr r:tokensrs rget_active_tokens#RegistrationToken.get_active_tokenss!" [[D[1FE$ NN5 !__&F   ""  #   21#6 7  ""  #    ""  #)3A>> CCCCC8Dc,[5nU(dgUR5nSnURX045 UR5 UR 5(a!UR 5 UR 5 gg![ aNn[SU35 SnAUR 5(a!WR 5 UR 5 ggSnAff=f!UR 5(a!WR 5 UR 5 ff=f)z+Marks a token as having been sent by email.Fz=UPDATE registration_tokens SET email_sent = 1 WHERE code = %sTzError marking token as sent: Nr?r@s r mark_as_sentRegistrationToken.mark_as_sents!" [[]FSE NN5' * KKM   ""  #   1!5 6  ""  #    ""  #rCc([5nU(dgURSS9nSnURU5 UR5nUUR 5(a!UR 5 UR 5 $$![ aNn[SU35 SnAUR 5(a!WR 5 UR 5 ggSnAff=f!UR 5(a!WR 5 UR 5 ff=f)z=Fetches all tokens with associated user and team information.NTra SELECT rt.code, rt.pid, rt.expires_at, rt.email_sent, CONCAT(e.first_name, ' ', e.last_name) as staff_name, ug.group_name as team_name, CASE WHEN rt.expires_at > NOW() THEN 1 ELSE 0 END as is_active FROM registration_tokens rt JOIN hris_core.employee_information_tbl e ON rt.pid = e.pid LEFT JOIN intra.user_group ug ON rt.team = ug.GID ORDER BY rt.expires_at DESC zError fetching all tokens: rErGs rget_all_tokens RegistrationToken.get_all_tokenss!" [[D[1FE* NN5 !__&F   ""  #   /s3 4  ""  #    ""  #rK)N) __name__ __module__ __qualname____firstlineno__ staticmethodrr4r<rArIrMrP__static_attributes__rRrr r s##J00d0(%%N(&&rYr ) services.mysql_servicerrrr"r%services.configrr rRrYrr\s 6( $llrY