Compare commits
25 Commits
dev/m5_rob
...
dev/m6_rob
| Author | SHA1 | Date | |
|---|---|---|---|
|
c13606c2c1 | ||
|
|
91856073e1 | ||
|
|
15d9287b47 | ||
|
|
462eee8994 | ||
|
|
98a3c6c790 | ||
|
|
abeefa2d74 | ||
|
|
5756f2b7d5 | ||
|
|
800d84bd41 | ||
|
|
d47f00093a | ||
|
|
aa936198c8 | ||
|
|
bab5bfd58e | ||
|
|
57a4470de3 | ||
|
|
92eb1b5363 | ||
|
|
3a74c02aec | ||
|
|
96a8f48982 | ||
|
|
8ef27c6b85 | ||
|
|
e7eb81b896 | ||
|
|
7f4c73d91d | ||
|
|
5ca6283aa3 | ||
|
|
713d5059b7 | ||
|
|
67e88a8185 | ||
|
|
a605ce4d34 | ||
|
|
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>
|
||||
|
||||
193
.idea/workspace.xml
generated
193
.idea/workspace.xml
generated
@@ -4,32 +4,30 @@
|
||||
<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">
|
||||
<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/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" />
|
||||
</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 +35,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 +57,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/Dossier",
|
||||
"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\Dossier" />
|
||||
<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" />
|
||||
</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 +102,114 @@
|
||||
<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="13412000" />
|
||||
<workItem from="1706091740788" duration="2624000" />
|
||||
</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>
|
||||
<task id="LOCAL-00009" summary="Alles bis auf paar sachen">
|
||||
<option name="closed" value="true" />
|
||||
<created>1705682140622</created>
|
||||
<option name="number" value="00009" />
|
||||
<option name="presentableId" value="LOCAL-00009" />
|
||||
<option name="project" value="LOCAL" />
|
||||
<updated>1705682140622</updated>
|
||||
</task>
|
||||
<task id="LOCAL-00010" summary="Alles">
|
||||
<option name="closed" value="true" />
|
||||
<created>1705683562748</created>
|
||||
<option name="number" value="00010" />
|
||||
<option name="presentableId" value="LOCAL-00010" />
|
||||
<option name="project" value="LOCAL" />
|
||||
<updated>1705683562748</updated>
|
||||
</task>
|
||||
<option name="localTasksCounter" value="11" />
|
||||
<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" />
|
||||
<MESSAGE value="Alles" />
|
||||
<option name="LAST_COMMIT_MESSAGE" value="Alles" />
|
||||
</component>
|
||||
</project>
|
||||
9
M5/.idea/M5.iml
generated
9
M5/.idea/M5.iml
generated
@@ -2,8 +2,17 @@
|
||||
<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" />
|
||||
|
||||
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>
|
||||
2
M5/.idea/dataSources.xml
generated
2
M5/.idea/dataSources.xml
generated
@@ -1,7 +1,7 @@
|
||||
<?xml version="1.0" encoding="UTF-8"?>
|
||||
<project version="4">
|
||||
<component name="DataSourceManagerImpl" format="xml" multifile-model="true">
|
||||
<data-source source="LOCAL" name="emensawerbeseite" uuid="0a2c3473-febe-491a-b3f1-82e9ba5b153f">
|
||||
<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>
|
||||
|
||||
2
M5/.idea/modules.xml
generated
2
M5/.idea/modules.xml
generated
@@ -2,7 +2,7 @@
|
||||
<project version="4">
|
||||
<component name="ProjectModuleManager">
|
||||
<modules>
|
||||
<module fileurl="file://$PROJECT_DIR$/.idea/M4.iml" filepath="$PROJECT_DIR$/.idea/M4.iml" />
|
||||
<module fileurl="file://$PROJECT_DIR$/.idea/M5.iml" filepath="$PROJECT_DIR$/.idea/M5.iml" />
|
||||
</modules>
|
||||
</component>
|
||||
</project>
|
||||
21
M5/.idea/php.xml
generated
21
M5/.idea/php.xml
generated
@@ -10,10 +10,29 @@
|
||||
<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" />
|
||||
<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>
|
||||
|
||||
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>
|
||||
@@ -1,19 +0,0 @@
|
||||
<mxfile host="Electron" modified="2023-12-01T15:21:01.688Z" agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) draw.io/22.1.2 Chrome/114.0.5735.289 Electron/25.9.4 Safari/537.36" etag="78gUQK1TRnweegfurtHK" version="22.1.2" type="device">
|
||||
<diagram name="Seite-1" id="jhCbnHoXzx65MXILfqUJ">
|
||||
<mxGraphModel dx="1050" dy="725" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
|
||||
<root>
|
||||
<mxCell id="0" />
|
||||
<mxCell id="1" parent="0" />
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-1" value="" style="rhombus;whiteSpace=wrap;html=1;" vertex="1" parent="1">
|
||||
<mxGeometry x="320" y="240" width="160" height="80" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-2" value="" style="rounded=0;whiteSpace=wrap;html=1;" vertex="1" parent="1">
|
||||
<mxGeometry x="80" y="240" width="160" height="80" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-3" value="" style="rounded=0;whiteSpace=wrap;html=1;" vertex="1" parent="1">
|
||||
<mxGeometry x="560" y="240" width="160" height="80" as="geometry" />
|
||||
</mxCell>
|
||||
</root>
|
||||
</mxGraphModel>
|
||||
</diagram>
|
||||
</mxfile>
|
||||
@@ -1,91 +0,0 @@
|
||||
<mxfile host="Electron" modified="2023-12-02T22:05:22.197Z" agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) draw.io/22.1.2 Chrome/114.0.5735.289 Electron/25.9.4 Safari/537.36" etag="rtvPorWLK5CfuI4500ka" version="22.1.2" type="device">
|
||||
<diagram name="Seite-1" id="jhCbnHoXzx65MXILfqUJ">
|
||||
<mxGraphModel dx="1048" dy="722" grid="0" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
|
||||
<root>
|
||||
<mxCell id="0" />
|
||||
<mxCell id="1" parent="0" />
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-1" value="erstellt" style="rhombus;whiteSpace=wrap;html=1;" parent="1" vertex="1">
|
||||
<mxGeometry x="320" y="240" width="160" height="80" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-2" value="Wunschgericht" style="rounded=0;whiteSpace=wrap;html=1;" parent="1" vertex="1">
|
||||
<mxGeometry x="560" y="240" width="160" height="80" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-3" value="Ersteller" style="rounded=0;whiteSpace=wrap;html=1;" parent="1" vertex="1">
|
||||
<mxGeometry x="80" y="240" width="160" height="80" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-4" value="Name" style="ellipse;whiteSpace=wrap;html=1;" parent="1" vertex="1">
|
||||
<mxGeometry x="560" y="140" width="80" height="40" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-5" value="Beschreibung" style="ellipse;whiteSpace=wrap;html=1;" parent="1" vertex="1">
|
||||
<mxGeometry x="680" y="140" width="80" height="40" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-6" value="Erstellungs-datum" style="ellipse;whiteSpace=wrap;html=1;" parent="1" vertex="1">
|
||||
<mxGeometry x="500" y="180" width="80" height="40" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-7" value="ID" style="ellipse;whiteSpace=wrap;html=1;fontStyle=4" parent="1" vertex="1">
|
||||
<mxGeometry x="620" y="180" width="80" height="40" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-12" value="" style="endArrow=none;html=1;rounded=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;" parent="1" target="8l75yZ3mhxg1qXRySu_G-5" edge="1">
|
||||
<mxGeometry width="50" height="50" relative="1" as="geometry">
|
||||
<mxPoint x="700" y="240" as="sourcePoint" />
|
||||
<mxPoint x="750" y="190" as="targetPoint" />
|
||||
</mxGeometry>
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-13" value="" style="endArrow=none;html=1;rounded=0;exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.621;entryY=0.005;entryDx=0;entryDy=0;entryPerimeter=0;" parent="1" source="8l75yZ3mhxg1qXRySu_G-7" target="8l75yZ3mhxg1qXRySu_G-2" edge="1">
|
||||
<mxGeometry width="50" height="50" relative="1" as="geometry">
|
||||
<mxPoint x="730" y="280" as="sourcePoint" />
|
||||
<mxPoint x="780" y="230" as="targetPoint" />
|
||||
</mxGeometry>
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-14" value="" style="endArrow=none;html=1;rounded=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;" parent="1" target="8l75yZ3mhxg1qXRySu_G-4" edge="1">
|
||||
<mxGeometry width="50" height="50" relative="1" as="geometry">
|
||||
<mxPoint x="600" y="240" as="sourcePoint" />
|
||||
<mxPoint x="628" y="154" as="targetPoint" />
|
||||
</mxGeometry>
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-15" value="" style="endArrow=none;html=1;rounded=0;entryX=1;entryY=1;entryDx=0;entryDy=0;exitX=0.15;exitY=0.003;exitDx=0;exitDy=0;exitPerimeter=0;" parent="1" source="8l75yZ3mhxg1qXRySu_G-2" target="8l75yZ3mhxg1qXRySu_G-6" edge="1">
|
||||
<mxGeometry width="50" height="50" relative="1" as="geometry">
|
||||
<mxPoint x="610" y="250" as="sourcePoint" />
|
||||
<mxPoint x="610" y="170" as="targetPoint" />
|
||||
</mxGeometry>
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-17" value="" style="endArrow=none;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" parent="1" edge="1">
|
||||
<mxGeometry width="50" height="50" relative="1" as="geometry">
|
||||
<mxPoint x="480" y="279.66" as="sourcePoint" />
|
||||
<mxPoint x="560" y="279.66" as="targetPoint" />
|
||||
</mxGeometry>
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-18" value="Name" style="ellipse;whiteSpace=wrap;html=1;" parent="1" vertex="1">
|
||||
<mxGeometry x="80" y="160" width="80" height="40" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-19" value="<u>E-Mail</u>" style="ellipse;whiteSpace=wrap;html=1;" parent="1" vertex="1">
|
||||
<mxGeometry x="170" y="160" width="80" height="40" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-20" value="" style="endArrow=none;html=1;rounded=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;exitX=0.25;exitY=0;exitDx=0;exitDy=0;" parent="1" source="8l75yZ3mhxg1qXRySu_G-3" edge="1">
|
||||
<mxGeometry width="50" height="50" relative="1" as="geometry">
|
||||
<mxPoint x="100" y="260" as="sourcePoint" />
|
||||
<mxPoint x="120" y="200" as="targetPoint" />
|
||||
</mxGeometry>
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-21" value="" style="endArrow=none;html=1;rounded=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;exitX=0.25;exitY=0;exitDx=0;exitDy=0;" parent="1" edge="1">
|
||||
<mxGeometry width="50" height="50" relative="1" as="geometry">
|
||||
<mxPoint x="209.65999999999997" y="240" as="sourcePoint" />
|
||||
<mxPoint x="209.65999999999997" y="200" as="targetPoint" />
|
||||
</mxGeometry>
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-22" value="N" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" parent="1" vertex="1">
|
||||
<mxGeometry x="530" y="250" width="30" height="30" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-23" value="1" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" parent="1" vertex="1">
|
||||
<mxGeometry x="240" y="250" width="30" height="30" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-24" value="" style="endArrow=none;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" parent="1" edge="1">
|
||||
<mxGeometry width="50" height="50" relative="1" as="geometry">
|
||||
<mxPoint x="240" y="280" as="sourcePoint" />
|
||||
<mxPoint x="320" y="280" as="targetPoint" />
|
||||
</mxGeometry>
|
||||
</mxCell>
|
||||
</root>
|
||||
</mxGraphModel>
|
||||
</diagram>
|
||||
</mxfile>
|
||||
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;
|
||||
@@ -1,91 +0,0 @@
|
||||
<mxfile host="Electron" modified="2023-12-02T22:05:19.234Z" agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) draw.io/22.1.2 Chrome/114.0.5735.289 Electron/25.9.4 Safari/537.36" etag="UqWXQEsGpaBe1QuKew26" version="22.1.2" type="device">
|
||||
<diagram name="Seite-1" id="jhCbnHoXzx65MXILfqUJ">
|
||||
<mxGraphModel dx="1048" dy="722" grid="0" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
|
||||
<root>
|
||||
<mxCell id="0" />
|
||||
<mxCell id="1" parent="0" />
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-1" value="erstellt" style="rhombus;whiteSpace=wrap;html=1;" parent="1" vertex="1">
|
||||
<mxGeometry x="320" y="240" width="160" height="80" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-2" value="Wunschgericht" style="rounded=0;whiteSpace=wrap;html=1;" parent="1" vertex="1">
|
||||
<mxGeometry x="560" y="240" width="160" height="80" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-3" value="Ersteller" style="rounded=0;whiteSpace=wrap;html=1;" parent="1" vertex="1">
|
||||
<mxGeometry x="80" y="240" width="160" height="80" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-4" value="Name" style="ellipse;whiteSpace=wrap;html=1;" parent="1" vertex="1">
|
||||
<mxGeometry x="560" y="140" width="80" height="40" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-5" value="Beschreibung" style="ellipse;whiteSpace=wrap;html=1;" parent="1" vertex="1">
|
||||
<mxGeometry x="680" y="140" width="80" height="40" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-6" value="Erstellungs-datum" style="ellipse;whiteSpace=wrap;html=1;" parent="1" vertex="1">
|
||||
<mxGeometry x="500" y="180" width="80" height="40" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-7" value="ID" style="ellipse;whiteSpace=wrap;html=1;fontStyle=4" parent="1" vertex="1">
|
||||
<mxGeometry x="620" y="180" width="80" height="40" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-12" value="" style="endArrow=none;html=1;rounded=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;" parent="1" target="8l75yZ3mhxg1qXRySu_G-5" edge="1">
|
||||
<mxGeometry width="50" height="50" relative="1" as="geometry">
|
||||
<mxPoint x="700" y="240" as="sourcePoint" />
|
||||
<mxPoint x="750" y="190" as="targetPoint" />
|
||||
</mxGeometry>
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-13" value="" style="endArrow=none;html=1;rounded=0;exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.621;entryY=0.005;entryDx=0;entryDy=0;entryPerimeter=0;" parent="1" source="8l75yZ3mhxg1qXRySu_G-7" target="8l75yZ3mhxg1qXRySu_G-2" edge="1">
|
||||
<mxGeometry width="50" height="50" relative="1" as="geometry">
|
||||
<mxPoint x="730" y="280" as="sourcePoint" />
|
||||
<mxPoint x="780" y="230" as="targetPoint" />
|
||||
</mxGeometry>
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-14" value="" style="endArrow=none;html=1;rounded=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;" parent="1" target="8l75yZ3mhxg1qXRySu_G-4" edge="1">
|
||||
<mxGeometry width="50" height="50" relative="1" as="geometry">
|
||||
<mxPoint x="600" y="240" as="sourcePoint" />
|
||||
<mxPoint x="628" y="154" as="targetPoint" />
|
||||
</mxGeometry>
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-15" value="" style="endArrow=none;html=1;rounded=0;entryX=1;entryY=1;entryDx=0;entryDy=0;exitX=0.15;exitY=0.003;exitDx=0;exitDy=0;exitPerimeter=0;" parent="1" source="8l75yZ3mhxg1qXRySu_G-2" target="8l75yZ3mhxg1qXRySu_G-6" edge="1">
|
||||
<mxGeometry width="50" height="50" relative="1" as="geometry">
|
||||
<mxPoint x="610" y="250" as="sourcePoint" />
|
||||
<mxPoint x="610" y="170" as="targetPoint" />
|
||||
</mxGeometry>
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-17" value="" style="endArrow=none;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" parent="1" edge="1">
|
||||
<mxGeometry width="50" height="50" relative="1" as="geometry">
|
||||
<mxPoint x="480" y="279.66" as="sourcePoint" />
|
||||
<mxPoint x="560" y="279.66" as="targetPoint" />
|
||||
</mxGeometry>
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-18" value="Name" style="ellipse;whiteSpace=wrap;html=1;" parent="1" vertex="1">
|
||||
<mxGeometry x="80" y="160" width="80" height="40" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-19" value="<u>E-Mail</u>" style="ellipse;whiteSpace=wrap;html=1;" parent="1" vertex="1">
|
||||
<mxGeometry x="170" y="160" width="80" height="40" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-20" value="" style="endArrow=none;html=1;rounded=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;exitX=0.25;exitY=0;exitDx=0;exitDy=0;" parent="1" source="8l75yZ3mhxg1qXRySu_G-3" edge="1">
|
||||
<mxGeometry width="50" height="50" relative="1" as="geometry">
|
||||
<mxPoint x="100" y="260" as="sourcePoint" />
|
||||
<mxPoint x="120" y="200" as="targetPoint" />
|
||||
</mxGeometry>
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-21" value="" style="endArrow=none;html=1;rounded=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;exitX=0.25;exitY=0;exitDx=0;exitDy=0;" parent="1" edge="1">
|
||||
<mxGeometry width="50" height="50" relative="1" as="geometry">
|
||||
<mxPoint x="209.65999999999997" y="240" as="sourcePoint" />
|
||||
<mxPoint x="209.65999999999997" y="200" as="targetPoint" />
|
||||
</mxGeometry>
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-22" value="N" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" parent="1" vertex="1">
|
||||
<mxGeometry x="530" y="250" width="30" height="30" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-23" value="1" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" parent="1" vertex="1">
|
||||
<mxGeometry x="240" y="250" width="30" height="30" as="geometry" />
|
||||
</mxCell>
|
||||
<mxCell id="8l75yZ3mhxg1qXRySu_G-24" value="" style="endArrow=none;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" parent="1" edge="1">
|
||||
<mxGeometry width="50" height="50" relative="1" as="geometry">
|
||||
<mxPoint x="240" y="280" as="sourcePoint" />
|
||||
<mxPoint x="320" y="280" as="targetPoint" />
|
||||
</mxGeometry>
|
||||
</mxCell>
|
||||
</root>
|
||||
</mxGraphModel>
|
||||
</diagram>
|
||||
</mxfile>
|
||||
Binary file not shown.
|
Before Width: | Height: | Size: 56 KiB |
153
M5/Dossier/M4.md
153
M5/Dossier/M4.md
@@ -1,153 +0,0 @@
|
||||
# Aufgabe 1
|
||||
> Dauer: 2 h
|
||||
## 1)
|
||||
|
||||
## 2) Datenbankentwurf in Relationenschreibweise
|
||||
```sql
|
||||
use emensawerbeseite;
|
||||
|
||||
-- Tabelle 'Ersteller' erstellen
|
||||
CREATE TABLE IF NOT EXISTS Ersteller (
|
||||
EMail VARCHAR(255) PRIMARY KEY,
|
||||
Name VARCHAR(255) DEFAULT 'anonym'
|
||||
);
|
||||
|
||||
-- Tabelle 'Wunschgericht' erstellen
|
||||
CREATE TABLE IF NOT EXISTS Wunschgericht (
|
||||
ID INT AUTO_INCREMENT PRIMARY KEY,
|
||||
Name VARCHAR(255) NOT NULL,
|
||||
Beschreibung TEXT,
|
||||
Erstellungsdatum DATE NOT NULL,
|
||||
Ersteller_EMail VARCHAR(255) NOT NULL,
|
||||
FOREIGN KEY (Ersteller_EMail) REFERENCES Ersteller(EMail)
|
||||
);
|
||||
```
|
||||
## 6)
|
||||
### a)
|
||||
````sql
|
||||
select * from wunschgericht order by Erstellungsdatum desc limit 5;
|
||||
````
|
||||
### b)
|
||||
````sql
|
||||
-- basierend auf M3 6) 4)
|
||||
select ersteller.Name,
|
||||
count(Ersteller_EMail) as anzahl from wunschgericht, ersteller where ersteller.EMail = wunschgericht.Ersteller_EMail
|
||||
group by Ersteller_EMail
|
||||
order by anzahl desc ;
|
||||
````
|
||||
---
|
||||
# Aufgabe 2
|
||||
> Dauer: 2h
|
||||
|
||||
Bei der Übergabe von Daten in die DB müssen diese geprüft werden.
|
||||
Bei der Ausgabe von Daten aus der DB im HTML Code müssen diese Maskiert werden.
|
||||
````php
|
||||
// wunschgericht.php
|
||||
// Zeile 33
|
||||
$sql_ersteller_exists = "SELECT * FROM ersteller WHERE EMail = '" . $ersteller_email . "'";
|
||||
$sql_ersteller_exists = "SELECT * FROM ersteller WHERE EMail = '" . mysqli_real_escape_string($link, $ersteller_email) . "'";
|
||||
|
||||
// Zeile 36
|
||||
$sql_ersteller = "INSERT INTO ersteller(EMail, Name) VALUES ('" . $ersteller_email . "','" . $ersteller_name . "')";
|
||||
$sql_ersteller = "INSERT INTO ersteller(EMail, Name) VALUES ('" . mysqli_real_escape_string($link, $ersteller_email) . "','" . mysqli_real_escape_string($link, $ersteller_name) . "')";
|
||||
|
||||
// Zeile 42
|
||||
$sql = "INSERT INTO wunschgericht(Name, Beschreibung, Erstellungsdatum, Ersteller_EMail) VALUES ('" . $gericht_name . "','" . $gericht_beschreibung . "','". $date ."','" . $ersteller_email . "')";
|
||||
$sql = "INSERT INTO wunschgericht(Name, Beschreibung, Erstellungsdatum, Ersteller_EMail) VALUES ('" . mysqli_real_escape_string($link, $gericht_name) . "','" . mysqli_real_escape_string($link, $gericht_beschreibung) . "','".$date."','" . mysqli_real_escape_string($link, $ersteller_email) . "')";
|
||||
?>
|
||||
````
|
||||
|
||||
````php
|
||||
// index.php
|
||||
// Zeile 43
|
||||
$sql_besucher = "UPDATE besucher_counter SET besucher =".$besucherCount;
|
||||
$sql_besucher = "UPDATE besucher_counter SET besucher =". mysqli_real_escape_string($link, $besucherCount);
|
||||
|
||||
// Zeile 190
|
||||
$tabelle .= "<tr class=\"speisen\"><td>" . $row_gerichte['name'] . " <sup>" . $allergene . "</sup></td><td>" . $preisintern . "€</td><td>" . $preisextern . "€</td><td>Kein Bild in der Datenbank </td></tr>";
|
||||
$tabelle .= "<tr class=\"speisen\"><td>" . htmlspecialchars($row_gerichte['name']) . " <sup>" . htmlspecialchars($allergene) . "</sup></td><td>" . htmlspecialchars($preisintern) . "€</td><td>" . htmlspecialchars($preisextern) . "€</td><td>Kein Bild in der Datenbank </td></tr>";
|
||||
|
||||
|
||||
// Zeile 202
|
||||
$verwendete_allergene_string .= "<sup>".$row_allergen['code']."</sup> ". $row_allergen['name']. ", ";
|
||||
$verwendete_allergene_string .= "<sup>". htmlspecialchars($row_allergen['code']) ."</sup> ". htmlspecialchars($row_allergen['name']) . ", ";
|
||||
|
||||
// Zeile 214f
|
||||
echo $besucherCount;
|
||||
echo $newletterCount;
|
||||
|
||||
echo htmlspecialchars($besucherCount);
|
||||
echo htmlspecialchars($newletterCount);
|
||||
|
||||
// Zeile 220
|
||||
echo $ausgabe["COUNT(id)"];
|
||||
echo htmlspecialchars($ausgabe["COUNT(id)"]);
|
||||
````
|
||||
Bei der Newsletteranmeldung sollte man sich auch ggf. überlegen, wie man die Eingaben prüft un zu vermeiden, das schadhafter Code gespeichert und später abgerufen wird.
|
||||
|
||||
# Aufgabe 4
|
||||
> Dauer 1,5 h
|
||||
1. Eindeutigkeit für die Kombination aus Gericht und Kategorie sicherstellen
|
||||
````sql
|
||||
ALTER TABLE gericht_hat_kategorie
|
||||
ADD CONSTRAINT gericht_kategorie_unique UNIQUE (gericht_id, kategorie_id);
|
||||
````
|
||||
2. In der Tabelle gericht soll eine Abfrage nach Name beschleunigt werden.
|
||||
````sql
|
||||
ALTER TABLE gericht
|
||||
ADD INDEX idx_name (name);
|
||||
````
|
||||
3. Bei Löschung eines Gerichts sollen
|
||||
1) die zugehörigen Zuordnungen zu einer Kategorie sowie
|
||||
````sql
|
||||
ALTER TABLE gericht_hat_kategorie
|
||||
DROP FOREIGN KEY gericht_hat_kategorie_ibfk_1, -- (gericht_id) -> gericht(id)
|
||||
ADD CONSTRAINT gericht_hat_kategorie_ibfk_1_new
|
||||
FOREIGN KEY (gericht_id) REFERENCES gericht(id)
|
||||
ON DELETE CASCADE;
|
||||
````
|
||||
2) die zugehörigen Zuordnungen zu Allergenen automatisch mit gelöscht werden.
|
||||
````sql
|
||||
ALTER TABLE gericht_hat_allergen
|
||||
DROP FOREIGN KEY gericht_hat_allergen_ibfk_2, -- (gericht_id) -> gericht(id)
|
||||
ADD CONSTRAINT gericht_hat_allergen_ibfk_2_new
|
||||
FOREIGN KEY (gericht_id) REFERENCES gericht(id)
|
||||
ON DELETE CASCADE;
|
||||
````
|
||||
4. Eine Kategorie kann nur dann gelöscht werden, wenn
|
||||
1) dieser keine Gerichte zugeordnet sind und
|
||||
````sql
|
||||
ALTER TABLE gericht_hat_kategorie
|
||||
ADD CONSTRAINT fk_gericht_hat_kategorie_kategorie_id
|
||||
FOREIGN KEY (kategorie_id) REFERENCES kategorie(id)
|
||||
ON DELETE RESTRICT;
|
||||
````
|
||||
2) diese keine Kindkategorien besitzt.
|
||||
````sql
|
||||
ALTER TABLE kategorie
|
||||
ADD CONSTRAINT fk_kategorie_eltern_id
|
||||
FOREIGN KEY (eltern_id) REFERENCES kategorie(id)
|
||||
ON DELETE RESTRICT;
|
||||
````
|
||||
5. Wird der Code eines Allergens verändert, so ändert sich dieser Code automatisch in den referenzierenden Datensätzen.
|
||||
````sql
|
||||
ALTER TABLE gericht_hat_allergen
|
||||
DROP FOREIGN KEY gericht_hat_allergen_ibfk_1, -- (code) -> allergen(code)
|
||||
ADD CONSTRAINT gericht_hat_allergen_ibfk_1_new
|
||||
FOREIGN KEY (code) REFERENCES allergen(code)
|
||||
ON UPDATE CASCADE;
|
||||
````
|
||||
6. Eine Kombination aus ``gericht_id`` und ``kategorie_id`` in ``gericht_hat_kategorie`` soll als Primärschlüssel dienen.
|
||||
````sql
|
||||
ALTER TABLE gericht_hat_kategorie
|
||||
ADD PRIMARY KEY (gericht_id, kategorie_id);
|
||||
````
|
||||
|
||||
# Aufgabe 6
|
||||
> Dauer 20 min
|
||||
|
||||
# Aufgabe 7
|
||||
> Dauer 2,5 h
|
||||
|
||||
# Aufgabe 8
|
||||
> Dauer 1 h
|
||||
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';
|
||||
579
M5/Dossier/emensa/vendor/composer/ClassLoader.php
vendored
Normal file
579
M5/Dossier/emensa/vendor/composer/ClassLoader.php
vendored
Normal file
@@ -0,0 +1,579 @@
|
||||
<?php
|
||||
|
||||
/*
|
||||
* This file is part of Composer.
|
||||
*
|
||||
* (c) Nils Adermann <naderman@naderman.de>
|
||||
* Jordi Boggiano <j.boggiano@seld.be>
|
||||
*
|
||||
* For the full copyright and license information, please view the LICENSE
|
||||
* file that was distributed with this source code.
|
||||
*/
|
||||
|
||||
namespace Composer\Autoload;
|
||||
|
||||
/**
|
||||
* ClassLoader implements a PSR-0, PSR-4 and classmap class loader.
|
||||
*
|
||||
* $loader = new \Composer\Autoload\ClassLoader();
|
||||
*
|
||||
* // register classes with namespaces
|
||||
* $loader->add('Symfony\Component', __DIR__.'/component');
|
||||
* $loader->add('Symfony', __DIR__.'/framework');
|
||||
*
|
||||
* // activate the autoloader
|
||||
* $loader->register();
|
||||
*
|
||||
* // to enable searching the include path (eg. for PEAR packages)
|
||||
* $loader->setUseIncludePath(true);
|
||||
*
|
||||
* In this example, if you try to use a class in the Symfony\Component
|
||||
* namespace or one of its children (Symfony\Component\Console for instance),
|
||||
* the autoloader will first look for the class under the component/
|
||||
* directory, and it will then fallback to the framework/ directory if not
|
||||
* found before giving up.
|
||||
*
|
||||
* This class is loosely based on the Symfony UniversalClassLoader.
|
||||
*
|
||||
* @author Fabien Potencier <fabien@symfony.com>
|
||||
* @author Jordi Boggiano <j.boggiano@seld.be>
|
||||
* @see https://www.php-fig.org/psr/psr-0/
|
||||
* @see https://www.php-fig.org/psr/psr-4/
|
||||
*/
|
||||
class ClassLoader
|
||||
{
|
||||
/** @var \Closure(string):void */
|
||||
private static $includeFile;
|
||||
|
||||
/** @var string|null */
|
||||
private $vendorDir;
|
||||
|
||||
// PSR-4
|
||||
/**
|
||||
* @var array<string, array<string, int>>
|
||||
*/
|
||||
private $prefixLengthsPsr4 = array();
|
||||
/**
|
||||
* @var array<string, list<string>>
|
||||
*/
|
||||
private $prefixDirsPsr4 = array();
|
||||
/**
|
||||
* @var list<string>
|
||||
*/
|
||||
private $fallbackDirsPsr4 = array();
|
||||
|
||||
// PSR-0
|
||||
/**
|
||||
* List of PSR-0 prefixes
|
||||
*
|
||||
* Structured as array('F (first letter)' => array('Foo\Bar (full prefix)' => array('path', 'path2')))
|
||||
*
|
||||
* @var array<string, array<string, list<string>>>
|
||||
*/
|
||||
private $prefixesPsr0 = array();
|
||||
/**
|
||||
* @var list<string>
|
||||
*/
|
||||
private $fallbackDirsPsr0 = array();
|
||||
|
||||
/** @var bool */
|
||||
private $useIncludePath = false;
|
||||
|
||||
/**
|
||||
* @var array<string, string>
|
||||
*/
|
||||
private $classMap = array();
|
||||
|
||||
/** @var bool */
|
||||
private $classMapAuthoritative = false;
|
||||
|
||||
/**
|
||||
* @var array<string, bool>
|
||||
*/
|
||||
private $missingClasses = array();
|
||||
|
||||
/** @var string|null */
|
||||
private $apcuPrefix;
|
||||
|
||||
/**
|
||||
* @var array<string, self>
|
||||
*/
|
||||
private static $registeredLoaders = array();
|
||||
|
||||
/**
|
||||
* @param string|null $vendorDir
|
||||
*/
|
||||
public function __construct($vendorDir = null)
|
||||
{
|
||||
$this->vendorDir = $vendorDir;
|
||||
self::initializeIncludeClosure();
|
||||
}
|
||||
|
||||
/**
|
||||
* @return array<string, list<string>>
|
||||
*/
|
||||
public function getPrefixes()
|
||||
{
|
||||
if (!empty($this->prefixesPsr0)) {
|
||||
return call_user_func_array('array_merge', array_values($this->prefixesPsr0));
|
||||
}
|
||||
|
||||
return array();
|
||||
}
|
||||
|
||||
/**
|
||||
* @return array<string, list<string>>
|
||||
*/
|
||||
public function getPrefixesPsr4()
|
||||
{
|
||||
return $this->prefixDirsPsr4;
|
||||
}
|
||||
|
||||
/**
|
||||
* @return list<string>
|
||||
*/
|
||||
public function getFallbackDirs()
|
||||
{
|
||||
return $this->fallbackDirsPsr0;
|
||||
}
|
||||
|
||||
/**
|
||||
* @return list<string>
|
||||
*/
|
||||
public function getFallbackDirsPsr4()
|
||||
{
|
||||
return $this->fallbackDirsPsr4;
|
||||
}
|
||||
|
||||
/**
|
||||
* @return array<string, string> Array of classname => path
|
||||
*/
|
||||
public function getClassMap()
|
||||
{
|
||||
return $this->classMap;
|
||||
}
|
||||
|
||||
/**
|
||||
* @param array<string, string> $classMap Class to filename map
|
||||
*
|
||||
* @return void
|
||||
*/
|
||||
public function addClassMap(array $classMap)
|
||||
{
|
||||
if ($this->classMap) {
|
||||
$this->classMap = array_merge($this->classMap, $classMap);
|
||||
} else {
|
||||
$this->classMap = $classMap;
|
||||
}
|
||||
}
|
||||
|
||||
/**
|
||||
* Registers a set of PSR-0 directories for a given prefix, either
|
||||
* appending or prepending to the ones previously set for this prefix.
|
||||
*
|
||||
* @param string $prefix The prefix
|
||||
* @param list<string>|string $paths The PSR-0 root directories
|
||||
* @param bool $prepend Whether to prepend the directories
|
||||
*
|
||||
* @return void
|
||||
*/
|
||||
public function add($prefix, $paths, $prepend = false)
|
||||
{
|
||||
$paths = (array) $paths;
|
||||
if (!$prefix) {
|
||||
if ($prepend) {
|
||||
$this->fallbackDirsPsr0 = array_merge(
|
||||
$paths,
|
||||
$this->fallbackDirsPsr0
|
||||
);
|
||||
} else {
|
||||
$this->fallbackDirsPsr0 = array_merge(
|
||||
$this->fallbackDirsPsr0,
|
||||
$paths
|
||||
);
|
||||
}
|
||||
|
||||
return;
|
||||
}
|
||||
|
||||
$first = $prefix[0];
|
||||
if (!isset($this->prefixesPsr0[$first][$prefix])) {
|
||||
$this->prefixesPsr0[$first][$prefix] = $paths;
|
||||
|
||||
return;
|
||||
}
|
||||
if ($prepend) {
|
||||
$this->prefixesPsr0[$first][$prefix] = array_merge(
|
||||
$paths,
|
||||
$this->prefixesPsr0[$first][$prefix]
|
||||
);
|
||||
} else {
|
||||
$this->prefixesPsr0[$first][$prefix] = array_merge(
|
||||
$this->prefixesPsr0[$first][$prefix],
|
||||
$paths
|
||||
);
|
||||
}
|
||||
}
|
||||
|
||||
/**
|
||||
* Registers a set of PSR-4 directories for a given namespace, either
|
||||
* appending or prepending to the ones previously set for this namespace.
|
||||
*
|
||||
* @param string $prefix The prefix/namespace, with trailing '\\'
|
||||
* @param list<string>|string $paths The PSR-4 base directories
|
||||
* @param bool $prepend Whether to prepend the directories
|
||||
*
|
||||
* @throws \InvalidArgumentException
|
||||
*
|
||||
* @return void
|
||||
*/
|
||||
public function addPsr4($prefix, $paths, $prepend = false)
|
||||
{
|
||||
$paths = (array) $paths;
|
||||
if (!$prefix) {
|
||||
// Register directories for the root namespace.
|
||||
if ($prepend) {
|
||||
$this->fallbackDirsPsr4 = array_merge(
|
||||
$paths,
|
||||
$this->fallbackDirsPsr4
|
||||
);
|
||||
} else {
|
||||
$this->fallbackDirsPsr4 = array_merge(
|
||||
$this->fallbackDirsPsr4,
|
||||
$paths
|
||||
);
|
||||
}
|
||||
} elseif (!isset($this->prefixDirsPsr4[$prefix])) {
|
||||
// Register directories for a new namespace.
|
||||
$length = strlen($prefix);
|
||||
if ('\\' !== $prefix[$length - 1]) {
|
||||
throw new \InvalidArgumentException("A non-empty PSR-4 prefix must end with a namespace separator.");
|
||||
}
|
||||
$this->prefixLengthsPsr4[$prefix[0]][$prefix] = $length;
|
||||
$this->prefixDirsPsr4[$prefix] = $paths;
|
||||
} elseif ($prepend) {
|
||||
// Prepend directories for an already registered namespace.
|
||||
$this->prefixDirsPsr4[$prefix] = array_merge(
|
||||
$paths,
|
||||
$this->prefixDirsPsr4[$prefix]
|
||||
);
|
||||
} else {
|
||||
// Append directories for an already registered namespace.
|
||||
$this->prefixDirsPsr4[$prefix] = array_merge(
|
||||
$this->prefixDirsPsr4[$prefix],
|
||||
$paths
|
||||
);
|
||||
}
|
||||
}
|
||||
|
||||
/**
|
||||
* Registers a set of PSR-0 directories for a given prefix,
|
||||
* replacing any others previously set for this prefix.
|
||||
*
|
||||
* @param string $prefix The prefix
|
||||
* @param list<string>|string $paths The PSR-0 base directories
|
||||
*
|
||||
* @return void
|
||||
*/
|
||||
public function set($prefix, $paths)
|
||||
{
|
||||
if (!$prefix) {
|
||||
$this->fallbackDirsPsr0 = (array) $paths;
|
||||
} else {
|
||||
$this->prefixesPsr0[$prefix[0]][$prefix] = (array) $paths;
|
||||
}
|
||||
}
|
||||
|
||||
/**
|
||||
* Registers a set of PSR-4 directories for a given namespace,
|
||||
* replacing any others previously set for this namespace.
|
||||
*
|
||||
* @param string $prefix The prefix/namespace, with trailing '\\'
|
||||
* @param list<string>|string $paths The PSR-4 base directories
|
||||
*
|
||||
* @throws \InvalidArgumentException
|
||||
*
|
||||
* @return void
|
||||
*/
|
||||
public function setPsr4($prefix, $paths)
|
||||
{
|
||||
if (!$prefix) {
|
||||
$this->fallbackDirsPsr4 = (array) $paths;
|
||||
} else {
|
||||
$length = strlen($prefix);
|
||||
if ('\\' !== $prefix[$length - 1]) {
|
||||
throw new \InvalidArgumentException("A non-empty PSR-4 prefix must end with a namespace separator.");
|
||||
}
|
||||
$this->prefixLengthsPsr4[$prefix[0]][$prefix] = $length;
|
||||
$this->prefixDirsPsr4[$prefix] = (array) $paths;
|
||||
}
|
||||
}
|
||||
|
||||
/**
|
||||
* Turns on searching the include path for class files.
|
||||
*
|
||||
* @param bool $useIncludePath
|
||||
*
|
||||
* @return void
|
||||
*/
|
||||
public function setUseIncludePath($useIncludePath)
|
||||
{
|
||||
$this->useIncludePath = $useIncludePath;
|
||||
}
|
||||
|
||||
/**
|
||||
* Can be used to check if the autoloader uses the include path to check
|
||||
* for classes.
|
||||
*
|
||||
* @return bool
|
||||
*/
|
||||
public function getUseIncludePath()
|
||||
{
|
||||
return $this->useIncludePath;
|
||||
}
|
||||
|
||||
/**
|
||||
* Turns off searching the prefix and fallback directories for classes
|
||||
* that have not been registered with the class map.
|
||||
*
|
||||
* @param bool $classMapAuthoritative
|
||||
*
|
||||
* @return void
|
||||
*/
|
||||
public function setClassMapAuthoritative($classMapAuthoritative)
|
||||
{
|
||||
$this->classMapAuthoritative = $classMapAuthoritative;
|
||||
}
|
||||
|
||||
/**
|
||||
* Should class lookup fail if not found in the current class map?
|
||||
*
|
||||
* @return bool
|
||||
*/
|
||||
public function isClassMapAuthoritative()
|
||||
{
|
||||
return $this->classMapAuthoritative;
|
||||
}
|
||||
|
||||
/**
|
||||
* APCu prefix to use to cache found/not-found classes, if the extension is enabled.
|
||||
*
|
||||
* @param string|null $apcuPrefix
|
||||
*
|
||||
* @return void
|
||||
*/
|
||||
public function setApcuPrefix($apcuPrefix)
|
||||
{
|
||||
$this->apcuPrefix = function_exists('apcu_fetch') && filter_var(ini_get('apc.enabled'), FILTER_VALIDATE_BOOLEAN) ? $apcuPrefix : null;
|
||||
}
|
||||
|
||||
/**
|
||||
* The APCu prefix in use, or null if APCu caching is not enabled.
|
||||
*
|
||||
* @return string|null
|
||||
*/
|
||||
public function getApcuPrefix()
|
||||
{
|
||||
return $this->apcuPrefix;
|
||||
}
|
||||
|
||||
/**
|
||||
* Registers this instance as an autoloader.
|
||||
*
|
||||
* @param bool $prepend Whether to prepend the autoloader or not
|
||||
*
|
||||
* @return void
|
||||
*/
|
||||
public function register($prepend = false)
|
||||
{
|
||||
spl_autoload_register(array($this, 'loadClass'), true, $prepend);
|
||||
|
||||
if (null === $this->vendorDir) {
|
||||
return;
|
||||
}
|
||||
|
||||
if ($prepend) {
|
||||
self::$registeredLoaders = array($this->vendorDir => $this) + self::$registeredLoaders;
|
||||
} else {
|
||||
unset(self::$registeredLoaders[$this->vendorDir]);
|
||||
self::$registeredLoaders[$this->vendorDir] = $this;
|
||||
}
|
||||
}
|
||||
|
||||
/**
|
||||
* Unregisters this instance as an autoloader.
|
||||
*
|
||||
* @return void
|
||||
*/
|
||||
public function unregister()
|
||||
{
|
||||
spl_autoload_unregister(array($this, 'loadClass'));
|
||||
|
||||
if (null !== $this->vendorDir) {
|
||||
unset(self::$registeredLoaders[$this->vendorDir]);
|
||||
}
|
||||
}
|
||||
|
||||
/**
|
||||
* Loads the given class or interface.
|
||||
*
|
||||
* @param string $class The name of the class
|
||||
* @return true|null True if loaded, null otherwise
|
||||
*/
|
||||
public function loadClass($class)
|
||||
{
|
||||
if ($file = $this->findFile($class)) {
|
||||
$includeFile = self::$includeFile;
|
||||
$includeFile($file);
|
||||
|
||||
return true;
|
||||
}
|
||||
|
||||
return null;
|
||||
}
|
||||
|
||||
/**
|
||||
* Finds the path to the file where the class is defined.
|
||||
*
|
||||
* @param string $class The name of the class
|
||||
*
|
||||
* @return string|false The path if found, false otherwise
|
||||
*/
|
||||
public function findFile($class)
|
||||
{
|
||||
// class map lookup
|
||||
if (isset($this->classMap[$class])) {
|
||||
return $this->classMap[$class];
|
||||
}
|
||||
if ($this->classMapAuthoritative || isset($this->missingClasses[$class])) {
|
||||
return false;
|
||||
}
|
||||
if (null !== $this->apcuPrefix) {
|
||||
$file = apcu_fetch($this->apcuPrefix.$class, $hit);
|
||||
if ($hit) {
|
||||
return $file;
|
||||
}
|
||||
}
|
||||
|
||||
$file = $this->findFileWithExtension($class, '.php');
|
||||
|
||||
// Search for Hack files if we are running on HHVM
|
||||
if (false === $file && defined('HHVM_VERSION')) {
|
||||
$file = $this->findFileWithExtension($class, '.hh');
|
||||
}
|
||||
|
||||
if (null !== $this->apcuPrefix) {
|
||||
apcu_add($this->apcuPrefix.$class, $file);
|
||||
}
|
||||
|
||||
if (false === $file) {
|
||||
// Remember that this class does not exist.
|
||||
$this->missingClasses[$class] = true;
|
||||
}
|
||||
|
||||
return $file;
|
||||
}
|
||||
|
||||
/**
|
||||
* Returns the currently registered loaders keyed by their corresponding vendor directories.
|
||||
*
|
||||
* @return array<string, self>
|
||||
*/
|
||||
public static function getRegisteredLoaders()
|
||||
{
|
||||
return self::$registeredLoaders;
|
||||
}
|
||||
|
||||
/**
|
||||
* @param string $class
|
||||
* @param string $ext
|
||||
* @return string|false
|
||||
*/
|
||||
private function findFileWithExtension($class, $ext)
|
||||
{
|
||||
// PSR-4 lookup
|
||||
$logicalPathPsr4 = strtr($class, '\\', DIRECTORY_SEPARATOR) . $ext;
|
||||
|
||||
$first = $class[0];
|
||||
if (isset($this->prefixLengthsPsr4[$first])) {
|
||||
$subPath = $class;
|
||||
while (false !== $lastPos = strrpos($subPath, '\\')) {
|
||||
$subPath = substr($subPath, 0, $lastPos);
|
||||
$search = $subPath . '\\';
|
||||
if (isset($this->prefixDirsPsr4[$search])) {
|
||||
$pathEnd = DIRECTORY_SEPARATOR . substr($logicalPathPsr4, $lastPos + 1);
|
||||
foreach ($this->prefixDirsPsr4[$search] as $dir) {
|
||||
if (file_exists($file = $dir . $pathEnd)) {
|
||||
return $file;
|
||||
}
|
||||
}
|
||||
}
|
||||
}
|
||||
}
|
||||
|
||||
// PSR-4 fallback dirs
|
||||
foreach ($this->fallbackDirsPsr4 as $dir) {
|
||||
if (file_exists($file = $dir . DIRECTORY_SEPARATOR . $logicalPathPsr4)) {
|
||||
return $file;
|
||||
}
|
||||
}
|
||||
|
||||
// PSR-0 lookup
|
||||
if (false !== $pos = strrpos($class, '\\')) {
|
||||
// namespaced class name
|
||||
$logicalPathPsr0 = substr($logicalPathPsr4, 0, $pos + 1)
|
||||
. strtr(substr($logicalPathPsr4, $pos + 1), '_', DIRECTORY_SEPARATOR);
|
||||
} else {
|
||||
// PEAR-like class name
|
||||
$logicalPathPsr0 = strtr($class, '_', DIRECTORY_SEPARATOR) . $ext;
|
||||
}
|
||||
|
||||
if (isset($this->prefixesPsr0[$first])) {
|
||||
foreach ($this->prefixesPsr0[$first] as $prefix => $dirs) {
|
||||
if (0 === strpos($class, $prefix)) {
|
||||
foreach ($dirs as $dir) {
|
||||
if (file_exists($file = $dir . DIRECTORY_SEPARATOR . $logicalPathPsr0)) {
|
||||
return $file;
|
||||
}
|
||||
}
|
||||
}
|
||||
}
|
||||
}
|
||||
|
||||
// PSR-0 fallback dirs
|
||||
foreach ($this->fallbackDirsPsr0 as $dir) {
|
||||
if (file_exists($file = $dir . DIRECTORY_SEPARATOR . $logicalPathPsr0)) {
|
||||
return $file;
|
||||
}
|
||||
}
|
||||
|
||||
// PSR-0 include paths.
|
||||
if ($this->useIncludePath && $file = stream_resolve_include_path($logicalPathPsr0)) {
|
||||
return $file;
|
||||
}
|
||||
|
||||
return false;
|
||||
}
|
||||
|
||||
/**
|
||||
* @return void
|
||||
*/
|
||||
private static function initializeIncludeClosure()
|
||||
{
|
||||
if (self::$includeFile !== null) {
|
||||
return;
|
||||
}
|
||||
|
||||
/**
|
||||
* Scope isolated include.
|
||||
*
|
||||
* Prevents access to $this/self from included files.
|
||||
*
|
||||
* @param string $file
|
||||
* @return void
|
||||
*/
|
||||
self::$includeFile = \Closure::bind(static function($file) {
|
||||
include $file;
|
||||
}, null, null);
|
||||
}
|
||||
}
|
||||
359
M5/Dossier/emensa/vendor/composer/InstalledVersions.php
vendored
Normal file
359
M5/Dossier/emensa/vendor/composer/InstalledVersions.php
vendored
Normal file
@@ -0,0 +1,359 @@
|
||||
<?php
|
||||
|
||||
/*
|
||||
* This file is part of Composer.
|
||||
*
|
||||
* (c) Nils Adermann <naderman@naderman.de>
|
||||
* Jordi Boggiano <j.boggiano@seld.be>
|
||||
*
|
||||
* For the full copyright and license information, please view the LICENSE
|
||||
* file that was distributed with this source code.
|
||||
*/
|
||||
|
||||
namespace Composer;
|
||||
|
||||
use Composer\Autoload\ClassLoader;
|
||||
use Composer\Semver\VersionParser;
|
||||
|
||||
/**
|
||||
* This class is copied in every Composer installed project and available to all
|
||||
*
|
||||
* See also https://getcomposer.org/doc/07-runtime.md#installed-versions
|
||||
*
|
||||
* To require its presence, you can require `composer-runtime-api ^2.0`
|
||||
*
|
||||
* @final
|
||||
*/
|
||||
class InstalledVersions
|
||||
{
|
||||
/**
|
||||
* @var mixed[]|null
|
||||
* @psalm-var array{root: array{name: string, pretty_version: string, version: string, reference: string|null, type: string, install_path: string, aliases: string[], dev: bool}, versions: array<string, array{pretty_version?: string, version?: string, reference?: string|null, type?: string, install_path?: string, aliases?: string[], dev_requirement: bool, replaced?: string[], provided?: string[]}>}|array{}|null
|
||||
*/
|
||||
private static $installed;
|
||||
|
||||
/**
|
||||
* @var bool|null
|
||||
*/
|
||||
private static $canGetVendors;
|
||||
|
||||
/**
|
||||
* @var array[]
|
||||
* @psalm-var array<string, array{root: array{name: string, pretty_version: string, version: string, reference: string|null, type: string, install_path: string, aliases: string[], dev: bool}, versions: array<string, array{pretty_version?: string, version?: string, reference?: string|null, type?: string, install_path?: string, aliases?: string[], dev_requirement: bool, replaced?: string[], provided?: string[]}>}>
|
||||
*/
|
||||
private static $installedByVendor = array();
|
||||
|
||||
/**
|
||||
* Returns a list of all package names which are present, either by being installed, replaced or provided
|
||||
*
|
||||
* @return string[]
|
||||
* @psalm-return list<string>
|
||||
*/
|
||||
public static function getInstalledPackages()
|
||||
{
|
||||
$packages = array();
|
||||
foreach (self::getInstalled() as $installed) {
|
||||
$packages[] = array_keys($installed['versions']);
|
||||
}
|
||||
|
||||
if (1 === \count($packages)) {
|
||||
return $packages[0];
|
||||
}
|
||||
|
||||
return array_keys(array_flip(\call_user_func_array('array_merge', $packages)));
|
||||
}
|
||||
|
||||
/**
|
||||
* Returns a list of all package names with a specific type e.g. 'library'
|
||||
*
|
||||
* @param string $type
|
||||
* @return string[]
|
||||
* @psalm-return list<string>
|
||||
*/
|
||||
public static function getInstalledPackagesByType($type)
|
||||
{
|
||||
$packagesByType = array();
|
||||
|
||||
foreach (self::getInstalled() as $installed) {
|
||||
foreach ($installed['versions'] as $name => $package) {
|
||||
if (isset($package['type']) && $package['type'] === $type) {
|
||||
$packagesByType[] = $name;
|
||||
}
|
||||
}
|
||||
}
|
||||
|
||||
return $packagesByType;
|
||||
}
|
||||
|
||||
/**
|
||||
* Checks whether the given package is installed
|
||||
*
|
||||
* This also returns true if the package name is provided or replaced by another package
|
||||
*
|
||||
* @param string $packageName
|
||||
* @param bool $includeDevRequirements
|
||||
* @return bool
|
||||
*/
|
||||
public static function isInstalled($packageName, $includeDevRequirements = true)
|
||||
{
|
||||
foreach (self::getInstalled() as $installed) {
|
||||
if (isset($installed['versions'][$packageName])) {
|
||||
return $includeDevRequirements || !isset($installed['versions'][$packageName]['dev_requirement']) || $installed['versions'][$packageName]['dev_requirement'] === false;
|
||||
}
|
||||
}
|
||||
|
||||
return false;
|
||||
}
|
||||
|
||||
/**
|
||||
* Checks whether the given package satisfies a version constraint
|
||||
*
|
||||
* e.g. If you want to know whether version 2.3+ of package foo/bar is installed, you would call:
|
||||
*
|
||||
* Composer\InstalledVersions::satisfies(new VersionParser, 'foo/bar', '^2.3')
|
||||
*
|
||||
* @param VersionParser $parser Install composer/semver to have access to this class and functionality
|
||||
* @param string $packageName
|
||||
* @param string|null $constraint A version constraint to check for, if you pass one you have to make sure composer/semver is required by your package
|
||||
* @return bool
|
||||
*/
|
||||
public static function satisfies(VersionParser $parser, $packageName, $constraint)
|
||||
{
|
||||
$constraint = $parser->parseConstraints((string) $constraint);
|
||||
$provided = $parser->parseConstraints(self::getVersionRanges($packageName));
|
||||
|
||||
return $provided->matches($constraint);
|
||||
}
|
||||
|
||||
/**
|
||||
* Returns a version constraint representing all the range(s) which are installed for a given package
|
||||
*
|
||||
* It is easier to use this via isInstalled() with the $constraint argument if you need to check
|
||||
* whether a given version of a package is installed, and not just whether it exists
|
||||
*
|
||||
* @param string $packageName
|
||||
* @return string Version constraint usable with composer/semver
|
||||
*/
|
||||
public static function getVersionRanges($packageName)
|
||||
{
|
||||
foreach (self::getInstalled() as $installed) {
|
||||
if (!isset($installed['versions'][$packageName])) {
|
||||
continue;
|
||||
}
|
||||
|
||||
$ranges = array();
|
||||
if (isset($installed['versions'][$packageName]['pretty_version'])) {
|
||||
$ranges[] = $installed['versions'][$packageName]['pretty_version'];
|
||||
}
|
||||
if (array_key_exists('aliases', $installed['versions'][$packageName])) {
|
||||
$ranges = array_merge($ranges, $installed['versions'][$packageName]['aliases']);
|
||||
}
|
||||
if (array_key_exists('replaced', $installed['versions'][$packageName])) {
|
||||
$ranges = array_merge($ranges, $installed['versions'][$packageName]['replaced']);
|
||||
}
|
||||
if (array_key_exists('provided', $installed['versions'][$packageName])) {
|
||||
$ranges = array_merge($ranges, $installed['versions'][$packageName]['provided']);
|
||||
}
|
||||
|
||||
return implode(' || ', $ranges);
|
||||
}
|
||||
|
||||
throw new \OutOfBoundsException('Package "' . $packageName . '" is not installed');
|
||||
}
|
||||
|
||||
/**
|
||||
* @param string $packageName
|
||||
* @return string|null If the package is being replaced or provided but is not really installed, null will be returned as version, use satisfies or getVersionRanges if you need to know if a given version is present
|
||||
*/
|
||||
public static function getVersion($packageName)
|
||||
{
|
||||
foreach (self::getInstalled() as $installed) {
|
||||
if (!isset($installed['versions'][$packageName])) {
|
||||
continue;
|
||||
}
|
||||
|
||||
if (!isset($installed['versions'][$packageName]['version'])) {
|
||||
return null;
|
||||
}
|
||||
|
||||
return $installed['versions'][$packageName]['version'];
|
||||
}
|
||||
|
||||
throw new \OutOfBoundsException('Package "' . $packageName . '" is not installed');
|
||||
}
|
||||
|
||||
/**
|
||||
* @param string $packageName
|
||||
* @return string|null If the package is being replaced or provided but is not really installed, null will be returned as version, use satisfies or getVersionRanges if you need to know if a given version is present
|
||||
*/
|
||||
public static function getPrettyVersion($packageName)
|
||||
{
|
||||
foreach (self::getInstalled() as $installed) {
|
||||
if (!isset($installed['versions'][$packageName])) {
|
||||
continue;
|
||||
}
|
||||
|
||||
if (!isset($installed['versions'][$packageName]['pretty_version'])) {
|
||||
return null;
|
||||
}
|
||||
|
||||
return $installed['versions'][$packageName]['pretty_version'];
|
||||
}
|
||||
|
||||
throw new \OutOfBoundsException('Package "' . $packageName . '" is not installed');
|
||||
}
|
||||
|
||||
/**
|
||||
* @param string $packageName
|
||||
* @return string|null If the package is being replaced or provided but is not really installed, null will be returned as reference
|
||||
*/
|
||||
public static function getReference($packageName)
|
||||
{
|
||||
foreach (self::getInstalled() as $installed) {
|
||||
if (!isset($installed['versions'][$packageName])) {
|
||||
continue;
|
||||
}
|
||||
|
||||
if (!isset($installed['versions'][$packageName]['reference'])) {
|
||||
return null;
|
||||
}
|
||||
|
||||
return $installed['versions'][$packageName]['reference'];
|
||||
}
|
||||
|
||||
throw new \OutOfBoundsException('Package "' . $packageName . '" is not installed');
|
||||
}
|
||||
|
||||
/**
|
||||
* @param string $packageName
|
||||
* @return string|null If the package is being replaced or provided but is not really installed, null will be returned as install path. Packages of type metapackages also have a null install path.
|
||||
*/
|
||||
public static function getInstallPath($packageName)
|
||||
{
|
||||
foreach (self::getInstalled() as $installed) {
|
||||
if (!isset($installed['versions'][$packageName])) {
|
||||
continue;
|
||||
}
|
||||
|
||||
return isset($installed['versions'][$packageName]['install_path']) ? $installed['versions'][$packageName]['install_path'] : null;
|
||||
}
|
||||
|
||||
throw new \OutOfBoundsException('Package "' . $packageName . '" is not installed');
|
||||
}
|
||||
|
||||
/**
|
||||
* @return array
|
||||
* @psalm-return array{name: string, pretty_version: string, version: string, reference: string|null, type: string, install_path: string, aliases: string[], dev: bool}
|
||||
*/
|
||||
public static function getRootPackage()
|
||||
{
|
||||
$installed = self::getInstalled();
|
||||
|
||||
return $installed[0]['root'];
|
||||
}
|
||||
|
||||
/**
|
||||
* Returns the raw installed.php data for custom implementations
|
||||
*
|
||||
* @deprecated Use getAllRawData() instead which returns all datasets for all autoloaders present in the process. getRawData only returns the first dataset loaded, which may not be what you expect.
|
||||
* @return array[]
|
||||
* @psalm-return array{root: array{name: string, pretty_version: string, version: string, reference: string|null, type: string, install_path: string, aliases: string[], dev: bool}, versions: array<string, array{pretty_version?: string, version?: string, reference?: string|null, type?: string, install_path?: string, aliases?: string[], dev_requirement: bool, replaced?: string[], provided?: string[]}>}
|
||||
*/
|
||||
public static function getRawData()
|
||||
{
|
||||
@trigger_error('getRawData only returns the first dataset loaded, which may not be what you expect. Use getAllRawData() instead which returns all datasets for all autoloaders present in the process.', E_USER_DEPRECATED);
|
||||
|
||||
if (null === self::$installed) {
|
||||
// only require the installed.php file if this file is loaded from its dumped location,
|
||||
// and not from its source location in the composer/composer package, see https://github.com/composer/composer/issues/9937
|
||||
if (substr(__DIR__, -8, 1) !== 'C') {
|
||||
self::$installed = include __DIR__ . '/installed.php';
|
||||
} else {
|
||||
self::$installed = array();
|
||||
}
|
||||
}
|
||||
|
||||
return self::$installed;
|
||||
}
|
||||
|
||||
/**
|
||||
* Returns the raw data of all installed.php which are currently loaded for custom implementations
|
||||
*
|
||||
* @return array[]
|
||||
* @psalm-return list<array{root: array{name: string, pretty_version: string, version: string, reference: string|null, type: string, install_path: string, aliases: string[], dev: bool}, versions: array<string, array{pretty_version?: string, version?: string, reference?: string|null, type?: string, install_path?: string, aliases?: string[], dev_requirement: bool, replaced?: string[], provided?: string[]}>}>
|
||||
*/
|
||||
public static function getAllRawData()
|
||||
{
|
||||
return self::getInstalled();
|
||||
}
|
||||
|
||||
/**
|
||||
* Lets you reload the static array from another file
|
||||
*
|
||||
* This is only useful for complex integrations in which a project needs to use
|
||||
* this class but then also needs to execute another project's autoloader in process,
|
||||
* and wants to ensure both projects have access to their version of installed.php.
|
||||
*
|
||||
* A typical case would be PHPUnit, where it would need to make sure it reads all
|
||||
* the data it needs from this class, then call reload() with
|
||||
* `require $CWD/vendor/composer/installed.php` (or similar) as input to make sure
|
||||
* the project in which it runs can then also use this class safely, without
|
||||
* interference between PHPUnit's dependencies and the project's dependencies.
|
||||
*
|
||||
* @param array[] $data A vendor/composer/installed.php data set
|
||||
* @return void
|
||||
*
|
||||
* @psalm-param array{root: array{name: string, pretty_version: string, version: string, reference: string|null, type: string, install_path: string, aliases: string[], dev: bool}, versions: array<string, array{pretty_version?: string, version?: string, reference?: string|null, type?: string, install_path?: string, aliases?: string[], dev_requirement: bool, replaced?: string[], provided?: string[]}>} $data
|
||||
*/
|
||||
public static function reload($data)
|
||||
{
|
||||
self::$installed = $data;
|
||||
self::$installedByVendor = array();
|
||||
}
|
||||
|
||||
/**
|
||||
* @return array[]
|
||||
* @psalm-return list<array{root: array{name: string, pretty_version: string, version: string, reference: string|null, type: string, install_path: string, aliases: string[], dev: bool}, versions: array<string, array{pretty_version?: string, version?: string, reference?: string|null, type?: string, install_path?: string, aliases?: string[], dev_requirement: bool, replaced?: string[], provided?: string[]}>}>
|
||||
*/
|
||||
private static function getInstalled()
|
||||
{
|
||||
if (null === self::$canGetVendors) {
|
||||
self::$canGetVendors = method_exists('Composer\Autoload\ClassLoader', 'getRegisteredLoaders');
|
||||
}
|
||||
|
||||
$installed = array();
|
||||
|
||||
if (self::$canGetVendors) {
|
||||
foreach (ClassLoader::getRegisteredLoaders() as $vendorDir => $loader) {
|
||||
if (isset(self::$installedByVendor[$vendorDir])) {
|
||||
$installed[] = self::$installedByVendor[$vendorDir];
|
||||
} elseif (is_file($vendorDir.'/composer/installed.php')) {
|
||||
/** @var array{root: array{name: string, pretty_version: string, version: string, reference: string|null, type: string, install_path: string, aliases: string[], dev: bool}, versions: array<string, array{pretty_version?: string, version?: string, reference?: string|null, type?: string, install_path?: string, aliases?: string[], dev_requirement: bool, replaced?: string[], provided?: string[]}>} $required */
|
||||
$required = require $vendorDir.'/composer/installed.php';
|
||||
$installed[] = self::$installedByVendor[$vendorDir] = $required;
|
||||
if (null === self::$installed && strtr($vendorDir.'/composer', '\\', '/') === strtr(__DIR__, '\\', '/')) {
|
||||
self::$installed = $installed[count($installed) - 1];
|
||||
}
|
||||
}
|
||||
}
|
||||
}
|
||||
|
||||
if (null === self::$installed) {
|
||||
// only require the installed.php file if this file is loaded from its dumped location,
|
||||
// and not from its source location in the composer/composer package, see https://github.com/composer/composer/issues/9937
|
||||
if (substr(__DIR__, -8, 1) !== 'C') {
|
||||
/** @var array{root: array{name: string, pretty_version: string, version: string, reference: string|null, type: string, install_path: string, aliases: string[], dev: bool}, versions: array<string, array{pretty_version?: string, version?: string, reference?: string|null, type?: string, install_path?: string, aliases?: string[], dev_requirement: bool, replaced?: string[], provided?: string[]}>} $required */
|
||||
$required = require __DIR__ . '/installed.php';
|
||||
self::$installed = $required;
|
||||
} else {
|
||||
self::$installed = array();
|
||||
}
|
||||
}
|
||||
|
||||
if (self::$installed !== array()) {
|
||||
$installed[] = self::$installed;
|
||||
}
|
||||
|
||||
return $installed;
|
||||
}
|
||||
}
|
||||
21
M5/Dossier/emensa/vendor/composer/LICENSE
vendored
Normal file
21
M5/Dossier/emensa/vendor/composer/LICENSE
vendored
Normal file
@@ -0,0 +1,21 @@
|
||||
|
||||
Copyright (c) Nils Adermann, Jordi Boggiano
|
||||
|
||||
Permission is hereby granted, free of charge, to any person obtaining a copy
|
||||
of this software and associated documentation files (the "Software"), to deal
|
||||
in the Software without restriction, including without limitation the rights
|
||||
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
|
||||
copies of the Software, and to permit persons to whom the Software is furnished
|
||||
to do so, subject to the following conditions:
|
||||
|
||||
The above copyright notice and this permission notice shall be included in all
|
||||
copies or substantial portions of the Software.
|
||||
|
||||
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
|
||||
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
|
||||
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
|
||||
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
|
||||
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
|
||||
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
|
||||
THE SOFTWARE.
|
||||
|
||||
10
M5/Dossier/emensa/vendor/composer/autoload_classmap.php
vendored
Normal file
10
M5/Dossier/emensa/vendor/composer/autoload_classmap.php
vendored
Normal file
@@ -0,0 +1,10 @@
|
||||
<?php
|
||||
|
||||
// autoload_classmap.php @generated by Composer
|
||||
|
||||
$vendorDir = dirname(__DIR__);
|
||||
$baseDir = dirname($vendorDir);
|
||||
|
||||
return array(
|
||||
'Composer\\InstalledVersions' => $vendorDir . '/composer/InstalledVersions.php',
|
||||
);
|
||||
9
M5/Dossier/emensa/vendor/composer/autoload_namespaces.php
vendored
Normal file
9
M5/Dossier/emensa/vendor/composer/autoload_namespaces.php
vendored
Normal file
@@ -0,0 +1,9 @@
|
||||
<?php
|
||||
|
||||
// autoload_namespaces.php @generated by Composer
|
||||
|
||||
$vendorDir = dirname(__DIR__);
|
||||
$baseDir = dirname($vendorDir);
|
||||
|
||||
return array(
|
||||
);
|
||||
12
M5/Dossier/emensa/vendor/composer/autoload_psr4.php
vendored
Normal file
12
M5/Dossier/emensa/vendor/composer/autoload_psr4.php
vendored
Normal file
@@ -0,0 +1,12 @@
|
||||
<?php
|
||||
|
||||
// autoload_psr4.php @generated by Composer
|
||||
|
||||
$vendorDir = dirname(__DIR__);
|
||||
$baseDir = dirname($vendorDir);
|
||||
|
||||
return array(
|
||||
'eftec\\bladeone\\' => array($vendorDir . '/eftec/bladeone/lib'),
|
||||
'Psr\\Log\\' => array($vendorDir . '/psr/log/src'),
|
||||
'Monolog\\' => array($vendorDir . '/monolog/monolog/src/Monolog'),
|
||||
);
|
||||
38
M5/Dossier/emensa/vendor/composer/autoload_real.php
vendored
Normal file
38
M5/Dossier/emensa/vendor/composer/autoload_real.php
vendored
Normal file
@@ -0,0 +1,38 @@
|
||||
<?php
|
||||
|
||||
// autoload_real.php @generated by Composer
|
||||
|
||||
class ComposerAutoloaderInit0a19be8f09bdc5d4e2b07ba9e95a5801
|
||||
{
|
||||
private static $loader;
|
||||
|
||||
public static function loadClassLoader($class)
|
||||
{
|
||||
if ('Composer\Autoload\ClassLoader' === $class) {
|
||||
require __DIR__ . '/ClassLoader.php';
|
||||
}
|
||||
}
|
||||
|
||||
/**
|
||||
* @return \Composer\Autoload\ClassLoader
|
||||
*/
|
||||
public static function getLoader()
|
||||
{
|
||||
if (null !== self::$loader) {
|
||||
return self::$loader;
|
||||
}
|
||||
|
||||
require __DIR__ . '/platform_check.php';
|
||||
|
||||
spl_autoload_register(array('ComposerAutoloaderInit0a19be8f09bdc5d4e2b07ba9e95a5801', 'loadClassLoader'), true, true);
|
||||
self::$loader = $loader = new \Composer\Autoload\ClassLoader(\dirname(__DIR__));
|
||||
spl_autoload_unregister(array('ComposerAutoloaderInit0a19be8f09bdc5d4e2b07ba9e95a5801', 'loadClassLoader'));
|
||||
|
||||
require __DIR__ . '/autoload_static.php';
|
||||
call_user_func(\Composer\Autoload\ComposerStaticInit0a19be8f09bdc5d4e2b07ba9e95a5801::getInitializer($loader));
|
||||
|
||||
$loader->register(true);
|
||||
|
||||
return $loader;
|
||||
}
|
||||
}
|
||||
52
M5/Dossier/emensa/vendor/composer/autoload_static.php
vendored
Normal file
52
M5/Dossier/emensa/vendor/composer/autoload_static.php
vendored
Normal file
@@ -0,0 +1,52 @@
|
||||
<?php
|
||||
|
||||
// autoload_static.php @generated by Composer
|
||||
|
||||
namespace Composer\Autoload;
|
||||
|
||||
class ComposerStaticInit0a19be8f09bdc5d4e2b07ba9e95a5801
|
||||
{
|
||||
public static $prefixLengthsPsr4 = array (
|
||||
'e' =>
|
||||
array (
|
||||
'eftec\\bladeone\\' => 15,
|
||||
),
|
||||
'P' =>
|
||||
array (
|
||||
'Psr\\Log\\' => 8,
|
||||
),
|
||||
'M' =>
|
||||
array (
|
||||
'Monolog\\' => 8,
|
||||
),
|
||||
);
|
||||
|
||||
public static $prefixDirsPsr4 = array (
|
||||
'eftec\\bladeone\\' =>
|
||||
array (
|
||||
0 => __DIR__ . '/..' . '/eftec/bladeone/lib',
|
||||
),
|
||||
'Psr\\Log\\' =>
|
||||
array (
|
||||
0 => __DIR__ . '/..' . '/psr/log/src',
|
||||
),
|
||||
'Monolog\\' =>
|
||||
array (
|
||||
0 => __DIR__ . '/..' . '/monolog/monolog/src/Monolog',
|
||||
),
|
||||
);
|
||||
|
||||
public static $classMap = array (
|
||||
'Composer\\InstalledVersions' => __DIR__ . '/..' . '/composer/InstalledVersions.php',
|
||||
);
|
||||
|
||||
public static function getInitializer(ClassLoader $loader)
|
||||
{
|
||||
return \Closure::bind(function () use ($loader) {
|
||||
$loader->prefixLengthsPsr4 = ComposerStaticInit0a19be8f09bdc5d4e2b07ba9e95a5801::$prefixLengthsPsr4;
|
||||
$loader->prefixDirsPsr4 = ComposerStaticInit0a19be8f09bdc5d4e2b07ba9e95a5801::$prefixDirsPsr4;
|
||||
$loader->classMap = ComposerStaticInit0a19be8f09bdc5d4e2b07ba9e95a5801::$classMap;
|
||||
|
||||
}, null, ClassLoader::class);
|
||||
}
|
||||
}
|
||||
225
M5/Dossier/emensa/vendor/composer/installed.json
vendored
Normal file
225
M5/Dossier/emensa/vendor/composer/installed.json
vendored
Normal file
@@ -0,0 +1,225 @@
|
||||
{
|
||||
"packages": [
|
||||
{
|
||||
"name": "eftec/bladeone",
|
||||
"version": "4.9",
|
||||
"version_normalized": "4.9.0.0",
|
||||
"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"
|
||||
},
|
||||
"time": "2023-05-01T12:48:42+00:00",
|
||||
"bin": [
|
||||
"lib/bladeonecli"
|
||||
],
|
||||
"type": "library",
|
||||
"installation-source": "dist",
|
||||
"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"
|
||||
},
|
||||
"install-path": "../eftec/bladeone"
|
||||
},
|
||||
{
|
||||
"name": "monolog/monolog",
|
||||
"version": "3.5.0",
|
||||
"version_normalized": "3.5.0.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"
|
||||
},
|
||||
"time": "2023-10-27T15:32:31+00:00",
|
||||
"type": "library",
|
||||
"extra": {
|
||||
"branch-alias": {
|
||||
"dev-main": "3.x-dev"
|
||||
}
|
||||
},
|
||||
"installation-source": "source",
|
||||
"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"
|
||||
}
|
||||
],
|
||||
"install-path": "../monolog/monolog"
|
||||
},
|
||||
{
|
||||
"name": "psr/log",
|
||||
"version": "3.0.0",
|
||||
"version_normalized": "3.0.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"
|
||||
},
|
||||
"time": "2021-07-14T16:46:02+00:00",
|
||||
"type": "library",
|
||||
"extra": {
|
||||
"branch-alias": {
|
||||
"dev-master": "3.x-dev"
|
||||
}
|
||||
},
|
||||
"installation-source": "source",
|
||||
"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"
|
||||
},
|
||||
"install-path": "../psr/log"
|
||||
}
|
||||
],
|
||||
"dev": true,
|
||||
"dev-package-names": []
|
||||
}
|
||||
Some files were not shown because too many files have changed in this diff Show More
Reference in New Issue
Block a user