4-WORDPRESS PLUGIN

Plugin: industrie-imkerei-system.php

Pfad:

/wp-content/plugins/industrie-imkerei-system/

Datei:

<?php
/*
Plugin Name: Industrie Imkerei System
Description: Managementsystem für 500 Bienenvölker
Version: 1.0
Author: OpenAI
*/

if (!defined('ABSPATH')) {
    exit;
}

class IndustrieImkereiSystem {

    public function __construct() {

        add_action('admin_menu', array($this, 'admin_menu'));

    }

    /*
    -----------------------------------
    CREAR TABLAS MYSQL
    -----------------------------------
    */

    public static function install_tables() {

        global $wpdb;

        $charset_collate = $wpdb->get_charset_collate();

        require_once(ABSPATH . 'wp-admin/includes/upgrade.php');

        /*
        TABLA BIENENVÖLKER
        */

        $table_bienen = $wpdb->prefix . 'bienenvoelker';

        $sql1 = "CREATE TABLE $table_bienen (

            id BIGINT(20) NOT NULL AUTO_INCREMENT,
            volk_id VARCHAR(50) NOT NULL,
            standort VARCHAR(100),
            status VARCHAR(50),
            honig_kg FLOAT DEFAULT 0,
            varroa FLOAT DEFAULT 0,
            letzte_kontrolle DATETIME,
            PRIMARY KEY (id)

        ) $charset_collate;";

        dbDelta($sql1);

        /*
        TABLA KONTROLLEN
        */

        $table_kontrollen = $wpdb->prefix . 'kontrollen';

        $sql2 = "CREATE TABLE $table_kontrollen (

            id BIGINT(20) NOT NULL AUTO_INCREMENT,
            volk_id VARCHAR(50),
            datum DATETIME,
            beobachtung TEXT,
            aktion TEXT,
            mitarbeiter VARCHAR(100),
            PRIMARY KEY (id)

        ) $charset_collate;";

        dbDelta($sql2);

        /*
        TABLA RANKING
        */

        $table_ranking = $wpdb->prefix . 'ranking';

        $sql3 = "CREATE TABLE $table_ranking (

            id BIGINT(20) NOT NULL AUTO_INCREMENT,
            volk_id VARCHAR(50),
            punktzahl FLOAT DEFAULT 0,
            position_nr INT DEFAULT 0,
            PRIMARY KEY (id)

        ) $charset_collate;";

        dbDelta($sql3);
    }

    /*
    -----------------------------------
    MENÚ ADMIN
    -----------------------------------
    */

    public function admin_menu() {

        add_menu_page(
            'Imkerei System',
            'Imkerei',
            'manage_options',
            'imkerei-dashboard',
            array($this, 'dashboard_page'),
            'dashicons-admin-site',
            6
        );
    }

    /*
    -----------------------------------
    DASHBOARD
    -----------------------------------
    */

    public function dashboard_page() {

        global $wpdb;

        $table = $wpdb->prefix . 'bienenvoelker';

        $count = $wpdb->get_var("SELECT COUNT(*) FROM $table");

        echo '<div class="wrap">';

        echo '<h1>Industrie Imkerei Dashboard</h1>';

        echo '<h2>Gesamtvölker: ' . $count . '</h2>';

        echo '<p>Das System funktioniert korrekt.</p>';

        echo '</div>';
    }
}

/*
-----------------------------------
PLUGIN START
-----------------------------------
*/

register_activation_hook(
    __FILE__,
    array('IndustrieImkereiSystem', 'install_tables')
);

new IndustrieImkereiSystem();