search

dbuckingham / wp-troop380

0 stars 0 forks source link

readme

# Troop 380

A WP plugin of useful, scouting related features, built for Troop 380 of the Lincoln Heritage Council.

Resources

WP_Query Snippets

<?php

$wp_troop380_eaglescout_id = 92;

$args = array(
    "post_type" => "eaglescout",
    "meta_key" => "_wp_troop380_eaglescout_id",
    "meta_value" => $wp_troop380_eaglescout_id
    );

// print_r( $args );
// echo "<br /><br />";

$query = new WP_Query( $args );

$posts = $query->posts;

foreach( $posts as $post ) {

    print_r( $post );
    echo "<br /><br />";

}
<?php

global $wpdb;

$query = "SELECT * FROM information_schema.TABLES WHERE TABLE_NAME = 'wp_troop380_eaglescout';";
$eagle_scout_table = $wpdb->get_results($query);

if( ($wpdb->num_rows <= 0) ) { return; }

$query = "SELECT id, YEAR(date_earned) 'year', firstname, lastname, date_earned, date_earned_is_real FROM wp_troop380_eaglescout ORDER BY date_earned, lastname, firstname LIMIT 1;";

$rows = $wpdb->get_results($query);

foreach($rows as $row) {

    $wp_troop380_eaglescout_id = $row->id;

    $args = array(
        "post_type" => "eaglescout",
        "meta_key" => "_wp_troop380_eaglescout_id",
        "meta_value" => $wp_troop380_eaglescout_id
        );

    $query = new WP_Query( $args );

    $posts = $query->posts;

    // print_r( $wp_troop380_eaglescout_id );
    // echo "<br />";

    if( count( $posts ) == 0 ) {
        // Eagle Scout post does not exist and needs to be created.

        $postarr = array(
            "post_title" => $row->firstname . " ". $row->lastname,
            "post_type" => "eaglescout",
            "post_status" => "publish",
            "meta_input"=> array(
                "board_of_review_date" => date( "m/d/Y", strtotime( $row->date_earned ) ),
                "board_of_review_date_is_real" => $row->date_earned_is_real,
                "year_earned" => date( "Y", strtotime( $row->date_earned ) ),
                "_wp_troop380_eaglescout_id" => $wp_troop380_eaglescout_id
            )
        );

        print_r( $postarr );
        echo "<br />";

        $result = wp_insert_post( $postarr );
        print_r($result);
        echo "<br />";

    }
}
<?php

$args = array(
    "post_type" => "eaglescout",
    "nopaging" => true,
    "meta_key" => "board_of_review_date",
    "meta_type" => "DATETIME",
    "orderby" => "meta_value",
    "order" => "desc"
);

$query = new WP_Query( $args );

echo "<table>";
foreach( $query->posts as $post ) {

    $output = "<tr>";
    $output .= "<td>";
    $output .= $post->ID;
    $output .= "</td>";
    $output .= "<td>";
    $output .= $post->post_title;
    $output .= "</td>";
    $output .= "<td>";
    $output .= get_post_meta( $post->ID, "board_of_review_date", true );
    $output .= "</td>";
    $output .= "<td>";
    $output .= get_post_meta( $post->ID, "year_earned", true );
    $output .= "</td>";
    $output .= "</tr>";

    echo $output;
}
echo "</table>";
<?php
$args = array(
    "post_type" => "eaglescout",
    "nopaging" => true,
    "meta_query" => array(
        "key" => "year_earned",
        "value" => "2022",
        "compare" => "="
    ),
    "meta_key" => "board_of_review_date",
    "meta_type" => "DATETIME",
    "orderby" => "meta_value",
    "order" => "desc"
);

$query = new WP_Query( $args );

echo "<table>";
foreach( $query->posts as $post ) {

    $output = "<tr>";
    $output .= "<td>";
    $output .= $post->ID;
    $output .= "</td>";
    $output .= "<td>";
    $output .= $post->post_title;
    $output .= "</td>";
    $output .= "<td>";
    $output .= get_post_meta( $post->ID, "board_of_review_date", true );
    $output .= "</td>";
    $output .= "<td>";
    $output .= get_post_meta( $post->ID, "year_earned", true );
    $output .= "</td>";
    $output .= "</tr>";

    echo $output;
}
echo "</table>";