
    Whb                     
   d dl mZmZmZmZmZmZ d dlmZmZ d dl	m
Z
 d dlZd dlZd dlZd dlmZ d dl mZ  eedd	      Zd
e_         ed      e_        dZdZd Zej3                  d      d        Zej3                  d      d        Zej3                  d      d        Zej3                  d      d        Zej3                  d      d        Zej3                  d      d        Zej3                  d      d        Z ej3                  d      d        Z!ej3                  d d!d"g#      d$        Z"ej3                  d%d!d"g#      d&        Z#ej3                  d'      d(        Z$ed)k(  r e        ejK                  d*d+d,-       yy).    )Flaskrender_templaterequestredirecturl_forsession)datetime	timedelta)check_password_hashN)BytesIO)	send_file	templatesstatic)template_folderstatic_folderweddingrs2025   )minuteszweddingRS.dbzscrypt:32768:8:1$F8U53F3uPKgI0NGM$df3c40b14a91dd751f42374eed15ace85632901a4cb1c9486af667abc6a2a49fc1e822646d817e564cc370b92aeee67b268376433c008dbbf2132c7bdbc8cc43c                      t        j                  t              5 } | j                  d       | j	                          d d d        y # 1 sw Y   y xY w)Na  
            CREATE TABLE IF NOT EXISTS registrations (
                id INTEGER PRIMARY KEY AUTOINCREMENT,
                first_name TEXT NOT NULL,
                last_name TEXT,
                email TEXT,
                camping BIT,
                vegitarian BIT,
                accommodation TEXT,
                kind_words TEXT,
                timestamp INTEGER DEFAULT (strftime('%s', 'now')) 
            )
        )sqlite3connectDATABASEexecutecommit)conns    /var/www/weddingrs/app.pyinit_dbr      sA    		" d  	 	  s   "AA/c                      t        d      S )Nz	home.htmlr        r   homer#   %   s    ;''r"   z/mobilec                      t        d      S )Nzhome_mobile.htmlr    r!   r"   r   home_mobiler%   )   s    -..r"   z/locatiec                      t        d      S )Nzlocation.htmlr    r!   r"   r   locationr'   -       ?++r"   z/fotosc                      t        d      S )Nzpictures.htmlr    r!   r"   r   picturesr*   1   r(   r"   z/jentinac                      t        dd      S NzDhttp://141.134.5.44:2283/albums/343a2461-05a2-43a8-93b4-e46d7de832adi.  )coder   r!   r"   r   jentinar/   5       Zadeer"   z/mamac                      t        dd      S r,   r.   r!   r"   r   mamar2   9   r0   r"   z/onzedagc                      t        d      S )Nzourday.htmlr    r!   r"   r   ourdayr4   >   s    =))r"   z/testc                      t        d      S )Nztestpage.htmlr    r!   r"   r   testr6   B   r(   r"   z/bevestigingGETPOST)methodsc                  d   t         j                  dk(  rt         j                  d   } t         j                  d   }t         j                  d   }t         j                  j                  dd      }t         j                  j                  dd      }t         j                  d   }|sd	}t         j                  d
   }|sd	}t	        j
                  t              5 }|j                  d| ||||||f       |j                          d d d        t        d      S t        d      S # 1 sw Y   t        d      S xY w)Nr8   
first_name	last_nameemailcamping0
vegetarianaddresszniet ingevuld
kind_wordsz
                INSERT INTO registrations (first_name, last_name, email, camping, vegitarian, accommodation, kind_words)
                VALUES (?, ?, ?, ?, ?, ?, ?)
            r   zregistration.html)r   methodformgetr   r   r   r   r   r   r   )r;   r<   r=   r>   
vegitarianaccommodationrB   r   s           r   registrationrH   G   s   ~~\\,/
LL-	W%,,""9S1\\%%lC8
Y/+M\\,/
(J __X& 	$LL  i]T^_a KKM	 }.//	 }s   *DD/z/loginc                      t         j                  dk(  rOt         j                  d   } t        t        |       rdt
        _        t        t        d            S t        dd      S t        d      S )Nr8   passwordTadminz
login.htmlzInvalid password)error)
r   rC   rD   r   ADMIN_PASSWORDr   	permanentr   r   r   )rJ   s    r   loginrO   `   sW    ~~<<
+~x8 $GGG,--"<7IJJ<((r"   z/adminc                  P   t         j                  dk(  r[t        j                  t              5 } | j                  d      }|j                         }|D 	
c	g c]Z  \  }}}}}}}	}
||||dk(  rdnd|dk(  rdnd||	t        j                  |
t        j                  d            j                  d      f\ }}	}}}}}}}
d d d        t        j                  j                  d	      d
k(  rvt        j                   g d      }t#               }t        j$                  |d      5 }|j'                  |d       d d d        |j)                  d       t+        |ddd      S t-        d      S t/        t1        d            S c c	}
}	}}}}}}w # 1 sw Y   xY w# 1 sw Y   bxY w)NTzqSELECT first_name, last_name, email, camping, vegitarian, accommodation, kind_words, timestamp FROM registrations   JaNeezEurope/Brussels)tzz%d-%m-%Y %H:%M:%Sexporttrue)z
First Namez	Last NameEmailCamping
VegetarianAccommodationz
Kind Words	Timestamp)columnsopenpyxl)engineF)indexr   zregistrations.xlsxzAapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet)as_attachmentdownload_namemimetypez
admin.html)registrationsrO   )r   rN   r   r   r   r   fetchallr	   fromtimestamppytztimezonestrftimer   argsrE   pd	DataFramer   ExcelWriterto_excelseekr   r   r   r   )r   cursorrc   r;   r<   r=   r>   rF   rG   rB   	timestampdfoutputwriters                 r   rK   rK   k   s   D __X& 	$\\  #V  WF"OO-M p}  lJ	5':}V`bk #qLDe&!OD!**9GX9YZccdwx	M 	  <<H%/m  6_  `B YF z: 1fF%01 KKN V4G[  gj  k  k|=II ())? 	 	01 1s*   -FAF:	F'FFFF%__main__z::Ti  )hostdebugport)&flaskr   r   r   r   r   r   r	   r
   werkzeug.securityr   r   rf   pandasrj   ior   r   __name__app
secret_keypermanent_session_lifetimer   rM   r   router#   r%   r'   r*   r/   r2   r4   r6   rH   rO   rK   runr!   r"   r   <module>r      s   M M ( 1     HkJ !*2!6   v" 3( ( 9/ / :, , 8, , :f f 7f f :* * 7, , >E6?30 400 8eV_-) .) 8$* $*N zIGGDtG, r"   