public function prepare_items()
{
global $wpdb;
// number of items per page
$per_page = 20;
// define column headers
$columns = $this->get_columns();
$hidden = array();
$sortable = $this->get_sortable_columns();
$this->_column_headers = array($columns, $hidden, $sortable);
$data = \Podlove\Cache\TemplateCache::get_instance()->cache_for('podlove_analytics_downloads_table', function () {
global $wpdb;
// retrieve data
$subSQL = function ($start = null, $end = null) {
$strToMysqlDate = function ($s) {
return date('Y-m-d', strtotime($s));
};
if ($start && $end) {
$timerange = " AND di2.accessed_at BETWEEN '{$strToMysqlDate($start)}' AND '{$strToMysqlDate($end)}'";
} elseif ($start) {
$timerange = " AND DATE(di2.accessed_at) = '{$strToMysqlDate($start)}'";
} else {
$timerange = "";
}
return "\n\t\t\t\t\tSELECT\n\t\t\t\t\t\tCOUNT(di2.id) downloads\n\t\t\t\t\tFROM\n\t\t\t\t\t\t" . Model\MediaFile::table_name() . " mf2\n\t\t\t\t\t\tLEFT JOIN " . Model\DownloadIntentClean::table_name() . " di2 ON di2.media_file_id = mf2.id\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tmf2.episode_id = e.id\n\t\t\t\t\t\t{$timerange}\n\t\t\t\t";
};
$sql = "\n\t\t\t\tSELECT\n\t\t\t\t\te.id,\n\t\t\t\t\tp.post_title title,\n\t\t\t\t\tp.post_date post_date,\n\t\t\t\t\tCOUNT(di.id) downloads,\n\t\t\t\t\t(" . $subSQL('28 days ago', 'now') . ") downloadsMonth,\n\t\t\t\t\t(" . $subSQL('7 days ago', 'now') . ") downloadsWeek,\n\t\t\t\t\t(" . $subSQL('1 day ago') . ") downloadsYesterday,\n\t\t\t\t\t(" . $subSQL('now') . ") downloadsToday\n\t\t\t\tFROM\n\t\t\t\t\t" . Model\Episode::table_name() . " e\n\t\t\t\t\tJOIN " . $wpdb->posts . " p ON e.post_id = p.ID\n\t\t\t\t\tJOIN " . Model\MediaFile::table_name() . " mf ON e.id = mf.episode_id\n\t\t\t\t\tLEFT JOIN " . Model\DownloadIntentClean::table_name() . " di ON di.media_file_id = mf.id\n\t\t\t\tWHERE\n\t\t\t\t\tp.post_status IN ('publish', 'private')\n\t\t\t\tGROUP BY\n\t\t\t\t\te.id\n\t\t\t";
return $wpdb->get_results($sql, ARRAY_A);
}, HOUR_IN_SECONDS);
$valid_order_keys = array('post_date', 'downloads', 'downloadsMonth', 'downloadsWeek', 'downloadsYesterday', 'downloadsToday');
// look for order options
if (isset($_GET['orderby']) && in_array($_GET['orderby'], $valid_order_keys)) {
$orderby = $_GET['orderby'];
} else {
$orderby = 'post_date';
}
// look how to sort
if (isset($_GET['order'])) {
$order = strtoupper($_GET['order']) == 'ASC' ? SORT_ASC : SORT_DESC;
} else {
$order = SORT_DESC;
}
array_multisort(\array_column($data, $orderby), $order, $data);
// get current page
$current_page = $this->get_pagenum();
// get total items
$total_items = count($data);
// extrage page for current page only
$data = array_slice($data, ($current_page - 1) * $per_page, $per_page);
// add items to table
$this->items = $data;
// register pagination options & calculations
$this->set_pagination_args(array('total_items' => $total_items, 'per_page' => $per_page, 'total_pages' => ceil($total_items / $per_page)));
}
/**
* Get Podlove episode template object.
*
* @param int|WP_Post $post Optional. Post ID or post object. Defaults to global $post.
* @return \Podlove\Template\Episode
*/
function get_episode($id = null)
{
$post = get_post($id);
if (!$post) {
return null;
}
$episode = Model\Episode::find_one_by_property('post_id', $post->ID);
if (!$episode) {
return null;
}
return new Template\Episode($episode);
}
/**
* Meta Box Template
*/
public static function post_type_meta_box_callback($post)
{
$post_id = $post->ID;
$podcast = Model\Podcast::get_instance();
$episode = Model\Episode::find_or_create_by_post_id($post_id);
wp_nonce_field(\Podlove\PLUGIN_FILE, 'podlove_noncename');
?>
<input type="hidden" name="show-media-file-base-uri" value="<?php
echo $podcast->media_file_base_uri;
?>
" />
<table class="form-table">
<?php
$form_args = array('context' => '_podlove_meta', 'submit_button' => false, 'form' => false);
\Podlove\Form\build_for($episode, $form_args, function ($form) use($podcast) {
$wrapper = new \Podlove\Form\Input\TableWrapper($form);
$episode = $form->object;
$wrapper->checkbox('active', array('label' => __('Post Episode to Show', 'podlove'), 'description' => '', 'default' => true));
$wrapper->string('slug', array('label' => __('Episode Media File Slug', 'podlove'), 'description' => '', 'html' => array('class' => 'regular-text')));
// TODO: validate and parse
$wrapper->string('duration', array('label' => __('Duration', 'podlove'), 'description' => '', 'html' => array('class' => 'regular-text')));
$wrapper->string('subtitle', array('label' => __('Subtitle', 'podlove'), 'description' => '', 'html' => array('class' => 'large-text')));
$wrapper->text('summary', array('label' => __('Summary', 'podlove'), 'description' => '', 'html' => array('class' => 'large-text', 'rows' => max(2, count(explode("\n", $episode->summary))))));
if ($podcast->supports_cover_art === 'manual') {
$wrapper->string('cover_art', array('label' => __('Episode Cover Art URL', 'podlove'), 'description' => __('JPEG or PNG. At least 1400 x 1400 pixels.', 'podlove'), 'html' => array('class' => 'regular-text')));
}
$wrapper->text('chapters', array('label' => __('Chapter Marks', 'podlove'), 'description' => __('One timepoint (hh:mm:ss[.mmm]) and the chapter title per line.', 'podlove'), 'html' => array('class' => 'large-text code', 'placeholder' => '00:00:00.000 Intro', 'rows' => max(2, count(explode("\n", $episode->chapters))))));
$wrapper->checkbox('enable', array('label' => __('Enable?', 'podlove'), 'description' => __('Allow this episode to appear in podcast directories.', 'podlove'), 'default' => true));
// TODO: button to update
// TODO: pretty display
// TODO: don't display link
// TODO: display last modified from header
$wrapper->multiselect('episode_assets', Podcast_Post_Meta_Box::episode_assets_form($episode));
});
?>
</table>
<?php
}
/**
* Meta Box Template
*/
public static function post_type_meta_box_callback($post)
{
$post_id = $post->ID;
$podcast = Model\Podcast::get();
$episode = Model\Episode::find_or_create_by_post_id($post_id);
wp_nonce_field(\Podlove\PLUGIN_FILE, 'podlove_noncename');
?>
<?php
do_action('podlove_episode_meta_box_start');
?>
<input type="hidden" name="show-media-file-base-uri" value="<?php
echo $podcast->media_file_base_uri;
?>
" />
<div class="podlove-div-wrapper-form">
<?php
$form_args = array('context' => '_podlove_meta', 'submit_button' => false, 'form' => false, 'is_table' => false);
$form_data = self::get_form_data($episode);
\Podlove\Form\build_for($episode, $form_args, function ($form) use($podcast, $form_data) {
$wrapper = new \Podlove\Form\Input\DivWrapper($form);
$episode = $form->object;
foreach ($form_data as $entry) {
$wrapper->{$entry['type']}($entry['key'], $entry['options']);
}
});
?>
</div>
<?php
do_action('podlove_episode_meta_box_end');
?>
<?php
}
function uninstall_for_current_blog()
{
global $wpdb;
Model\Feed::destroy();
Model\FileType::destroy();
Model\EpisodeAsset::destroy();
Model\MediaFile::destroy();
Model\Episode::destroy();
Model\Template::destroy();
Model\DownloadIntent::destroy();
Model\DownloadIntentClean::destroy();
Model\UserAgent::destroy();
Model\GeoArea::destroy();
Model\GeoAreaName::destroy();
do_action('podlove_uninstall_plugin');
// trash all episodes
$query = new \WP_Query(['post_type' => 'podcast']);
if ($query->have_posts()) {
while ($query->have_posts()) {
$query->the_post();
wp_trash_post(get_the_ID());
}
}
wp_reset_postdata();
// delete everything from wp_options
$wpdb->query('DELETE FROM `' . $wpdb->options . '` WHERE option_name LIKE "%podlove%"');
}
function uninstall_for_current_blog()
{
Model\Feed::destroy();
Model\FileType::destroy();
Model\EpisodeAsset::destroy();
Model\MediaFile::destroy();
Model\Show::destroy();
Model\Episode::destroy();
Model\Release::destroy();
}
