Beiträge von TeamPower

<?php


/**
* Registriert den Post Type „product“
*/
function register_product_post_type() {
    $labels = array(
        'name'                  => __( 'Produkte', TRANSLATION_CONST ),
        'singular_name'         => __( 'Produkt', TRANSLATION_CONST ),
        'add_new'               => __( 'Hinzufügen', TRANSLATION_CONST ),
        'add_new_item'          => __( 'Produkt hinzufügen', TRANSLATION_CONST ),
        'edit_item'             => __( 'Produkt bearbeiten', TRANSLATION_CONST ),
        'new_item'              => __( 'Produkt hinzufügen', TRANSLATION_CONST ),
        'view_item'             => __( 'Produkt anzeigen', TRANSLATION_CONST ),
        'view_items'             => __( 'Produkte anzeigen', TRANSLATION_CONST ),
        'search_items'          => __( 'Produkt suchen', TRANSLATION_CONST ),
        'not_found'             => __( 'Keine Produkte gefunden', TRANSLATION_CONST ),
        'not_found_in_trash'    => __( 'Keine Produkte im Papierkorb gefunden', TRANSLATION_CONST ),
        'parent_item_colon'     => __( 'Übergeordnete Produkte:', TRANSLATION_CONST ),
        'all_items'             => __( 'Alle Produkte:', TRANSLATION_CONST ),
        'archives'              => __( 'Produkt Archiv:', TRANSLATION_CONST ),
        'attributes'            => __( 'Produkt Attribute:', TRANSLATION_CONST ),
        'insert_into_item'      => __( 'Zum Produkt hinzufügen', TRANSLATION_CONST ),
        'uploaded_to_this_item' => __( 'Zum Produkt hinzugefügt', TRANSLATION_CONST ),
        'featured_image'        => __( 'Produktbild', TRANSLATION_CONST ),
        'set_featured_image'    => __( 'Produktbild setzen:', TRANSLATION_CONST ),
        'remove_featured_image' => __( 'Produktbild entfernen:', TRANSLATION_CONST ),
        'use_featured_image'    => __( 'Als Produktbild verwenden:', TRANSLATION_CONST ),
        'menu_name'             => __( 'Produkte', TRANSLATION_CONST ),
    );
 
    $supports = array(
        'title',
        'editor', // Content Bereich
        'excerpt', // Kurzer Auszug des Contents für Archivseiten
        'author',
        'thumbnail', // featured_image / Produktbild
        //'trackbacks',
        'custom-fields',
        //'revisions',
        'page-attributes',
        'comments'
    );
 
    $args = array(
        'labels' => $labels,
        'hierarchical' => false,
        'description' => __( 'Produkte für mein eigenes E-Commerce Plugin', TRANSLATION_CONST ),
        'supports' => $supports,
        'public' => true,
        'show_ui' => true,
        'show_in_menu' => true,
        'menu_position' => 5, // Unterhalb der Posts
        'menu_icon' => 'dashicons-card',
        'show_in_nav_menus' => true,
        'publicly_queryable' => true,
        'exclude_from_search' => false,
        'has_archive' => true,
        'query_var' => true,
        'can_export' => true,
        'capability_type' => 'post'
    );
 
    register_post_type( 'product', $args );
}
add_action( 'init', 'register_product_post_type' );




function product_post_type_add_meta_boxes( $post ){
    add_meta_box( 'price_meta_box',
        'Price Detail',
        'product_post_type_build_price_meta_box',
        'product', 'normal', 'high'
    );
}
add_action( 'add_meta_boxes_product', 'product_post_type_add_meta_boxes' );


function product_post_type_build_price_meta_box($post) {
    wp_nonce_field( basename( __FILE__ ), 'product_post_type_price_meta_box_nonce' );


    $current_price = get_post_meta( $post->ID, 'product_price', true );
    ?>
    <div class="inside">
        <section id="price-meta-box-container">
            <p>
                <input type="number" name="product_price" id="product-price"<?php echo ' value="'.$current_price.'"'; ?>>
            </p>
        </section>
    </div>
    <?php
}


function product_post_type_save_price_meta_boxes_data( $post_id ){
    if ( !isset( $_POST['product_post_type_price_meta_box_nonce'] ) ||
            !wp_verify_nonce(
                $_POST['product_post_type_price_meta_box_nonce'],
                basename( __FILE__ )
            ) ){
        return;
    }


    if ( defined( 'DOING_AUTOSAVE' ) && DOING_AUTOSAVE )
        return;


    if ( defined( 'DOING_AJAX' ) && DOING_AJAX )
        return;


    if ( !current_user_can( 'edit_post', $post_id ) )
        return;


    if ( isset( $_REQUEST['product_price'] ) ) {
        update_post_meta(
            $post_id,
            'product_price',
            sanitize_text_field( $_POST['product_price'] )
        );
    }
}
add_action( 'save_post_product', 'product_post_type_save_price_meta_boxes_data', 10, 2 );


function the_product_price($post = 0, $echo = true) {
    $post = get_post( $post );


    $id = isset( $post->ID ) ? $post->ID : 0;
    $value = get_post_meta( $id, 'product_price', true );


    if($echo) {
        echo sprintf(
            '<span class="product-detail--price">%s %s</span>',
            esc_html($value),
            __('€', TRANSLATION_CONST)
        );
    }
    else
        return $value;
}

<?php
/**
 * Template Name: Archive Product Template
 *
 * Description: Eine eigene Archivseite für meinen Post Type „product“
 */


get_header(); ?>


    <div class="main-wrap" role="main">


        <!-- Darstellung der Produkte -->
        <section id="product-listing">
            <?php if ( have_posts() ) : ?>
                <div class="row">
                <?php while ( have_posts() ) : the_post(); ?>
                    <div class="column"">
           <?php get_template_part( 'product-content', get_post_format() ); ?>
        </div>
                <? endwhile; ?>
                </div>
            <?php endif; ?>
        </section>


    </div>


<?php get_footer();

<?php
/**
 * Das Standard-Template zum Anzeigen eines Produktes
 */
?>


<div class="product-container" id="product-<?php the_ID(); ?>">
    <?php if ( has_post_thumbnail() ) : ?>
    <a href="<?php the_permalink(); ?>">
         <img src="<?php the_post_thumbnail_url( ); ?>">
    </a>
    <?php endif; ?>


    <div class="product-content-section">
        <header>
            <h3><a href="<?php the_permalink(); ?>"><?php the_title(); ?></a></h3>
        </header>
        <div class="entry-content">
            <?php
                the_product_price(get_the_ID());
                echo '<br />';
                the_excerpt();
            ?>


        </div>
    </div>
</div>

<?php get_header(); ?>


<?php while ( have_posts() ) : the_post(); ?>
<article <?php post_class() ?> id="product-<?php the_ID(); ?>">
    <div class="row column" id="product-header">
        <h1 class="entry-title"><?php the_title(); ?></h1>
    </div>


    <div class="main-wrap" role="main">
        <div class="entry-content">
            <div class="row">
                <div class="medium-6 columns">
                    <?php if(has_post_thumbnail( )) : ?>
                        <a href="<?php the_post_thumbnail_url('large'); ?>">
                                <img src="<?php the_post_thumbnail_url('large'); ?>"/>
                        </a>
                    <?php endif; ?>
                </div>
                <div class="medium-6 columns">
                    <?php the_product_price(get_the_ID()); ?>
                </div>
            </div>


            <div class="row columns">
                <?php the_content(); ?>
            </div>
        </div>


        <footer>
            <?php
                wp_link_pages(
                    array(
                        'before' => '<nav id="page-nav"><p>' . __( 'Produkte:', TRANSLATION_CONST ),
                        'after'  => '</p></nav>',
                    )
                );
            ?>
        </footer>


        <!-- Das ist das mit dem Kommentar kram -->   
        <?php comments_template(); ?>


    </div>
</article>
<?php endwhile;?>


<?php get_footer();

function create_verein_cpt() {


    $labels = array(
        'name' => 'Verein',
        'singular_name' => 'Verein',
    );
    $args = array(
        'label' => __( 'Verein', 'Verein' ),
        'description' => __( 'Verein', 'Verein' ),
        'labels' => $labels,
        'menu_icon' => 'dashicons-admin-tools',
        'supports' => array(),
        'taxonomies' => array(),
        'public' => true,
        'show_ui' => true,
        'show_in_menu' => true,
        'menu_position' => 5,
        'show_in_admin_bar' => true,
        'show_in_nav_menus' => true,
        'can_export' => true,
        'has_archive' => true,
        'hierarchical' => false,
        'exclude_from_search' => false,
        'show_in_rest' => true,
        'publicly_queryable' => true,
        'capability_type' => 'post',
    );
    register_post_type( 'verein', $args );


}
add_action( 'init', 'create_verein_cpt', 0 );


add_action( 'admin_init', 'my_admin' );


function my_admin() {
    add_meta_box(
        'verein_review_meta_box',
        'Verein Informationen',
        'display_verein_review_meta_box',
        'verein',
    );
}


function display_verein_review_meta_box() {
    ?>
    <table>
        <tr>
            <td style="width: 50%">ID</td>
            <td><input type="text" size="40" name="verein" value="<?php echo get_post_meta( get_the_ID(), 'ID', true ); ?>"  /></td>
        </tr>
        <tr>
            <td style="width: 50%">Vereinsname</td>
            <td><input type="text" size="40" name="verein" value="<?php echo get_post_meta( get_the_ID(), 'Name', true ); ?>"  /></td>
        </tr>
        <tr>
            <td style="width: 50%">Vereins Email</td>
            <td><input type="text" size="40" name="verein" value="<?php echo get_post_meta( get_the_ID(), 'Email', true ); ?>"  /></td>       
        </tr>
        <tr>
            <td style="width: 50%">Landesverband</td>
            <td><input type="text" size="40" name="verein" value="<?php echo get_post_meta( get_the_ID(), 'Verband', true ); ?>"  /></td>       
        </tr>
    </table>
    <?php
}


add_action( 'wp', 'insert_into_verein_cpt' );


function check_for_similar_meta_ids() {
    $id_arrays_in_cpt = array();


    $args = array(
        'post_type'      => 'verein',
        'posts_per_page' => -1,
    );


    $loop = new WP_Query($args);
    while( $loop->have_posts() ) {
        $loop->the_post();
        $id_arrays_in_cpt[] = get_post_meta( get_the_ID(), 'ID', true );
    }


    return $id_arrays_in_cpt;
}


function query_verein_table( $verein_available_in_cpt_array ) {
    global $wpdb;
    $table_name = $wpdb->prefix . 'verein';


    if ( NULL === $verein_available_in_cpt_array || 0 === $verein_available_in_cpt_array || '0' === $verein_available_in_cpt_array || empty( $verein_available_in_cpt_array ) ) {
        $results = $wpdb->get_results("SELECT * FROM $table_name");
        return $results;
    } else {
        $ids = implode( ",", $verein_available_in_cpt_array );
        $sql = "SELECT * FROM $table_name WHERE id NOT IN ( $ids )";
        $results = $wpdb->get_results( $sql );
        return $results;
    }
}


function insert_into_verein_cpt() {


    $verein_available_in_cpt_array = check_for_similar_meta_ids();
    $database_results = query_verein_table( $verein_available_in_cpt_array );


    if ( NULL === $database_results || 0 === $database_results || '0' === $database_results || empty( $database_results ) ) {
        return;
    }


    foreach ( $database_results as $result ) {
        $verein_model = array(
            'post_title' => wp_strip_all_tags( $result->Name ),
            'meta_input' => array(
                'ID'        => $result->ID,
                'Name'        => $result->Name,
                'Email'        => $result->Email,
                'Verband'        => $result->Verband,
            ),
            'post_type'   => 'verein',
            'post_status' => 'publish',
        );
        wp_insert_post( $verein_model );
    }
}

function print_mitglieder() {
//Hier wird das JavaScript erstellt


    echo "<script>function myFunction() {alert('<?php echo print_MitgliederDetails() ?>')};</script>";
    


    $content = "<figure><table>";
    $content .= "<thead>
                    <tr>
                        <th>ID</th>
                        <th>Vorname</th>
                        <th>Nachname</th>
                        <th>Geburtsdatum</th>
                        <th>Beispiel</th>
                    </tr>
                <thead>";
    $content .= "<tbody>";
    
    $res = execute_query("select * from Mitglied");
    
    if($res->num_rows > 0) {
        while($row = $res->fetch_assoc()) {
            $currDate = $row["Geburtsdatum"];
            $changeDate = date("d-m-Y", strtotime($currDate));
            $mitgliedID = $row['MitgliederID'];
            if($mitgliedID % 2 == 0)
            $content .= "<tr class='whiteRow'>
                            <td><a href='#' data-toggle='tooltip' title=' ' id=" . $row['MitgliederID'] . ">" . $row["MitgliederID"] . "</a></td>
                            <td><a onclick='myFunction()'>" . $row["Vorname"] . "</a></td>
                            <td>" . $row["Nachname"] . "</td>
                            <td>" . $changeDate . "</td>
                            <td>" . '<a href="javascript:PUM.open(288);">DetailAnsicht</a>' . "</td>
                        </tr>";
            else
                    $content .= "<tr class='grayRow'>
                            <td><a href='#' data-toggle='tooltip' title='Hooray!' id=" . $row['MitgliederID'] . ">" . $row["MitgliederID"] . "</a></td>
                            <td>" . $row["Vorname"] . "</td>
                            <td>" . $row["Nachname"] . "</td>
                            <td>" . $changeDate . "</td>
                            <td>" . '<a href="javascript:PUM.open(288);">DetailAnsicht</a>' . "</td>
                        </tr>";
        }
    }
    
    $content .= "</tbody></table></figure>";


    return $content;
}

function print_MitgliederDetails($id) {
    // Kopf der Tabelle
    $content = "<figure class='wp-block-table is-style-stripes'><table>";
    $content .= "<thead>
                    <tr>
                        <th>ID</th>
                        <th>Name</th>
                        <th>Alter</th>
                        <th>Aktiv</th>
                        <th>Disziplin</th>
                    </tr>
                <thead>";
    $content .= "<tbody>";
    
    // Daten fuer die Tabelle holen
    $res = execute_query("select $id from Formation");
    
    // Wenn Daten existieren ...
    if($res->num_rows > 0) {
        // ... schreibe jeden Datensatz in eine Zeile
        while($row = $res->fetch_assoc()) {
            $content .= "<tr>
                            <td>" . $row["ID"] . "</td>
                            <td>" . $row["Name"] . "</td>
                            <td>" . $row["Alter"] . "</td>
                            <td>" . $row["Aktiv"] . "</td>
                            <td>" . $row["Disziplin"] . "</td>
                        </tr>";
        }
    }
    
    // Tabelle endet hier
    $content .= "</tbody></table></figure>";
    
    return $content;
}

function print_Sportler() {
    $content = "<figure class='wp-block-table is-style-stripes'><table>";
    $content .= "<thead>
                    <tr>
                        <th>ID</th>
                        <th>Name</th>
                        <th>Alter</th>
                        <th>Aktiv</th>
                        <th>Disziplin</th>
                    </tr>
                <thead>";
    $content .= "<tbody>";
    
    $res = execute_query("select * from Sportler");
    
    if($res->num_rows > 0) {
        // ... schreibe jeden Datensatz in eine Zeile
        while($row = $res->fetch_assoc()) {
            $content .= "<tr>
                            <td>" . $row["ID"] . "</td>
                            <td>" . $row["Name"] . "</td>
                            <td>" . $row["Alter"] . "</td>
                            <td>" . $row["Aktiv"] . "</td>
                            <td>" . $row["Disziplin"] . "</td>
                        </tr>";
        }
    }
    
    $content .= "</tbody></table></figure>";
    
    return $content;
}

/* Chrome, Safari, Edge, Opera */


input::-webkit-outer-spin-button,
input::-webkit-inner-spin-button {
  -webkit-appearance: none;
  margin: 0;
}


/* Firefox */
input[type=number] {
  -moz-appearance: textfield;
}

/**
* CF7: Numbers Only Validation
* Validate the input fields with CSS class .wpcf7-numbers-only to allow numbers only.
*/
add_action( 'wp_footer', 'wpcf7_input_numbers_only');
function wpcf7_input_numbers_only() {
  echo '
  <script>
  onload =function(){
    var ele = document.querySelectorAll(\'.wpcf7-numbers-only\');
    ele.forEach(function(el) {
          el.onkeypress = function(e) {
              if(isNaN(this.value + "" + parseInt(String.fromCharCode(e.charCode))))
              return false;
        }
        el.onpaste = function(e){
              e.preventDefault();
        }
    });
  }
  </script>
  ';
}

/**
* CF7: Numbers Only Validation
* Validate the input fields with CSS class .wpcf7-numbers-only to allow numbers only.
*/
add_action( 'wp_footer', 'wpcf7_input_numbers_only');
function wpcf7_input_numbers_only() {
  echo '
  <script>
  onload =function(){
    var ele = document.querySelectorAll(\'.wpcf7-numbers-only\')[0];
    ele.onkeypress = function(e) {
      if(isNaN(this.value+""+String.fromCharCode(e.charCode)))
      return false;
    }
    ele.onpaste = function(e){
      e.preventDefault();
    }
  }
  </script>
  ';
}