Compare commits
29 Commits
dev/m4_rob
...
dev/m6_rob
| Author | SHA1 | Date | |
|---|---|---|---|
|
fcba35dc00 | ||
|
|
91856073e1 | ||
|
|
15d9287b47 | ||
|
|
462eee8994 | ||
|
|
98a3c6c790 | ||
|
|
abeefa2d74 | ||
|
|
5756f2b7d5 | ||
|
|
800d84bd41 | ||
|
|
d47f00093a | ||
|
|
aa936198c8 | ||
|
|
bab5bfd58e | ||
|
|
57a4470de3 | ||
|
|
92eb1b5363 | ||
|
|
3a74c02aec | ||
|
|
96a8f48982 | ||
|
|
8ef27c6b85 | ||
|
|
e7eb81b896 | ||
|
|
7f4c73d91d | ||
|
|
5ca6283aa3 | ||
|
|
713d5059b7 | ||
|
|
67e88a8185 | ||
|
|
a605ce4d34 | ||
|
|
05258cfb22 | ||
|
|
5ee2f923fe | ||
|
|
94f7100138 | ||
|
|
b6100b2ab6 | ||
|
|
aa921725c9 | ||
|
|
4ed0518f1b | ||
|
|
99d78584ec |
@@ -1365,8 +1365,8 @@
|
||||
<CollationName>utf8mb3_general_ci</CollationName>
|
||||
</schema>
|
||||
<schema id="512" parent="1" name="emensawerbeseite">
|
||||
<IntrospectionTimestamp>2023-11-24.21:00:41</IntrospectionTimestamp>
|
||||
<LocalIntrospectionTimestamp>2023-11-24.19:00:41</LocalIntrospectionTimestamp>
|
||||
<IntrospectionTimestamp>2024-01-19.03:45:30</IntrospectionTimestamp>
|
||||
<LocalIntrospectionTimestamp>2024-01-19.01:45:30</LocalIntrospectionTimestamp>
|
||||
<CollationName>latin1_swedish_ci</CollationName>
|
||||
</schema>
|
||||
<user id="513" parent="1" name="mariadb.sys">
|
||||
@@ -1384,224 +1384,561 @@
|
||||
<user id="517" parent="1" name="root">
|
||||
<Host>::1</Host>
|
||||
</user>
|
||||
<table id="518" parent="512" name="allergen">
|
||||
<routine id="518" parent="512" name="incrementAnzahlAnmeldungen">
|
||||
<Definer>root@localhost</Definer>
|
||||
<RoutineKind>procedure</RoutineKind>
|
||||
<SourceTextLength>106</SourceTextLength>
|
||||
</routine>
|
||||
<table id="519" parent="512" name="allergen">
|
||||
<Engine>InnoDB</Engine>
|
||||
<CollationName>latin1_swedish_ci</CollationName>
|
||||
</table>
|
||||
<table id="519" parent="512" name="besucher_counter">
|
||||
<table id="520" parent="512" name="benutzer">
|
||||
<Engine>InnoDB</Engine>
|
||||
<CollationName>latin1_swedish_ci</CollationName>
|
||||
</table>
|
||||
<table id="520" parent="512" name="gericht">
|
||||
<table id="521" parent="512" name="besucher_counter">
|
||||
<Engine>InnoDB</Engine>
|
||||
<CollationName>latin1_swedish_ci</CollationName>
|
||||
</table>
|
||||
<table id="521" parent="512" name="gericht_hat_allergen">
|
||||
<table id="522" parent="512" name="bewertungen">
|
||||
<Engine>InnoDB</Engine>
|
||||
<CollationName>latin1_swedish_ci</CollationName>
|
||||
</table>
|
||||
<table id="522" parent="512" name="gericht_hat_kategorie">
|
||||
<table id="523" parent="512" name="ersteller">
|
||||
<Engine>InnoDB</Engine>
|
||||
<CollationName>latin1_swedish_ci</CollationName>
|
||||
</table>
|
||||
<table id="523" parent="512" name="kategorie">
|
||||
<table id="524" parent="512" name="gericht">
|
||||
<Engine>InnoDB</Engine>
|
||||
<CollationName>latin1_swedish_ci</CollationName>
|
||||
</table>
|
||||
<column id="524" parent="518" name="code">
|
||||
<table id="525" parent="512" name="gericht_hat_allergen">
|
||||
<Engine>InnoDB</Engine>
|
||||
<CollationName>latin1_swedish_ci</CollationName>
|
||||
</table>
|
||||
<table id="526" parent="512" name="gericht_hat_kategorie">
|
||||
<Engine>InnoDB</Engine>
|
||||
<CollationName>latin1_swedish_ci</CollationName>
|
||||
</table>
|
||||
<table id="527" parent="512" name="kategorie">
|
||||
<Engine>InnoDB</Engine>
|
||||
<CollationName>latin1_swedish_ci</CollationName>
|
||||
</table>
|
||||
<table id="528" parent="512" name="wunschgericht">
|
||||
<Engine>InnoDB</Engine>
|
||||
<CollationName>latin1_swedish_ci</CollationName>
|
||||
</table>
|
||||
<view id="529" parent="512" name="view_anmeldungen">
|
||||
<Definer>root@localhost</Definer>
|
||||
<SourceTextLength>225</SourceTextLength>
|
||||
</view>
|
||||
<view id="530" parent="512" name="view_kategoriegerichte_vegetarisch">
|
||||
<Definer>root@localhost</Definer>
|
||||
<SourceTextLength>343</SourceTextLength>
|
||||
</view>
|
||||
<view id="531" parent="512" name="view_suppengerichte">
|
||||
<Definer>root@localhost</Definer>
|
||||
<SourceTextLength>587</SourceTextLength>
|
||||
</view>
|
||||
<argument id="532" parent="518" name="benutzerid">
|
||||
<DasType>int(11)|0s</DasType>
|
||||
<Position>1</Position>
|
||||
</argument>
|
||||
<column id="533" parent="519" name="code">
|
||||
<DasType>char(4)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>1</Position>
|
||||
</column>
|
||||
<column id="525" parent="518" name="name">
|
||||
<column id="534" parent="519" name="name">
|
||||
<DasType>varchar(300)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>2</Position>
|
||||
</column>
|
||||
<column id="526" parent="518" name="typ">
|
||||
<column id="535" parent="519" name="typ">
|
||||
<DasType>varchar(20)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>3</Position>
|
||||
</column>
|
||||
<index id="527" parent="518" name="PRIMARY">
|
||||
<index id="536" parent="519" name="PRIMARY">
|
||||
<ColNames>code</ColNames>
|
||||
<Type>btree</Type>
|
||||
<Unique>1</Unique>
|
||||
</index>
|
||||
<key id="528" parent="518" name="PRIMARY">
|
||||
<key id="537" parent="519" name="PRIMARY">
|
||||
<NameSurrogate>1</NameSurrogate>
|
||||
<Primary>1</Primary>
|
||||
<UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
|
||||
</key>
|
||||
<column id="529" parent="519" name="id">
|
||||
<DasType>int(11)|0s</DasType>
|
||||
<column id="538" parent="520" name="id">
|
||||
<AutoIncrement>2</AutoIncrement>
|
||||
<DasType>bigint(20)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>1</Position>
|
||||
</column>
|
||||
<column id="530" parent="519" name="besucher">
|
||||
<DasType>bigint(20)|0s</DasType>
|
||||
<column id="539" parent="520" name="name">
|
||||
<DasType>varchar(200)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>2</Position>
|
||||
</column>
|
||||
<index id="531" parent="519" name="PRIMARY">
|
||||
<column id="540" parent="520" name="email">
|
||||
<DasType>varchar(100)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>3</Position>
|
||||
</column>
|
||||
<column id="541" parent="520" name="passwort">
|
||||
<DasType>varchar(200)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>4</Position>
|
||||
</column>
|
||||
<column id="542" parent="520" name="admin">
|
||||
<DasType>tinyint(1)|0s</DasType>
|
||||
<DefaultExpression>0</DefaultExpression>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>5</Position>
|
||||
</column>
|
||||
<column id="543" parent="520" name="anzahlfehler">
|
||||
<DasType>int(11)|0s</DasType>
|
||||
<DefaultExpression>0</DefaultExpression>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>6</Position>
|
||||
</column>
|
||||
<column id="544" parent="520" name="anzahlanmeldungen">
|
||||
<DasType>int(11)|0s</DasType>
|
||||
<DefaultExpression>0</DefaultExpression>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>7</Position>
|
||||
</column>
|
||||
<column id="545" parent="520" name="letzteanmeldung">
|
||||
<DasType>datetime|0s</DasType>
|
||||
<Position>8</Position>
|
||||
</column>
|
||||
<column id="546" parent="520" name="letzterfehler">
|
||||
<DasType>datetime|0s</DasType>
|
||||
<Position>9</Position>
|
||||
</column>
|
||||
<index id="547" parent="520" name="PRIMARY">
|
||||
<ColNames>id</ColNames>
|
||||
<Type>btree</Type>
|
||||
<Unique>1</Unique>
|
||||
</index>
|
||||
<key id="532" parent="519" name="PRIMARY">
|
||||
<index id="548" parent="520" name="email">
|
||||
<ColNames>email</ColNames>
|
||||
<Type>btree</Type>
|
||||
<Unique>1</Unique>
|
||||
</index>
|
||||
<key id="549" parent="520" name="PRIMARY">
|
||||
<NameSurrogate>1</NameSurrogate>
|
||||
<Primary>1</Primary>
|
||||
<UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
|
||||
</key>
|
||||
<column id="533" parent="520" name="id">
|
||||
<key id="550" parent="520" name="email">
|
||||
<UnderlyingIndexName>email</UnderlyingIndexName>
|
||||
</key>
|
||||
<column id="551" parent="521" name="id">
|
||||
<DasType>int(11)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>1</Position>
|
||||
</column>
|
||||
<column id="552" parent="521" name="besucher">
|
||||
<DasType>bigint(20)|0s</DasType>
|
||||
<Position>2</Position>
|
||||
</column>
|
||||
<index id="553" parent="521" name="PRIMARY">
|
||||
<ColNames>id</ColNames>
|
||||
<Type>btree</Type>
|
||||
<Unique>1</Unique>
|
||||
</index>
|
||||
<key id="554" parent="521" name="PRIMARY">
|
||||
<NameSurrogate>1</NameSurrogate>
|
||||
<Primary>1</Primary>
|
||||
<UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
|
||||
</key>
|
||||
<column id="555" parent="522" name="id">
|
||||
<AutoIncrement>1</AutoIncrement>
|
||||
<DasType>bigint(20)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>1</Position>
|
||||
</column>
|
||||
<column id="556" parent="522" name="ersteller_id">
|
||||
<DasType>bigint(20)|0s</DasType>
|
||||
<Position>2</Position>
|
||||
</column>
|
||||
<column id="557" parent="522" name="gericht_id">
|
||||
<DasType>bigint(20)|0s</DasType>
|
||||
<Position>3</Position>
|
||||
</column>
|
||||
<column id="558" parent="522" name="erstellungsdatum">
|
||||
<DasType>date|0s</DasType>
|
||||
<DefaultExpression>current_timestamp()</DefaultExpression>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>4</Position>
|
||||
</column>
|
||||
<column id="559" parent="522" name="bemerkung">
|
||||
<DasType>text|0s</DasType>
|
||||
<Position>5</Position>
|
||||
</column>
|
||||
<column id="560" parent="522" name="sterne">
|
||||
<DasType>int(11)|0s</DasType>
|
||||
<Position>6</Position>
|
||||
</column>
|
||||
<column id="561" parent="522" name="hervorgehoben">
|
||||
<DasType>tinyint(1)|0s</DasType>
|
||||
<Position>7</Position>
|
||||
</column>
|
||||
<foreign-key id="562" parent="522" name="ersteller_id">
|
||||
<ColNames>ersteller_id</ColNames>
|
||||
<OnUpdate>cascade</OnUpdate>
|
||||
<RefColNames>id</RefColNames>
|
||||
<RefTableName>benutzer</RefTableName>
|
||||
</foreign-key>
|
||||
<foreign-key id="563" parent="522" name="gericht_id">
|
||||
<ColNames>gericht_id</ColNames>
|
||||
<OnUpdate>cascade</OnUpdate>
|
||||
<RefColNames>id</RefColNames>
|
||||
<RefTableName>gericht</RefTableName>
|
||||
</foreign-key>
|
||||
<index id="564" parent="522" name="PRIMARY">
|
||||
<ColNames>id</ColNames>
|
||||
<Type>btree</Type>
|
||||
<Unique>1</Unique>
|
||||
</index>
|
||||
<index id="565" parent="522" name="ersteller_id">
|
||||
<ColNames>ersteller_id</ColNames>
|
||||
<Type>btree</Type>
|
||||
</index>
|
||||
<index id="566" parent="522" name="gericht_id">
|
||||
<ColNames>gericht_id</ColNames>
|
||||
<Type>btree</Type>
|
||||
</index>
|
||||
<key id="567" parent="522" name="PRIMARY">
|
||||
<NameSurrogate>1</NameSurrogate>
|
||||
<Primary>1</Primary>
|
||||
<UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
|
||||
</key>
|
||||
<column id="568" parent="523" name="EMail">
|
||||
<DasType>varchar(255)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>1</Position>
|
||||
</column>
|
||||
<column id="569" parent="523" name="Name">
|
||||
<DasType>varchar(255)|0s</DasType>
|
||||
<DefaultExpression>'anonym'</DefaultExpression>
|
||||
<Position>2</Position>
|
||||
</column>
|
||||
<index id="570" parent="523" name="PRIMARY">
|
||||
<ColNames>EMail</ColNames>
|
||||
<Type>btree</Type>
|
||||
<Unique>1</Unique>
|
||||
</index>
|
||||
<key id="571" parent="523" name="PRIMARY">
|
||||
<NameSurrogate>1</NameSurrogate>
|
||||
<Primary>1</Primary>
|
||||
<UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
|
||||
</key>
|
||||
<column id="572" parent="524" name="id">
|
||||
<AutoIncrement>21</AutoIncrement>
|
||||
<DasType>bigint(20)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>1</Position>
|
||||
</column>
|
||||
<column id="534" parent="520" name="name">
|
||||
<column id="573" parent="524" name="name">
|
||||
<DasType>varchar(80)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>2</Position>
|
||||
</column>
|
||||
<column id="535" parent="520" name="beschreibung">
|
||||
<column id="574" parent="524" name="beschreibung">
|
||||
<DasType>varchar(80)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>3</Position>
|
||||
</column>
|
||||
<column id="536" parent="520" name="erfasst_am">
|
||||
<column id="575" parent="524" name="erfasst_am">
|
||||
<DasType>date|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>4</Position>
|
||||
</column>
|
||||
<column id="537" parent="520" name="vegetarisch">
|
||||
<column id="576" parent="524" name="vegetarisch">
|
||||
<DasType>tinyint(1)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>5</Position>
|
||||
</column>
|
||||
<column id="538" parent="520" name="vegan">
|
||||
<column id="577" parent="524" name="vegan">
|
||||
<DasType>tinyint(1)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>6</Position>
|
||||
</column>
|
||||
<column id="539" parent="520" name="preisintern">
|
||||
<column id="578" parent="524" name="preisintern">
|
||||
<DasType>double|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>7</Position>
|
||||
</column>
|
||||
<column id="540" parent="520" name="preisextern">
|
||||
<column id="579" parent="524" name="preisextern">
|
||||
<DasType>double|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>8</Position>
|
||||
</column>
|
||||
<index id="541" parent="520" name="PRIMARY">
|
||||
<column id="580" parent="524" name="bildname">
|
||||
<DasType>varchar(200)|0s</DasType>
|
||||
<Position>9</Position>
|
||||
</column>
|
||||
<index id="581" parent="524" name="PRIMARY">
|
||||
<ColNames>id</ColNames>
|
||||
<Type>btree</Type>
|
||||
<Unique>1</Unique>
|
||||
</index>
|
||||
<index id="542" parent="520" name="name">
|
||||
<index id="582" parent="524" name="name">
|
||||
<ColNames>name</ColNames>
|
||||
<Type>btree</Type>
|
||||
<Unique>1</Unique>
|
||||
</index>
|
||||
<key id="543" parent="520" name="PRIMARY">
|
||||
<index id="583" parent="524" name="idx_name">
|
||||
<ColNames>name</ColNames>
|
||||
<Type>btree</Type>
|
||||
</index>
|
||||
<key id="584" parent="524" name="PRIMARY">
|
||||
<NameSurrogate>1</NameSurrogate>
|
||||
<Primary>1</Primary>
|
||||
<UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
|
||||
</key>
|
||||
<key id="544" parent="520" name="name">
|
||||
<key id="585" parent="524" name="name">
|
||||
<UnderlyingIndexName>name</UnderlyingIndexName>
|
||||
</key>
|
||||
<column id="545" parent="521" name="code">
|
||||
<column id="586" parent="525" name="code">
|
||||
<DasType>char(4)|0s</DasType>
|
||||
<Position>1</Position>
|
||||
</column>
|
||||
<column id="546" parent="521" name="gericht_id">
|
||||
<column id="587" parent="525" name="gericht_id">
|
||||
<DasType>bigint(20)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>2</Position>
|
||||
</column>
|
||||
<foreign-key id="547" parent="521" name="gericht_hat_allergen_ibfk_1">
|
||||
<foreign-key id="588" parent="525" name="gericht_hat_allergen_ibfk_1_new">
|
||||
<ColNames>code</ColNames>
|
||||
<OnUpdate>cascade</OnUpdate>
|
||||
<RefColNames>code</RefColNames>
|
||||
<RefTableName>allergen</RefTableName>
|
||||
</foreign-key>
|
||||
<foreign-key id="548" parent="521" name="gericht_hat_allergen_ibfk_2">
|
||||
<foreign-key id="589" parent="525" name="gericht_hat_allergen_ibfk_2_new">
|
||||
<ColNames>gericht_id</ColNames>
|
||||
<OnDelete>cascade</OnDelete>
|
||||
<RefColNames>id</RefColNames>
|
||||
<RefTableName>gericht</RefTableName>
|
||||
</foreign-key>
|
||||
<index id="549" parent="521" name="code">
|
||||
<index id="590" parent="525" name="gericht_hat_allergen_ibfk_1_new">
|
||||
<ColNames>code</ColNames>
|
||||
<Type>btree</Type>
|
||||
</index>
|
||||
<index id="550" parent="521" name="gericht_id">
|
||||
<index id="591" parent="525" name="gericht_hat_allergen_ibfk_2_new">
|
||||
<ColNames>gericht_id</ColNames>
|
||||
<Type>btree</Type>
|
||||
</index>
|
||||
<column id="551" parent="522" name="gericht_id">
|
||||
<column id="592" parent="526" name="gericht_id">
|
||||
<DasType>bigint(20)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>1</Position>
|
||||
</column>
|
||||
<column id="552" parent="522" name="kategorie_id">
|
||||
<column id="593" parent="526" name="kategorie_id">
|
||||
<DasType>bigint(20)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>2</Position>
|
||||
</column>
|
||||
<foreign-key id="553" parent="522" name="gericht_hat_kategorie_ibfk_1">
|
||||
<foreign-key id="594" parent="526" name="gericht_hat_kategorie_ibfk_1_new">
|
||||
<ColNames>gericht_id</ColNames>
|
||||
<OnDelete>cascade</OnDelete>
|
||||
<RefColNames>id</RefColNames>
|
||||
<RefTableName>gericht</RefTableName>
|
||||
</foreign-key>
|
||||
<foreign-key id="554" parent="522" name="gericht_hat_kategorie_ibfk_2">
|
||||
<foreign-key id="595" parent="526" name="fk_gericht_hat_kategorie_kategorie_id">
|
||||
<ColNames>kategorie_id</ColNames>
|
||||
<RefColNames>id</RefColNames>
|
||||
<RefTableName>kategorie</RefTableName>
|
||||
</foreign-key>
|
||||
<index id="555" parent="522" name="gericht_id">
|
||||
<ColNames>gericht_id</ColNames>
|
||||
<foreign-key id="596" parent="526" name="gericht_hat_kategorie_ibfk_2">
|
||||
<ColNames>kategorie_id</ColNames>
|
||||
<RefColNames>id</RefColNames>
|
||||
<RefTableName>kategorie</RefTableName>
|
||||
</foreign-key>
|
||||
<index id="597" parent="526" name="PRIMARY">
|
||||
<ColNames>gericht_id
|
||||
kategorie_id</ColNames>
|
||||
<Type>btree</Type>
|
||||
<Unique>1</Unique>
|
||||
</index>
|
||||
<index id="556" parent="522" name="kategorie_id">
|
||||
<index id="598" parent="526" name="gericht_kategorie_unique">
|
||||
<ColNames>gericht_id
|
||||
kategorie_id</ColNames>
|
||||
<Type>btree</Type>
|
||||
<Unique>1</Unique>
|
||||
</index>
|
||||
<index id="599" parent="526" name="fk_gericht_hat_kategorie_kategorie_id">
|
||||
<ColNames>kategorie_id</ColNames>
|
||||
<Type>btree</Type>
|
||||
</index>
|
||||
<column id="557" parent="523" name="id">
|
||||
<key id="600" parent="526" name="PRIMARY">
|
||||
<NameSurrogate>1</NameSurrogate>
|
||||
<Primary>1</Primary>
|
||||
<UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
|
||||
</key>
|
||||
<key id="601" parent="526" name="gericht_kategorie_unique">
|
||||
<UnderlyingIndexName>gericht_kategorie_unique</UnderlyingIndexName>
|
||||
</key>
|
||||
<column id="602" parent="527" name="id">
|
||||
<DasType>bigint(20)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>1</Position>
|
||||
</column>
|
||||
<column id="558" parent="523" name="name">
|
||||
<column id="603" parent="527" name="name">
|
||||
<DasType>varchar(80)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>2</Position>
|
||||
</column>
|
||||
<column id="559" parent="523" name="eltern_id">
|
||||
<column id="604" parent="527" name="eltern_id">
|
||||
<DasType>bigint(20)|0s</DasType>
|
||||
<Position>3</Position>
|
||||
</column>
|
||||
<column id="560" parent="523" name="bildname">
|
||||
<column id="605" parent="527" name="bildname">
|
||||
<DasType>varchar(200)|0s</DasType>
|
||||
<Position>4</Position>
|
||||
</column>
|
||||
<foreign-key id="561" parent="523" name="kategorie_ibfk_1">
|
||||
<foreign-key id="606" parent="527" name="fk_kategorie_eltern_id">
|
||||
<ColNames>eltern_id</ColNames>
|
||||
<RefColNames>id</RefColNames>
|
||||
<RefTableName>kategorie</RefTableName>
|
||||
</foreign-key>
|
||||
<index id="562" parent="523" name="PRIMARY">
|
||||
<foreign-key id="607" parent="527" name="kategorie_ibfk_1">
|
||||
<ColNames>eltern_id</ColNames>
|
||||
<RefColNames>id</RefColNames>
|
||||
<RefTableName>kategorie</RefTableName>
|
||||
</foreign-key>
|
||||
<index id="608" parent="527" name="PRIMARY">
|
||||
<ColNames>id</ColNames>
|
||||
<Type>btree</Type>
|
||||
<Unique>1</Unique>
|
||||
</index>
|
||||
<index id="563" parent="523" name="eltern_id">
|
||||
<index id="609" parent="527" name="fk_kategorie_eltern_id">
|
||||
<ColNames>eltern_id</ColNames>
|
||||
<Type>btree</Type>
|
||||
</index>
|
||||
<key id="564" parent="523" name="PRIMARY">
|
||||
<key id="610" parent="527" name="PRIMARY">
|
||||
<NameSurrogate>1</NameSurrogate>
|
||||
<Primary>1</Primary>
|
||||
<UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
|
||||
</key>
|
||||
<column id="611" parent="528" name="ID">
|
||||
<AutoIncrement>1</AutoIncrement>
|
||||
<DasType>int(11)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>1</Position>
|
||||
</column>
|
||||
<column id="612" parent="528" name="Name">
|
||||
<DasType>varchar(255)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>2</Position>
|
||||
</column>
|
||||
<column id="613" parent="528" name="Beschreibung">
|
||||
<DasType>text|0s</DasType>
|
||||
<Position>3</Position>
|
||||
</column>
|
||||
<column id="614" parent="528" name="Erstellungsdatum">
|
||||
<DasType>date|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>4</Position>
|
||||
</column>
|
||||
<column id="615" parent="528" name="Ersteller_EMail">
|
||||
<DasType>varchar(255)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>5</Position>
|
||||
</column>
|
||||
<foreign-key id="616" parent="528" name="wunschgericht_ibfk_1">
|
||||
<ColNames>Ersteller_EMail</ColNames>
|
||||
<RefColNames>EMail</RefColNames>
|
||||
<RefTableName>ersteller</RefTableName>
|
||||
</foreign-key>
|
||||
<index id="617" parent="528" name="PRIMARY">
|
||||
<ColNames>ID</ColNames>
|
||||
<Type>btree</Type>
|
||||
<Unique>1</Unique>
|
||||
</index>
|
||||
<index id="618" parent="528" name="Ersteller_EMail">
|
||||
<ColNames>Ersteller_EMail</ColNames>
|
||||
<Type>btree</Type>
|
||||
</index>
|
||||
<key id="619" parent="528" name="PRIMARY">
|
||||
<NameSurrogate>1</NameSurrogate>
|
||||
<Primary>1</Primary>
|
||||
<UnderlyingIndexName>PRIMARY</UnderlyingIndexName>
|
||||
</key>
|
||||
<column id="620" parent="529" name="name">
|
||||
<DasType>varchar(200)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>1</Position>
|
||||
</column>
|
||||
<column id="621" parent="529" name="anzahlanmeldungen">
|
||||
<DasType>int(11)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>2</Position>
|
||||
</column>
|
||||
<column id="622" parent="530" name="Kategorie">
|
||||
<DasType>varchar(80)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>1</Position>
|
||||
</column>
|
||||
<column id="623" parent="530" name="id">
|
||||
<DasType>bigint(20)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>2</Position>
|
||||
</column>
|
||||
<column id="624" parent="530" name="gericht_id">
|
||||
<DasType>bigint(20)|0s</DasType>
|
||||
<Position>3</Position>
|
||||
</column>
|
||||
<column id="625" parent="530" name="name">
|
||||
<DasType>varchar(80)|0s</DasType>
|
||||
<Position>4</Position>
|
||||
</column>
|
||||
<column id="626" parent="531" name="id">
|
||||
<DasType>bigint(20)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>1</Position>
|
||||
</column>
|
||||
<column id="627" parent="531" name="name">
|
||||
<DasType>varchar(80)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>2</Position>
|
||||
</column>
|
||||
<column id="628" parent="531" name="beschreibung">
|
||||
<DasType>varchar(80)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>3</Position>
|
||||
</column>
|
||||
<column id="629" parent="531" name="erfasst_am">
|
||||
<DasType>date|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>4</Position>
|
||||
</column>
|
||||
<column id="630" parent="531" name="vegetarisch">
|
||||
<DasType>tinyint(1)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>5</Position>
|
||||
</column>
|
||||
<column id="631" parent="531" name="vegan">
|
||||
<DasType>tinyint(1)|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>6</Position>
|
||||
</column>
|
||||
<column id="632" parent="531" name="preisintern">
|
||||
<DasType>double|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>7</Position>
|
||||
</column>
|
||||
<column id="633" parent="531" name="preisextern">
|
||||
<DasType>double|0s</DasType>
|
||||
<NotNull>1</NotNull>
|
||||
<Position>8</Position>
|
||||
</column>
|
||||
<column id="634" parent="531" name="bildname">
|
||||
<DasType>varchar(200)|0s</DasType>
|
||||
<Position>9</Position>
|
||||
</column>
|
||||
</database-model>
|
||||
</dataSource>
|
||||
@@ -1,2 +1,2 @@
|
||||
#n:emensawerbeseite
|
||||
!<md> [1700856041000, 0, null, null, -2147483648, -2147483648]
|
||||
!<md> [1705632330000, 0, null, null, -2147483648, -2147483648]
|
||||
|
||||
Binary file not shown.
13
.idea/php.xml
generated
13
.idea/php.xml
generated
@@ -10,6 +10,19 @@
|
||||
<option name="highlightLevel" value="WARNING" />
|
||||
<option name="transferred" value="true" />
|
||||
</component>
|
||||
<component name="PhpIncludePathManager">
|
||||
<include_path>
|
||||
<path value="$PROJECT_DIR$/M5/vendor/monolog/monolog" />
|
||||
<path value="$PROJECT_DIR$/M5/vendor/psr/log" />
|
||||
<path value="$PROJECT_DIR$/M5/vendor/composer" />
|
||||
<path value="$PROJECT_DIR$/M4/emensa/vendor/eftec/bladeone" />
|
||||
<path value="$PROJECT_DIR$/M4/emensa/vendor/composer" />
|
||||
<path value="$PROJECT_DIR$/M5/emensa/vendor/eftec/bladeone" />
|
||||
<path value="$PROJECT_DIR$/M5/emensa/vendor/composer" />
|
||||
<path value="$PROJECT_DIR$/M5/emensa/vendor/psr/log" />
|
||||
<path value="$PROJECT_DIR$/M5/emensa/vendor/monolog/monolog" />
|
||||
</include_path>
|
||||
</component>
|
||||
<component name="PhpProjectSharedConfiguration" php_language_level="7.4">
|
||||
<option name="suggestChangeDefaultLanguageLevel" value="false" />
|
||||
</component>
|
||||
|
||||
57
.idea/shelf/Uncommitted_changes_before_rebase_[Changes]/shelved.patch
generated
Normal file
57
.idea/shelf/Uncommitted_changes_before_rebase_[Changes]/shelved.patch
generated
Normal file
File diff suppressed because one or more lines are too long
4
.idea/shelf/Uncommitted_changes_before_rebase__Changes_.xml
generated
Normal file
4
.idea/shelf/Uncommitted_changes_before_rebase__Changes_.xml
generated
Normal file
@@ -0,0 +1,4 @@
|
||||
<changelist name="Uncommitted_changes_before_rebase_[Changes]" date="1703077231768" recycled="false" toDelete="true">
|
||||
<option name="PATH" value="$PROJECT_DIR$/.idea/shelf/Uncommitted_changes_before_rebase_[Changes]/shelved.patch" />
|
||||
<option name="DESCRIPTION" value="Uncommitted changes before rebase [Changes]" />
|
||||
</changelist>
|
||||
177
.idea/workspace.xml
generated
177
.idea/workspace.xml
generated
@@ -4,32 +4,32 @@
|
||||
<option name="autoReloadType" value="SELECTIVE" />
|
||||
</component>
|
||||
<component name="ChangeListManager">
|
||||
<list default="true" id="6dcbe3e4-9d68-41d8-8c39-5cfbe5cd4a21" name="Changes" comment="">
|
||||
<change afterPath="$PROJECT_DIR$/M4/emensa/controllers/MainController.php" afterDir="false" />
|
||||
<change afterPath="$PROJECT_DIR$/M4/emensa/models/gerichte_main.php" afterDir="false" />
|
||||
<change afterPath="$PROJECT_DIR$/M4/emensa/public/css/style.css" afterDir="false" />
|
||||
<change afterPath="$PROJECT_DIR$/M4/emensa/public/img/fh-logo.jpg" afterDir="false" />
|
||||
<change afterPath="$PROJECT_DIR$/M4/emensa/public/img/mensa21.jpg" afterDir="false" />
|
||||
<change afterPath="$PROJECT_DIR$/M4/emensa/views/layouts/main_layout.blade.php" afterDir="false" />
|
||||
<change afterPath="$PROJECT_DIR$/M4/emensa/views/main/index.blade.php" afterDir="false" />
|
||||
<list default="true" id="6dcbe3e4-9d68-41d8-8c39-5cfbe5cd4a21" name="Changes" comment="Alles bis auf paar sachen">
|
||||
<change beforePath="$PROJECT_DIR$/.idea/workspace.xml" beforeDir="false" afterPath="$PROJECT_DIR$/.idea/workspace.xml" afterDir="false" />
|
||||
<change beforePath="$PROJECT_DIR$/M4/emensa/models/gerichte_self.php" beforeDir="false" afterPath="$PROJECT_DIR$/M4/emensa/models/gerichte_self.php" afterDir="false" />
|
||||
<change beforePath="$PROJECT_DIR$/M4/emensa/routes/web.php" beforeDir="false" afterPath="$PROJECT_DIR$/M4/emensa/routes/web.php" afterDir="false" />
|
||||
<change beforePath="$PROJECT_DIR$/M4/emensa/storage/cache/.layouts.m4_7d_layout_ecc36cbad49aa38782cc08cc5e9ca6c7ae3590d0.bladec" beforeDir="false" afterPath="$PROJECT_DIR$/M4/emensa/storage/cache/.layouts.m4_7d_layout_ecc36cbad49aa38782cc08cc5e9ca6c7ae3590d0.bladec" afterDir="false" />
|
||||
<change beforePath="$PROJECT_DIR$/M4/emensa/views/layouts/m4_7d_layout.blade.php" beforeDir="false" afterPath="$PROJECT_DIR$/M4/emensa/views/layouts/m4_7d_layout.blade.php" afterDir="false" />
|
||||
<change beforePath="$PROJECT_DIR$/M6/emensamobile/app/Models/bewertungen.php" beforeDir="false" afterPath="$PROJECT_DIR$/M6/emensamobile/app/Models/bewertungen.php" afterDir="false" />
|
||||
<change beforePath="$PROJECT_DIR$/M6/emensamobile/public/css/style.css" beforeDir="false" afterPath="$PROJECT_DIR$/M6/emensamobile/public/css/style.css" afterDir="false" />
|
||||
<change beforePath="$PROJECT_DIR$/M6/emensamobile/resources/views/main/bewertung.blade.php" beforeDir="false" afterPath="$PROJECT_DIR$/M6/emensamobile/resources/views/main/bewertung.blade.php" afterDir="false" />
|
||||
<change beforePath="$PROJECT_DIR$/M6/emensamobile/resources/views/main/index.blade.php" beforeDir="false" afterPath="$PROJECT_DIR$/M6/emensamobile/resources/views/main/index.blade.php" afterDir="false" />
|
||||
</list>
|
||||
<option name="SHOW_DIALOG" value="false" />
|
||||
<option name="HIGHLIGHT_CONFLICTS" value="true" />
|
||||
<option name="HIGHLIGHT_NON_ACTIVE_CHANGELIST" value="false" />
|
||||
<option name="LAST_RESOLUTION" value="IGNORE" />
|
||||
</component>
|
||||
<component name="ComposerSettings">
|
||||
<component name="ComposerConfigs">
|
||||
<option name="configs">
|
||||
<option value="$PROJECT_DIR$/M4/emensa/composer.json" />
|
||||
<option value="$PROJECT_DIR$/M5/emensa/composer.json" />
|
||||
</option>
|
||||
</component>
|
||||
<component name="ComposerSettings" synchronizationState="SYNCHRONIZE">
|
||||
<pharConfigPath>$PROJECT_DIR$/M5/composer.json</pharConfigPath>
|
||||
<execution />
|
||||
</component>
|
||||
<component name="Git.Settings">
|
||||
<option name="RECENT_BRANCH_BY_REPOSITORY">
|
||||
<map>
|
||||
<entry key="$PROJECT_DIR$" value="dev/m3_safak" />
|
||||
<entry key="$PROJECT_DIR$" value="dev/m5_safak" />
|
||||
</map>
|
||||
</option>
|
||||
<option name="RECENT_GIT_ROOT_PATH" value="$PROJECT_DIR$" />
|
||||
@@ -37,7 +37,19 @@
|
||||
<component name="MarkdownSettingsMigration">
|
||||
<option name="stateVersion" value="1" />
|
||||
</component>
|
||||
<component name="PhpWorkspaceProjectConfiguration" interpreter_name="Xampp" />
|
||||
<component name="PhpWorkspaceProjectConfiguration" interpreter_name="Xampp">
|
||||
<include_path>
|
||||
<path value="$PROJECT_DIR$/M5/vendor/monolog/monolog" />
|
||||
<path value="$PROJECT_DIR$/M5/vendor/psr/log" />
|
||||
<path value="$PROJECT_DIR$/M5/vendor/composer" />
|
||||
<path value="$PROJECT_DIR$/M4/emensa/vendor/eftec/bladeone" />
|
||||
<path value="$PROJECT_DIR$/M4/emensa/vendor/composer" />
|
||||
<path value="$PROJECT_DIR$/M5/emensa/vendor/eftec/bladeone" />
|
||||
<path value="$PROJECT_DIR$/M5/emensa/vendor/composer" />
|
||||
<path value="$PROJECT_DIR$/M5/emensa/vendor/psr/log" />
|
||||
<path value="$PROJECT_DIR$/M5/emensa/vendor/monolog/monolog" />
|
||||
</include_path>
|
||||
</component>
|
||||
<component name="ProjectColorInfo">{
|
||||
"customColor": "",
|
||||
"associatedIndex": 0
|
||||
@@ -47,32 +59,39 @@
|
||||
<option name="hideEmptyMiddlePackages" value="true" />
|
||||
<option name="showLibraryContents" value="true" />
|
||||
</component>
|
||||
<component name="PropertiesComponent"><![CDATA[{
|
||||
"keyToString": {
|
||||
"RunOnceActivity.OpenProjectViewOnStart": "true",
|
||||
"RunOnceActivity.ShowReadmeOnStart": "true",
|
||||
"WebServerToolWindowFactoryState": "false",
|
||||
"database.data.extractors.current.export.id": "Comma-separated (CSV)_id",
|
||||
"git-widget-placeholder": "dev/m4__robert",
|
||||
"last_opened_file_path": "C:/Users/rober/Documents/GitHub/DBWT-Praktika/M4/emensa/public/img",
|
||||
"node.js.detected.package.eslint": "true",
|
||||
"node.js.detected.package.tslint": "true",
|
||||
"node.js.selected.package.eslint": "(autodetect)",
|
||||
"node.js.selected.package.tslint": "(autodetect)",
|
||||
"nodejs_package_manager_path": "npm",
|
||||
"settings.editor.selected.configurable": "preferences.pluginManager",
|
||||
"vue.rearranger.settings.migration": "true"
|
||||
<component name="PropertiesComponent">{
|
||||
"keyToString": {
|
||||
"RunOnceActivity.OpenProjectViewOnStart": "true",
|
||||
"RunOnceActivity.ShowReadmeOnStart": "true",
|
||||
"WebServerToolWindowFactoryState": "false",
|
||||
"database.data.extractors.current.export.id": "Comma-separated (CSV)_id",
|
||||
"git-widget-placeholder": "dev/m6__robert",
|
||||
"last_opened_file_path": "C:/Users/rober/Documents/GitHub/DBWT-Praktika/M6/emensamobile/public",
|
||||
"node.js.detected.package.eslint": "true",
|
||||
"node.js.detected.package.tslint": "true",
|
||||
"node.js.selected.package.eslint": "(autodetect)",
|
||||
"node.js.selected.package.tslint": "(autodetect)",
|
||||
"nodejs_package_manager_path": "npm",
|
||||
"settings.editor.selected.configurable": "preferences.pluginManager",
|
||||
"vue.rearranger.settings.migration": "true"
|
||||
},
|
||||
"keyToStringList": {
|
||||
"DatabaseDriversLRU": [
|
||||
"mariadb"
|
||||
"keyToStringList": {
|
||||
"DatabaseDriversLRU": [
|
||||
"mariadb"
|
||||
]
|
||||
}
|
||||
}]]></component>
|
||||
}</component>
|
||||
<component name="RecentsManager">
|
||||
<key name="CopyFile.RECENT_KEYS">
|
||||
<recent name="C:\Users\rober\Documents\GitHub\DBWT-Praktika\M4\emensa\public\img" />
|
||||
<recent name="C:\Users\rober\Documents\GitHub\DBWT-Praktika\M4\emensa\public\css" />
|
||||
<recent name="C:\Users\rober\Documents\GitHub\DBWT-Praktika\M6\emensamobile\public" />
|
||||
<recent name="C:\Users\rober\Documents\GitHub\DBWT-Praktika\M6\emensamobile\resources\views" />
|
||||
<recent name="C:\Users\rober\Documents\GitHub\DBWT-Praktika\M6\emensamobile\app\Models" />
|
||||
<recent name="C:\Users\rober\Documents\GitHub\DBWT-Praktika\M6\emensamobile\resources\css" />
|
||||
<recent name="C:\Users\rober\Documents\GitHub\DBWT-Praktika\M6\emensamobile\app\Http\Controllers" />
|
||||
</key>
|
||||
<key name="MoveFile.RECENT_KEYS">
|
||||
<recent name="C:\Users\rober\Documents\GitHub\DBWT-Praktika\M6\emensamobile\app\Models\Anmeldung" />
|
||||
<recent name="C:\Users\rober\Documents\GitHub\DBWT-Praktika\M6\emensamobile\app\Models\Main" />
|
||||
</key>
|
||||
</component>
|
||||
<component name="SpellCheckerSettings" RuntimeDictionaries="0" Folders="0" CustomDictionaries="0" DefaultDictionary="application-level" UseSingleDictionary="true" transferred="true" />
|
||||
@@ -85,10 +104,96 @@
|
||||
<updated>1700736495450</updated>
|
||||
<workItem from="1700736497007" duration="15223000" />
|
||||
<workItem from="1702027267170" duration="12429000" />
|
||||
<workItem from="1704879915312" duration="5579000" />
|
||||
<workItem from="1704901745332" duration="7535000" />
|
||||
<workItem from="1705063082944" duration="2121000" />
|
||||
<workItem from="1705065239294" duration="1925000" />
|
||||
<workItem from="1705405736678" duration="5488000" />
|
||||
<workItem from="1705414744237" duration="1967000" />
|
||||
<workItem from="1705488930166" duration="3342000" />
|
||||
<workItem from="1705492444098" duration="553000" />
|
||||
<workItem from="1705493014644" duration="21207000" />
|
||||
<workItem from="1705627589042" duration="2719000" />
|
||||
<workItem from="1705630465063" duration="13023000" />
|
||||
</task>
|
||||
<task id="LOCAL-00001" summary="Webseite ohne Anmeldung läuft auf laravel">
|
||||
<option name="closed" value="true" />
|
||||
<created>1705491845444</created>
|
||||
<option name="number" value="00001" />
|
||||
<option name="presentableId" value="LOCAL-00001" />
|
||||
<option name="project" value="LOCAL" />
|
||||
<updated>1705491845444</updated>
|
||||
</task>
|
||||
<task id="LOCAL-00002" summary="Webseite ohne Anmeldung läuft auf laravel">
|
||||
<option name="closed" value="true" />
|
||||
<created>1705491897073</created>
|
||||
<option name="number" value="00002" />
|
||||
<option name="presentableId" value="LOCAL-00002" />
|
||||
<option name="project" value="LOCAL" />
|
||||
<updated>1705491897073</updated>
|
||||
</task>
|
||||
<task id="LOCAL-00003" summary="Anmeldung läuft">
|
||||
<option name="closed" value="true" />
|
||||
<created>1705501430071</created>
|
||||
<option name="number" value="00003" />
|
||||
<option name="presentableId" value="LOCAL-00003" />
|
||||
<option name="project" value="LOCAL" />
|
||||
<updated>1705501430071</updated>
|
||||
</task>
|
||||
<task id="LOCAL-00004" summary="Abmeldung gefixt">
|
||||
<option name="closed" value="true" />
|
||||
<created>1705501770457</created>
|
||||
<option name="number" value="00004" />
|
||||
<option name="presentableId" value="LOCAL-00004" />
|
||||
<option name="project" value="LOCAL" />
|
||||
<updated>1705501770457</updated>
|
||||
</task>
|
||||
<task id="LOCAL-00005" summary="Aufgabe 1 ca 80%">
|
||||
<option name="closed" value="true" />
|
||||
<created>1705630515269</created>
|
||||
<option name="number" value="00005" />
|
||||
<option name="presentableId" value="LOCAL-00005" />
|
||||
<option name="project" value="LOCAL" />
|
||||
<updated>1705630515269</updated>
|
||||
</task>
|
||||
<task id="LOCAL-00006" summary="Aufgabe 1">
|
||||
<option name="closed" value="true" />
|
||||
<created>1705673592045</created>
|
||||
<option name="number" value="00006" />
|
||||
<option name="presentableId" value="LOCAL-00006" />
|
||||
<option name="project" value="LOCAL" />
|
||||
<updated>1705673592045</updated>
|
||||
</task>
|
||||
<task id="LOCAL-00007" summary="Bewertungs model">
|
||||
<option name="closed" value="true" />
|
||||
<created>1705675225498</created>
|
||||
<option name="number" value="00007" />
|
||||
<option name="presentableId" value="LOCAL-00007" />
|
||||
<option name="project" value="LOCAL" />
|
||||
<updated>1705675225498</updated>
|
||||
</task>
|
||||
<task id="LOCAL-00008" summary="Alles bis auf paar sachen">
|
||||
<option name="closed" value="true" />
|
||||
<created>1705679416721</created>
|
||||
<option name="number" value="00008" />
|
||||
<option name="presentableId" value="LOCAL-00008" />
|
||||
<option name="project" value="LOCAL" />
|
||||
<updated>1705679416721</updated>
|
||||
</task>
|
||||
<option name="localTasksCounter" value="9" />
|
||||
<servers />
|
||||
</component>
|
||||
<component name="TypeScriptGeneratedFilesManager">
|
||||
<option name="version" value="3" />
|
||||
</component>
|
||||
<component name="VcsManagerConfiguration">
|
||||
<MESSAGE value="Webseite ohne Anmeldung läuft auf laravel" />
|
||||
<MESSAGE value="Anmeldung läuft" />
|
||||
<MESSAGE value="Abmeldung gefixt" />
|
||||
<MESSAGE value="Aufgabe 1 ca 80%" />
|
||||
<MESSAGE value="Aufgabe 1" />
|
||||
<MESSAGE value="Bewertungs model" />
|
||||
<MESSAGE value="Alles bis auf paar sachen" />
|
||||
<option name="LAST_COMMIT_MESSAGE" value="Alles bis auf paar sachen" />
|
||||
</component>
|
||||
</project>
|
||||
1
M3/.idea/sqldialects.xml
generated
1
M3/.idea/sqldialects.xml
generated
@@ -1,7 +1,6 @@
|
||||
<?xml version="1.0" encoding="UTF-8"?>
|
||||
<project version="4">
|
||||
<component name="SqlDialectMappings">
|
||||
<file url="file://$PROJECT_DIR$/werbeseite_daten.sql" dialect="MariaDB" />
|
||||
<file url="PROJECT" dialect="MariaDB" />
|
||||
</component>
|
||||
</project>
|
||||
5
M4/.idea/M4.iml
generated
5
M4/.idea/M4.iml
generated
@@ -1,7 +1,10 @@
|
||||
<?xml version="1.0" encoding="UTF-8"?>
|
||||
<module type="WEB_MODULE" version="4">
|
||||
<component name="NewModuleRootManager">
|
||||
<content url="file://$MODULE_DIR$" />
|
||||
<content url="file://$MODULE_DIR$">
|
||||
<excludeFolder url="file://$MODULE_DIR$/emensa/vendor/composer" />
|
||||
<excludeFolder url="file://$MODULE_DIR$/emensa/vendor/eftec/bladeone" />
|
||||
</content>
|
||||
<orderEntry type="inheritedJdk" />
|
||||
<orderEntry type="sourceFolder" forTests="false" />
|
||||
</component>
|
||||
|
||||
8
M4/.idea/php.xml
generated
8
M4/.idea/php.xml
generated
@@ -10,7 +10,13 @@
|
||||
<option name="highlightLevel" value="WARNING" />
|
||||
<option name="transferred" value="true" />
|
||||
</component>
|
||||
<component name="PhpProjectSharedConfiguration" php_language_level="8.0" />
|
||||
<component name="PhpIncludePathManager">
|
||||
<include_path>
|
||||
<path value="$PROJECT_DIR$/emensa/vendor/composer" />
|
||||
<path value="$PROJECT_DIR$/emensa/vendor/eftec/bladeone" />
|
||||
</include_path>
|
||||
</component>
|
||||
<component name="PhpProjectSharedConfiguration" php_language_level="8.2" />
|
||||
<component name="PhpStanOptionsConfiguration">
|
||||
<option name="transferred" value="true" />
|
||||
</component>
|
||||
|
||||
@@ -21,7 +21,7 @@ $newletterCount = 0;
|
||||
$link = mysqli_connect(
|
||||
"127.0.0.1", // Host der Datenbank
|
||||
"root", // Benutzername zur Anmeldung
|
||||
"admin", // Passwort
|
||||
"wm#32", // Passwort
|
||||
"emensawerbeseite" // Auswahl der Datenbanken (bzw. des Schemas)
|
||||
);
|
||||
|
||||
|
||||
@@ -2,7 +2,7 @@
|
||||
return [
|
||||
'host' => 'localhost', // 'localhost' or '127.0.0.1'
|
||||
'user' => 'root', // '<yourusername>'
|
||||
'password' => 'admin', // '<yourpassword>'
|
||||
'password' => 'wm#32', // '<yourpassword>'
|
||||
'database' => 'emensawerbeseite',
|
||||
// optionally: set port below if it differs from the default 3306
|
||||
// 'port' => 13306 // !! this is not your webserver port, but the mariadb port
|
||||
|
||||
34
M4/emensa/storage/cache/examples.m4_7c_gerichte_24dbedd391e1a47ee18b0686a8182fae7dda8164.bladec
vendored
Normal file
34
M4/emensa/storage/cache/examples.m4_7c_gerichte_24dbedd391e1a47ee18b0686a8182fae7dda8164.bladec
vendored
Normal file
@@ -0,0 +1,34 @@
|
||||
<!DOCTYPE html>
|
||||
<html lang="de">
|
||||
<head>
|
||||
<meta charset="UTF-8">
|
||||
<title>Beispiel: Daten aus der Datenbank</title>
|
||||
|
||||
</head>
|
||||
<body>
|
||||
|
||||
<?php if(isset($data['error'])): ?>
|
||||
<h1>Es gab ein Problem mit der Datenbankverbindung</h1>
|
||||
<p>Fehlermeldung</p>
|
||||
<pre> <?php echo \htmlentities($data['beschreibung']??'', ENT_QUOTES, 'UTF-8', false); ?></pre>
|
||||
|
||||
<?php else: ?>
|
||||
|
||||
<article>
|
||||
<h1>Daten aus der Datenbank der Tabelle: Kategorien</h1>
|
||||
|
||||
<ul>
|
||||
<?php $__empty_1 = true; foreach($data as $a): $__empty_1 = false; ?>
|
||||
<?php if(!empty($a['name'])): ?>
|
||||
<li><?php echo \htmlentities($a['name']??'', ENT_QUOTES, 'UTF-8', false); ?></li>
|
||||
<?php endif; ?>
|
||||
|
||||
<?php endforeach; if ($__empty_1): ?>
|
||||
<li>Es sind keine Gerichte vorhanden</li>
|
||||
<?php endif; ?>
|
||||
</ul>
|
||||
</article>
|
||||
<?php endif; ?>
|
||||
|
||||
</body>
|
||||
</html>
|
||||
30
M4/emensa/storage/cache/layouts.main_layout_9f099eee303f11c8c3f1b61e05a54e7376df8add.bladec
vendored
Normal file
30
M4/emensa/storage/cache/layouts.main_layout_9f099eee303f11c8c3f1b61e05a54e7376df8add.bladec
vendored
Normal file
@@ -0,0 +1,30 @@
|
||||
<!doctype html>
|
||||
<html class="no-js" lang="DE">
|
||||
<head>
|
||||
<meta charset="utf-8">
|
||||
|
||||
<title><?php echo \htmlentities($title??'', ENT_QUOTES, 'UTF-8', false); ?></title>
|
||||
|
||||
<?php echo $this->yieldContent("header"); ?>
|
||||
|
||||
<!-- good developers check the markup ;) -->
|
||||
</head>
|
||||
<body>
|
||||
<?php echo $this->yieldContent("nav"); ?>
|
||||
<hr>
|
||||
<div class="grid">
|
||||
<div></div>
|
||||
<div>
|
||||
<?php echo $this->yieldContent("text"); ?>
|
||||
|
||||
<?php echo $this->yieldContent("gerichte"); ?>
|
||||
</div>
|
||||
<div></div>
|
||||
</div>
|
||||
<footer>
|
||||
<table class="fusszeile">
|
||||
<?php echo $this->yieldContent("footer"); ?>
|
||||
</table>
|
||||
</footer>
|
||||
</body>
|
||||
</html>
|
||||
62
M4/emensa/storage/cache/main.index_1dae39c16001572743356f32c7852146f9bbc1ec.bladec
vendored
Normal file
62
M4/emensa/storage/cache/main.index_1dae39c16001572743356f32c7852146f9bbc1ec.bladec
vendored
Normal file
@@ -0,0 +1,62 @@
|
||||
<?php $_shouldextend[1]=1; ?>
|
||||
|
||||
<?php $this->startSection("header"); ?>
|
||||
<link rel="stylesheet" href="/css/style.css">
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("nav"); ?>
|
||||
<div class="grid">
|
||||
<div>
|
||||
<img src="/img/fh-logo.jpg" alt="FH-Logo">
|
||||
</div>
|
||||
<div>
|
||||
<a href="#ankündigung">Ankündigung</a>
|
||||
<a href="#speisen">Speisen</a>
|
||||
<a href="#zahlen">Zahlen</a>
|
||||
<a href="#kontakt">Kontakt</a>
|
||||
<a href="#wichtig">Wichtig für uns</a>
|
||||
|
||||
</div>
|
||||
</div>
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("text"); ?>
|
||||
|
||||
<img src="/img/mensa21.jpg" alt="Essen">
|
||||
<h1 id="ankündigung">Bald gibt es auch Essen online ;)</h1>
|
||||
<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et
|
||||
dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet
|
||||
clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,
|
||||
consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,
|
||||
sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no
|
||||
sea takimata sanctus est Lorem ipsum dolor sit amet.</p>
|
||||
<h1 id="speisen">Köstlichkeiten die Sie erwarten</h1>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("gerichte"); ?>
|
||||
|
||||
<?php if(isset($data['error'])): ?>
|
||||
<h1>Es gab ein Problem mit der Datenbankverbindung</h1>
|
||||
<p>Fehlermeldung</p>
|
||||
<pre> <?php echo \htmlentities($data['beschreibung']??'', ENT_QUOTES, 'UTF-8', false); ?></pre>
|
||||
|
||||
<?php else: ?>
|
||||
<?php
|
||||
echo $data["gericht"];
|
||||
echo $data["allergene"];
|
||||
?>
|
||||
<?php endif; ?>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("footer"); ?>
|
||||
|
||||
<tr>
|
||||
<td>(c) E-Mensa GmbH</td>
|
||||
<td>Şafak Hazinedar & Robert Joel</td>
|
||||
<td><a href="">Impressum</a></td>
|
||||
</tr>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
<?php if (isset($_shouldextend[1])) { echo $this->runChild("layouts.main_layout", ['title' => "E-Mensa"]); } ?>
|
||||
8
M5/.idea/.gitignore
generated
vendored
Normal file
8
M5/.idea/.gitignore
generated
vendored
Normal file
@@ -0,0 +1,8 @@
|
||||
# Default ignored files
|
||||
/shelf/
|
||||
/workspace.xml
|
||||
# Editor-based HTTP Client requests
|
||||
/httpRequests/
|
||||
# Datasource local storage ignored files
|
||||
/dataSources/
|
||||
/dataSources.local.xml
|
||||
8
M5/.idea/M4.iml
generated
Normal file
8
M5/.idea/M4.iml
generated
Normal file
@@ -0,0 +1,8 @@
|
||||
<?xml version="1.0" encoding="UTF-8"?>
|
||||
<module type="WEB_MODULE" version="4">
|
||||
<component name="NewModuleRootManager">
|
||||
<content url="file://$MODULE_DIR$" />
|
||||
<orderEntry type="inheritedJdk" />
|
||||
<orderEntry type="sourceFolder" forTests="false" />
|
||||
</component>
|
||||
</module>
|
||||
20
M5/.idea/M5.iml
generated
Normal file
20
M5/.idea/M5.iml
generated
Normal file
@@ -0,0 +1,20 @@
|
||||
<?xml version="1.0" encoding="UTF-8"?>
|
||||
<module type="WEB_MODULE" version="4">
|
||||
<component name="NewModuleRootManager">
|
||||
<content url="file://$MODULE_DIR$">
|
||||
<sourceFolder url="file://$MODULE_DIR$/emensa/spec" isTestSource="true" />
|
||||
<sourceFolder url="file://$MODULE_DIR$/emensa/tests" isTestSource="true" />
|
||||
<sourceFolder url="file://$MODULE_DIR$/spec" isTestSource="true" />
|
||||
<sourceFolder url="file://$MODULE_DIR$/tests" isTestSource="true" />
|
||||
<excludeFolder url="file://$MODULE_DIR$/emensa/vendor/composer" />
|
||||
<excludeFolder url="file://$MODULE_DIR$/emensa/vendor/eftec/bladeone" />
|
||||
<excludeFolder url="file://$MODULE_DIR$/emensa/vendor/monolog/monolog" />
|
||||
<excludeFolder url="file://$MODULE_DIR$/emensa/vendor/psr/log" />
|
||||
<excludeFolder url="file://$MODULE_DIR$/vendor/composer" />
|
||||
<excludeFolder url="file://$MODULE_DIR$/vendor/monolog/monolog" />
|
||||
<excludeFolder url="file://$MODULE_DIR$/vendor/psr/log" />
|
||||
</content>
|
||||
<orderEntry type="inheritedJdk" />
|
||||
<orderEntry type="sourceFolder" forTests="false" />
|
||||
</component>
|
||||
</module>
|
||||
18
M5/.idea/codeception.xml
generated
Normal file
18
M5/.idea/codeception.xml
generated
Normal file
@@ -0,0 +1,18 @@
|
||||
<?xml version="1.0" encoding="UTF-8"?>
|
||||
<project version="4">
|
||||
<component name="Codeception">
|
||||
<option name="configurations">
|
||||
<list>
|
||||
<Configuration>
|
||||
<option name="path" value="$PROJECT_DIR$/tests" />
|
||||
</Configuration>
|
||||
<Configuration>
|
||||
<option name="path" value="$PROJECT_DIR$/emensa/tests" />
|
||||
</Configuration>
|
||||
<Configuration>
|
||||
<option name="path" value="$PROJECT_DIR$/tests" />
|
||||
</Configuration>
|
||||
</list>
|
||||
</option>
|
||||
</component>
|
||||
</project>
|
||||
12
M5/.idea/dataSources.xml
generated
Normal file
12
M5/.idea/dataSources.xml
generated
Normal file
@@ -0,0 +1,12 @@
|
||||
<?xml version="1.0" encoding="UTF-8"?>
|
||||
<project version="4">
|
||||
<component name="DataSourceManagerImpl" format="xml" multifile-model="true">
|
||||
<data-source source="LOCAL" name="@localhost" uuid="4d4a3631-9643-46e8-bf05-bcc46f8031b4">
|
||||
<driver-ref>mariadb</driver-ref>
|
||||
<synchronize>true</synchronize>
|
||||
<jdbc-driver>org.mariadb.jdbc.Driver</jdbc-driver>
|
||||
<jdbc-url>jdbc:mariadb://localhost:3306</jdbc-url>
|
||||
<working-dir>$ProjectFileDir$</working-dir>
|
||||
</data-source>
|
||||
</component>
|
||||
</project>
|
||||
8
M5/.idea/modules.xml
generated
Normal file
8
M5/.idea/modules.xml
generated
Normal file
@@ -0,0 +1,8 @@
|
||||
<?xml version="1.0" encoding="UTF-8"?>
|
||||
<project version="4">
|
||||
<component name="ProjectModuleManager">
|
||||
<modules>
|
||||
<module fileurl="file://$PROJECT_DIR$/.idea/M5.iml" filepath="$PROJECT_DIR$/.idea/M5.iml" />
|
||||
</modules>
|
||||
</component>
|
||||
</project>
|
||||
39
M5/.idea/php.xml
generated
Normal file
39
M5/.idea/php.xml
generated
Normal file
@@ -0,0 +1,39 @@
|
||||
<?xml version="1.0" encoding="UTF-8"?>
|
||||
<project version="4">
|
||||
<component name="MessDetectorOptionsConfiguration">
|
||||
<option name="transferred" value="true" />
|
||||
</component>
|
||||
<component name="PHPCSFixerOptionsConfiguration">
|
||||
<option name="transferred" value="true" />
|
||||
</component>
|
||||
<component name="PHPCodeSnifferOptionsConfiguration">
|
||||
<option name="highlightLevel" value="WARNING" />
|
||||
<option name="transferred" value="true" />
|
||||
</component>
|
||||
<component name="PhpIncludePathManager">
|
||||
<include_path>
|
||||
<path value="$PROJECT_DIR$/emensa/vendor/composer" />
|
||||
<path value="$PROJECT_DIR$/emensa/vendor/eftec/bladeone" />
|
||||
<path value="$PROJECT_DIR$/emensa/vendor/psr/log" />
|
||||
<path value="$PROJECT_DIR$/emensa/vendor/monolog/monolog" />
|
||||
<path value="$PROJECT_DIR$/vendor/composer" />
|
||||
<path value="$PROJECT_DIR$/vendor/psr/log" />
|
||||
<path value="$PROJECT_DIR$/vendor/monolog/monolog" />
|
||||
</include_path>
|
||||
</component>
|
||||
<component name="PhpProjectSharedConfiguration" php_language_level="8.3">
|
||||
<option name="suggestChangeDefaultLanguageLevel" value="false" />
|
||||
</component>
|
||||
<component name="PhpStanOptionsConfiguration">
|
||||
<option name="transferred" value="true" />
|
||||
</component>
|
||||
<component name="PhpUnit">
|
||||
<phpunit_settings>
|
||||
<PhpUnitSettings custom_loader_path="$PROJECT_DIR$/emensa/vendor/autoload.php" />
|
||||
<PhpUnitSettings custom_loader_path="$PROJECT_DIR$/vendor/autoload.php" />
|
||||
</phpunit_settings>
|
||||
</component>
|
||||
<component name="PsalmOptionsConfiguration">
|
||||
<option name="transferred" value="true" />
|
||||
</component>
|
||||
</project>
|
||||
16
M5/.idea/phpspec.xml
generated
Normal file
16
M5/.idea/phpspec.xml
generated
Normal file
@@ -0,0 +1,16 @@
|
||||
<?xml version="1.0" encoding="UTF-8"?>
|
||||
<project version="4">
|
||||
<component name="PHPSpec">
|
||||
<suites>
|
||||
<PhpSpecSuiteConfiguration>
|
||||
<option name="myPath" value="$PROJECT_DIR$" />
|
||||
</PhpSpecSuiteConfiguration>
|
||||
<PhpSpecSuiteConfiguration>
|
||||
<option name="myPath" value="$PROJECT_DIR$/emensa" />
|
||||
</PhpSpecSuiteConfiguration>
|
||||
<PhpSpecSuiteConfiguration>
|
||||
<option name="myPath" value="$PROJECT_DIR$" />
|
||||
</PhpSpecSuiteConfiguration>
|
||||
</suites>
|
||||
</component>
|
||||
</project>
|
||||
11
M5/.idea/phpunit.xml
generated
Normal file
11
M5/.idea/phpunit.xml
generated
Normal file
@@ -0,0 +1,11 @@
|
||||
<?xml version="1.0" encoding="UTF-8"?>
|
||||
<project version="4">
|
||||
<component name="PHPUnit">
|
||||
<option name="directories">
|
||||
<list>
|
||||
<option value="$PROJECT_DIR$/emensa/tests" />
|
||||
<option value="$PROJECT_DIR$/tests" />
|
||||
</list>
|
||||
</option>
|
||||
</component>
|
||||
</project>
|
||||
6
M5/.idea/sqldialects.xml
generated
Normal file
6
M5/.idea/sqldialects.xml
generated
Normal file
@@ -0,0 +1,6 @@
|
||||
<?xml version="1.0" encoding="UTF-8"?>
|
||||
<project version="4">
|
||||
<component name="SqlDialectMappings">
|
||||
<file url="PROJECT" dialect="MariaDB" />
|
||||
</component>
|
||||
</project>
|
||||
6
M5/.idea/vcs.xml
generated
Normal file
6
M5/.idea/vcs.xml
generated
Normal file
@@ -0,0 +1,6 @@
|
||||
<?xml version="1.0" encoding="UTF-8"?>
|
||||
<project version="4">
|
||||
<component name="VcsDirectoryMappings">
|
||||
<mapping directory="$PROJECT_DIR$/.." vcs="Git" />
|
||||
</component>
|
||||
</project>
|
||||
15
M5/Dossier/AlterAndUpdate.txt
Normal file
15
M5/Dossier/AlterAndUpdate.txt
Normal file
@@ -0,0 +1,15 @@
|
||||
ALTER TABLE gericht ADD bildname varchar(200)
|
||||
|
||||
UPDATE gericht SET bildname = '01_bratkartoffel.jpg' WHERE id=1;
|
||||
UPDATE gericht SET bildname = '03_bratkartoffel.jpg' WHERE id=3;
|
||||
UPDATE gericht SET bildname = '04_tofu.jpg' WHERE id=4;
|
||||
UPDATE gericht SET bildname = '09_suppe.jpg' WHERE id=9;
|
||||
UPDATE gericht SET bildname = '06_lasagne.jpg' WHERE id=6;
|
||||
UPDATE gericht SET bildname = '10_forelle.jpg' WHERE id=10;
|
||||
UPDATE gericht SET bildname = '11_soup.jpg' WHERE id=11;
|
||||
UPDATE gericht SET bildname = '12_kassler.jpg' WHERE id=12;
|
||||
UPDATE gericht SET bildname = '13_reibekuchen.jpg' WHERE id=13;
|
||||
UPDATE gericht SET bildname = '15_pilze.jpg' WHERE id=15;
|
||||
UPDATE gericht SET bildname = '17_broetchen.jpg' WHERE id=17;
|
||||
UPDATE gericht SET bildname = '19_mousse.jpg' WHERE id=19;
|
||||
UPDATE gericht SET bildname = '20_suppe.jpg' WHERE id=20;
|
||||
144
M5/Dossier/M5.md
Normal file
144
M5/Dossier/M5.md
Normal file
@@ -0,0 +1,144 @@
|
||||
# Aufgabe 1
|
||||
## 1. Tabelle Benutzer anlegen
|
||||
``` sql
|
||||
CREATE TABLE benutzer (
|
||||
id BIGINT AUTO_INCREMENT PRIMARY KEY,
|
||||
name VARCHAR(200) NOT NULL,
|
||||
email VARCHAR(100) NOT NULL UNIQUE,
|
||||
passwort VARCHAR(200) NOT NULL,
|
||||
admin TINYINT(1) NOT NULL DEFAULT 0,
|
||||
anzahlfehler INT NOT NULL DEFAULT 0,
|
||||
anzahlanmeldungen INT NOT NULL DEFAULT 0,
|
||||
letzteanmeldung DATETIME DEFAULT NULL,
|
||||
letzterfehler DATETIME DEFAULT NULL
|
||||
);
|
||||
```
|
||||
## 3. Admin anlegen
|
||||
```sql
|
||||
INSERT INTO benutzer (name, email, passwort, admin)
|
||||
VALUES ('admin', 'admin@emensa.example', '2e2b6533a81bc15430cf65de46dc097eeb5ba70c', 1);
|
||||
-- '2e2b6533a81bc15430cf65de46dc097eeb5ba70c' = 'passwort'
|
||||
```
|
||||
## 9. Transaktion
|
||||
`mysqli_begin_transaction` und `mysqli_commit` sind Funktionen, die im Zusammenhang mit Transaktionen in MySQL verwendet werden. Eine Transaktion ist eine Sequenz von Datenbankoperationen, die als eine einzige logische Einheit ausgeführt wird. Transaktionen gewährleisten, dass entweder alle Operationen erfolgreich durchgeführt werden oder keine von ihnen, wenn ein Fehler auftritt. Dieses Konzept wird als ACID-Eigenschaften bekannt: Atomarität, Konsistenz, Isolation und Dauerhaftigkeit.
|
||||
- **`mysqli_begin_transaction`:** Diese Funktion startet eine neue Transaktion. Ab diesem Punkt können mehrere SQL-Operationen ausgeführt werden, die entweder alle gleichzeitig bestätigt (commited) oder abgebrochen (rolled back) werden. Das heißt, keine der Operationen ist für andere Verbindungen sichtbar, bis sie bestätigt werden.
|
||||
- **`mysqli_commit`:** Diese Funktion wird verwendet, um alle Änderungen, die während der Transaktion gemacht wurden, zu bestätigen und dauerhaft in der Datenbank zu speichern. Nach dem Aufruf dieser Funktion werden alle Änderungen für andere Benutzer und Prozesse sichtbar.
|
||||
|
||||
Im Kontext des gegebenen PHP-Codes wird eine Transaktion verwendet, um die Sicherheit und Integrität der Datenbank zu erhöhen, wenn die Informationen eines Benutzers aktualisiert werden. Hier ist ein Überblick über die Abläufe in der Funktion `anmelden`:
|
||||
1. Eine Verbindung zur Datenbank wird hergestellt (`connectdb`).
|
||||
2. Es wird ein SQL-Select-Statement ausgeführt, um den Benutzer mit der spezifizierten E-Mail zu finden.
|
||||
3. Wenn kein Passwort für den Benutzer gesetzt ist, wird die Funktion frühzeitig mit einem Rückgabewert von 0 beendet.
|
||||
4. Wenn das Passwort des Benutzers übereinstimmt, werden die folgenden Schritte innerhalb einer Transaktion durchgeführt:
|
||||
- Die Transaktion wird mit `mysqli_begin_transaction` begonnen.
|
||||
- Ein Update-Statement wird vorbereitet und ausgeführt, um die `letzteanmeldung` auf die aktuelle Zeit und `anzahlfehler` auf 0 zu setzen.
|
||||
- Ein weiteres Update-Statement wird vorbereitet und ausgeführt, um die `anzahlanmeldungen` um eins zu erhöhen.
|
||||
- Die Transaktion wird mit `mysqli_commit` abgeschlossen.
|
||||
- Sitzungsvariablen werden gesetzt, und die Funktion gibt 1 zurück, was eine erfolgreiche Anmeldung bedeutet.
|
||||
5. Wenn das Passwort nicht übereinstimmt, wird ebenfalls eine Transaktion durchgeführt:
|
||||
- Die Transaktion wird mit `mysqli_begin_transaction` begonnen.
|
||||
- Ein Update-Statement wird vorbereitet und ausgeführt, um `anzahlfehler` um eins zu erhöhen und `letzterfehler` auf die aktuelle Zeit zu setzen.
|
||||
- Die Transaktion wird mit `mysqli_commit` abgeschlossen.
|
||||
- Die Funktion gibt 0 zurück, was eine fehlgeschlagene Anmeldung bedeutet.
|
||||
|
||||
Durch die Verwendung von Transaktionen wird sichergestellt, dass, wenn z.B. ein Fehler bei einer der Update-Operationen auftritt oder die Verbindung zur Datenbank verloren geht, keine teilweise aktualisierten Daten zurückbleiben, was zu Inkonsistenzen führen könnte. Stattdessen würde die gesamte Transaktion automatisch zurückgerollt oder abgebrochen werden (`rollback`), sodass die Datenbank in einem konsistenten Zustand bleibt.
|
||||
|
||||
# Aufgabe 2
|
||||
```sql
|
||||
ALTER TABLE gericht ADD bildname varchar(200);
|
||||
|
||||
UPDATE gericht SET bildname = '01_bratkartoffel.jpg' WHERE id=1;
|
||||
UPDATE gericht SET bildname = '03_bratkartoffel.jpg' WHERE id=3;
|
||||
UPDATE gericht SET bildname = '04_tofu.jpg' WHERE id=4;
|
||||
UPDATE gericht SET bildname = '09_suppe.jpg' WHERE id=9;
|
||||
UPDATE gericht SET bildname = '06_lasagne.jpg' WHERE id=6;
|
||||
UPDATE gericht SET bildname = '10_forelle.jpg' WHERE id=10;
|
||||
UPDATE gericht SET bildname = '11_soup.jpg' WHERE id=11;
|
||||
UPDATE gericht SET bildname = '12_kassler.jpg' WHERE id=12;
|
||||
UPDATE gericht SET bildname = '13_reibekuchen.jpg' WHERE id=13;
|
||||
UPDATE gericht SET bildname = '15_pilze.jpg' WHERE id=15;
|
||||
UPDATE gericht SET bildname = '17_broetchen.jpg' WHERE id=17;
|
||||
UPDATE gericht SET bildname = '19_mousse.jpg' WHERE id=19;
|
||||
UPDATE gericht SET bildname = '20_suppe.jpg' WHERE id=20;
|
||||
```
|
||||
|
||||
# Aufgabe 3
|
||||
1. Composer installieren
|
||||
1. **Download der Composer-Installer-EXE:** Gehen Sie zur offiziellen Composer-Website [getcomposer.org](https://getcomposer.org/) und klicken Sie auf den Button "Download" oder direkt auf "Composer-Setup.exe", um den Installer für Windows herunterzuladen.
|
||||
2. **Ausführen des Installers:** Führen Sie die heruntergeladene "Composer-Setup.exe"-Datei aus. Es wird ein Installationsassistent gestartet.
|
||||
3. **Installationsoptionen:** Folgen Sie den Anweisungen im Installationsassistenten. Der Assistent wird Sie nach dem Pfad zur PHP-Executable fragen. Wenn Sie PHP bereits installiert haben und die Umgebungsvariable `PATH` gesetzt ist, kann der Assistent PHP automatisch finden. Falls nicht, müssen Sie den Pfad zur PHP-Executable (`php.exe`) manuell angeben.
|
||||
4. **Abschluss der Installation:** Führen Sie den Installationsprozess durch. Am Ende können Sie die Option aktivieren, um die Befehlszeileneingabe zu ändern und den Pfad zu Composer in die Windows-Umgebungsvariable `PATH` aufzunehmen. Damit wird Composer global zugänglich gemacht.
|
||||
5. **Überprüfung der Installation:** Öffnen Sie nach Abschluss der Installation die Kommandozeile (CMD) oder PowerShell und geben Sie `composer` ein, um zu überprüfen, ob Composer erfolgreich installiert wurde. Wenn alles korrekt installiert wurde, sollten Informationen und verfügbare Befehle von Composer angezeigt werden.
|
||||
2. Abhängigkeiten laden
|
||||
1. Verzeichnis `./emensa` wechseln
|
||||
2. `composer require monolog/monolog` ausführen
|
||||
|
||||
# Aufgabe 4
|
||||
|
||||
```sql
|
||||
-- a)
|
||||
CREATE OR REPLACE
|
||||
VIEW view_suppengerichte
|
||||
AS select * from gericht
|
||||
WHERE name LIKE '%suppe%';
|
||||
|
||||
-- b)
|
||||
CREATE OR REPLACE
|
||||
VIEW view_anmeldungen
|
||||
AS select name,anzahlanmeldungen
|
||||
from benutzer
|
||||
ORDER BY anzahlanmeldungen DESC;
|
||||
|
||||
-- c)
|
||||
CREATE OR REPLACE VIEW view_kategoriegerichte_vegetarisch
|
||||
AS select gericht.name as gericht_name,
|
||||
vegetarisch,
|
||||
kategorie.name as katergorie_name
|
||||
from gericht, kategorie
|
||||
WHERE vegetarisch = 1 ;
|
||||
```
|
||||
|
||||
# Aufgabe 5
|
||||
## Was ist eine SQL-Prozedur
|
||||
Eine SQL-Prozedur ist eine Sammlung von SQL-Anweisungen, die unter einem Namen gespeichert werden und bei Bedarf aufgerufen werden können. Die Struktur einer SQL-Prozedur umfasst in der Regel zusammengesetzte Anweisungen, die durch die Schlüsselwörter BEGIN und END begrenzt sind[1]. Gespeicherte Prozeduren ermöglichen es, komplexe Abläufe von Anweisungen vom Datenbank-Client auszuführen und sind somit ein eigenständiger Befehl, der eine Abfolge gespeicherter Befehle darstellt[2].
|
||||
|
||||
Diese Prozedur kann dann mithilfe des Befehls EXECUTE aufgerufen werden.
|
||||
|
||||
Gespeicherte Prozeduren bieten Vorteile wie die Wiederverwendbarkeit von Code, die Verbesserung der Leistung und die Reduzierung von Netzwerkverkehr, da die gespeicherten Prozeduren einmal erstellt und dann mehrmals aufgerufen werden können[2].
|
||||
|
||||
Quellen:
|
||||
1. https://www.ibm.com/docs/de/db2/11.1?topic=procedures-structure-sql
|
||||
2. https://de.wikipedia.org/wiki/Gespeicherte_Prozedur
|
||||
3. https://www.ibm.com/docs/de/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0008329.html
|
||||
4. https://learn.microsoft.com/de-de/sql/relational-databases/stored-procedures/create-a-stored-procedure?view=sql-server-ver16
|
||||
5. https://learn.microsoft.com/de-de/sql/relational-databases/stored-procedures/execute-a-stored-procedure?view=sql-server-ver16
|
||||
|
||||
## Lösung
|
||||
### a)
|
||||
``` sql
|
||||
CREATE PROCEDURE incrementAnzahlAnmeldungen (IN benutzerid INT)
|
||||
BEGIN
|
||||
UPDATE benutzer
|
||||
SET anzahlanmeldungen = anzahlanmeldungen + 1
|
||||
WHERE id = benutzerid;
|
||||
END;
|
||||
```
|
||||
Die Prozedur die in M5_5.sql hinterlegt ist, muss einmal manuell ausgeführt werden.
|
||||
|
||||
### c)
|
||||
Die Anwendung die am naheliegensten sind, wären das Incrementieren der `anzahlfehler` analog zu Teilaufgabe (a).
|
||||
Darüber hinaus könnten alle Queries als Stored Procedures von der
|
||||
Emensa-Werbeseite aufgerufen werden und dies hätte mehrere Vorteile.
|
||||
Zum einen hätte es einen _Security-Vorteil_, wenn alle Queries der Werbeseiten als
|
||||
Proceduren gespeichert werden würedn. Dadruch wäre es nähmlich möglich alle
|
||||
erwarteten Queries abzuspeichern und der Werbeseite nur die _Berechtigung zum
|
||||
Verwenden von Stored-Procedures_ zu geben. Dadurch kann nur noch in definierten
|
||||
Schnittstellen mit der Dankenbank interagiert werden.
|
||||
Darüber hinaus hat es wohl auch einen Vorteil gegenüber SQL-Injections.
|
||||
Ein letzter Vorteil wäre, dass im PHP-Code einfach kurz die Prozedur aufgerufen
|
||||
werdne kann statt lange Query-Strings zu haben.
|
||||
Somit würde ich wahrscheinlich - alleine für die _Lesbarkeit_ - diese Query in
|
||||
eine Stored Procedure auslagern.
|
||||
Ein weiterer Vorteil wäre, dass Stored-Procedures _vor-opitimiert_ sind.
|
||||
Darüber hinaus kann durch das Speichern der Queries in der Datenbank
|
||||
Businesslogik "bewahren" unabhängig von git.
|
||||
... Verkapselung....
|
||||
22
M5/Dossier/emensa/README.md
Normal file
22
M5/Dossier/emensa/README.md
Normal file
@@ -0,0 +1,22 @@
|
||||
# Routingscript MVC
|
||||
|
||||
little routing script for use in DBWT
|
||||
|
||||
intended to run with only one dependency (bladeone).
|
||||
|
||||
## usage
|
||||
|
||||
* start this script by either executing `start_server.bat` or running `php -S 127.0.0.1:9000 -t public` in a shell from the project´s root directory.
|
||||
|
||||
* [open the website](http://127.0.0.1:9000/)
|
||||
|
||||
## folder overview
|
||||
|
||||
* `bin/` is only necessary if you need to use composer and dont have it installed already
|
||||
* `config/` holds configuration files
|
||||
* `controllers/` contains all Controller Classes
|
||||
* `models/` contains the Model Classes
|
||||
* `public/` is the web root for your http server and contains the routing script itself, next to resources that will be accessible by http clients (css, js, images, etc.)
|
||||
* `storage/` is necessary to hold Blade Cache Files
|
||||
* `views/` holds all View Files
|
||||
|
||||
BIN
M5/Dossier/emensa/bin/composer.phar
Normal file
BIN
M5/Dossier/emensa/bin/composer.phar
Normal file
Binary file not shown.
10
M5/Dossier/emensa/composer.json
Normal file
10
M5/Dossier/emensa/composer.json
Normal file
@@ -0,0 +1,10 @@
|
||||
{
|
||||
"name": "emensa/mvc",
|
||||
"description": "routing script for module Datenbanken und Webtechnologien MVC",
|
||||
"license": "proprietary",
|
||||
"require": {
|
||||
"eftec/bladeone": "^4.1",
|
||||
"ext-mysqli": "*",
|
||||
"monolog/monolog": "^3.5"
|
||||
}
|
||||
}
|
||||
231
M5/Dossier/emensa/composer.lock
generated
Normal file
231
M5/Dossier/emensa/composer.lock
generated
Normal file
@@ -0,0 +1,231 @@
|
||||
{
|
||||
"_readme": [
|
||||
"This file locks the dependencies of your project to a known state",
|
||||
"Read more about it at https://getcomposer.org/doc/01-basic-usage.md#installing-dependencies",
|
||||
"This file is @generated automatically"
|
||||
],
|
||||
"content-hash": "56e35407c924fe62af5e2eb164530d54",
|
||||
"packages": [
|
||||
{
|
||||
"name": "eftec/bladeone",
|
||||
"version": "4.9",
|
||||
"source": {
|
||||
"type": "git",
|
||||
"url": "https://github.com/EFTEC/BladeOne.git",
|
||||
"reference": "019036c226086fbe7591360d260067c5d82400ca"
|
||||
},
|
||||
"dist": {
|
||||
"type": "zip",
|
||||
"url": "https://api.github.com/repos/EFTEC/BladeOne/zipball/019036c226086fbe7591360d260067c5d82400ca",
|
||||
"reference": "019036c226086fbe7591360d260067c5d82400ca",
|
||||
"shasum": ""
|
||||
},
|
||||
"require": {
|
||||
"ext-json": "*",
|
||||
"php": ">=7.2.5"
|
||||
},
|
||||
"require-dev": {
|
||||
"phpunit/phpunit": "^8.5.23"
|
||||
},
|
||||
"suggest": {
|
||||
"eftec/bladeonehtml": "Extension to create forms",
|
||||
"ext-mbstring": "This extension is used if it's active"
|
||||
},
|
||||
"bin": [
|
||||
"lib/bladeonecli"
|
||||
],
|
||||
"type": "library",
|
||||
"autoload": {
|
||||
"psr-4": {
|
||||
"eftec\\bladeone\\": "lib/"
|
||||
}
|
||||
},
|
||||
"notification-url": "https://packagist.org/downloads/",
|
||||
"license": [
|
||||
"MIT"
|
||||
],
|
||||
"authors": [
|
||||
{
|
||||
"name": "Jorge Patricio Castro Castillo",
|
||||
"email": "jcastro@eftec.cl"
|
||||
}
|
||||
],
|
||||
"description": "The standalone version Blade Template Engine from Laravel in a single php file",
|
||||
"homepage": "https://github.com/EFTEC/BladeOne",
|
||||
"keywords": [
|
||||
"blade",
|
||||
"php",
|
||||
"template",
|
||||
"templating",
|
||||
"view"
|
||||
],
|
||||
"support": {
|
||||
"issues": "https://github.com/EFTEC/BladeOne/issues",
|
||||
"source": "https://github.com/EFTEC/BladeOne/tree/4.9"
|
||||
},
|
||||
"time": "2023-05-01T12:48:42+00:00"
|
||||
},
|
||||
{
|
||||
"name": "monolog/monolog",
|
||||
"version": "3.5.0",
|
||||
"source": {
|
||||
"type": "git",
|
||||
"url": "https://github.com/Seldaek/monolog.git",
|
||||
"reference": "c915e2634718dbc8a4a15c61b0e62e7a44e14448"
|
||||
},
|
||||
"dist": {
|
||||
"type": "zip",
|
||||
"url": "https://api.github.com/repos/Seldaek/monolog/zipball/c915e2634718dbc8a4a15c61b0e62e7a44e14448",
|
||||
"reference": "c915e2634718dbc8a4a15c61b0e62e7a44e14448",
|
||||
"shasum": ""
|
||||
},
|
||||
"require": {
|
||||
"php": ">=8.1",
|
||||
"psr/log": "^2.0 || ^3.0"
|
||||
},
|
||||
"provide": {
|
||||
"psr/log-implementation": "3.0.0"
|
||||
},
|
||||
"require-dev": {
|
||||
"aws/aws-sdk-php": "^3.0",
|
||||
"doctrine/couchdb": "~1.0@dev",
|
||||
"elasticsearch/elasticsearch": "^7 || ^8",
|
||||
"ext-json": "*",
|
||||
"graylog2/gelf-php": "^1.4.2 || ^2.0",
|
||||
"guzzlehttp/guzzle": "^7.4.5",
|
||||
"guzzlehttp/psr7": "^2.2",
|
||||
"mongodb/mongodb": "^1.8",
|
||||
"php-amqplib/php-amqplib": "~2.4 || ^3",
|
||||
"phpstan/phpstan": "^1.9",
|
||||
"phpstan/phpstan-deprecation-rules": "^1.0",
|
||||
"phpstan/phpstan-strict-rules": "^1.4",
|
||||
"phpunit/phpunit": "^10.1",
|
||||
"predis/predis": "^1.1 || ^2",
|
||||
"ruflin/elastica": "^7",
|
||||
"symfony/mailer": "^5.4 || ^6",
|
||||
"symfony/mime": "^5.4 || ^6"
|
||||
},
|
||||
"suggest": {
|
||||
"aws/aws-sdk-php": "Allow sending log messages to AWS services like DynamoDB",
|
||||
"doctrine/couchdb": "Allow sending log messages to a CouchDB server",
|
||||
"elasticsearch/elasticsearch": "Allow sending log messages to an Elasticsearch server via official client",
|
||||
"ext-amqp": "Allow sending log messages to an AMQP server (1.0+ required)",
|
||||
"ext-curl": "Required to send log messages using the IFTTTHandler, the LogglyHandler, the SendGridHandler, the SlackWebhookHandler or the TelegramBotHandler",
|
||||
"ext-mbstring": "Allow to work properly with unicode symbols",
|
||||
"ext-mongodb": "Allow sending log messages to a MongoDB server (via driver)",
|
||||
"ext-openssl": "Required to send log messages using SSL",
|
||||
"ext-sockets": "Allow sending log messages to a Syslog server (via UDP driver)",
|
||||
"graylog2/gelf-php": "Allow sending log messages to a GrayLog2 server",
|
||||
"mongodb/mongodb": "Allow sending log messages to a MongoDB server (via library)",
|
||||
"php-amqplib/php-amqplib": "Allow sending log messages to an AMQP server using php-amqplib",
|
||||
"rollbar/rollbar": "Allow sending log messages to Rollbar",
|
||||
"ruflin/elastica": "Allow sending log messages to an Elastic Search server"
|
||||
},
|
||||
"type": "library",
|
||||
"extra": {
|
||||
"branch-alias": {
|
||||
"dev-main": "3.x-dev"
|
||||
}
|
||||
},
|
||||
"autoload": {
|
||||
"psr-4": {
|
||||
"Monolog\\": "src/Monolog"
|
||||
}
|
||||
},
|
||||
"notification-url": "https://packagist.org/downloads/",
|
||||
"license": [
|
||||
"MIT"
|
||||
],
|
||||
"authors": [
|
||||
{
|
||||
"name": "Jordi Boggiano",
|
||||
"email": "j.boggiano@seld.be",
|
||||
"homepage": "https://seld.be"
|
||||
}
|
||||
],
|
||||
"description": "Sends your logs to files, sockets, inboxes, databases and various web services",
|
||||
"homepage": "https://github.com/Seldaek/monolog",
|
||||
"keywords": [
|
||||
"log",
|
||||
"logging",
|
||||
"psr-3"
|
||||
],
|
||||
"support": {
|
||||
"issues": "https://github.com/Seldaek/monolog/issues",
|
||||
"source": "https://github.com/Seldaek/monolog/tree/3.5.0"
|
||||
},
|
||||
"funding": [
|
||||
{
|
||||
"url": "https://github.com/Seldaek",
|
||||
"type": "github"
|
||||
},
|
||||
{
|
||||
"url": "https://tidelift.com/funding/github/packagist/monolog/monolog",
|
||||
"type": "tidelift"
|
||||
}
|
||||
],
|
||||
"time": "2023-10-27T15:32:31+00:00"
|
||||
},
|
||||
{
|
||||
"name": "psr/log",
|
||||
"version": "3.0.0",
|
||||
"source": {
|
||||
"type": "git",
|
||||
"url": "https://github.com/php-fig/log.git",
|
||||
"reference": "fe5ea303b0887d5caefd3d431c3e61ad47037001"
|
||||
},
|
||||
"dist": {
|
||||
"type": "zip",
|
||||
"url": "https://api.github.com/repos/php-fig/log/zipball/fe5ea303b0887d5caefd3d431c3e61ad47037001",
|
||||
"reference": "fe5ea303b0887d5caefd3d431c3e61ad47037001",
|
||||
"shasum": ""
|
||||
},
|
||||
"require": {
|
||||
"php": ">=8.0.0"
|
||||
},
|
||||
"type": "library",
|
||||
"extra": {
|
||||
"branch-alias": {
|
||||
"dev-master": "3.x-dev"
|
||||
}
|
||||
},
|
||||
"autoload": {
|
||||
"psr-4": {
|
||||
"Psr\\Log\\": "src"
|
||||
}
|
||||
},
|
||||
"notification-url": "https://packagist.org/downloads/",
|
||||
"license": [
|
||||
"MIT"
|
||||
],
|
||||
"authors": [
|
||||
{
|
||||
"name": "PHP-FIG",
|
||||
"homepage": "https://www.php-fig.org/"
|
||||
}
|
||||
],
|
||||
"description": "Common interface for logging libraries",
|
||||
"homepage": "https://github.com/php-fig/log",
|
||||
"keywords": [
|
||||
"log",
|
||||
"psr",
|
||||
"psr-3"
|
||||
],
|
||||
"support": {
|
||||
"source": "https://github.com/php-fig/log/tree/3.0.0"
|
||||
},
|
||||
"time": "2021-07-14T16:46:02+00:00"
|
||||
}
|
||||
],
|
||||
"packages-dev": [],
|
||||
"aliases": [],
|
||||
"minimum-stability": "stable",
|
||||
"stability-flags": [],
|
||||
"prefer-stable": false,
|
||||
"prefer-lowest": false,
|
||||
"platform": {
|
||||
"ext-mysqli": "*"
|
||||
},
|
||||
"platform-dev": [],
|
||||
"plugin-api-version": "2.6.0"
|
||||
}
|
||||
9
M5/Dossier/emensa/config/db.php
Normal file
9
M5/Dossier/emensa/config/db.php
Normal file
@@ -0,0 +1,9 @@
|
||||
<?php
|
||||
return [
|
||||
'host' => 'localhost', // 'localhost' or '127.0.0.1'
|
||||
'user' => 'root', // '<yourusername>'
|
||||
'password' => 'admin', // '<yourpassword>'
|
||||
'database' => 'emensawerbeseite',
|
||||
// optionally: set port below if it differs from the default 3306
|
||||
// 'port' => 13306 // !! this is not your webserver port, but the mariadb port
|
||||
];
|
||||
75
M5/Dossier/emensa/controllers/AnmeldungController.php
Normal file
75
M5/Dossier/emensa/controllers/AnmeldungController.php
Normal file
@@ -0,0 +1,75 @@
|
||||
<?php
|
||||
require_once($_SERVER['DOCUMENT_ROOT'].'/../models/benutzer.php');
|
||||
|
||||
|
||||
class AnmeldungController
|
||||
{
|
||||
|
||||
public function start(){
|
||||
return view(
|
||||
'm5_a1.anmeldung',
|
||||
[]
|
||||
);
|
||||
}
|
||||
|
||||
public function anmeldung_verifizieren(RequestData $rd){
|
||||
|
||||
$data = $rd->getPostData();
|
||||
|
||||
$email = $data["email"] ?? NULL;
|
||||
$passwort = $data["passwort"] ?? NULL;
|
||||
|
||||
$anmeldung = anmelden($email, sha1($passwort));
|
||||
|
||||
if($anmeldung){
|
||||
|
||||
$log = logger('anmeldung', '../storage/logs');
|
||||
$log->info('Anmeldung erfolgreich!');
|
||||
}
|
||||
else{
|
||||
|
||||
$log = logger('anmeldung', '../storage/logs');
|
||||
$log->warning('Anmeldung fehlgeschlagen!');
|
||||
}
|
||||
|
||||
return view(
|
||||
'm5_a1.anmeldung_verifizieren',
|
||||
[
|
||||
'email' => $email,
|
||||
'passwort' => $passwort,
|
||||
'anmeldung' => $anmeldung
|
||||
]
|
||||
);
|
||||
}
|
||||
|
||||
public function check(RequestData $rd){
|
||||
|
||||
$data = $rd->getPostData();
|
||||
|
||||
$email = $data["email"] ?? NULL;
|
||||
$passwort = $data["passwort"] ?? NULL;
|
||||
$anmeldung = $data["anmeldung"] ?? NULL;
|
||||
|
||||
return view(
|
||||
'm5_a1.anmeldung',
|
||||
[
|
||||
'email' => $email,
|
||||
'passwort' => $passwort,
|
||||
'anmeldung' => $anmeldung,
|
||||
'data' => $data
|
||||
]
|
||||
);
|
||||
}
|
||||
|
||||
|
||||
function abmelden(){
|
||||
|
||||
session_unset();
|
||||
session_destroy();
|
||||
|
||||
$log = logger('anmeldung', '../storage/logs');
|
||||
$log->info('Abmeldung erfolgreich!');
|
||||
|
||||
return view('m5_a1.abmeldung', []);
|
||||
}
|
||||
}
|
||||
36
M5/Dossier/emensa/controllers/DemoController.php
Normal file
36
M5/Dossier/emensa/controllers/DemoController.php
Normal file
@@ -0,0 +1,36 @@
|
||||
<?php
|
||||
require_once($_SERVER['DOCUMENT_ROOT'].'/../models/gericht.php');
|
||||
require_once($_SERVER['DOCUMENT_ROOT'].'/../models/kategorie.php');
|
||||
|
||||
class DemoController
|
||||
{
|
||||
public function dbconnect() {
|
||||
$data = db_gericht_select_all();
|
||||
// Frage Daten aus kategorie ab:
|
||||
// $data = db_kategorie_select_all();
|
||||
return view('demo.dbdata', ['data' => $data]);
|
||||
}
|
||||
|
||||
public function demo(RequestData $rd) {
|
||||
$vars = [
|
||||
'bgcolor' => $rd->query['bgcolor'] ?? 'ffffff',
|
||||
'name' => $rd->query['name'] ?? 'Dich',
|
||||
'rd' => $rd
|
||||
];
|
||||
return view('demo.demo', $vars);
|
||||
}
|
||||
|
||||
/**
|
||||
* error action for debug purposes
|
||||
* @throws Exception
|
||||
* @noinspection PhpUnusedLocalVariableInspection
|
||||
*/
|
||||
public function error(RequestData $rd) {
|
||||
$test = $rd;
|
||||
throw new Exception("Not implemented");
|
||||
}
|
||||
|
||||
public function requestdata(RequestData $rd) {
|
||||
return view('demo.requestdata', ['rd' => $rd]);
|
||||
}
|
||||
}
|
||||
47
M5/Dossier/emensa/controllers/ExampleController.php
Normal file
47
M5/Dossier/emensa/controllers/ExampleController.php
Normal file
@@ -0,0 +1,47 @@
|
||||
<?php
|
||||
require_once($_SERVER['DOCUMENT_ROOT'].'/../models/kategorie.php');
|
||||
require_once($_SERVER['DOCUMENT_ROOT'].'/../models/gerichte_self.php');
|
||||
|
||||
class ExampleController
|
||||
{
|
||||
public function m4_6a_queryparameter(RequestData $rd) {
|
||||
/*
|
||||
Wenn Sie hier landen:
|
||||
bearbeiten Sie diese Action,
|
||||
so dass Sie die Aufgabe löst
|
||||
*/
|
||||
$rd = $rd->query['name'] ?? 'Kein Name angegeben';
|
||||
|
||||
return view('examples.m4_7a_queryparameter', [
|
||||
'request'=>$rd,
|
||||
'url' => 'http' . (isset($_SERVER['HTTPS']) ? 's' : '') . '://' . "{$_SERVER['HTTP_HOST']}{$_SERVER['REQUEST_URI']}"
|
||||
]);
|
||||
}
|
||||
|
||||
|
||||
public function m4_7b_kategorie() {
|
||||
$data = db_kategorie_select_all();
|
||||
|
||||
return view('examples.m4_7b_kategorie', [
|
||||
'data'=>$data,
|
||||
]);
|
||||
}
|
||||
|
||||
|
||||
public function m4_7c_gerichte() {
|
||||
$data = db_gericht_select_intern();
|
||||
|
||||
return view('examples.m4_7c_gerichte', [
|
||||
'data'=>$data,
|
||||
]);
|
||||
}
|
||||
|
||||
public function m4_7d(RequestData $rd) {
|
||||
|
||||
$rd = $rd->query['no'] ?? 1;
|
||||
if ($rd == 1)
|
||||
return view('examples.pages.m4_7d_page_1', []);
|
||||
elseif ($rd == 2)
|
||||
return view('examples.pages.m4_7d_page_2', []);
|
||||
}
|
||||
}
|
||||
14
M5/Dossier/emensa/controllers/HomeController.php
Normal file
14
M5/Dossier/emensa/controllers/HomeController.php
Normal file
@@ -0,0 +1,14 @@
|
||||
<?php
|
||||
require_once($_SERVER['DOCUMENT_ROOT'].'/../models/gericht.php');
|
||||
|
||||
/* Datei: controllers/HomeController.php */
|
||||
class HomeController
|
||||
{
|
||||
public function index(RequestData $request) {
|
||||
return view('home', ['rd' => $request ]);
|
||||
}
|
||||
|
||||
public function debug(RequestData $request) {
|
||||
return view('debug');
|
||||
}
|
||||
}
|
||||
23
M5/Dossier/emensa/controllers/MainController.php
Normal file
23
M5/Dossier/emensa/controllers/MainController.php
Normal file
@@ -0,0 +1,23 @@
|
||||
<?php
|
||||
require_once($_SERVER['DOCUMENT_ROOT'].'/../models/gerichte_main.php');
|
||||
|
||||
class MainController
|
||||
{
|
||||
public function index() {
|
||||
/*
|
||||
Wenn Sie hier landen:
|
||||
bearbeiten Sie diese Action,
|
||||
so dass Sie die Aufgabe löst
|
||||
*/
|
||||
|
||||
|
||||
|
||||
$data = db_gericht_select_karte();
|
||||
|
||||
return view('main.index', [
|
||||
'data'=>$data,
|
||||
'url' => 'http' . (isset($_SERVER['HTTPS']) ? 's' : '') . '://' . "{$_SERVER['HTTP_HOST']}{$_SERVER['REQUEST_URI']}"
|
||||
]);
|
||||
}
|
||||
|
||||
}
|
||||
51
M5/Dossier/emensa/models/benutzer.php
Normal file
51
M5/Dossier/emensa/models/benutzer.php
Normal file
@@ -0,0 +1,51 @@
|
||||
<?php
|
||||
/**
|
||||
* Diese Datei enthält alle SQL Statements für die Tabelle "benutzer"
|
||||
*/
|
||||
|
||||
function anmelden(string $email, string $passwort)
|
||||
{
|
||||
$link = connectdb();
|
||||
|
||||
$sql = "SELECT * FROM benutzer
|
||||
WHERE (`email` = '$email')";
|
||||
$result = $link->query($sql);
|
||||
$row = $result->fetch_assoc();
|
||||
|
||||
if ($row['passwort'] == NULL) {
|
||||
$row = 0;
|
||||
} elseif ($row['passwort'] == $passwort) {
|
||||
session_start();
|
||||
|
||||
mysqli_begin_transaction($link);
|
||||
$sql = "UPDATE benutzer
|
||||
SET letzteanmeldung = current_time, anzahlfehler = 0
|
||||
WHERE email = '$email'";
|
||||
$link->query($sql);
|
||||
|
||||
|
||||
// $sql = "UPDATE benutzer SET anzahlanmeldungen = anzahlanmeldungen + 1 WHERE id = " . $row['id'];
|
||||
$sql = "CALL incrementAnzahlAnmeldungen(" . ($row['id']) . ")";
|
||||
$link->query($sql);
|
||||
|
||||
mysqli_commit($link);
|
||||
|
||||
$_SESSION['uid'] = session_id();
|
||||
$_SESSION['login'] = 1;
|
||||
$_SESSION['name'] = $row['name'];
|
||||
$_SESSION['email'] = $row['email'];
|
||||
return 1;
|
||||
} else {
|
||||
|
||||
mysqli_begin_transaction($link);
|
||||
|
||||
$sql = "UPDATE benutzer
|
||||
SET anzahlfehler = anzahlfehler+1, letzterfehler = current_time
|
||||
WHERE email = '$email'";
|
||||
$link->query($sql);
|
||||
|
||||
mysqli_commit($link);
|
||||
|
||||
}
|
||||
return 0;
|
||||
}
|
||||
27
M5/Dossier/emensa/models/gericht.php
Normal file
27
M5/Dossier/emensa/models/gericht.php
Normal file
@@ -0,0 +1,27 @@
|
||||
<?php
|
||||
/**
|
||||
* Diese Datei enthält alle SQL Statements für die Tabelle "gerichte"
|
||||
*/
|
||||
function db_gericht_select_all() {
|
||||
try {
|
||||
$link = connectdb();
|
||||
|
||||
$sql = 'SELECT id, name, beschreibung FROM gericht ORDER BY name';
|
||||
$result = mysqli_query($link, $sql);
|
||||
|
||||
$data = mysqli_fetch_all($result, MYSQLI_BOTH);
|
||||
|
||||
mysqli_close($link);
|
||||
}
|
||||
catch (Exception $ex) {
|
||||
$data = array(
|
||||
'id'=>'-1',
|
||||
'error'=>true,
|
||||
'name' => 'Datenbankfehler '.$ex->getCode(),
|
||||
'beschreibung' => $ex->getMessage());
|
||||
}
|
||||
finally {
|
||||
return $data;
|
||||
}
|
||||
|
||||
}
|
||||
62
M5/Dossier/emensa/models/gerichte_main.php
Normal file
62
M5/Dossier/emensa/models/gerichte_main.php
Normal file
@@ -0,0 +1,62 @@
|
||||
<?php
|
||||
|
||||
function db_gericht_select_karte()
|
||||
{
|
||||
try {
|
||||
|
||||
$link = connectdb();
|
||||
|
||||
|
||||
$sql_gerichte = "SELECT * FROM gericht ORDER BY RAND() LIMIT 5";
|
||||
$result_sql_gerichte = mysqli_query($link, $sql_gerichte);
|
||||
$result_sql_gerichte1 = mysqli_query($link, $sql_gerichte);
|
||||
|
||||
|
||||
$verwendete_allergene_code = [];
|
||||
$verwendete_allergene_string = "";
|
||||
|
||||
while ($row_gerichte = mysqli_fetch_assoc($result_sql_gerichte)) {
|
||||
|
||||
// Abfrage der vorhandenen Allergene im aktuellen Gericht
|
||||
|
||||
$sql_gericht_hat_allergene = "SELECT * FROM gericht_hat_allergen WHERE gericht_id=" . $row_gerichte['id'];
|
||||
$result_sql_gericht_hat_allergene = mysqli_query($link, $sql_gericht_hat_allergene);
|
||||
$allergene = "";
|
||||
while ($row_allergene = mysqli_fetch_assoc($result_sql_gericht_hat_allergene)) {
|
||||
$allergene .= $row_allergene['code'] . ", ";
|
||||
|
||||
if (!in_array($row_allergene['code'], $verwendete_allergene_code)) {
|
||||
$verwendete_allergene_code[] = $row_allergene['code'];
|
||||
}
|
||||
}
|
||||
|
||||
}
|
||||
|
||||
|
||||
$sql_allergen = "SELECT code, name FROM allergen";
|
||||
$result_sql_allergen = mysqli_query($link, $sql_allergen);
|
||||
|
||||
|
||||
|
||||
$data = [
|
||||
"allergene" => $verwendete_allergene_string,
|
||||
"result_sql_allergen" => $result_sql_allergen,
|
||||
"verwendete_allergene_code" => $verwendete_allergene_code,
|
||||
"result_sql_gerichte" => $result_sql_gerichte1,
|
||||
"allergene1" => $allergene
|
||||
];
|
||||
|
||||
|
||||
mysqli_close($link);
|
||||
|
||||
|
||||
} catch (Exception $ex) {
|
||||
$data = array(
|
||||
'id' => '-1',
|
||||
'error' => true,
|
||||
'name' => 'Datenbankfehler ' . $ex->getCode(),
|
||||
'beschreibung' => $ex->getMessage());
|
||||
} finally {
|
||||
return $data;
|
||||
}
|
||||
}
|
||||
23
M5/Dossier/emensa/models/gerichte_self.php
Normal file
23
M5/Dossier/emensa/models/gerichte_self.php
Normal file
@@ -0,0 +1,23 @@
|
||||
<?php
|
||||
|
||||
function db_gericht_select_intern()
|
||||
{
|
||||
try {
|
||||
$link = connectdb();
|
||||
|
||||
$sql = 'SELECT name, preisintern FROM gericht WHERE preisintern > 2 ORDER BY name DESC';
|
||||
$result = mysqli_query($link, $sql);
|
||||
|
||||
$data = mysqli_fetch_all($result, MYSQLI_BOTH);
|
||||
|
||||
mysqli_close($link);
|
||||
} catch (Exception $ex) {
|
||||
$data = array(
|
||||
'id' => '-1',
|
||||
'error' => true,
|
||||
'name' => 'Datenbankfehler ' . $ex->getCode(),
|
||||
'beschreibung' => $ex->getMessage());
|
||||
} finally {
|
||||
return $data;
|
||||
}
|
||||
}
|
||||
15
M5/Dossier/emensa/models/kategorie.php
Normal file
15
M5/Dossier/emensa/models/kategorie.php
Normal file
@@ -0,0 +1,15 @@
|
||||
<?php
|
||||
/**
|
||||
* Diese Datei enthält alle SQL Statements für die Tabelle "kategorie"
|
||||
*/
|
||||
function db_kategorie_select_all() {
|
||||
$link = connectdb();
|
||||
|
||||
$sql = "SELECT * FROM kategorie ORDER BY name ASC";
|
||||
$result = mysqli_query($link, $sql);
|
||||
|
||||
$data = mysqli_fetch_all($result, MYSQLI_BOTH);
|
||||
|
||||
mysqli_close($link);
|
||||
return $data;
|
||||
}
|
||||
6
M5/Dossier/emensa/public/css/default.min.css
vendored
Normal file
6
M5/Dossier/emensa/public/css/default.min.css
vendored
Normal file
File diff suppressed because one or more lines are too long
96
M5/Dossier/emensa/public/css/style.css
Normal file
96
M5/Dossier/emensa/public/css/style.css
Normal file
@@ -0,0 +1,96 @@
|
||||
* {
|
||||
font-family: Arial;
|
||||
}
|
||||
|
||||
.grid {
|
||||
display: grid;
|
||||
grid-template-columns: 200px auto 200px;
|
||||
}
|
||||
|
||||
img {
|
||||
width: 100%;
|
||||
height: auto;
|
||||
}
|
||||
|
||||
.speisen {
|
||||
border: solid;
|
||||
border-collapse: collapse;
|
||||
}
|
||||
|
||||
.speisen td {
|
||||
border: solid;
|
||||
border-collapse: collapse;
|
||||
border-radius: 4px;
|
||||
padding: 5px;
|
||||
width: auto;
|
||||
}
|
||||
|
||||
.speisen td:not(:first-of-type) {
|
||||
text-align: center;
|
||||
}
|
||||
|
||||
.speisen img{
|
||||
width: 100px;
|
||||
height: 100px;
|
||||
}
|
||||
|
||||
|
||||
p {
|
||||
text-align: justify;
|
||||
}
|
||||
|
||||
.zahlen {
|
||||
list-style-type: none;
|
||||
display: grid;
|
||||
grid-template-columns: auto auto auto;
|
||||
gap: 10px;
|
||||
}
|
||||
|
||||
.zahlen p {
|
||||
text-align: center;
|
||||
font-weight: bold;
|
||||
}
|
||||
|
||||
.formular {
|
||||
display: grid;
|
||||
grid-template-columns: auto auto auto;
|
||||
justify-content: start;
|
||||
gap: 10px;
|
||||
}
|
||||
|
||||
.wichtig {
|
||||
text-align: center;
|
||||
}
|
||||
|
||||
.wichtigListe {
|
||||
display: inline-block;
|
||||
text-align: left;
|
||||
}
|
||||
|
||||
.freude {
|
||||
text-align: center;
|
||||
}
|
||||
|
||||
footer {
|
||||
border-top: 1px solid;
|
||||
}
|
||||
|
||||
.fusszeile {
|
||||
padding-top: 20px;
|
||||
padding-bottom: 20px;
|
||||
margin-left: auto;
|
||||
margin-right: auto;
|
||||
border: none;
|
||||
}
|
||||
|
||||
.fusszeile td:first-child {
|
||||
border-left: none;
|
||||
padding-left: 20px;
|
||||
padding-right: 20px;
|
||||
}
|
||||
|
||||
.fusszeile td {
|
||||
border-left: 3px solid;
|
||||
padding-left: 20px;
|
||||
padding-right: 20px;
|
||||
}
|
||||
BIN
M5/Dossier/emensa/public/favicon.ico
Normal file
BIN
M5/Dossier/emensa/public/favicon.ico
Normal file
Binary file not shown.
|
After Width: | Height: | Size: 151 B |
BIN
M5/Dossier/emensa/public/img/fh-logo.jpg
Normal file
BIN
M5/Dossier/emensa/public/img/fh-logo.jpg
Normal file
Binary file not shown.
|
After Width: | Height: | Size: 64 KiB |
BIN
M5/Dossier/emensa/public/img/gerichte/00_image_missing.jpg
Normal file
BIN
M5/Dossier/emensa/public/img/gerichte/00_image_missing.jpg
Normal file
Binary file not shown.
|
After Width: | Height: | Size: 86 KiB |
BIN
M5/Dossier/emensa/public/img/gerichte/01_bratkartoffel.jpg
Normal file
BIN
M5/Dossier/emensa/public/img/gerichte/01_bratkartoffel.jpg
Normal file
Binary file not shown.
|
After Width: | Height: | Size: 174 KiB |
BIN
M5/Dossier/emensa/public/img/gerichte/03_bratkartoffel.jpg
Normal file
BIN
M5/Dossier/emensa/public/img/gerichte/03_bratkartoffel.jpg
Normal file
Binary file not shown.
|
After Width: | Height: | Size: 93 KiB |
BIN
M5/Dossier/emensa/public/img/gerichte/04_tofu.jpg
Normal file
BIN
M5/Dossier/emensa/public/img/gerichte/04_tofu.jpg
Normal file
Binary file not shown.
|
After Width: | Height: | Size: 70 KiB |
BIN
M5/Dossier/emensa/public/img/gerichte/06_lasagne.jpg
Normal file
BIN
M5/Dossier/emensa/public/img/gerichte/06_lasagne.jpg
Normal file
Binary file not shown.
|
After Width: | Height: | Size: 84 KiB |
BIN
M5/Dossier/emensa/public/img/gerichte/09_suppe.jpg
Normal file
BIN
M5/Dossier/emensa/public/img/gerichte/09_suppe.jpg
Normal file
Binary file not shown.
|
After Width: | Height: | Size: 49 KiB |
BIN
M5/Dossier/emensa/public/img/gerichte/10_forelle.jpg
Normal file
BIN
M5/Dossier/emensa/public/img/gerichte/10_forelle.jpg
Normal file
Binary file not shown.
|
After Width: | Height: | Size: 133 KiB |
BIN
M5/Dossier/emensa/public/img/gerichte/11_soup.jpg
Normal file
BIN
M5/Dossier/emensa/public/img/gerichte/11_soup.jpg
Normal file
Binary file not shown.
|
After Width: | Height: | Size: 105 KiB |
BIN
M5/Dossier/emensa/public/img/gerichte/12_kassler.jpg
Normal file
BIN
M5/Dossier/emensa/public/img/gerichte/12_kassler.jpg
Normal file
Binary file not shown.
|
After Width: | Height: | Size: 98 KiB |
BIN
M5/Dossier/emensa/public/img/gerichte/13_reibekuchen.jpg
Normal file
BIN
M5/Dossier/emensa/public/img/gerichte/13_reibekuchen.jpg
Normal file
Binary file not shown.
|
After Width: | Height: | Size: 103 KiB |
BIN
M5/Dossier/emensa/public/img/gerichte/15_pilze.jpg
Normal file
BIN
M5/Dossier/emensa/public/img/gerichte/15_pilze.jpg
Normal file
Binary file not shown.
|
After Width: | Height: | Size: 66 KiB |
BIN
M5/Dossier/emensa/public/img/gerichte/17_broetchen.jpg
Normal file
BIN
M5/Dossier/emensa/public/img/gerichte/17_broetchen.jpg
Normal file
Binary file not shown.
|
After Width: | Height: | Size: 161 KiB |
BIN
M5/Dossier/emensa/public/img/gerichte/19_mousse.jpg
Normal file
BIN
M5/Dossier/emensa/public/img/gerichte/19_mousse.jpg
Normal file
Binary file not shown.
|
After Width: | Height: | Size: 41 KiB |
BIN
M5/Dossier/emensa/public/img/gerichte/20_suppe.jpg
Normal file
BIN
M5/Dossier/emensa/public/img/gerichte/20_suppe.jpg
Normal file
Binary file not shown.
|
After Width: | Height: | Size: 138 KiB |
6
M5/Dossier/emensa/public/img/gerichte/license.txt
Normal file
6
M5/Dossier/emensa/public/img/gerichte/license.txt
Normal file
@@ -0,0 +1,6 @@
|
||||
Grafiken von unsplash.com.
|
||||
|
||||
Lizenz:
|
||||
https://unsplash.com/license
|
||||
|
||||
Letzter Zugriff 31.08.2020
|
||||
BIN
M5/Dossier/emensa/public/img/mensa21.jpg
Normal file
BIN
M5/Dossier/emensa/public/img/mensa21.jpg
Normal file
Binary file not shown.
|
After Width: | Height: | Size: 153 KiB |
BIN
M5/Dossier/emensa/public/img/test.jpg
Normal file
BIN
M5/Dossier/emensa/public/img/test.jpg
Normal file
Binary file not shown.
|
After Width: | Height: | Size: 9.2 KiB |
373
M5/Dossier/emensa/public/index.php
Normal file
373
M5/Dossier/emensa/public/index.php
Normal file
@@ -0,0 +1,373 @@
|
||||
<?php
|
||||
|
||||
// start session
|
||||
session_start();
|
||||
// if session just started and uid is not set, add initial information such as user agent and ip address
|
||||
|
||||
|
||||
if (!isset($_SESSION['uid']))
|
||||
{
|
||||
$_SESSION['ipremote'] = $_SERVER['REMOTE_ADDR'];
|
||||
|
||||
$_SESSION['useragent'] = $_SERVER['HTTP_USER_AGENT'];
|
||||
}
|
||||
else
|
||||
{
|
||||
// uid is set in session variables. User gets logged out in case of changed ip address and user agent.
|
||||
if ($_SESSION['ipremote'] !== $_SERVER['REMOTE_ADDR'] && $_SESSION['useragent'] !== $_SERVER['HTTP_USER_AGENT'])
|
||||
{
|
||||
session_unset();
|
||||
session_destroy();
|
||||
}
|
||||
// if client information has not changed just regenerate the session
|
||||
session_regenerate_id(true);
|
||||
}
|
||||
|
||||
const VERBOSITY = 0;
|
||||
const PUBLIC_DIRNAME = "public";
|
||||
const CONFIG_WEBROUTES = "/../routes/web.php"; // like in laravel
|
||||
const CONFIG_DB = "/../config/db.php";
|
||||
const ROUTER_VERSION = '0.8.2';
|
||||
|
||||
assert_php_version('8.2.0');
|
||||
assert_path();
|
||||
|
||||
try {
|
||||
if (!file_exists(realpath($_SERVER['DOCUMENT_ROOT'] . "/../vendor/autoload.php"))) {
|
||||
echo "<h1>Abhängigkeiten nicht gefunden</h1><pre>DOCUMENT_ROOT: {$_SERVER['DOCUMENT_ROOT']}</pre><br><p>Datei nicht gefunden: <strong>{$_SERVER['DOCUMENT_ROOT']}/../vendor/autoload.php</strong></p>";
|
||||
echo "<p>Häufigste Ursache</p><ul>
|
||||
<li>Das Verzeichnis <code>public/</code> ist <em>nicht</em> als Wurzelverzeichnis verwendet worden.</li>
|
||||
<li>Die Abhängigkeiten wurden nicht mit <code>composer update</code> installiert.</code></li>
|
||||
</ul>";
|
||||
exit(1);
|
||||
}
|
||||
// file exists
|
||||
require_once realpath($_SERVER['DOCUMENT_ROOT'] . "/../vendor/autoload.php");
|
||||
|
||||
} catch (Exception $ex) {
|
||||
echo "<code>DOCUMENT_ROOT</code><br><pre>{$_SERVER['DOCUMENT_ROOT']}</pre><code>Error</code><br><pre>" . $ex->getMessage() . "</pre>";
|
||||
}
|
||||
|
||||
use eftec\bladeone\BladeOne;
|
||||
|
||||
/* Routing Script for PHP Dev Server */
|
||||
$verbosity = VERBOSITY;
|
||||
if (preg_match('/\.(?:css|js|png|jpg|jpeg|gif)$/', $_SERVER["REQUEST_URI"])) {
|
||||
return false;
|
||||
} else {
|
||||
if ($verbosity > 1) {
|
||||
echo
|
||||
"<pre>Verbosity-Level: <strong>{$verbosity}</strong></pre>" .
|
||||
"<pre>" . print_r($_SERVER, 1) . "</pre><hr>";
|
||||
}
|
||||
FrontController::handleRequest("$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]", $_SERVER['REQUEST_METHOD'], VERBOSITY);
|
||||
}
|
||||
|
||||
class RequestData
|
||||
{
|
||||
/**
|
||||
* @var array Request Querystring, broken down to key-value pairs
|
||||
*/
|
||||
public array $query;
|
||||
/**
|
||||
* @var array Request arguments from path, after cutting two segments out for controller and action names
|
||||
*/
|
||||
public array $args;
|
||||
/**
|
||||
* @var string HTTP Verb used
|
||||
*/
|
||||
public string $method;
|
||||
|
||||
public function getData()
|
||||
{
|
||||
return array_merge($_GET, $_POST);
|
||||
}
|
||||
|
||||
/**
|
||||
* @return array
|
||||
*/
|
||||
public function getPostData()
|
||||
{
|
||||
return $_POST;
|
||||
}
|
||||
|
||||
/**
|
||||
* @return array
|
||||
*/
|
||||
public function getGetData()
|
||||
{
|
||||
return $_GET;
|
||||
}
|
||||
|
||||
/**
|
||||
* RequestData is the way the Router will provide information, use it in your Action methods.
|
||||
* @param $method string Verb used
|
||||
* @param $args array Arguments
|
||||
* @param $query array Key-Value Pairs
|
||||
*/
|
||||
public function __construct($method, $args, $query)
|
||||
{
|
||||
$this->query = $query;
|
||||
$this->args = $args;
|
||||
$this->method = $method;
|
||||
}
|
||||
}
|
||||
|
||||
class FrontController
|
||||
{
|
||||
|
||||
public static function handleRequest($url, $method = 'GET', $verbosity = 0, $configPath = CONFIG_WEBROUTES)
|
||||
{
|
||||
assert_blade(); // check if the class is found
|
||||
|
||||
if (!str_contains($url, ':')) $url = $_SERVER['HTTP_HOST'] . ':' . $_SERVER['SERVER_PORT'] . $_SERVER['REQUEST_URI'];
|
||||
|
||||
$scriptPath = dirname(__FILE__, 2) . '/';
|
||||
$controllerDirectory = $scriptPath . 'controllers/';
|
||||
|
||||
// get a router/web-like config array to override filebased convention
|
||||
$config = FrontController::getConfig($configPath);
|
||||
|
||||
// /Impressum/ --> ImpressumController->index()
|
||||
$request = parse_url($url);
|
||||
$ctrlName = $request['path'];
|
||||
$actionName = 'index';
|
||||
$args = array();
|
||||
$query = array();
|
||||
parse_str($request['query'] ?? "", $query);
|
||||
|
||||
// provide POST data
|
||||
if ($method != 'GET')
|
||||
$query = array_merge($query, $_REQUEST);
|
||||
|
||||
|
||||
// check, if route has two levels
|
||||
if (strpos($ctrlName, '/', 1) > 0) {
|
||||
$path = explode('/', $request['path']); // Werbeseite/Speise/1/mobile?pretty=true&user=marcel
|
||||
array_shift($path); // skip once
|
||||
$ctrlName = array_shift($path); // Werbeseite
|
||||
$actionName = array_shift($path); // Speise
|
||||
$args = $path; // remainder of path-parts // [1][mobile]
|
||||
if ($verbosity > 1) {
|
||||
echo "<pre>Request\n", print_r($request), "</pre>";
|
||||
echo "<pre>Path\n", print_r($path), "</pre>";
|
||||
echo "<pre>Query\n", print_r($query), "</pre>";
|
||||
}
|
||||
}
|
||||
|
||||
// fix: trim slashes
|
||||
$ctrlName = trim($ctrlName, '/');
|
||||
$actionName = trim($actionName, '/');
|
||||
|
||||
// $config based renaming of Controller/Action, precedes filebased convention
|
||||
// $config values must use syntax <ClassController>@<actionname>
|
||||
if (array_key_exists('/' . $ctrlName . '/' . $actionName, $config)) {
|
||||
$routingConfig = explode('@', $config['/' . $ctrlName . '/' . $actionName]);
|
||||
if ($verbosity > 0) {
|
||||
echo "<p>Routing Config matched request for <code>/" . $ctrlName . "/" . $actionName . "</code>:</p><p>routing config is</p><pre>" . print_r($routingConfig, 1) . '</pre>';
|
||||
}
|
||||
// important: overwriting controller and action name
|
||||
$ctrlClass = $routingConfig[0];
|
||||
$actionName = $routingConfig[1];
|
||||
} elseif (array_key_exists($request['path'], $config)) {
|
||||
// exact match on full path, this also means "/"
|
||||
$routingConfig = explode('@', $config[$request['path']]);
|
||||
if ($verbosity > 0) {
|
||||
echo "<p>Routing Config matched for full path <code>" . $request['path'] . "</code>:</p><p>routing config is</p><pre>" . print_r($routingConfig, 1) . '</pre>';
|
||||
}
|
||||
// important: overwriting controller and action name
|
||||
$ctrlClass = $routingConfig[0];
|
||||
$actionName = $routingConfig[1];
|
||||
} else {
|
||||
if ($verbosity > 0) {
|
||||
echo "Request $ctrlName/$actionName was not in \$config.";
|
||||
}
|
||||
|
||||
// fall back to filebased convention: match controller classes in directory
|
||||
$ctrlClass = ucfirst($ctrlName . 'Controller');
|
||||
}
|
||||
|
||||
$ctrlFile = ($ctrlClass . '.php');
|
||||
$validControllers = FrontController::getValidControllers($controllerDirectory);
|
||||
if (!in_array($controllerDirectory . $ctrlFile, $validControllers)) {
|
||||
if ($verbosity > 0) {
|
||||
echo "<div><p>Controller: $ctrlFile not found in</p><pre>" . print_r($validControllers, 1) . "</pre><p>Config Array:</p><pre>" . print_r($config, 1) . "</pre></div>";
|
||||
}
|
||||
// #ERROR
|
||||
FrontController::showErrorMessage("<h1>Web Software Error</h1><img alt='shrug' src='https://c.tenor.com/9TEDud6eP2UAAAAC/woody-woodpecker-shrug-shoulders.gif'>" .
|
||||
"<p>Keine entspreche Zuordnung der Route für {$ctrlName}::{$actionName} gefunden. Tippfehler in der Route?" .
|
||||
"<p>Es konnte keine Klasse <abbr title='Gesucht im Verzeichnis {$controllerDirectory}'>" . $ctrlFile . "</abbr> gefunden werden! Request fehlgeschlagen.</p>" .
|
||||
"<p> Prüfen Sie die Einträge in der Datei <code>config/web.php</code> und gleichen Sie den getätigten Aufruf damit ab.</p>");
|
||||
}
|
||||
|
||||
// a file matching has been found, now try to load the class
|
||||
try {
|
||||
require_once $controllerDirectory . $ctrlFile;
|
||||
// instantiate the controller
|
||||
|
||||
$controller = new $ctrlClass();
|
||||
$rd = new RequestData($method, $args, $query);
|
||||
|
||||
if ($verbosity > 0) {
|
||||
var_dump($controller, $rd);
|
||||
}
|
||||
// the controller will load model and view and return some html
|
||||
print call_user_func_array(array($controller, $actionName), array($rd));
|
||||
} catch (Exception $ex) {
|
||||
// #ERROR
|
||||
FrontController::showErrorMessage(
|
||||
"<h2>Fehler in Controller " . get_class($controller) . "!</h2><p>Stellen Sie sicher, dass die Action/der Controller existiert.</p>
|
||||
<p>Das Routing Config-Array hat " . count($config) . " Einträge.</p>
|
||||
<p><strong>Exception text</strong><br>" . $ex->getMessage() . "</p>");
|
||||
}
|
||||
}
|
||||
|
||||
public static function showErrorMessage($text, $severity = 3, $die = true)
|
||||
{
|
||||
$styles = array(0 => "background-color: #F08170; border: 2px solid lightgray; padding: 2em; margin: 5em; width: 50%; box-shadow: 0em 0em 1em #F08170;",
|
||||
1 => "background-color: #F08170; border: 2px solid lightgray; padding: 2em; margin: 5em; width: 50%; box-shadow: 0em 0em 1em #F08170;",
|
||||
2 => "background-color: #F08170; border: 2px solid lightgray; padding: 2em; margin: 5em; width: 50%; box-shadow: 0em 0em 1em #F08170;",
|
||||
3 => "background-color: #F08170; border: 2px solid lightgray; padding: 2em; margin: 5em; width: 50%; box-shadow: 0em 0em 1em #F08170;");
|
||||
print("<div style=\"{$styles[$severity]}\">{$text}</div>");
|
||||
if ($die) exit($severity);
|
||||
}
|
||||
|
||||
public static function getConfig($configPath)
|
||||
{
|
||||
try {
|
||||
// load the $config Array from a file given in $configPath
|
||||
$path_to_config = realpath($_SERVER['DOCUMENT_ROOT'] . DIRECTORY_SEPARATOR . $configPath);
|
||||
// print("Path to config " . $path_to_config);
|
||||
$config = include $path_to_config;
|
||||
} catch (Exception $e) {
|
||||
print_r($e);
|
||||
$config = array('/' => 'HomeController@index');
|
||||
} finally {
|
||||
return $config;
|
||||
}
|
||||
}
|
||||
|
||||
public static function getValidControllers($path = '')
|
||||
{
|
||||
if ($path == '') {
|
||||
$path = getcwd() . DIRECTORY_SEPARATOR . 'controllers' . DIRECTORY_SEPARATOR;
|
||||
}
|
||||
return glob($path . '*Controller.php');
|
||||
}
|
||||
}
|
||||
|
||||
function connectdb()
|
||||
{
|
||||
$path_to_config_db = $_SERVER['DOCUMENT_ROOT'] . DIRECTORY_SEPARATOR . CONFIG_DB;
|
||||
$config = include $path_to_config_db;
|
||||
$link = mysqli_connect( // Daten aus config/db.php
|
||||
$config['host'],
|
||||
$config['user'],
|
||||
$config['password'],
|
||||
$config['database'], // Auswahl der Datenbank
|
||||
$config['port'] ?? 3306);
|
||||
if (!$link) {
|
||||
FrontController::showErrorMessage("<h1>Verbindung mit der Datenbank nicht möglich</h1>
|
||||
<p style='margin-bottom: 2em;'>Verbindung fehlgeschlagen: <code>" . mysqli_connect_error() . "</code>.</p>
|
||||
<h2>Prüfen Sie</h2><ol><li>die Angaben in der Datei <code>config/db.php</code>:
|
||||
( ist Benutzer <code>{$config['user']}</code> an Datenbank <code>{$config['database']}</code> auf Server <code>{$config['host']}</code> korrekt?)<br>
|
||||
</li><li>ob Ihre Datenbank unter der oben gezeigten Adresse läuft </li></ol>");
|
||||
exit(1);
|
||||
}
|
||||
if (mysqli_connect_errno()) {
|
||||
FrontController::showErrorMessage("<h1>Verbindung mit der Datenbank nicht möglich</h1>
|
||||
<code>Fehlermeldung</code><pre>" . mysqli_connect_error() . "</pre>", 2, true);
|
||||
exit(1);
|
||||
}
|
||||
|
||||
return $link;
|
||||
}
|
||||
|
||||
function view($viewname, $viewargs = array())
|
||||
{
|
||||
$views = dirname(__DIR__) . '/views';
|
||||
$cache = dirname(__DIR__) . '/storage/cache';
|
||||
$blade = new BladeOne($views, $cache, BladeOne::MODE_DEBUG);
|
||||
|
||||
return $blade->run($viewname, $viewargs);
|
||||
}
|
||||
|
||||
/**
|
||||
* let the script die if the php minimum version is not met.
|
||||
* @param $minversion
|
||||
* @return void
|
||||
*/
|
||||
function assert_php_version($minversion = '8.0.0')
|
||||
{
|
||||
$version_too_low = 0;
|
||||
$minver = explode('.', $minversion);
|
||||
$version = explode('.', phpversion());
|
||||
|
||||
if (intval($minver[0]) > intval($version[0])) {
|
||||
$version_too_low = 1;
|
||||
} elseif (intval($minver[1]) > intval($version[1])) {
|
||||
$version_too_low = 1;
|
||||
} elseif (intval($minver[2]) > intval($version[2])) {
|
||||
$version_too_low = 1;
|
||||
}
|
||||
|
||||
if ($version_too_low) {
|
||||
FrontController::showErrorMessage("Diese PHP-Version wird nicht unterstützt: <strong>Minimum PHP Version " . $minversion . "</strong><br>Sie betreiben gerade PHP Version " . phpversion());
|
||||
exit(1);
|
||||
}
|
||||
// version is okay, go on.
|
||||
}
|
||||
|
||||
/**
|
||||
* let the script die if the path contains problematic characters.
|
||||
* @return void
|
||||
*/
|
||||
function assert_path(): void
|
||||
{
|
||||
static $chars = array("[", "]", "{", "}");
|
||||
$charsfound = 0;
|
||||
str_ireplace($chars, '', $_SERVER['DOCUMENT_ROOT'], $charsfound);
|
||||
if ($charsfound > 0) {
|
||||
FrontController::showErrorMessage("<h1>Bitte verwenden Sie einen anderen Ordner für das Projekt!</h1>
|
||||
<p>Der Pfad <strong>" . $_SERVER['DOCUMENT_ROOT'] . "</strong> enthält <code>" . $charsfound . "</code> problematische Zeichen, die die korrekte Ausführung verhindern.</p>>
|
||||
<p>Bekannte problematische Zeichen sind</p>
|
||||
<pre> " . implode(" ", $chars) . " </pre>");
|
||||
exit(1);
|
||||
}
|
||||
|
||||
}
|
||||
|
||||
function assert_blade(): void
|
||||
{
|
||||
if (!class_exists('eftec\bladeone\BladeOne')) {
|
||||
// #ERROR
|
||||
FrontController::showErrorMessage("
|
||||
<h1>Fehler: Blade wurde nicht gefunden</h1>
|
||||
<p>Tipps für die Lösung:</p>
|
||||
<ul>
|
||||
<li><p>führen Sie im Terminal folgende Zeilen aus.</p>
|
||||
<ol>
|
||||
<li><code>php bin/composer.phar update</code> oder <code>php bin/composer.phar reinstall eftec/bladeone</code></li>
|
||||
<li><code>php bin/composer.phar dump-autoload</code></li>
|
||||
</ol>
|
||||
<li><p>Prüfen Sie im Anschluss: befindet sich in dem Ordner <code>vendor/eftec/bladeone/lib/</code> die Datei <code>BladeOne.php</code> ?</p></li>
|
||||
<li><p>Starten Sie dann den Webserver neu.</p></li>
|
||||
<li><p>Befragen Sie gerne auch das Forum in Ilias.</p></li>
|
||||
</ul>
|
||||
|
||||
</div>");
|
||||
exit(1);
|
||||
}
|
||||
}
|
||||
|
||||
use Monolog\Level;
|
||||
use Monolog\Logger;
|
||||
use Monolog\Handler\StreamHandler;
|
||||
|
||||
function logger($name, $path){
|
||||
|
||||
$fullpath = $path . '\\' . $name . '.txt';
|
||||
$log = new Logger($name);
|
||||
$log->pushHandler(new StreamHandler($fullpath), Level::Warning);
|
||||
return $log;
|
||||
}
|
||||
593
M5/Dossier/emensa/public/js/highlight.min.js
vendored
Normal file
593
M5/Dossier/emensa/public/js/highlight.min.js
vendored
Normal file
File diff suppressed because one or more lines are too long
28
M5/Dossier/emensa/routes/web.php
Normal file
28
M5/Dossier/emensa/routes/web.php
Normal file
@@ -0,0 +1,28 @@
|
||||
<?php
|
||||
/**
|
||||
* Mapping of paths to controllers.
|
||||
* Note, that the path only supports one level of directory depth:
|
||||
* /demo is ok,
|
||||
* /demo/subpage will not work as expected
|
||||
*/
|
||||
|
||||
return array(
|
||||
'/' => "MainController@index",
|
||||
"/demo" => "DemoController@demo",
|
||||
'/dbconnect' => 'DemoController@dbconnect',
|
||||
'/debug' => 'HomeController@debug',
|
||||
'/error' => 'DemoController@error',
|
||||
'/requestdata' => 'DemoController@requestdata',
|
||||
|
||||
// Erstes Beispiel:
|
||||
'/m4_6a_queryparameter' => 'ExampleController@m4_6a_queryparameter',
|
||||
'/m4' => 'ExampleController@m4_6a_queryparameter',
|
||||
'/m4_7b_kategorie' => 'ExampleController@m4_7b_kategorie',
|
||||
'/m4_7c_gerichte' => 'ExampleController@m4_7c_gerichte',
|
||||
'/m4_7d' => 'ExampleController@m4_7d',
|
||||
|
||||
'/anmeldung' => 'AnmeldungController@start',
|
||||
'/anmeldung_verifizieren' => 'AnmeldungController@anmeldung_verifizieren',
|
||||
'/anmeldung_fehler' => 'AnmeldungController@check',
|
||||
'/abmeldung' => 'AnmeldungController@abmelden'
|
||||
);
|
||||
23
M5/Dossier/emensa/storage/cache/.layouts.layout_7b6f1811f474eb66a51163e3ee689e7d001c551d.bladec
vendored
Normal file
23
M5/Dossier/emensa/storage/cache/.layouts.layout_7b6f1811f474eb66a51163e3ee689e7d001c551d.bladec
vendored
Normal file
@@ -0,0 +1,23 @@
|
||||
<!doctype html>
|
||||
<html class="no-js" lang="DE">
|
||||
<head>
|
||||
<meta charset="utf-8">
|
||||
<title>E-Mensa Routing Script</title>
|
||||
<meta name="description" content="unused">
|
||||
<meta name="viewport" content="width=device-width, initial-scale=1">
|
||||
<link rel="stylesheet" href="css/default.min.css">
|
||||
<?php echo $this->yieldContent("cssextra"); ?>
|
||||
<meta name="theme-color" content="#dadada">
|
||||
<!-- good developers check the markup ;) -->
|
||||
</head>
|
||||
<body>
|
||||
<div class="container">
|
||||
<div class="row">
|
||||
<?php echo $this->yieldContent("content"); ?>
|
||||
</div>
|
||||
</div>
|
||||
|
||||
<?php echo $this->yieldContent("jsextra"); ?>
|
||||
</body>
|
||||
|
||||
</html>
|
||||
23
M5/Dossier/emensa/storage/cache/.layouts.layout_933596b3f8bdab5243334e13bf36856f2a87605f.bladec
vendored
Normal file
23
M5/Dossier/emensa/storage/cache/.layouts.layout_933596b3f8bdab5243334e13bf36856f2a87605f.bladec
vendored
Normal file
@@ -0,0 +1,23 @@
|
||||
<!doctype html>
|
||||
<html class="no-js" lang="DE">
|
||||
<head>
|
||||
<meta charset="utf-8">
|
||||
<title>E-Mensa Routing Script</title>
|
||||
<meta name="description" content="unused">
|
||||
<meta name="viewport" content="width=device-width, initial-scale=1">
|
||||
<link rel="stylesheet" href="css/default.min.css">
|
||||
<?php echo $this->yieldContent("cssextra"); ?>
|
||||
<meta name="theme-color" content="#dadada">
|
||||
<!-- good developers check the markup ;) -->
|
||||
</head>
|
||||
<body>
|
||||
<div class="container">
|
||||
<div class="row">
|
||||
<?php echo $this->yieldContent("content"); ?>
|
||||
</div>
|
||||
</div>
|
||||
|
||||
<?php echo $this->yieldContent("jsextra"); ?>
|
||||
</body>
|
||||
|
||||
</html>
|
||||
@@ -0,0 +1,21 @@
|
||||
<!doctype html>
|
||||
<html class="no-js" lang="DE">
|
||||
<head>
|
||||
<meta charset="utf-8">
|
||||
|
||||
<title><?php echo \htmlentities($title??'', ENT_QUOTES, 'UTF-8', false); ?></title>
|
||||
|
||||
<?php echo $this->yieldContent("header"); ?>
|
||||
|
||||
<!-- good developers check the markup ;) -->
|
||||
</head>
|
||||
<body>
|
||||
<?php echo $this->yieldContent("body"); ?>
|
||||
|
||||
<footer>
|
||||
<table class="fusszeile">
|
||||
<?php echo $this->yieldContent("footer"); ?>
|
||||
</table>
|
||||
</footer>
|
||||
</body>
|
||||
</html>
|
||||
6
M5/Dossier/emensa/storage/cache/debug_1cfaf3bc805922afe3272185b5787ee3e27fa4ad.bladec
vendored
Normal file
6
M5/Dossier/emensa/storage/cache/debug_1cfaf3bc805922afe3272185b5787ee3e27fa4ad.bladec
vendored
Normal file
@@ -0,0 +1,6 @@
|
||||
<h1>This is a blade view showing phpinfo();</h1>
|
||||
<p><a href="/">go back</a>.</p>
|
||||
|
||||
<?php
|
||||
phpinfo();
|
||||
?>
|
||||
32
M5/Dossier/emensa/storage/cache/demo.dbdata_371b3aba36aa73bbc6704e7ce839ac185b43f3a9.bladec
vendored
Normal file
32
M5/Dossier/emensa/storage/cache/demo.dbdata_371b3aba36aa73bbc6704e7ce839ac185b43f3a9.bladec
vendored
Normal file
@@ -0,0 +1,32 @@
|
||||
<!DOCTYPE html>
|
||||
<html lang="de">
|
||||
<head>
|
||||
<meta charset="UTF-8">
|
||||
<title>Beispiel: Daten aus der Datenbank</title>
|
||||
</head>
|
||||
<body>
|
||||
|
||||
|
||||
<?php if(isset($data['error'])): ?>
|
||||
<h1>Es gab ein Problem mit der Datenbankverbindung</h1>
|
||||
<p>Fehlermeldung</p>
|
||||
<pre> <?php echo \htmlentities($data['beschreibung']??'', ENT_QUOTES, 'UTF-8', false); ?></pre>
|
||||
|
||||
<?php else: ?>
|
||||
|
||||
|
||||
<article>
|
||||
<h1>Daten aus der Datenbank der Tabelle: Gerichte</h1>
|
||||
<p>Der Controller inkludiert das benötigte Model (gerichte.php in diesem Fall)
|
||||
und ruft die benötigte Funktion <code>db_gerichte_select_all()</code> zum Laden der Daten auf</p>
|
||||
<ul>
|
||||
<?php $__empty_1 = true; foreach($data as $a): $__empty_1 = false; ?>
|
||||
<li><?php echo \htmlentities($a['name']??'', ENT_QUOTES, 'UTF-8', false); ?></li>
|
||||
<?php endforeach; if ($__empty_1): ?>
|
||||
<li>Keine Daten vorhanden.</li>
|
||||
<?php endif; ?>
|
||||
</ul>
|
||||
</article>
|
||||
<?php endif; ?>
|
||||
</body>
|
||||
</html>
|
||||
94
M5/Dossier/emensa/storage/cache/demo.demo_ce8d2fe4373603a01d84973e3d70c715b31a9f25.bladec
vendored
Normal file
94
M5/Dossier/emensa/storage/cache/demo.demo_ce8d2fe4373603a01d84973e3d70c715b31a9f25.bladec
vendored
Normal file
@@ -0,0 +1,94 @@
|
||||
<?php $_shouldextend[1]=1; ?>
|
||||
|
||||
<?php $this->startSection("content"); ?>
|
||||
<div>
|
||||
<h1>Demo für <?php echo \htmlentities($name??'', ENT_QUOTES, 'UTF-8', false); ?></h1>
|
||||
<p>Kurze Übersicht, wie die Arbeit mit dem Router und der Blade View-Engine funktioniert.</p>
|
||||
|
||||
<h2>Router</h2>
|
||||
<p>Der Router nimmt den Request entgegen und zerlegt ihn in die einzelnen Teile der URI. Wichtig ist hier vor
|
||||
allem der Pfad und der Querystring.</p>
|
||||
<p>Wenn der Pfad in der Routenkonfiguration (<code>\$config</code> Array aus der Datei
|
||||
<code>routes/web.php</code>) gefunden wird, lädt der Router die angegebene Klasse.</p>
|
||||
|
||||
<h3>Funktionsweise</h3>
|
||||
<p>Im vorliegenden Beispiel sehen Sie diese Seite ... </p>
|
||||
<ol>
|
||||
<li>weil der Pfad in der Routenkonfiguration gefunden wurde</li>
|
||||
<li>und dort <span class="code">'DemoController@howto'</span> hinterlegt ist</li>
|
||||
<li>und im Ordner <span class="code">controllers/</span> die Datei <code class="language-php">DemoController.php</code> gefunden werden konnte
|
||||
</li>
|
||||
<li>und mit ihr ein Objekt des Typs <span class="code">DemoController</span> instanziiert werden konnte</li>
|
||||
<li>und dieses Objekt die Funktion (Action) <span class="code">howto()</span> ausgeführt hat</li>
|
||||
</ol>
|
||||
<p>Sie sehen: da muss einiges stimmen und vieles davon ist Konvention.</p>
|
||||
<h3>Querystrings und Pfadsegmente</h3>
|
||||
<p>Die Actions in den Controller-Klassen sollen per Konvention immer ein <span class="code">RequestData</span> Objekt
|
||||
entgegennehmen. Beispiel: <code class="language-php">howto(RequestData \$rd)</code></p>
|
||||
<p>Dieses RequestData Objekt wird durch den Router befüllt, wenn Daten in der URL extrahiert werden konnten.</p>
|
||||
<p>Daten finden sich URLs...</p>
|
||||
|
||||
<ul>
|
||||
<li>
|
||||
<p>
|
||||
<strong>im Querystring</strong><br>Beispiel: rufen Sie diese mit
|
||||
<code class="language-http"><?php echo \htmlentities(strtolower(explode('/',$_SERVER["SERVER_PROTOCOL"])[0])??'', ENT_QUOTES, 'UTF-8', false); ?>://<?php echo \htmlentities($_SERVER["HTTP_HOST"]??'', ENT_QUOTES, 'UTF-8', false); ?>/demo?<strong>bgcolor=fefbd8&name=Remmy</strong></code>
|
||||
auf, werden <span class="language-php">bgcolor</span> und <code class="language-php">name</code> mitsamt Werten als Query Array
|
||||
<code class="language-php">$rd->query</code>) übergeben
|
||||
</p>
|
||||
</li>
|
||||
</ul>
|
||||
|
||||
<p>Probieren Sie es aus ;)</p>
|
||||
<?php if(count($rd->args)): ?>
|
||||
<p><strong>Argumente dieses Aufrufs:</strong></p>
|
||||
|
||||
<?php $__empty_1 = true; foreach($rd->args as $a): $__empty_1 = false; ?>
|
||||
<div><span class="code"><?php echo \htmlentities($a??'', ENT_QUOTES, 'UTF-8', false); ?></span></div>
|
||||
<?php endforeach; if ($__empty_1): ?>
|
||||
<p>Keine weiteren Argumente im Request</p>
|
||||
<?php endif; ?>
|
||||
<?php endif; ?>
|
||||
<?php if(count($rd->query)): ?>
|
||||
<p><strong>Daten aus der Query dieses Aufrufs:</strong></p>
|
||||
<pre><code class="language-php">
|
||||
<?php $__empty_1 = true; foreach($rd->query as $k => $v): $__empty_1 = false; ?>
|
||||
$rd->query['<?php echo \htmlentities($k??'', ENT_QUOTES, 'UTF-8', false); ?>']=<?php echo \htmlentities($v??'', ENT_QUOTES, 'UTF-8', false); ?>
|
||||
|
||||
<?php endforeach; if ($__empty_1): ?>
|
||||
<p>Keine Querydaten</p>
|
||||
<?php endif; ?>
|
||||
</code></pre>
|
||||
<?php endif; ?>
|
||||
<h2>Blade</h2>
|
||||
<p>Blade <a href="https://github.com/EFTEC/BladeOne#install-pick-one-of-the-next-one">muss installiert</a> sein.
|
||||
Die Installation ist bereits geschehen und die Bibliothek liegt unter /vendor.
|
||||
</p>
|
||||
<h3>Daten übergeben und View rendern</h3>
|
||||
<p>Bei der Verwendung der View-Engine gelten einige Konventionen:
|
||||
Die Dateien müssen <code class="language-php"><viewname>.blade.php</code> heißen und im Ordner <code class="language-php">views</code> liegen.
|
||||
</p>
|
||||
<p>Sie können der View dann Daten mitgeben, indem Sie alle Daten in ein Array schreiben und dieses dann
|
||||
übergeben.</p>
|
||||
<p>Beispiel:</p>
|
||||
<pre><code class="language-php">
|
||||
view("viewtest",
|
||||
array(
|
||||
"texts"=>$textArray,
|
||||
"persona"=>$persona,
|
||||
"rd"=>$rd
|
||||
)); // öffnet ../views/viewtest.blade.php
|
||||
</code></pre>
|
||||
</div>
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("cssextra"); ?>
|
||||
<style>
|
||||
body > div {background-color: <?php echo \htmlentities('#' . $bgcolor??'', ENT_QUOTES, 'UTF-8', false); ?>; }
|
||||
</style>
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("jsextra"); ?>
|
||||
<script src="/js/highlight.min.js"></script><script>hljs.highlightAll();</script>
|
||||
<?php $this->stopSection(); ?>
|
||||
<?php if (isset($_shouldextend[1])) { echo $this->runChild(".layouts.layout"); } ?>
|
||||
94
M5/Dossier/emensa/storage/cache/demo.demo_fc1036c569380dbc95c820cc4f5096087e39b268.bladec
vendored
Normal file
94
M5/Dossier/emensa/storage/cache/demo.demo_fc1036c569380dbc95c820cc4f5096087e39b268.bladec
vendored
Normal file
@@ -0,0 +1,94 @@
|
||||
<?php $_shouldextend[1]=1; ?>
|
||||
|
||||
<?php $this->startSection("content"); ?>
|
||||
<div>
|
||||
<h1>Demo für <?php echo \htmlentities($name??'', ENT_QUOTES, 'UTF-8', false); ?></h1>
|
||||
<p>Kurze Übersicht, wie die Arbeit mit dem Router und der Blade View-Engine funktioniert.</p>
|
||||
|
||||
<h2>Router</h2>
|
||||
<p>Der Router nimmt den Request entgegen und zerlegt ihn in die einzelnen Teile der URI. Wichtig ist hier vor
|
||||
allem der Pfad und der Querystring.</p>
|
||||
<p>Wenn der Pfad in der Routenkonfiguration (<code>\$config</code> Array aus der Datei
|
||||
<code>routes/web.php</code>) gefunden wird, lädt der Router die angegebene Klasse.</p>
|
||||
|
||||
<h3>Funktionsweise</h3>
|
||||
<p>Im vorliegenden Beispiel sehen Sie diese Seite ... </p>
|
||||
<ol>
|
||||
<li>weil der Pfad in der Routenkonfiguration gefunden wurde</li>
|
||||
<li>und dort <span class="code">'DemoController@howto'</span> hinterlegt ist</li>
|
||||
<li>und im Ordner <span class="code">controllers/</span> die Datei <code class="language-php">DemoController.php</code> gefunden werden konnte
|
||||
</li>
|
||||
<li>und mit ihr ein Objekt des Typs <span class="code">DemoController</span> instanziiert werden konnte</li>
|
||||
<li>und dieses Objekt die Funktion (Action) <span class="code">howto()</span> ausgeführt hat</li>
|
||||
</ol>
|
||||
<p>Sie sehen: da muss einiges stimmen und vieles davon ist Konvention.</p>
|
||||
<h3>Querystrings und Pfadsegmente</h3>
|
||||
<p>Die Actions in den Controller-Klassen sollen per Konvention immer ein <span class="code">RequestData</span> Objekt
|
||||
entgegennehmen. Beispiel: <code class="language-php">howto(RequestData \$rd)</code></p>
|
||||
<p>Dieses RequestData Objekt wird durch den Router befüllt, wenn Daten in der URL extrahiert werden konnten.</p>
|
||||
<p>Daten finden sich URLs...</p>
|
||||
|
||||
<ul>
|
||||
<li>
|
||||
<p>
|
||||
<strong>im Querystring</strong><br>Beispiel: rufen Sie diese mit
|
||||
<code class="language-http"><?php echo \htmlentities(strtolower(explode('/',$_SERVER["SERVER_PROTOCOL"])[0])??'', ENT_QUOTES, 'UTF-8', false); ?>://<?php echo \htmlentities($_SERVER["HTTP_HOST"]??'', ENT_QUOTES, 'UTF-8', false); ?>/demo?<strong>bgcolor=fefbd8&name=Remmy</strong></code>
|
||||
auf, werden <span class="language-php">bgcolor</span> und <code class="language-php">name</code> mitsamt Werten als Query Array
|
||||
<code class="language-php">$rd->query</code>) übergeben
|
||||
</p>
|
||||
</li>
|
||||
</ul>
|
||||
|
||||
<p>Probieren Sie es aus ;)</p>
|
||||
<?php if(count($rd->args)): ?>
|
||||
<p><strong>Argumente dieses Aufrufs:</strong></p>
|
||||
|
||||
<?php $__empty_1 = true; foreach($rd->args as $a): $__empty_1 = false; ?>
|
||||
<div><span class="code"><?php echo \htmlentities($a??'', ENT_QUOTES, 'UTF-8', false); ?></span></div>
|
||||
<?php endforeach; if ($__empty_1): ?>
|
||||
<p>Keine weiteren Argumente im Request</p>
|
||||
<?php endif; ?>
|
||||
<?php endif; ?>
|
||||
<?php if(count($rd->query)): ?>
|
||||
<p><strong>Daten aus der Query dieses Aufrufs:</strong></p>
|
||||
<pre><code class="language-php">
|
||||
<?php $__empty_1 = true; foreach($rd->query as $k => $v): $__empty_1 = false; ?>
|
||||
$rd->query['<?php echo \htmlentities($k??'', ENT_QUOTES, 'UTF-8', false); ?>']=<?php echo \htmlentities($v??'', ENT_QUOTES, 'UTF-8', false); ?>
|
||||
|
||||
<?php endforeach; if ($__empty_1): ?>
|
||||
<p>Keine Querydaten</p>
|
||||
<?php endif; ?>
|
||||
</code></pre>
|
||||
<?php endif; ?>
|
||||
<h2>Blade</h2>
|
||||
<p>Blade <a href="https://github.com/EFTEC/BladeOne#install-pick-one-of-the-next-one">muss installiert</a> sein.
|
||||
Die Installation ist bereits geschehen und die Bibliothek liegt unter /vendor.
|
||||
</p>
|
||||
<h3>Daten übergeben und View rendern</h3>
|
||||
<p>Bei der Verwendung der View-Engine gelten einige Konventionen:
|
||||
Die Dateien müssen <code class="language-php"><viewname>.blade.php</code> heißen und im Ordner <code class="language-php">views</code> liegen.
|
||||
</p>
|
||||
<p>Sie können der View dann Daten mitgeben, indem Sie alle Daten in ein Array schreiben und dieses dann
|
||||
übergeben.</p>
|
||||
<p>Beispiel:</p>
|
||||
<pre><code class="language-php">
|
||||
view("viewtest",
|
||||
array(
|
||||
"texts"=>$textArray,
|
||||
"persona"=>$persona,
|
||||
"rd"=>$rd
|
||||
)); // öffnet ../views/viewtest.blade.php
|
||||
</code></pre>
|
||||
</div>
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("cssextra"); ?>
|
||||
<style>
|
||||
body > div {background-color: <?php echo \htmlentities('#' . $bgcolor??'', ENT_QUOTES, 'UTF-8', false); ?>; }
|
||||
</style>
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("jsextra"); ?>
|
||||
<script src="/js/highlight.min.js"></script><script>hljs.highlightAll();</script>
|
||||
<?php $this->stopSection(); ?>
|
||||
<?php if (isset($_shouldextend[1])) { echo $this->runChild(".layouts.layout"); } ?>
|
||||
@@ -0,0 +1,14 @@
|
||||
<!DOCTYPE html>
|
||||
<html lang="de">
|
||||
<head>
|
||||
<meta charset="UTF-8">
|
||||
<title>7a</title>
|
||||
</head>
|
||||
<body>
|
||||
|
||||
Der Wert von name lautet: <?php echo \htmlentities($request??'', ENT_QUOTES, 'UTF-8', false); ?>
|
||||
|
||||
|
||||
|
||||
</body>
|
||||
</html>
|
||||
@@ -0,0 +1,41 @@
|
||||
<!DOCTYPE html>
|
||||
<html lang="de">
|
||||
<head>
|
||||
<meta charset="UTF-8">
|
||||
<title>Beispiel: Daten aus der Datenbank</title>
|
||||
|
||||
<style>
|
||||
h1 {
|
||||
font-weight: 300;
|
||||
}
|
||||
</style>
|
||||
</head>
|
||||
<body>
|
||||
|
||||
<?php if(isset($data['error'])): ?>
|
||||
<h1>Es gab ein Problem mit der Datenbankverbindung</h1>
|
||||
<p>Fehlermeldung</p>
|
||||
<pre> <?php echo \htmlentities($data['beschreibung']??'', ENT_QUOTES, 'UTF-8', false); ?></pre>
|
||||
|
||||
<?php else: ?>
|
||||
<?php
|
||||
$zweites = false; ?>
|
||||
|
||||
<article>
|
||||
<h1>Daten aus der Datenbank der Tabelle: Kategorien</h1>
|
||||
|
||||
<ul>
|
||||
<?php $__empty_1 = true; foreach($data as $a): $__empty_1 = false; ?>
|
||||
<?php if($zweites): ?> <h1><li><?php echo \htmlentities($a['name']??'', ENT_QUOTES, 'UTF-8', false); ?></li></h1> <?php $zweites = false; ?>
|
||||
<?php else: ?>
|
||||
<li><?php echo \htmlentities($a['name']??'', ENT_QUOTES, 'UTF-8', false); ?></li> <?php $zweites = true; ?>
|
||||
<?php endif; ?>
|
||||
<?php endforeach; if ($__empty_1): ?>
|
||||
<li>Keine Daten vorhanden.</li>
|
||||
<?php endif; ?>
|
||||
</ul>
|
||||
</article>
|
||||
<?php endif; ?>
|
||||
|
||||
</body>
|
||||
</html>
|
||||
@@ -0,0 +1,34 @@
|
||||
<!DOCTYPE html>
|
||||
<html lang="de">
|
||||
<head>
|
||||
<meta charset="UTF-8">
|
||||
<title>Beispiel: Daten aus der Datenbank</title>
|
||||
|
||||
</head>
|
||||
<body>
|
||||
|
||||
<?php if(isset($data['error'])): ?>
|
||||
<h1>Es gab ein Problem mit der Datenbankverbindung</h1>
|
||||
<p>Fehlermeldung</p>
|
||||
<pre> <?php echo \htmlentities($data['beschreibung']??'', ENT_QUOTES, 'UTF-8', false); ?></pre>
|
||||
|
||||
<?php else: ?>
|
||||
|
||||
<article>
|
||||
<h1>Daten aus der Datenbank der Tabelle: Kategorien</h1>
|
||||
|
||||
<ul>
|
||||
<?php $__empty_1 = true; foreach($data as $a): $__empty_1 = false; ?>
|
||||
<?php if(!empty($a['name'])): ?>
|
||||
<li><?php echo \htmlentities($a['name']??'', ENT_QUOTES, 'UTF-8', false); ?></li>
|
||||
<?php endif; ?>
|
||||
|
||||
<?php endforeach; if ($__empty_1): ?>
|
||||
<li>Es sind keine Gerichte vorhanden</li>
|
||||
<?php endif; ?>
|
||||
</ul>
|
||||
</article>
|
||||
<?php endif; ?>
|
||||
|
||||
</body>
|
||||
</html>
|
||||
@@ -0,0 +1,34 @@
|
||||
<!DOCTYPE html>
|
||||
<html lang="de">
|
||||
<head>
|
||||
<meta charset="UTF-8">
|
||||
<title>Beispiel: Daten aus der Datenbank</title>
|
||||
|
||||
</head>
|
||||
<body>
|
||||
|
||||
<?php if(isset($data['error'])): ?>
|
||||
<h1>Es gab ein Problem mit der Datenbankverbindung</h1>
|
||||
<p>Fehlermeldung</p>
|
||||
<pre> <?php echo \htmlentities($data['beschreibung']??'', ENT_QUOTES, 'UTF-8', false); ?></pre>
|
||||
|
||||
<?php else: ?>
|
||||
|
||||
<article>
|
||||
<h1>Daten aus der Datenbank der Tabelle: Kategorien</h1>
|
||||
|
||||
<ul>
|
||||
<?php $__empty_1 = true; foreach($data as $a): $__empty_1 = false; ?>
|
||||
<?php if(!empty($a['name'])): ?>
|
||||
<li><?php echo \htmlentities($a['name']??'', ENT_QUOTES, 'UTF-8', false); ?></li>
|
||||
<?php endif; ?>
|
||||
|
||||
<?php endforeach; if ($__empty_1): ?>
|
||||
<li>Es sind keine Gerichte vorhanden</li>
|
||||
<?php endif; ?>
|
||||
</ul>
|
||||
</article>
|
||||
<?php endif; ?>
|
||||
|
||||
</body>
|
||||
</html>
|
||||
@@ -0,0 +1,14 @@
|
||||
<?php $_shouldextend[1]=1; ?>
|
||||
|
||||
<?php $this->startSection("header"); ?>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("body"); ?>
|
||||
<p>Page 1</p>
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("footer"); ?>
|
||||
<p>Footer of Page 1</p>
|
||||
<?php $this->stopSection(); ?>
|
||||
<?php if (isset($_shouldextend[1])) { echo $this->runChild(".layouts.m4_7d_layout",['title' => "Page 1"]); } ?>
|
||||
@@ -0,0 +1,14 @@
|
||||
<?php $_shouldextend[1]=1; ?>
|
||||
|
||||
<?php $this->startSection("header"); ?>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("body"); ?>
|
||||
<p>Page 2</p>
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("footer"); ?>
|
||||
<p>Footer of Page 2</p>
|
||||
<?php $this->stopSection(); ?>
|
||||
<?php if (isset($_shouldextend[1])) { echo $this->runChild(".layouts.m4_7d_layout",['title' => "Page 2"]); } ?>
|
||||
36
M5/Dossier/emensa/storage/cache/home_be3f101c28919ade210629435b0b22d1f6f23f27.bladec
vendored
Normal file
36
M5/Dossier/emensa/storage/cache/home_be3f101c28919ade210629435b0b22d1f6f23f27.bladec
vendored
Normal file
@@ -0,0 +1,36 @@
|
||||
<?php $_shouldextend[1]=1; ?>
|
||||
|
||||
<?php $this->startSection("content"); ?>
|
||||
<header class="mt-5">
|
||||
<h1>Hauptseite E-Mensa</h1>
|
||||
<img src="/img/test.jpg"
|
||||
alt="Testbild von https://cdn.pixabay.com/photo/2014/06/03/19/38/road-sign-361513_960_720.jpg">
|
||||
</header>
|
||||
<nav class="mt-5">
|
||||
<strong>Navigation</strong>
|
||||
<ul>
|
||||
<li><a href="/demo">Demo</a></li>
|
||||
<li><a href="/dbconnect">Datenbank: Gerichte</a></li>
|
||||
</ul>
|
||||
<ul>
|
||||
<li><a href="/debug"><code class="language-php">phpinfo();</code></a></li>
|
||||
</ul>
|
||||
</nav>
|
||||
<footer>
|
||||
© Team-Name DBWT
|
||||
</footer>
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("cssextra"); ?>
|
||||
<style>
|
||||
body > div {
|
||||
background-color: <?php echo \htmlentities($rd->query['bgcolor'] ?? 'ffffff'??'', ENT_QUOTES, 'UTF-8', false); ?>
|
||||
|
||||
}
|
||||
</style>
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("jsextra"); ?>
|
||||
<script src="/js/highlight.min.js"></script><script>hljs.highlightAll();</script>
|
||||
<?php $this->stopSection(); ?>
|
||||
<?php if (isset($_shouldextend[1])) { echo $this->runChild("layouts.layout"); } ?>
|
||||
23
M5/Dossier/emensa/storage/cache/layouts.layout_2f0f79205058eeea097745ed1e89073738d8b7f7.bladec
vendored
Normal file
23
M5/Dossier/emensa/storage/cache/layouts.layout_2f0f79205058eeea097745ed1e89073738d8b7f7.bladec
vendored
Normal file
@@ -0,0 +1,23 @@
|
||||
<!doctype html>
|
||||
<html class="no-js" lang="DE">
|
||||
<head>
|
||||
<meta charset="utf-8">
|
||||
<title>E-Mensa Routing Script</title>
|
||||
<meta name="description" content="unused">
|
||||
<meta name="viewport" content="width=device-width, initial-scale=1">
|
||||
<link rel="stylesheet" href="css/default.min.css">
|
||||
<?php echo $this->yieldContent("cssextra"); ?>
|
||||
<meta name="theme-color" content="#dadada">
|
||||
<!-- good developers check the markup ;) -->
|
||||
</head>
|
||||
<body>
|
||||
<div class="container">
|
||||
<div class="row">
|
||||
<?php echo $this->yieldContent("content"); ?>
|
||||
</div>
|
||||
</div>
|
||||
|
||||
<?php echo $this->yieldContent("jsextra"); ?>
|
||||
</body>
|
||||
|
||||
</html>
|
||||
@@ -0,0 +1,30 @@
|
||||
<!doctype html>
|
||||
<html class="no-js" lang="DE">
|
||||
<head>
|
||||
<meta charset="utf-8">
|
||||
|
||||
<title><?php echo \htmlentities($title??'', ENT_QUOTES, 'UTF-8', false); ?></title>
|
||||
|
||||
<?php echo $this->yieldContent("header"); ?>
|
||||
|
||||
<!-- good developers check the markup ;) -->
|
||||
</head>
|
||||
<body>
|
||||
<?php echo $this->yieldContent("nav"); ?>
|
||||
<hr>
|
||||
<div class="grid">
|
||||
<div></div>
|
||||
<div>
|
||||
<?php echo $this->yieldContent("text"); ?>
|
||||
|
||||
<?php echo $this->yieldContent("gerichte"); ?>
|
||||
</div>
|
||||
<div></div>
|
||||
</div>
|
||||
<footer>
|
||||
<table class="fusszeile">
|
||||
<?php echo $this->yieldContent("footer"); ?>
|
||||
</table>
|
||||
</footer>
|
||||
</body>
|
||||
</html>
|
||||
@@ -0,0 +1,30 @@
|
||||
<!doctype html>
|
||||
<html class="no-js" lang="DE">
|
||||
<head>
|
||||
<meta charset="utf-8">
|
||||
|
||||
<title><?php echo \htmlentities($title??'', ENT_QUOTES, 'UTF-8', false); ?></title>
|
||||
|
||||
<?php echo $this->yieldContent("header"); ?>
|
||||
|
||||
<!-- good developers check the markup ;) -->
|
||||
</head>
|
||||
<body>
|
||||
<?php echo $this->yieldContent("nav"); ?>
|
||||
<hr>
|
||||
<div class="grid">
|
||||
<div></div>
|
||||
<div>
|
||||
<?php echo $this->yieldContent("text"); ?>
|
||||
|
||||
<?php echo $this->yieldContent("gerichte"); ?>
|
||||
</div>
|
||||
<div></div>
|
||||
</div>
|
||||
<footer>
|
||||
<table class="fusszeile">
|
||||
<?php echo $this->yieldContent("footer"); ?>
|
||||
</table>
|
||||
</footer>
|
||||
</body>
|
||||
</html>
|
||||
@@ -0,0 +1,30 @@
|
||||
<!doctype html>
|
||||
<html class="no-js" lang="DE">
|
||||
<head>
|
||||
<meta charset="utf-8">
|
||||
|
||||
<title><?php echo \htmlentities($title??'', ENT_QUOTES, 'UTF-8', false); ?></title>
|
||||
|
||||
<?php echo $this->yieldContent("header"); ?>
|
||||
|
||||
<!-- good developers check the markup ;) -->
|
||||
</head>
|
||||
<body>
|
||||
<?php echo $this->yieldContent("nav"); ?>
|
||||
<hr>
|
||||
<div class="grid">
|
||||
<div></div>
|
||||
<div>
|
||||
<?php echo $this->yieldContent("text"); ?>
|
||||
|
||||
<?php echo $this->yieldContent("gerichte"); ?>
|
||||
</div>
|
||||
<div></div>
|
||||
</div>
|
||||
<footer>
|
||||
<table class="fusszeile">
|
||||
<?php echo $this->yieldContent("footer"); ?>
|
||||
</table>
|
||||
</footer>
|
||||
</body>
|
||||
</html>
|
||||
@@ -0,0 +1,30 @@
|
||||
<!doctype html>
|
||||
<html class="no-js" lang="DE">
|
||||
<head>
|
||||
<meta charset="utf-8">
|
||||
|
||||
<title><?php echo \htmlentities($title??'', ENT_QUOTES, 'UTF-8', false); ?></title>
|
||||
|
||||
<?php echo $this->yieldContent("header"); ?>
|
||||
|
||||
<!-- good developers check the markup ;) -->
|
||||
</head>
|
||||
<body>
|
||||
<?php echo $this->yieldContent("nav"); ?>
|
||||
<hr>
|
||||
<div class="grid">
|
||||
<div></div>
|
||||
<div>
|
||||
<?php echo $this->yieldContent("text"); ?>
|
||||
|
||||
<?php echo $this->yieldContent("gerichte"); ?>
|
||||
</div>
|
||||
<div></div>
|
||||
</div>
|
||||
<footer>
|
||||
<table class="fusszeile">
|
||||
<?php echo $this->yieldContent("footer"); ?>
|
||||
</table>
|
||||
</footer>
|
||||
</body>
|
||||
</html>
|
||||
12
M5/Dossier/emensa/storage/cache/m5_a1.abmeldung_17f241c320c4a8a9a33bfe29835f14c33bd19626.bladec
vendored
Normal file
12
M5/Dossier/emensa/storage/cache/m5_a1.abmeldung_17f241c320c4a8a9a33bfe29835f14c33bd19626.bladec
vendored
Normal file
@@ -0,0 +1,12 @@
|
||||
<?php $_shouldextend[1]=1; ?>
|
||||
|
||||
<?php $this->startSection("main"); ?>
|
||||
|
||||
<?php if(!isset($_SESSION['name'])): ?>
|
||||
|
||||
<meta http-equiv="refresh" content="0;url=/" />
|
||||
|
||||
<?php endif; ?>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
<?php if (isset($_shouldextend[1])) { echo $this->runChild("m5_a1.layout_anmeldung"); } ?>
|
||||
25
M5/Dossier/emensa/storage/cache/m5_a1.anmeldung_01c45fd41d095952aa184fb3fc764d18878732cb.bladec
vendored
Normal file
25
M5/Dossier/emensa/storage/cache/m5_a1.anmeldung_01c45fd41d095952aa184fb3fc764d18878732cb.bladec
vendored
Normal file
@@ -0,0 +1,25 @@
|
||||
<?php $_shouldextend[1]=1; ?>
|
||||
|
||||
<?php $this->startSection("main"); ?>
|
||||
|
||||
<form action="/anmeldung_verifizieren" method="post">
|
||||
|
||||
<label for="email">E-Mail</label>
|
||||
<input id="email" name="email" type="email" placeholder="email" required maxlength="100">
|
||||
|
||||
<label for="passwort">Passwort</label>
|
||||
<input id="passwort" name="passwort" type="password" placeholder="passwort" required maxlength="200">
|
||||
|
||||
<button type="submit" >Anmelden</button>
|
||||
</form>
|
||||
|
||||
<?php if(!isset($anmeldung)): ?> Bitte anmelden!
|
||||
<?php elseif($anmeldung == 1): ?>
|
||||
<?php echo \htmlentities(session_start()??'', ENT_QUOTES, 'UTF-8', false); ?>
|
||||
|
||||
Anmeldung erlaubt!
|
||||
<?php else: ?> Es ist ein Fehler aufgetretten!
|
||||
<?php endif; ?>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
<?php if (isset($_shouldextend[1])) { echo $this->runChild("m5_a1.layout_anmeldung"); } ?>
|
||||
25
M5/Dossier/emensa/storage/cache/m5_a1.anmeldung_c24d33e917eb7ef9d14d646f11f37749504ff5c8.bladec
vendored
Normal file
25
M5/Dossier/emensa/storage/cache/m5_a1.anmeldung_c24d33e917eb7ef9d14d646f11f37749504ff5c8.bladec
vendored
Normal file
@@ -0,0 +1,25 @@
|
||||
<?php $_shouldextend[1]=1; ?>
|
||||
|
||||
<?php $this->startSection("main"); ?>
|
||||
|
||||
<form action="/anmeldung_verifizieren" method="post">
|
||||
|
||||
<label for="email">E-Mail</label>
|
||||
<input id="email" name="email" type="email" placeholder="email" required maxlength="100">
|
||||
|
||||
<label for="passwort">Passwort</label>
|
||||
<input id="passwort" name="passwort" type="password" placeholder="passwort" required maxlength="200">
|
||||
|
||||
<button type="submit" >Anmelden</button>
|
||||
</form>
|
||||
|
||||
<?php if(!isset($anmeldung)): ?> Bitte anmelden!
|
||||
<?php elseif($anmeldung == 1): ?>
|
||||
<?php echo \htmlentities(session_start()??'', ENT_QUOTES, 'UTF-8', false); ?>
|
||||
|
||||
Anmeldung erlaubt!
|
||||
<?php else: ?> Es ist ein Fehler aufgetretten!
|
||||
<?php endif; ?>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
<?php if (isset($_shouldextend[1])) { echo $this->runChild("m5_a1.layout_anmeldung"); } ?>
|
||||
@@ -0,0 +1,51 @@
|
||||
<?php $_shouldextend[1]=1; ?>
|
||||
|
||||
<?php $this->startSection("main"); ?>
|
||||
|
||||
<?php if($anmeldung == 1): ?>
|
||||
<meta http-equiv="refresh" content="/"/>
|
||||
<form id="form_ok" action="/"></form>
|
||||
|
||||
<script type="text/javascript">
|
||||
|
||||
function formAutoSubmit() {
|
||||
|
||||
var frm = document.getElementById("form_ok");
|
||||
|
||||
frm.submit();
|
||||
|
||||
}
|
||||
|
||||
|
||||
window.onload = formAutoSubmit;
|
||||
|
||||
</script>
|
||||
<?php else: ?>
|
||||
|
||||
<form method="post" id="auto_form" action="/anmeldung_fehler">
|
||||
<input type="hidden" name="email" value=<?php echo \htmlentities($email??'', ENT_QUOTES, 'UTF-8', false); ?>>
|
||||
<input type="hidden" name="passwort" value=<?php echo \htmlentities($passwort??'', ENT_QUOTES, 'UTF-8', false); ?>>
|
||||
<input type="hidden" name="anmeldung" value=<?php echo \htmlentities($anmeldung??'', ENT_QUOTES, 'UTF-8', false); ?>>
|
||||
</form>
|
||||
|
||||
<script type="text/javascript">
|
||||
|
||||
function formAutoSubmit() {
|
||||
|
||||
var frm = document.getElementById("auto_form");
|
||||
|
||||
frm.submit();
|
||||
|
||||
}
|
||||
|
||||
window.onload = formAutoSubmit;
|
||||
|
||||
</script>
|
||||
<?php endif; ?>
|
||||
|
||||
<img src="https://upload.wikimedia.org/wikipedia/commons/b/b1/Loading_icon.gif?20151024034921" alt="loading">
|
||||
<br>
|
||||
Bitte warten!
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
<?php if (isset($_shouldextend[1])) { echo $this->runChild("m5_a1.layout_anmeldung"); } ?>
|
||||
@@ -0,0 +1,21 @@
|
||||
<!doctype html>
|
||||
<html class="no-js" lang="DE">
|
||||
<head>
|
||||
<meta charset="utf-8">
|
||||
<title>Layout-m5-a1</title>
|
||||
</head>
|
||||
<body>
|
||||
<header class="header_7d">
|
||||
<?php echo $this->yieldContent("header"); ?>
|
||||
</header>
|
||||
|
||||
<main class="main">
|
||||
<?php echo $this->yieldContent("main"); ?>
|
||||
</main>
|
||||
|
||||
<footer class="footer">
|
||||
<?php echo $this->yieldContent("footer"); ?>
|
||||
</footer>
|
||||
|
||||
</body>
|
||||
</html>
|
||||
@@ -0,0 +1,21 @@
|
||||
<!doctype html>
|
||||
<html class="no-js" lang="DE">
|
||||
<head>
|
||||
<meta charset="utf-8">
|
||||
<title>Layout-m5-a1</title>
|
||||
</head>
|
||||
<body>
|
||||
<header class="header_7d">
|
||||
<?php echo $this->yieldContent("header"); ?>
|
||||
</header>
|
||||
|
||||
<main class="main">
|
||||
<?php echo $this->yieldContent("main"); ?>
|
||||
</main>
|
||||
|
||||
<footer class="footer">
|
||||
<?php echo $this->yieldContent("footer"); ?>
|
||||
</footer>
|
||||
|
||||
</body>
|
||||
</html>
|
||||
62
M5/Dossier/emensa/storage/cache/main.index_1dae39c16001572743356f32c7852146f9bbc1ec.bladec
vendored
Normal file
62
M5/Dossier/emensa/storage/cache/main.index_1dae39c16001572743356f32c7852146f9bbc1ec.bladec
vendored
Normal file
@@ -0,0 +1,62 @@
|
||||
<?php $_shouldextend[1]=1; ?>
|
||||
|
||||
<?php $this->startSection("header"); ?>
|
||||
<link rel="stylesheet" href="/css/style.css">
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("nav"); ?>
|
||||
<div class="grid">
|
||||
<div>
|
||||
<img src="/img/fh-logo.jpg" alt="FH-Logo">
|
||||
</div>
|
||||
<div>
|
||||
<a href="#ankündigung">Ankündigung</a>
|
||||
<a href="#speisen">Speisen</a>
|
||||
<a href="#zahlen">Zahlen</a>
|
||||
<a href="#kontakt">Kontakt</a>
|
||||
<a href="#wichtig">Wichtig für uns</a>
|
||||
|
||||
</div>
|
||||
</div>
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("text"); ?>
|
||||
|
||||
<img src="/img/mensa21.jpg" alt="Essen">
|
||||
<h1 id="ankündigung">Bald gibt es auch Essen online ;)</h1>
|
||||
<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et
|
||||
dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet
|
||||
clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,
|
||||
consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,
|
||||
sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no
|
||||
sea takimata sanctus est Lorem ipsum dolor sit amet.</p>
|
||||
<h1 id="speisen">Köstlichkeiten die Sie erwarten</h1>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("gerichte"); ?>
|
||||
|
||||
<?php if(isset($data['error'])): ?>
|
||||
<h1>Es gab ein Problem mit der Datenbankverbindung</h1>
|
||||
<p>Fehlermeldung</p>
|
||||
<pre> <?php echo \htmlentities($data['beschreibung']??'', ENT_QUOTES, 'UTF-8', false); ?></pre>
|
||||
|
||||
<?php else: ?>
|
||||
<?php
|
||||
echo $data["gericht"];
|
||||
echo $data["allergene"];
|
||||
?>
|
||||
<?php endif; ?>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("footer"); ?>
|
||||
|
||||
<tr>
|
||||
<td>(c) E-Mensa GmbH</td>
|
||||
<td>Şafak Hazinedar & Robert Joel</td>
|
||||
<td><a href="">Impressum</a></td>
|
||||
</tr>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
<?php if (isset($_shouldextend[1])) { echo $this->runChild("layouts.main_layout", ['title' => "E-Mensa"]); } ?>
|
||||
73
M5/Dossier/emensa/storage/cache/main.index_9109369b5cbb1a20226820e2c52ae9625c829d43.bladec
vendored
Normal file
73
M5/Dossier/emensa/storage/cache/main.index_9109369b5cbb1a20226820e2c52ae9625c829d43.bladec
vendored
Normal file
@@ -0,0 +1,73 @@
|
||||
<?php $_shouldextend[1]=1; ?>
|
||||
|
||||
<?php $this->startSection("header"); ?>
|
||||
<link rel="stylesheet" href="/css/style.css">
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("nav"); ?>
|
||||
<div class="grid">
|
||||
<div>
|
||||
<img src="/img/fh-logo.jpg" alt="FH-Logo">
|
||||
</div>
|
||||
<div>
|
||||
<a href="#ankündigung">Ankündigung</a>
|
||||
<a href="#speisen">Speisen</a>
|
||||
<a href="#zahlen">Zahlen</a>
|
||||
<a href="#kontakt">Kontakt</a>
|
||||
<a href="#wichtig">Wichtig für uns</a>
|
||||
|
||||
</div>
|
||||
<div>
|
||||
|
||||
<?php if(($_SESSION['login'] ?? NULL) == 0): ?>
|
||||
<a href="/anmeldung">Anmelden</a>
|
||||
<?php else: ?>
|
||||
Angemeldet als:<br>
|
||||
<div><?php echo \htmlentities($_SESSION['name']??'', ENT_QUOTES, 'UTF-8', false); ?></div>
|
||||
<a href="/abmeldung">Abmelden</a>
|
||||
<?php endif; ?>
|
||||
</div>
|
||||
</div>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("text"); ?>
|
||||
|
||||
<img src="/img/mensa21.jpg" alt="Essen">
|
||||
<h1 id="ankündigung">Bald gibt es auch Essen online ;)</h1>
|
||||
<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et
|
||||
dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet
|
||||
clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,
|
||||
consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,
|
||||
sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no
|
||||
sea takimata sanctus est Lorem ipsum dolor sit amet.</p>
|
||||
<h1 id="speisen">Köstlichkeiten die Sie erwarten</h1>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("gerichte"); ?>
|
||||
|
||||
<?php if(isset($data['error'])): ?>
|
||||
<h1>Es gab ein Problem mit der Datenbankverbindung</h1>
|
||||
<p>Fehlermeldung</p>
|
||||
<pre> <?php echo \htmlentities($data['beschreibung']??'', ENT_QUOTES, 'UTF-8', false); ?></pre>
|
||||
|
||||
<?php else: ?>
|
||||
<?php
|
||||
echo $data["gericht"];
|
||||
echo $data["allergene"];
|
||||
?>
|
||||
<?php endif; ?>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("footer"); ?>
|
||||
|
||||
<tr>
|
||||
<td>(c) E-Mensa GmbH</td>
|
||||
<td>Şafak Hazinedar & Robert Joel</td>
|
||||
<td><a href="">Impressum</a></td>
|
||||
</tr>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
<?php if (isset($_shouldextend[1])) { echo $this->runChild("layouts.main_layout", ['title' => "E-Mensa"]); } ?>
|
||||
112
M5/Dossier/emensa/storage/cache/main.index_b8ca93da07664813b96b9705f586eaa04a44db3c.bladec
vendored
Normal file
112
M5/Dossier/emensa/storage/cache/main.index_b8ca93da07664813b96b9705f586eaa04a44db3c.bladec
vendored
Normal file
@@ -0,0 +1,112 @@
|
||||
<?php $_shouldextend[1]=1; ?>
|
||||
|
||||
<?php $this->startSection("header"); ?>
|
||||
<link rel="stylesheet" href="/css/style.css">
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("nav"); ?>
|
||||
<div class="grid">
|
||||
<div>
|
||||
<img src="/img/fh-logo.jpg" alt="FH-Logo">
|
||||
</div>
|
||||
<div>
|
||||
<a href="#ankündigung">Ankündigung</a>
|
||||
<a href="#speisen">Speisen</a>
|
||||
<a href="#zahlen">Zahlen</a>
|
||||
<a href="#kontakt">Kontakt</a>
|
||||
<a href="#wichtig">Wichtig für uns</a>
|
||||
|
||||
</div>
|
||||
<div>
|
||||
|
||||
<?php if(($_SESSION['login'] ?? NULL) == 0): ?>
|
||||
<a href="/anmeldung">Anmelden</a>
|
||||
<?php else: ?>
|
||||
Angemeldet als:<br>
|
||||
<div><?php echo \htmlentities($_SESSION['name']??'', ENT_QUOTES, 'UTF-8', false); ?></div>
|
||||
<a href="/abmeldung">Abmelden</a>
|
||||
<?php endif; ?>
|
||||
</div>
|
||||
</div>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("text"); ?>
|
||||
|
||||
<img src="/img/mensa21.jpg" alt="Essen">
|
||||
<h1 id="ankündigung">Bald gibt es auch Essen online ;)</h1>
|
||||
<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et
|
||||
dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet
|
||||
clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,
|
||||
consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,
|
||||
sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no
|
||||
sea takimata sanctus est Lorem ipsum dolor sit amet.</p>
|
||||
<h1 id="speisen">Köstlichkeiten die Sie erwarten</h1>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("gerichte"); ?>
|
||||
|
||||
|
||||
<?php if(isset($data['error'])): ?>
|
||||
<h1>Es gab ein Problem mit der Datenbankverbindung</h1>
|
||||
<p>Fehlermeldung</p>
|
||||
<pre> <?php echo \htmlentities($data['beschreibung']??'', ENT_QUOTES, 'UTF-8', false); ?></pre>
|
||||
|
||||
<?php else: ?>
|
||||
<?php
|
||||
|
||||
$result_sql_allergen = $data["result_sql_allergen"];
|
||||
$verwendete_allergene_code = $data["verwendete_allergene_code"];
|
||||
$result_sql_gerichte = $data["result_sql_gerichte"];
|
||||
$verwendete_allergene_string = $data["allergene"];
|
||||
$allergene = $data["allergene1"];
|
||||
|
||||
$tabelle = "<table class=\"speisen\"><tr class=\"speisen\"> <td>Gerichte</td><td>Preis intern</td><td>Preis extern</td><td>Bild</td></tr>";
|
||||
|
||||
|
||||
|
||||
while ($row_gerichte = mysqli_fetch_assoc($result_sql_gerichte)) {
|
||||
|
||||
$preisintern = number_format($row_gerichte['preisintern'], 2, ',', '.');
|
||||
$preisextern = number_format($row_gerichte['preisextern'], 2, ',', '.');
|
||||
|
||||
$bildname = $row_gerichte['bildname'];
|
||||
|
||||
if ($bildname == Null) {
|
||||
$bildname = "00_image_missing.jpg";
|
||||
}
|
||||
|
||||
$bildname = "/img/gerichte/" . $bildname;
|
||||
|
||||
$tabelle .= "<tr class=\"speisen\"><td>" . htmlspecialchars($row_gerichte['name']) . " <sup>" . htmlspecialchars($allergene) . "</sup></td><td>" . htmlspecialchars($preisintern) . "€</td><td>" . htmlspecialchars($preisextern) . "€</td><td> <img src=\"" . $bildname . "\" alt =\"Bild vom Gericht\" width= \"10\" height=\"10\"> </td></tr>";
|
||||
|
||||
|
||||
}
|
||||
$tabelle .= "</table>";
|
||||
|
||||
while ($row_allergen = mysqli_fetch_assoc($result_sql_allergen)) {
|
||||
if (in_array($row_allergen['code'], $verwendete_allergene_code)) {
|
||||
$verwendete_allergene_string .= "<sup>" . htmlspecialchars($row_allergen['code']) . "</sup> " . htmlspecialchars($row_allergen['name']) . ", ";
|
||||
}
|
||||
}
|
||||
|
||||
|
||||
|
||||
echo $tabelle;
|
||||
echo $verwendete_allergene_string;
|
||||
?>
|
||||
<?php endif; ?>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("footer"); ?>
|
||||
|
||||
<tr>
|
||||
<td>(c) E-Mensa GmbH</td>
|
||||
<td>Şafak Hazinedar & Robert Joel</td>
|
||||
<td><a href="">Impressum</a></td>
|
||||
</tr>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
<?php if (isset($_shouldextend[1])) { echo $this->runChild("layouts.main_layout", ['title' => "E-Mensa"]); } ?>
|
||||
62
M5/Dossier/emensa/storage/cache/main.index_f9ba54cc63d68ab97f296301b5ce3ed3926b073a.bladec
vendored
Normal file
62
M5/Dossier/emensa/storage/cache/main.index_f9ba54cc63d68ab97f296301b5ce3ed3926b073a.bladec
vendored
Normal file
@@ -0,0 +1,62 @@
|
||||
<?php $_shouldextend[1]=1; ?>
|
||||
|
||||
<?php $this->startSection("header"); ?>
|
||||
<link rel="stylesheet" href="/css/style.css">
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("nav"); ?>
|
||||
<div class="grid">
|
||||
<div>
|
||||
<img src="/img/fh-logo.jpg" alt="FH-Logo">
|
||||
</div>
|
||||
<div>
|
||||
<a href="#ankündigung">Ankündigung</a>
|
||||
<a href="#speisen">Speisen</a>
|
||||
<a href="#zahlen">Zahlen</a>
|
||||
<a href="#kontakt">Kontakt</a>
|
||||
<a href="#wichtig">Wichtig für uns</a>
|
||||
|
||||
</div>
|
||||
</div>
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("text"); ?>
|
||||
|
||||
<img src="/img/mensa21.jpg" alt="Essen">
|
||||
<h1 id="ankündigung">Bald gibt es auch Essen online ;)</h1>
|
||||
<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et
|
||||
dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet
|
||||
clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,
|
||||
consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,
|
||||
sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no
|
||||
sea takimata sanctus est Lorem ipsum dolor sit amet.</p>
|
||||
<h1 id="speisen">Köstlichkeiten die Sie erwarten</h1>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("gerichte"); ?>
|
||||
|
||||
<?php if(isset($data['error'])): ?>
|
||||
<h1>Es gab ein Problem mit der Datenbankverbindung</h1>
|
||||
<p>Fehlermeldung</p>
|
||||
<pre> <?php echo \htmlentities($data['beschreibung']??'', ENT_QUOTES, 'UTF-8', false); ?></pre>
|
||||
|
||||
<?php else: ?>
|
||||
<?php
|
||||
echo $data["gericht"];
|
||||
echo $data["allergene"];
|
||||
?>
|
||||
<?php endif; ?>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
|
||||
<?php $this->startSection("footer"); ?>
|
||||
|
||||
<tr>
|
||||
<td>(c) E-Mensa GmbH</td>
|
||||
<td>Şafak Hazinedar & Robert Joel</td>
|
||||
<td><a href="">Impressum</a></td>
|
||||
</tr>
|
||||
|
||||
<?php $this->stopSection(); ?>
|
||||
<?php if (isset($_shouldextend[1])) { echo $this->runChild("layouts.main_layout", ['title' => "E-Mensa"]); } ?>
|
||||
9
M5/Dossier/emensa/storage/logs/anmeldung.txt
Normal file
9
M5/Dossier/emensa/storage/logs/anmeldung.txt
Normal file
@@ -0,0 +1,9 @@
|
||||
[2023-12-20T16:18:29.055116+00:00] anmeldung.WARNING: Anmeldung fehlgeschlagen! [] []
|
||||
[2023-12-20T16:18:56.231427+00:00] anmeldung.INFO: Anmeldung erfolgreich! [] []
|
||||
[2023-12-20T16:19:05.370972+00:00] anmeldung.INFO: Abmeldung erfolgreich! [] []
|
||||
[2023-12-21T14:29:55.917076+00:00] anmeldung.INFO: Anmeldung erfolgreich! [] []
|
||||
[2024-01-06T17:35:10.417463+00:00] anmeldung.INFO: Abmeldung erfolgreich! [] []
|
||||
[2024-01-06T18:40:26.912833+00:00] anmeldung.INFO: Anmeldung erfolgreich! [] []
|
||||
[2024-01-06T18:40:42.244963+00:00] anmeldung.INFO: Abmeldung erfolgreich! [] []
|
||||
[2024-01-06T18:50:32.238610+00:00] anmeldung.INFO: Anmeldung erfolgreich! [] []
|
||||
[2024-01-06T18:50:56.848358+00:00] anmeldung.INFO: Abmeldung erfolgreich! [] []
|
||||
17
M5/Dossier/emensa/storage/logs/werbeseite_log.txt
Normal file
17
M5/Dossier/emensa/storage/logs/werbeseite_log.txt
Normal file
@@ -0,0 +1,17 @@
|
||||
[2023-12-20T16:17:52.471118+00:00] werbeseite_log.INFO: werbeseite aufgerufen! [] []
|
||||
[2023-12-20T16:18:56.302288+00:00] werbeseite_log.INFO: werbeseite aufgerufen! [] []
|
||||
[2023-12-20T16:19:05.430442+00:00] werbeseite_log.INFO: werbeseite aufgerufen! [] []
|
||||
[2023-12-21T14:22:30.892716+00:00] werbeseite_log.INFO: werbeseite aufgerufen! [] []
|
||||
[2023-12-21T14:29:56.044899+00:00] werbeseite_log.INFO: werbeseite aufgerufen! [] []
|
||||
[2024-01-06T17:35:05.003569+00:00] werbeseite_log.INFO: werbeseite aufgerufen! [] []
|
||||
[2024-01-06T17:35:10.520517+00:00] werbeseite_log.INFO: werbeseite aufgerufen! [] []
|
||||
[2024-01-06T18:40:01.915599+00:00] werbeseite_log.INFO: werbeseite aufgerufen! [] []
|
||||
[2024-01-06T18:40:27.020355+00:00] werbeseite_log.INFO: werbeseite aufgerufen! [] []
|
||||
[2024-01-06T18:40:36.435542+00:00] werbeseite_log.INFO: werbeseite aufgerufen! [] []
|
||||
[2024-01-06T18:40:37.189838+00:00] werbeseite_log.INFO: werbeseite aufgerufen! [] []
|
||||
[2024-01-06T18:40:37.906183+00:00] werbeseite_log.INFO: werbeseite aufgerufen! [] []
|
||||
[2024-01-06T18:40:38.505567+00:00] werbeseite_log.INFO: werbeseite aufgerufen! [] []
|
||||
[2024-01-06T18:40:42.359774+00:00] werbeseite_log.INFO: werbeseite aufgerufen! [] []
|
||||
[2024-01-06T18:50:12.019483+00:00] werbeseite_log.INFO: werbeseite aufgerufen! [] []
|
||||
[2024-01-06T18:50:32.335954+00:00] werbeseite_log.INFO: werbeseite aufgerufen! [] []
|
||||
[2024-01-06T18:50:56.902291+00:00] werbeseite_log.INFO: werbeseite aufgerufen! [] []
|
||||
25
M5/Dossier/emensa/vendor/autoload.php
vendored
Normal file
25
M5/Dossier/emensa/vendor/autoload.php
vendored
Normal file
@@ -0,0 +1,25 @@
|
||||
<?php
|
||||
|
||||
// autoload.php @generated by Composer
|
||||
|
||||
if (PHP_VERSION_ID < 50600) {
|
||||
if (!headers_sent()) {
|
||||
header('HTTP/1.1 500 Internal Server Error');
|
||||
}
|
||||
$err = 'Composer 2.3.0 dropped support for autoloading on PHP <5.6 and you are running '.PHP_VERSION.', please upgrade PHP or use Composer 2.2 LTS via "composer self-update --2.2". Aborting.'.PHP_EOL;
|
||||
if (!ini_get('display_errors')) {
|
||||
if (PHP_SAPI === 'cli' || PHP_SAPI === 'phpdbg') {
|
||||
fwrite(STDERR, $err);
|
||||
} elseif (!headers_sent()) {
|
||||
echo $err;
|
||||
}
|
||||
}
|
||||
trigger_error(
|
||||
$err,
|
||||
E_USER_ERROR
|
||||
);
|
||||
}
|
||||
|
||||
require_once __DIR__ . '/composer/autoload_real.php';
|
||||
|
||||
return ComposerAutoloaderInit0a19be8f09bdc5d4e2b07ba9e95a5801::getLoader();
|
||||
18
M5/Dossier/emensa/vendor/bin/bladeonecli
vendored
Normal file
18
M5/Dossier/emensa/vendor/bin/bladeonecli
vendored
Normal file
@@ -0,0 +1,18 @@
|
||||
#!/usr/bin/env php
|
||||
<?php
|
||||
|
||||
/**
|
||||
* Proxy PHP file generated by Composer
|
||||
*
|
||||
* This file includes the referenced bin path (../eftec/bladeone/lib/bladeonecli)
|
||||
*
|
||||
* @generated
|
||||
*/
|
||||
|
||||
namespace Composer;
|
||||
|
||||
$GLOBALS['_composer_bin_dir'] = __DIR__;
|
||||
$GLOBALS['_composer_autoload_path'] = __DIR__ . '/..'.'/autoload.php';
|
||||
|
||||
|
||||
return include __DIR__ . '/..'.'/eftec/bladeone/lib/bladeonecli';
|
||||
Some files were not shown because too many files have changed in this diff Show More
Reference in New Issue
Block a user