Author: Ipstenu (Mika Epstein)

The statistics page on my TV database site is pretty fun. It’s the one I learned how to use Chart.js for in the first place.

I wanted to add in some pie charts, but first I upgraded the code to the 2.0-beta and refined the PHP on my stats. Originally I just had some pretty basic bar charts for category statistics. Now I have some pie charts to show characters by role (by which I mean are they a main character, a guest, or a recurring character).

Better Category Stats

Let’s talk about some better PHP first. The stuff I had before worked, but it could have been better. Here’s the better PHP:

$count_characters = wp_count_posts( 'post_type_characters' )->publish + wp_count_posts( 'post_type_characters' )->draft ;
$tropes = get_terms('chartags');

$trope_terms_array = array();
foreach ( $tropes as $trope ) {
	$trope_terms_array[$trope->slug] = array( 'count' => $trope->count, 'name'  => $trope->name, 'url' => get_term_link( $trope ) );
}

What I did here was take the data and make a single array for it which gives me the data structured as follows:

Array
(
    [addict] => Array
        (
            [count] => 2
            [name] => Addict
            [url] => http://example.com/tropes/addict/
        )

    [athlete] => Array
        (
            [count] => 3
            [name] => Athlete
            [url] => http://example.com/tropes/athlete/
        )
)

This makes my array much smaller and simpler to run through. Next I changed how I call the data in my javascript:

	labels : [<?php
		$unset = array('foo','bar','baz');
		foreach ( $unset as $item ) {
			unset($trope_terms_array[$item]);
		}

		foreach ( $trope_terms_array as $trope ) {
			echo '"'.$trope['name'].'", ';
		}
	?>],

The unsetting at the top is a quick run to remove the tropes I don’t need for this chart because I’m displaying them in the pie chart. See? It all comes together!

Pie No. 1 – Sexuality

There are two pie charts. One is checking how many characters are gay, straight, or bisexual. I’m sure eventually I’ll be add asexual, but that isn’t today. Anyway, that chart is surprisingly simple. Since I’d already improved the PHP call for category stats, and sexuality is saved as a character taxonomy, I was able to do this simply as follows:

<script>
// Piechart for sexuality stats
var pieSexdata = {
    labels: [
        "Gay",
        "Straight",
        "Bisexual"
    ],
    datasets: [
        {
            data: [ <?php echo '
	            "'.( $count_characters - $trope_terms_array['straight']['count'] - $trope_terms_array['bisexual']['count'] ).'",
	            "'.$trope_terms_array['straight']['count'].'",
	            "'.$trope_terms_array['bisexual']['count'].'"
	            '; ?>],
            backgroundColor: [
                "#7d3255",
                "#327A7D",
                "#32557D"
            ],
            hoverBackgroundColor: [
                "#B18499",
                "#BCD4D5",
                "#ABB9CA"
            ]
        }]
};

var ctx = document.getElementById("pieSex").getContext("2d");
var pieSex = new Chart(ctx,{
    type:'doughnut',
    data: pieSexdata,
    options: {}
});
</script>

The default assumption is that any character being added is a homosexual. The reason ‘straight’ is there is for a character who was presented as gay, but that turned out to be a fantasy sequence. Thanks, Roseanne. With that in mind, calculating the number of gay characters was a matter of subtracting the straight and bisexual. And yes, I named the chart pieSexdata on purpose.

Pie No. 2 – Character Role

The second pie chart was a lot harder. You see, I’d chosen to save the ‘role’ as a custom meta field in the post. There’s a dropdown for ‘Main’ or ‘Recurring’ or ‘Guest’ and it defaults to ‘None’ if you don’t fill it out. Right now everyone has a role but I coded in a failsafe.

This code took me a while to sort out, but as soon as I realized how simple it was, I made a loop so I didn’t have to repeat code:

$roles = array( 'regular', 'recurring', 'guest' );
$roles_array = array();
foreach ( $roles as $role ) {
	$args = array(
		'post_type'       => 'post_type_characters',
		'posts_per_page'  => -1,
		'post_status'     => array( 'publish', 'draft' ),
		'meta_query'      => array(
			array(
				'key'     => 'chars_type',
				'value'   => $role,
				'compare' => '=',
			),
		),
    );
	$thisrole = new WP_Query($args);
	$roles_array[$role] = $thisrole->post_count;
}

This produces a nice array:

Array
(
    [regular] => 147
    [recurring] => 37
    [guest] => 23
)

I wanted it to be an array since I can see this expanding sooner or later. The pie chart code looks very much the same as the one for sexuality, and all that’s really different is how I’m calling the data and doing the math for how many characters have no listed role.

    labels: [
        "Main Character",
        "Recurring Character",
        "Guest Character",
        "No Role"
    ],
    datasets: [
        {
            data: [ <?php echo '
	            "'.$roles_array['regular'].'",
	            "'.$roles_array['recurring'].'",
	            "'.$roles_array['guest'].'",
	            "'.( $count_characters - $roles_array['guest'] - $roles_array['recurring'] - $roles_array['regular'] ).'",
	            '; ?>],

What’s Next?

Things are shaping up nicely, but I want to add in better labels. I’d like if they show the percentage when you hover over them on pie charts, and if they could link to the taxonomy pages for the bar charts. But I haven’t quite sorted out how to do that yet.

I also have to blame Tracy for this, because she’s the one who wanted stats like that in the first place.

I didn’t plan to, the first time. I’d inherited a site that I offered to help someone clean up and they had CMB2. They didn’t actually. They had CMB, the original. This was a while ago. Looking at their site, I realized they had one (yes, one) custom meta box, so I removed CMB and coded in that one meta box and called it a day.

Flash forward a while. A long while. I have a site that was mostly built out by someone else, and it worked great except on mobile. After trying to update content on the site on my iPad and getting frustrated to the point of angor, I re-did the theme as Metro Pro (yes, it’s that site), and folded in a lot of the meta boxes into mu-plugins, so we could keep them no matter what the theme.

But again, she’d used CMB. Not CMB2. And since I know CMB2 has a lot more features, I decided to upgrade. Three hours later, I had it done and had it done rather nicely.

Decide how to install CMB2

I did it as an mu-plugin – Look. It’s a library. I have my font library (aaah!) in there as well. This is how I organize things. I don’t want people disabling it on accident, so by having it in my Must Use folder, only people with SSH or Git access can screw with it. This is a protection thing.

I tossed the cmb2 folder in there and whipped up a fast cmb2.php bootstrap file:

if ( file_exists( dirname( __FILE__ ) . '/cmb2/init.php' ) ) {
	require_once dirname( __FILE__ ) . '/cmb2/init.php';
} elseif ( file_exists( dirname( __FILE__ ) . '/CMB2/init.php' ) ) {
	require_once dirname( __FILE__ ) . '/CMB2/init.php';
}

// Extra Get post options.
function cmb2_get_post_options( $query_args ) {
    $args = wp_parse_args( $query_args, array(
        'post_type'   => 'post',
        'numberposts' => -1,
    ) );
    $posts = get_posts( $args );
    $post_options = array();
    if ( $posts ) {
        foreach ( $posts as $post ) {
          $post_options[ $post->ID ] = $post->post_title;
        }
    }
    asort($post_options);
    return $post_options;
}

// Handle the CSS for this
function cmb2_site_scripts( $hook ) {
	if ( $hook == 'post.php' || $hook == 'post-new.php' || $hook == 'page-new.php' || $hook == 'page.php' ) {
		wp_register_style( 'cmb-styles', plugins_url('/cmb2.css', __FILE__ ) );
		wp_enqueue_style( 'cmb-styles' );
	}
}
add_action( 'admin_enqueue_scripts', 'cmb2_site_scripts', 10 );

You’ll notice that’s more than just bootstrapping. This is the other reason I wanted it as an MU plugin. The first part with the require_once is the call for CMB2. I could simplify it since the folder is lowercase, but it’s fine as is. The second part with function cmb2_get_post_options is so that I can use the names of all my posts as options in a dropdown. I didn’t invent this code, it’s from the CMB2 documentation. The last bit of function cmb2_site_scripts is just to make sure my custom CSS gets loaded on the right pages (I wanted to change the layout of some things).

Convert the Calls

This was the weird part. I’d never really used CMB before. CMB2, through various things including reviews, I’m pretty familiar with the general aspects of it, though not all the specific calls. From CMB to CMB2, the major change was that instead of multiple nested arrays with a return, the code was wrapped in a function that had an array, but then it had callbacks.

This:

	$meta_boxes[] = array(
		'id'         => 'chars_metabox',
		'title'      => 'Character Details',
		'pages'      => array( 'post_type_characters', ), // Post type
		'context'    => 'normal',
		'priority'   => 'high',
		'show_names' => true, // Character field names on the left
		'fields'     => array( ... )
	);

	return $meta_boxes;

became this:

	$cmb_characters = new_cmb2_box( array(
		'id'            => 'chars_metabox',
		'title'         => 'Character Details',
		'object_types'  => array( 'post_type_characters', ), // Post type
		'context'       => 'normal',
		'priority'      => 'high',
		'show_names   ' => true, // Show field names on the left
	) );

You can totally see how one transmuted into the other, right?

The biggest change is the 'fields' => array( ... ) section, which is totally missing from the new version. Remaking the fields was trickier since some changed a great deal. And some changed in fantastic ways.

Here’s the original actor name field:

			array(
				'name' => 'Actor Name',
				'id'   => $prefix . 'actor',
				'type' => 'text',
			),

And here is the new one:

	$cmb_characters->add_field( array(
		'name'       => 'Actor Name',
		'desc'       => 'Include years (in parens) for multiple actors',
		'id'         => $prefix . 'actor',
		'type'       => 'text',
		'repeatable' => 'true',
	) );

I’ve added in two things. First is the desc (description), which was needed because I was adding in the repeatable field! Sometimes actors are replaced, and with that in mind we’d been using ‘Foo (2013), Bar (2014-2015)’ and so on. But now with repeatable fields we could easily add in a new line for every actor. Problem solved!

Why not hand code?

Because the Fields API is a sack of wet, smelly, rotting, hair. It’s actually worse than the Settings API. I can’t wait for the Fields API plugin to hit release candidate and have a UI built in. Until then, hand coding more than one meta box is a headache. Making three groups with three to eight fields in each with cross dependencies? A nightmare.

Simply put, CMB2 does it well, obviously, and simply. The code is easy to understand and implement. I wish it was in core. It’s around 3 megs, but 2 of them are from translations, so it’s really not as horrible as all that.