c779a533b2
neue Migrations Vorbereitung für Logging von versendeten SMSen und Mails zweck rate Limit
969 lines
34 KiB
PHP
969 lines
34 KiB
PHP
<?php
|
|
declare(strict_types=1);
|
|
|
|
use Phinx\Migration\AbstractMigration;
|
|
|
|
final class InsertTimerecordingHoliday extends AbstractMigration
|
|
{
|
|
public function up(): void
|
|
{
|
|
if($this->getEnvironment() == "thetool") {
|
|
$rows=[
|
|
[
|
|
'timestamp' => 1704063600,
|
|
'description' => 'Neujahr',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1704495600,
|
|
'description' => 'Heilige Drei Könige',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1711922400,
|
|
'description' => 'Ostermontag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1714514400,
|
|
'description' => 'Staatsfeiertag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1715205600,
|
|
'description' => 'Christi Himmelfahrt',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1716156000,
|
|
'description' => 'Pfingstmontag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1717020000,
|
|
'description' => 'Fronleichnam',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1723672800,
|
|
'description' => 'Mariä Himmelfahrt',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1729893600,
|
|
'description' => 'Nationalfeiertag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1730415600,
|
|
'description' => 'Allerheiligen',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1733612400,
|
|
'description' => 'Maria Empfängnis',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1735081200,
|
|
'description' => 'Christtag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1735167600,
|
|
'description' => 'Stefanitag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1735686000,
|
|
'description' => 'Neujahr',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1736118000,
|
|
'description' => 'Heilige Drei Könige',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1745186400,
|
|
'description' => 'Ostermontag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1746050400,
|
|
'description' => 'Staatsfeiertag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1748469600,
|
|
'description' => 'Christi Himmelfahrt',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1749420000,
|
|
'description' => 'Pfingstmontag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1750284000,
|
|
'description' => 'Fronleichnam',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1755208800,
|
|
'description' => 'Mariä Himmelfahrt',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1761429600,
|
|
'description' => 'Nationalfeiertag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1761951600,
|
|
'description' => 'Allerheiligen',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1765148400,
|
|
'description' => 'Maria Empfängnis',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1766617200,
|
|
'description' => 'Christtag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1766703600,
|
|
'description' => 'Stefanitag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1767222000,
|
|
'description' => 'Neujahr',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1767654000,
|
|
'description' => 'Heilige Drei Könige',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1775426400,
|
|
'description' => 'Ostermontag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1777586400,
|
|
'description' => 'Staatsfeiertag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1778709600,
|
|
'description' => 'Christi Himmelfahrt',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1779660000,
|
|
'description' => 'Pfingstmontag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1780524000,
|
|
'description' => 'Fronleichnam',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1786744800,
|
|
'description' => 'Mariä Himmelfahrt',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1792969200,
|
|
'description' => 'Nationalfeiertag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1793487600,
|
|
'description' => 'Allerheiligen',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1796684400,
|
|
'description' => 'Maria Empfängnis',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1798153200,
|
|
'description' => 'Christtag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1798239600,
|
|
'description' => 'Stefanitag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1798758000,
|
|
'description' => 'Neujahr',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1799190000,
|
|
'description' => 'Heilige Drei Könige',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1806271200,
|
|
'description' => 'Ostermontag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1809122400,
|
|
'description' => 'Staatsfeiertag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1809554400,
|
|
'description' => 'Christi Himmelfahrt',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1810504800,
|
|
'description' => 'Pfingstmontag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1811368800,
|
|
'description' => 'Fronleichnam',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1818280800,
|
|
'description' => 'Mariä Himmelfahrt',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1824501600,
|
|
'description' => 'Nationalfeiertag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1825023600,
|
|
'description' => 'Allerheiligen',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1828220400,
|
|
'description' => 'Maria Empfängnis',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1829689200,
|
|
'description' => 'Christtag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1829775600,
|
|
'description' => 'Stefanitag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1830294000,
|
|
'description' => 'Neujahr',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1830726000,
|
|
'description' => 'Heilige Drei Könige',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1839535200,
|
|
'description' => 'Ostermontag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1840744800,
|
|
'description' => 'Staatsfeiertag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1842818400,
|
|
'description' => 'Christi Himmelfahrt',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1843768800,
|
|
'description' => 'Pfingstmontag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1844632800,
|
|
'description' => 'Fronleichnam',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1849903200,
|
|
'description' => 'Mariä Himmelfahrt',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1856124000,
|
|
'description' => 'Nationalfeiertag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1856646000,
|
|
'description' => 'Allerheiligen',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1859842800,
|
|
'description' => 'Maria Empfängnis',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1861311600,
|
|
'description' => 'Christtag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1861398000,
|
|
'description' => 'Stefanitag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1861916400,
|
|
'description' => 'Neujahr',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1862348400,
|
|
'description' => 'Heilige Drei Könige',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1869775200,
|
|
'description' => 'Ostermontag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1872280800,
|
|
'description' => 'Staatsfeiertag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1873058400,
|
|
'description' => 'Christi Himmelfahrt',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1874008800,
|
|
'description' => 'Pfingstmontag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1874872800,
|
|
'description' => 'Fronleichnam',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1881439200,
|
|
'description' => 'Mariä Himmelfahrt',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1887660000,
|
|
'description' => 'Nationalfeiertag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1888182000,
|
|
'description' => 'Allerheiligen',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1891378800,
|
|
'description' => 'Maria Empfängnis',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1892847600,
|
|
'description' => 'Christtag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1892934000,
|
|
'description' => 'Stefanitag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1893452400,
|
|
'description' => 'Neujahr',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1893884400,
|
|
'description' => 'Heilige Drei Könige',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1903039200,
|
|
'description' => 'Ostermontag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1903816800,
|
|
'description' => 'Staatsfeiertag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1906322400,
|
|
'description' => 'Christi Himmelfahrt',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1907272800,
|
|
'description' => 'Pfingstmontag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1908136800,
|
|
'description' => 'Fronleichnam',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1912975200,
|
|
'description' => 'Mariä Himmelfahrt',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1919196000,
|
|
'description' => 'Nationalfeiertag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1919718000,
|
|
'description' => 'Allerheiligen',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1922914800,
|
|
'description' => 'Maria Empfängnis',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1924383600,
|
|
'description' => 'Christtag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1924470000,
|
|
'description' => 'Stefanitag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1924988400,
|
|
'description' => 'Neujahr',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1925420400,
|
|
'description' => 'Heilige Drei Könige',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1933884000,
|
|
'description' => 'Ostermontag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1935352800,
|
|
'description' => 'Staatsfeiertag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1937167200,
|
|
'description' => 'Christi Himmelfahrt',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1938117600,
|
|
'description' => 'Pfingstmontag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1938981600,
|
|
'description' => 'Fronleichnam',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1944511200,
|
|
'description' => 'Mariä Himmelfahrt',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1950732000,
|
|
'description' => 'Nationalfeiertag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1951254000,
|
|
'description' => 'Allerheiligen',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1954450800,
|
|
'description' => 'Maria Empfängnis',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1955919600,
|
|
'description' => 'Christtag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1956006000,
|
|
'description' => 'Stefanitag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1956524400,
|
|
'description' => 'Neujahr',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1956956400,
|
|
'description' => 'Heilige Drei Könige',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1964124000,
|
|
'description' => 'Ostermontag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1966975200,
|
|
'description' => 'Staatsfeiertag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1967407200,
|
|
'description' => 'Christi Himmelfahrt',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1968357600,
|
|
'description' => 'Pfingstmontag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1969221600,
|
|
'description' => 'Fronleichnam',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1976133600,
|
|
'description' => 'Mariä Himmelfahrt',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1982354400,
|
|
'description' => 'Nationalfeiertag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1982876400,
|
|
'description' => 'Allerheiligen',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1986073200,
|
|
'description' => 'Maria Empfängnis',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1987542000,
|
|
'description' => 'Christtag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
[
|
|
'timestamp' => 1987628400,
|
|
'description' => 'Stefanitag',
|
|
'create_by' => 1,
|
|
'edit_by' => 1,
|
|
'create' => 1705051720,
|
|
'edit' => 1705051720
|
|
],
|
|
];
|
|
|
|
$this->table('TimerecordingHoliday')->insert($rows)->save();
|
|
}
|
|
|
|
if($this->getEnvironment() == "addressdb") {
|
|
|
|
}
|
|
}
|
|
|
|
public function down(): void
|
|
{
|
|
if($this->getEnvironment() == "thetool") {
|
|
$this->execute('DELETE FROM TimerecordingHoliday');
|
|
}
|
|
|
|
if($this->getEnvironment() == "addressdb") {
|
|
|
|
}
|
|
}
|
|
}
|