
    th                        d dl mZmZmZmZmZmZmZ d dlm	Z	m
Z
mZmZmZmZ d dlmZ  ede          Ze                    dd          d             Ze                    d	d          e
d
                         Ze                    dd          e
d                         Ze                    ddg          e
d                         ZdS )    )	Blueprintrender_templaterequestredirecturl_forsessionjsonify)
init_utilslogin_requiredadmin_requiredmysqlpaginatenow_str)datetimecore/F)strict_slashesc                  :    t          t          d                    S )Ncore.dashboard)r   r        (/var/www/html/KniffelGame/core_routes.pyhome_redirectr   	   s    G,--...r   z
/dashboardc                    	 t           j                                        }|                    d           |                                }|                                 |r|d                             d          nd }t          d| d         |          S # t          $ r }t          dd| 	          d
fcY d }~S d }~ww xY w)Nz
            SELECT zeitpunkt 
            FROM logeintraege 
            WHERE meldung = 'Schalter aktiviert' 
            ORDER BY zeitpunkt DESC LIMIT 1
        r   z%d.%m.%Y um %H:%M Uhrz	home.htmlbenutzername)benutzerletzter_statusfehler.htmlzFehler beim Dashboard: fehlermeldung  )	r   
connectioncursorexecutefetchoneclosestrftimer   	Exception)userr#   resultr   es        r   	dashboardr,      s    `!((**  	 	 	 ""HNX++,CDDDTX{T.5IZhiiii ` ` `}<YVW<Y<YZZZ\________`s   BB 
B>B93B>9B>z/profilc                 L    t          d| d         | d         | d                   S )Nzprofil.htmlr   emailtheme)r   r.   r/   )r   )r)   s    r   profilr0   "   s3     =.)7m7m   r   z/themePOST)methodsc                    t           j                            dd          }|t          d<   	 t          j                                        }|                    d|| d         f           t          j                                         |	                                 n-# t          $ r }t          dd|           dfcY d }~S d }~ww xY wt          t           j        pt          d	                    S )
Nr/   lightz,UPDATE benutzer SET theme = %s WHERE id = %sidr   z"Fehler beim Speichern des Themes: r   r!   r   )r   formgetr   r   r"   r#   r$   commitr&   r(   r   r   referrerr   )r)   neues_themer#   r+   s       r   r/   r/   ,   s     ,""7G44K"GGk!((**EUYZ^U_G`aaa!!! k k k}<dab<d<deeegjjjjjjjjkG$A0@(A(ABBBs   A.B 
C%C :C CN)flaskr   r   r   r   r   r   r	   utilsr
   r   r   r   r   r   r   __name__r   router   r,   r0   r/   r   r   r   <module>r?      sp   Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z V V V V V V V V V V V V V V V V      y"" C&&/ / '&/ L//` `  0/`& Ie,,   -, Hvh''
C 
C  ('
C 
C 
Cr   