static function render_comments_meta_box($post)
{
global $wpdb;
$comment_type = Kanban_Utils::format_key(self::$slug, 'comment');
$sql = "SELECT `{$wpdb->prefix}comments`.*\n\t\t\t\tFROM `{$wpdb->prefix}comments`\n\t\t\t\tWHERE `comment_post_ID` = '{$post->ID}'\n\t\t\t\tAND `comment_type` = '{$comment_type}'\n\t\t\t\tORDER BY `{$wpdb->prefix}comments`.`comment_date` DESC\n\t\t\t;";
$sql = apply_filters(sprintf('%s_sql_%s_comments_meta_box', Kanban::get_instance()->settings->basename, self::$slug), $sql);
$comments = $wpdb->get_results($sql);
?>
<style>
#kanban_task_comments .inside {
margin: 0;
padding: 0;
}
#kanban_task_comments li {
padding: 10px;
}
#kanban_task_comments small {
color: #CCC;
display: block;
}
</style>
<ul class="striped">
<?php
foreach ($comments as $comment) {
$comment_date_dt = new DateTime($comment->comment_date);
?>
<li>
<small>
<?php
echo $comment_date_dt->format('D, j M, Y');
?>
at
<?php
echo $comment_date_dt->format('g:ia');
?>
</small>
<?php
echo $comment->comment_content;
?>
</li>
<?php
}
?>
</ul>
<?php
}
static function ajax_save()
{
if (!isset($_POST[Kanban_Utils::get_nonce()]) || !wp_verify_nonce($_POST[Kanban_Utils::get_nonce()], sprintf('%s-save', Kanban::get_instance()->settings->basename)) || !is_user_logged_in()) {
wp_send_json_error();
}
do_action(sprintf('%s_before_%s_ajax_save', Kanban::get_instance()->settings->basename, self::$slug));
$status_id_old = Kanban_Utils::format_key(self::$slug, 'status_id_old');
$status_id_new = Kanban_Utils::format_key(self::$slug, 'status_id_new');
// build post data
$post_data = array('post_type' => Kanban_Post_Types::format_post_type(self::$slug), 'post_title' => sprintf('changed task ID %s from %s to %s', $_POST['task_id'], $_POST['status_id_old'], $_POST['status_id_new']), 'post_parent' => $_POST['task_id'], 'postmeta' => array($status_id_old => $_POST['status_id_old'], $status_id_new => $_POST['status_id_new']), 'terms' => array());
// save our work_hour
$post_data = Kanban_Post::save($post_data);
if (!$post_data) {
wp_send_json_error();
}
do_action(sprintf('%s_after_%s_ajax_save', Kanban::get_instance()->settings->basename, self::$slug));
wp_send_json_success(array('message' => sprintf('%s saved', self::$slug), self::$slug => $post_data));
}
/**
* load data needed for board's javascript
* @param string $template the passed in template path
* @return string the same template path
*/
static function send_page_data_to_template($template)
{
if (!isset(Kanban_Template::get_instance()->slug) || Kanban_Template::get_instance()->slug != self::$slug) {
return $template;
}
global $wp_query;
$wp_query->query_vars['kanban'] = (object) array();
$wp_query->query_vars['kanban']->board = (object) array();
// // get all data for the javascript
$wp_query->query_vars['kanban']->board->allowed_users = Kanban_User::get_allowed_users();
$wp_query->query_vars['kanban']->board->estimates = Kanban_Terms::terms_in_order('task', 'estimate');
$wp_query->query_vars['kanban']->board->status_tax_key = Kanban_Utils::format_key('task', 'status');
$wp_query->query_vars['kanban']->board->status_color_field_name = sprintf('%s_colors', $wp_query->query_vars['kanban']->board->status_tax_key);
$wp_query->query_vars['kanban']->board->status_colors = Kanban_Settings::get_option($wp_query->query_vars['kanban']->board->status_color_field_name, null, array());
$wp_query->query_vars['kanban']->board->statuses = Kanban_Terms::terms_in_order('task', 'status');
foreach ($wp_query->query_vars['kanban']->board->statuses as $status) {
if (!isset($wp_query->query_vars['kanban']->board->status_colors[$status->term_id])) {
continue;
}
$status->color = $wp_query->query_vars['kanban']->board->status_colors[$status->term_id];
}
$wp_query->query_vars['kanban']->board->projects = Kanban_Project::get_all();
$wp_query->query_vars['kanban']->board->tasks = Kanban_Task::get_all();
$current_user_id = get_current_user_id();
$wp_query->query_vars['kanban']->board->current_user = get_user_by('id', $current_user_id);
unset($wp_query->query_vars['kanban']->board->current_user->data->user_pass);
$wp_query->query_vars['kanban']->board->current_user->data->long_name_email = Kanban_User::format_user_name($wp_query->query_vars['kanban']->board->current_user);
$wp_query->query_vars['kanban']->board->current_user->data->short_name = Kanban_User::format_user_name($wp_query->query_vars['kanban']->board->current_user, TRUE);
$wp_query->query_vars['kanban']->board->current_user->data->initials = Kanban_User::get_initials($wp_query->query_vars['kanban']->board->current_user);
$wp_query->query_vars['kanban']->board->col_percent_w = count($wp_query->query_vars['kanban']->board->statuses) > 0 ? 100 / count($wp_query->query_vars['kanban']->board->statuses) : 100;
$wp_query->query_vars['kanban']->board->sidebar_w = count($wp_query->query_vars['kanban']->board->statuses) > 0 ? 100 / (count($wp_query->query_vars['kanban']->board->statuses) - 2) : 0;
return $template;
}
static function ajax_save()
{
if (!isset($_POST[Kanban_Utils::get_nonce()]) || !wp_verify_nonce($_POST[Kanban_Utils::get_nonce()], sprintf('%s-save', Kanban::get_instance()->settings->basename)) || !is_user_logged_in()) {
wp_send_json_error();
}
do_action(sprintf('%s_before_%s_ajax_save', Kanban::get_instance()->settings->basename, self::$slug));
$user_id_author = isset($_POST['user_id_author']) ? $_POST['user_id_author'] : get_current_user_id();
if (empty($_POST['user_id_worked'])) {
$_POST['user_id_worked'] = $user_id_author;
}
try {
$operator = substr($_POST['operator'], 0, 1) == '-' ? '-' : '+';
$val = sprintf('%s%s', $operator, abs(floatval($_POST['operator'])));
} catch (Exception $e) {
wp_send_json_error(array('message' => sprintf('Error saving %s', str_replace('_', ' ', self::$slug))));
}
eval(sprintf('$hours = 0%s;', $val));
$data = array('task_id' => $_POST['task']['id'], 'worked_dt_gmt' => Kanban_Utils::mysql_now_gmt(), 'hours' => $hours, 'status_is' => $_POST['task']['status_id'], 'user_id_author' => $user_id_author, 'user_id_worked' => $_POST['user_id_worked']);
$is_successful = self::_insert($data);
do_action(sprintf('%s_after_%s_ajax_save', Kanban::get_instance()->settings->basename, self::$slug));
if (!empty($_POST['comment'])) {
do_action(sprintf('%s_before_%s_ajax_comment_save', Kanban::get_instance()->settings->basename, self::$slug));
Kanban_Comment::add($_POST['comment'], 'system', $_POST['task']['id']);
do_action(sprintf('%s_after_%s_ajax_comment_save', Kanban::get_instance()->settings->basename, self::$slug));
}
if ($is_successful) {
wp_send_json_success(array('message' => sprintf('%s saved', str_replace('_', ' ', self::$slug))));
} else {
wp_send_json_error(array('message' => sprintf('Error saving %s', str_replace('_', ' ', self::$slug))));
}
}
static function get_all($sql = NULL)
{
$table_name = self::table_name();
$sql = "SELECT *\n\t\t\t\tFROM `{$table_name}`\n\t\t\t\tORDER BY `position` ASC\n\t\t;";
$sql = apply_filters('kanban_estimate_get_all_sql', $sql);
$records = parent::get_all($sql);
return apply_filters('kanban_estimate_get_all_return', Kanban_Utils::build_array_with_id_keys($records, 'id'));
}
static function wpse56652_filt_comm($param)
{
if (isset($param->query_vars)) {
$comment_types = array(Kanban_Utils::format_key('task', 'comment'));
$param->query_vars['type__not_in'] = $comment_types;
}
return $param;
}
static function add($task_id, $status_id_new, $status_id_old = 0, $user_id_author = NULL)
{
if (!$user_id_author) {
$user_id_author = get_current_user_id();
}
$data = array('task_id' => $task_id, 'created_dt_gmt' => Kanban_Utils::mysql_now_gmt(), 'status_id_old' => $status_id_old, 'status_id_new' => $status_id_new, 'user_id_author' => $user_id_author);
$id = self::_insert($data);
}
static function get_all($sql = NULL)
{
$table_name = self::table_name();
$sql = "SELECT *\n\t\t\t\tFROM `{$table_name}`\n\t\t\t\tORDER BY `position` ASC\n\t\t;";
$sql = apply_filters(sprintf('%s_sql_%s_get_all', Kanban::get_instance()->settings->basename, self::$table_name), $sql);
$records = parent::get_all($sql);
return Kanban_Utils::build_array_with_id_keys($records, 'id');
}
static function get_all($sql = NULL)
{
$table_name = self::table_name();
$sql = "SELECT *\n\t\t\t\tFROM `{$table_name}`\n\t\t\t\tORDER BY `position` ASC\n\t\t;";
$sql = apply_filters('kanban_status_get_all_sql', $sql);
$records = parent::get_all($sql);
foreach ($records as $key => $record) {
$records[$key]->title = Kanban_Utils::str_for_frontend($records[$key]->title);
}
return apply_filters('kanban_status_get_all_return', Kanban_Utils::build_array_with_id_keys($records, 'id'));
}
static function get_all($sql = NULL)
{
$table_name = self::table_name();
$tasks_table_name = Kanban_Task::table_name();
$sql = "SELECT `projects`.*,\n\t\t\t\t(\n\t\t\t\t\tSELECT COUNT(`id`)\n\t\t\t\t\tFROM `{$tasks_table_name}` tasks\n\t\t\t\t\tWHERE `tasks`.`project_id` = `projects`.`id`\n\t\t\t\t\tAND `tasks`.`is_active` = 1\n\t\t\t\t)\n\t\t\t\tAS 'task_count'\n\t\t\t\tFROM `{$table_name}` projects\n\t\t\t\tWHERE `projects`.`is_active` = 1\n\t\t;";
$sql = apply_filters(sprintf('%s_sql_%s_get_all', Kanban::get_instance()->settings->basename, self::$slug), $sql);
$records = parent::get_all($sql);
foreach ($records as $key => $record) {
$records[$key]->title = Kanban_Utils::str_for_frontend($records[$key]->title);
}
return Kanban_Utils::build_array_with_id_keys($records, 'id');
}
static function ajax_delete()
{
if (!isset($_POST[Kanban_Utils::get_nonce()]) || !wp_verify_nonce($_POST[Kanban_Utils::get_nonce()], sprintf('%s-save', Kanban::$instance->settings->basename)) || !isset($_POST[self::$slug]) || !is_user_logged_in()) {
wp_send_json_error();
}
do_action(sprintf('%s_before_%s_ajax_delete', Kanban::$instance->settings->basename, self::$slug));
$is_successful = Kanban_Post::delete($_POST[self::$slug]);
do_action(sprintf('%s_after_%s_ajax_delete', Kanban::$instance->settings->basename, self::$slug));
if ($is_successful) {
wp_send_json_success(array('message' => sprintf('%s deleted', self::$slug)));
} else {
wp_send_json_error(array('message' => sprintf('Error deleting %s', self::$slug)));
}
}
static function terms_in_order($post_type, $key)
{
$tax_key = Kanban_Utils::format_key($post_type, $key);
$field_name = sprintf('%s_order', $tax_key);
$order = Kanban_Settings::get_option($field_name, $field_name, array());
asort($order);
// get all terms for displaying
$args = array('hide_empty' => 0);
$terms = get_terms($tax_key, $args);
$terms = Kanban_Utils::build_array_with_id_keys($terms, 'term_id');
$terms_in_order = array();
if (!empty($order)) {
foreach ($order as $status_id => $order) {
$terms_in_order[] = $terms[$status_id];
unset($terms[$status_id]);
}
}
return array_filter(array_merge($terms_in_order, $terms));
}
static function get_allowed_users()
{
if (!isset(Kanban_User::$instance->allowed_users)) {
$users_field_name = sprintf('%s_user', Kanban::$instance->settings->basename);
$allowed_user_ids = Kanban_Settings::get_option($users_field_name, 'allowed_users', array());
if (empty($allowed_user_ids)) {
$allowed_user_ids = array(0);
}
$pm_users = get_users(array('include' => $allowed_user_ids));
Kanban_User::$instance->allowed_users = Kanban_Utils::build_array_with_id_keys($pm_users);
foreach (Kanban_User::$instance->allowed_users as $user_id => $user) {
if (self::validate_gravatar($user->data->user_email)) {
Kanban_User::$instance->allowed_users[$user_id]->data->avatar = get_avatar($user->data->user_email);
}
Kanban_User::$instance->allowed_users[$user_id]->data->long_name_email = Kanban_User::format_user_name($user);
Kanban_User::$instance->allowed_users[$user_id]->data->short_name = Kanban_User::format_user_name($user, TRUE);
Kanban_User::$instance->allowed_users[$user_id]->data->initials = Kanban_User::get_initials($user);
}
}
return apply_filters(sprintf('%s_after_get_allowed_users', Kanban::$instance->settings->basename), Kanban_User::$instance->allowed_users);
}
static function custom_post_types()
{
foreach (Kanban_Post_Types::$post_types as $post_type_slug => $post_type_data) {
$post_type_label = ucfirst($post_type_slug);
$labels = array('name' => str_replace('_', ' ', sprintf('%ss', $post_type_label)), 'singular_name' => str_replace('_', ' ', $post_type_label), 'menu_name' => str_replace('_', ' ', sprintf('%ss', $post_type_label)), 'name_admin_bar' => str_replace('_', ' ', $post_type_label), 'parent_item_colon' => str_replace('_', ' ', sprintf('Parent %s:', $post_type_label)), 'all_items' => str_replace('_', ' ', sprintf('All %ss', $post_type_label)), 'add_new_item' => str_replace('_', ' ', sprintf('Add New %s', $post_type_label)), 'add_new' => 'Add New', 'new_item' => str_replace('_', ' ', sprintf('New %s', $post_type_label)), 'edit_item' => str_replace('_', ' ', sprintf('Edit %s', $post_type_label)), 'update_item' => str_replace('_', ' ', sprintf('Update %s', $post_type_label)), 'view_item' => str_replace('_', ' ', sprintf('View %s', $post_type_label)), 'search_items' => str_replace('_', ' ', sprintf('Search %s', $post_type_label)), 'not_found' => 'Not found', 'not_found_in_trash' => 'Not found in Trash');
$rewrite = array('slug' => NULL, 'with_front' => true, 'pages' => true, 'feeds' => true);
$args = array('label' => $post_type_label, 'labels' => $labels, 'supports' => array('title', 'editor', 'custom-fields'), 'hierarchical' => true, 'public' => false, 'show_ui' => false, 'show_in_menu' => false, 'menu_position' => 5, 'show_in_admin_bar' => false, 'show_in_nav_menus' => false, 'can_export' => true, 'has_archive' => false, 'exclude_from_search' => true, 'publicly_queryable' => false, 'rewrite' => false, 'capability_type' => 'page');
register_post_type(Kanban_Post_Types::format_post_type($post_type_slug), $args);
// register taxonomies associated with each post type
foreach ($post_type_data['taxonomies'] as $taxonomy_slug => $values) {
$taxonomy_key = Kanban_Utils::format_key($post_type_slug, $taxonomy_slug);
$taxonomy_label = ucwords(sprintf('%s %s', $post_type_slug, $taxonomy_slug));
$labels = array('name' => $taxonomy_label, 'singular_name' => $taxonomy_label, 'menu_name' => $taxonomy_label, 'all_items' => sprintf('All %ss', $taxonomy_label), 'parent_item' => sprintf('Parent %s', $taxonomy_label), 'parent_item_colon' => sprintf('Parent %s:', $taxonomy_label), 'new_item_name' => sprintf('New %s Name', $taxonomy_label), 'add_new_item' => sprintf('Add New %s', $taxonomy_label), 'edit_item' => sprintf('Edit %s', $taxonomy_label), 'update_item' => sprintf('Update %s', $taxonomy_label), 'view_item' => sprintf('View %s', $taxonomy_label), 'separate_items_with_commas' => sprintf('Separate %ss with commas', $taxonomy_label), 'add_or_remove_items' => sprintf('Add or remove %ss', $taxonomy_label), 'choose_from_most_used' => 'Choose from the most used', 'popular_items' => sprintf('Popular %ss', $taxonomy_label), 'search_items' => sprintf('Search %ss', $taxonomy_label), 'not_found' => 'Not Found');
$rewrite = array('slug' => sprintf('%s/%s/%s', Kanban::$slug, Kanban_Utils::make_word_plural($post_type_slug), Kanban_Utils::make_word_plural($taxonomy_slug)), 'with_front' => true, 'hierarchical' => false);
$args = array('labels' => $labels, 'hierarchical' => false, 'public' => true, 'show_ui' => true, 'show_admin_column' => true, 'show_in_nav_menus' => false, 'show_tagcloud' => false, 'rewrite' => false);
register_taxonomy($taxonomy_key, Kanban_Post_Types::format_post_type($post_type_slug), $args);
}
// taxonomies
}
// post_types
}
static function ajax_save()
{
if (!isset($_POST[Kanban_Utils::get_nonce()]) || !wp_verify_nonce($_POST[Kanban_Utils::get_nonce()], sprintf('%s-save', Kanban::$instance->settings->basename)) || !isset($_POST[Kanban_Task::$slug]) || !is_user_logged_in()) {
wp_send_json_error();
}
do_action(sprintf('%s_before_%s_ajax_save', Kanban::$instance->settings->basename, self::$slug));
// build post data
$post_data = array('post_type' => Kanban_Post_Types::format_post_type('work_hour'), 'post_title' => sanitize_text_field($_POST[Kanban_Task::$slug]['post_title']), 'postmeta' => array(), 'terms' => array());
$hour_operator = Kanban_Utils::format_key('work_hour', 'operator');
$post_data['postmeta'][$hour_operator] = $_POST['operator'];
// set assignee as author of work hour
$task_user_id_assigned_to = Kanban_Utils::format_key('task', 'user_id_assigned');
if ($_POST[Kanban_Task::$slug]['postmeta'][$task_user_id_assigned_to] > 0) {
$post_data['post_author'] = $_POST[Kanban_Task::$slug]['postmeta'][$task_user_id_assigned_to];
}
// link task to hour
$hour_task_id = Kanban_Utils::format_key('work_hour', 'project_id');
$post_data['postmeta'][$hour_task_id] = $_POST[Kanban_Task::$slug]['ID'];
// link current user to hour
$hour_user_id_logged = Kanban_Utils::format_key('work_hour', 'user_id_logged');
$post_data['postmeta'][$hour_user_id_logged] = get_current_user_id();
// set task project as work project
$task_project_id = Kanban_Utils::format_key('task', 'project_id');
$hour_project_id = Kanban_Utils::format_key('work_hour', 'project_id');
$post_data['postmeta'][$hour_project_id] = $_POST[Kanban_Task::$slug]['postmeta'][$task_project_id];
// set current task status for work hour
$task_status = Kanban_Utils::format_key('task', 'status');
$hour_status_id = Kanban_Utils::format_key('work_hour', 'task_status_id');
$post_data['postmeta'][$hour_status_id] = $_POST[Kanban_Task::$slug]['terms'][$task_status][0];
// save our work_hour
$post_data = Kanban_Post::save($post_data);
if (!$post_data) {
wp_send_json_error();
}
do_action(sprintf('%s_after_%s_ajax_save', Kanban::$instance->settings->basename, self::$slug));
wp_send_json_success(array('message' => sprintf('%s saved', self::$slug), self::$slug => $post_data));
}
} else {
// is_user_logged_in
?>
<p>
<?php
echo __('Whoops, looks like you haven\'t been granted access yet. Click below to request access.', Kanban::$instance->settings->file);
?>
</p>
<p class="text-center">
<button type="submit" class="btn btn-primary btn-lg">
<?php
echo __('Request access', Kanban::$instance->settings->file);
?>
</button>
<?php
wp_nonce_field('request_access', Kanban_Utils::get_nonce());
?>
</p>
<?php
}
?>
</form>
</div><!-- jumbotron -->
<?php
include Kanban_Template::find_template('inc/footer');
?>
static function save_settings()
{
if (!isset($_POST[Kanban_Utils::get_nonce()]) || !wp_verify_nonce($_POST[Kanban_Utils::get_nonce()], 'kanban-options') || !is_user_logged_in()) {
return;
}
$statuses = Kanban_Status::get_all();
$status_ids = array_keys($statuses);
// any statuses to delete?
if (isset($_POST['statuses']['saved'])) {
$deleted_statuses = array_diff($status_ids, array_keys($_POST['statuses']['saved']));
if (!empty($deleted_statuses)) {
foreach ($deleted_statuses as $key => $id) {
Kanban_Status::delete(array('id' => $id));
}
}
}
// add new statuses first
if (isset($_POST['statuses']['new'])) {
foreach ($_POST['statuses']['new'] as $status) {
// save it
$success = Kanban_Status::replace($status);
if ($success) {
$status_id = Kanban_Status::insert_id();
// add it to all the statuses to save
$_POST['statuses']['saved'][$status_id] = $status;
}
}
}
// now save all statuses with positions
if (isset($_POST['statuses']['saved'])) {
foreach ($_POST['statuses']['saved'] as $status_id => $status) {
$status['id'] = $status_id;
Kanban_Status::replace($status);
}
}
$estimates = Kanban_Estimate::get_all();
$estimate_ids = array_keys($estimates);
// any estimates to delete?
if (isset($_POST['estimates']['saved'])) {
$deleted_estimates = array_diff($estimate_ids, array_keys($_POST['estimates']['saved']));
if (!empty($deleted_estimates)) {
foreach ($deleted_estimates as $key => $id) {
Kanban_Estimate::delete(array('id' => $id));
}
}
}
// add new estimates first
if (isset($_POST['estimates']['new'])) {
foreach ($_POST['estimates']['new'] as $estimate) {
// save it
$success = Kanban_Estimate::replace($estimate);
if ($success) {
$estimate_id = Kanban_Estimate::insert_id();
// add it to all the estimates to save
$_POST['estimates']['saved'][$estimate_id] = $estimate;
}
}
}
// now save all estimates with positions
if (isset($_POST['estimates']['saved'])) {
foreach ($_POST['estimates']['saved'] as $estimate_id => $estimate) {
$estimate['id'] = $estimate_id;
Kanban_Estimate::replace($estimate);
}
}
// get current settings
$settings = Kanban_Option::get_all_raw();
$settings = Kanban_Utils::build_array_with_id_keys($settings);
// save all single settings
foreach ($_POST['settings'] as $key => $value) {
if (is_array($value)) {
$value = serialize($value);
}
$data = array('name' => $key, 'value' => $value);
// see if it's already set
$id = Kanban_Utils::find_key_of_object_by_property('name', $key, $settings);
if ($id) {
$data['id'] = $id;
}
Kanban_Option::_replace($data);
}
$url = add_query_arg(array('message' => urlencode(__('Settings saved', 'kanban'))), $_POST['_wp_http_referer']);
wp_redirect($url);
exit;
}
static function get_all($sql = NULL)
{
$table_name = self::table_name();
$worked_table_name = Kanban_Task_Hour::table_name();
$sql = "SELECT tasks.*,\n\t\t\t\tCOALESCE(SUM(worked.hours), 0) 'hour_count'\n\t\t\t\tFROM {$table_name} tasks\n\t\t\t\tLEFT JOIN {$worked_table_name} worked\n\t\t\t\tON tasks.id = worked.task_id\n\t\t\t\tWHERE tasks.is_active = 1\n\t\t\t\tGROUP BY tasks.id\n\t\t;";
$sql = apply_filters('kanban_task_get_all_sql', $sql);
$records = parent::get_all($sql);
foreach ($records as $key => $record) {
$records[$key]->title = Kanban_Utils::str_for_frontend($records[$key]->title);
$records[$key]->description = Kanban_Utils::str_for_frontend($records[$key]->description);
}
return apply_filters('kanban_task_get_all_return', Kanban_Utils::build_array_with_id_keys($records, 'id'));
}
static function on_activation()
{
// http://wordpress.stackexchange.com/questions/20043/inserting-taxonomy-terms-during-a-plugin-activation
Kanban_Post_Types::custom_post_types();
foreach (Kanban_Post_Types::$post_types as $post_type_slug => $post_type_data) {
foreach ($post_type_data['taxonomies'] as $taxonomy_slug => $values) {
$taxonomy_key = Kanban_Utils::format_key($post_type_slug, $taxonomy_slug);
foreach ($values as $slug => $value) {
$term_id_arr = wp_insert_term($value, $taxonomy_key, array('slug' => $slug));
}
}
}
// add current user to board
$current_user_id = get_current_user_id();
$users_field_name = sprintf('%s_user', Kanban::$instance->settings->basename);
$user_settings = Kanban_Settings::get_option($users_field_name, null, array());
if (!isset($user_settings['allowed_users'])) {
$user_settings['allowed_users'] = array();
}
if (!in_array($current_user_id, $user_settings['allowed_users'])) {
$user_settings['allowed_users'][$current_user_id] = $current_user_id;
}
update_option($users_field_name, $user_settings);
// add status order
$tax_key = Kanban_Utils::format_key('task', 'status');
$field_name = sprintf('%s_order', $tax_key);
$settings = Kanban_Settings::get_option($field_name, null, array());
$slugs_in_order = array_keys(Kanban_Post_Types::$post_types['task']['taxonomies']['status']);
$term_ids_in_order = array();
foreach ($slugs_in_order as $order => $slug) {
$term = get_term_by('slug', $slug, $tax_key);
$term_ids_in_order[$term->term_id] = $order;
}
update_option($field_name, $term_ids_in_order);
// add estimate order
$tax_key = Kanban_Utils::format_key('task', 'estimate');
$field_name = sprintf('%s_order', $tax_key);
$settings = Kanban_Settings::get_option($field_name, null, array());
$slugs_in_order = array_keys(Kanban_Post_Types::$post_types['task']['taxonomies']['estimate']);
$term_ids_in_order = array();
foreach ($slugs_in_order as $order => $slug) {
$term = get_term_by('slug', $slug, $tax_key);
$term_ids_in_order[$term->term_id] = $order;
}
update_option($field_name, $term_ids_in_order);
// add an example task
$post = array('post_status' => 'publish', 'post_type' => Kanban_Post_Types::format_post_type('task'), 'post_author' => $current_user_id);
$post_id = wp_insert_post($post);
flush_rewrite_rules();
// redirect to welcome page
// @link http://premium.wpmudev.org/blog/tabbed-interface/
set_transient(sprintf('_%s_welcome_screen_activation_redirect', Kanban::$instance->settings->basename), true, 30);
}
static function admin_init()
{
$users_field_name = sprintf('%s_user', Kanban::get_instance()->settings->basename);
$status_tax_key = Kanban_Utils::format_key('task', 'status');
$status_color_field_name = sprintf('%s_colors', $status_tax_key);
$status_order_field_name = sprintf('%s_order', $status_tax_key);
$estimate_tax_key = Kanban_Utils::format_key('task', 'estimate');
$estimate_order_field_name = sprintf('%s_order', $estimate_tax_key);
$sections = array(array('id' => $users_field_name, 'title' => 'Users'), array('id' => $status_order_field_name, 'title' => 'Status Order'), array('id' => $status_color_field_name, 'title' => 'Status Colors'), array('id' => $estimate_order_field_name, 'title' => 'Estimate Order'));
$fields = array();
$fields[$users_field_name] = array();
$all_users = get_users();
$all_users_arr = array();
foreach ($all_users as $user) {
$all_users_arr[$user->ID] = Kanban_User::format_user_name($user);
}
$fields[$users_field_name][] = array('name' => 'allowed_users', 'label' => 'Allowed Users', 'desc' => 'Users who have access to the board', 'type' => 'multicheck', 'options' => $all_users_arr);
$statuses_in_order = Kanban_Terms::terms_in_order('task', 'status');
$fields[$status_color_field_name] = array();
foreach ($statuses_in_order as $status) {
$fields[$status_color_field_name][] = array('name' => $status->term_id, 'label' => $status->name, 'type' => 'color');
}
$fields[$status_order_field_name] = array();
foreach ($statuses_in_order as $status) {
$fields[$status_order_field_name][$status->term_id] = array('name' => $status->term_id, 'label' => $status->name, 'type' => 'number');
}
$estimates_in_order = Kanban_Terms::terms_in_order('task', 'estimate');
$fields[$estimate_order_field_name] = array();
foreach ($estimates_in_order as $status) {
$fields[$estimate_order_field_name][$status->term_id] = array('name' => $status->term_id, 'label' => $status->name, 'type' => 'number');
}
self::get_instance()->settings_api = new WeDevs_Settings_API();
//set sections and fields
self::get_instance()->settings_api->set_sections($sections);
self::get_instance()->settings_api->set_fields($fields);
//initialize them
self::get_instance()->settings_api->admin_init();
}
/**
* get the users that are allowed to access the board
* @return array allowed user objects
*/
static function get_allowed_users()
{
if (!isset(Kanban_User::get_instance()->allowed_users)) {
// get all settings
$allowed_users = Kanban_Option::get_option('allowed_users');
// pull out allowed user id's
$allowed_user_ids = array();
if (is_array($allowed_users)) {
$allowed_user_ids = $allowed_users;
}
if (empty($allowed_user_ids)) {
$allowed_user_ids = array(0);
}
// load actual users
$users = get_users(array('include' => $allowed_user_ids, 'fields' => array('ID', 'user_email')));
// add users to object
Kanban_User::get_instance()->allowed_users = Kanban_Utils::build_array_with_id_keys($users, 'ID');
// load extra data
foreach (Kanban_User::get_instance()->allowed_users as $user_id => $user) {
Kanban_User::get_instance()->allowed_users[$user_id]->caps = array('write');
// get gravatar
if (self::validate_gravatar($user->user_email)) {
Kanban_User::get_instance()->allowed_users[$user_id]->avatar = get_avatar($user->user_email);
}
// fancy name formating
Kanban_User::get_instance()->allowed_users[$user_id]->long_name_email = Kanban_User::get_username_long($user);
Kanban_User::get_instance()->allowed_users[$user_id]->short_name = Kanban_User::get_username_short($user, TRUE);
Kanban_User::get_instance()->allowed_users[$user_id]->initials = Kanban_User::get_initials($user);
}
}
return apply_filters(sprintf('%s_after_get_allowed_users', Kanban::get_instance()->settings->basename), Kanban_User::get_instance()->allowed_users);
}
</div><!-- modal -->
<div id="screen-size">
<div class="visible-xs" data-size="xs"></div>
<div class="visible-sm" data-size="sm"></div>
<div class="visible-md" data-size="md"></div>
<div class="visible-lg" data-size="lg"></div>
</div>
<?php
wp_nonce_field(sprintf('%s-save', Kanban::$instance->settings->basename), Kanban_Utils::get_nonce());
?>
<script type="text/javascript">
var ajaxurl = '<?php
echo admin_url('admin-ajax.php');
?>
';
var status_records = <?php
echo json_encode($wp_query->query_vars['kanban']->board->statuses);
?>
;
var status_colors = <?php
/**
* get the users that are allowed to access the board
* @return array allowed user objects
*/
static function get_allowed_users()
{
if (!isset(Kanban_User::get_instance()->allowed_users)) {
global $wpdb;
// get all settings
$allowed_users = Kanban_Option::get_option('allowed_users');
// pull out allowed user id's
$allowed_user_ids = array();
if (is_array($allowed_users)) {
$allowed_user_ids = $allowed_users;
}
if (empty($allowed_user_ids)) {
$allowed_user_ids = array(0);
}
// load actual users
// $users = get_users(array(
// 'include' => $allowed_user_ids,
// 'fields' => array(
// 'ID',
// 'user_email',
// )
// ));
$allowed_user_ids_str = implode(',', $allowed_user_ids);
$users = $wpdb->get_results("SELECT {$wpdb->users}.ID,\n\t\t\t{$wpdb->users}.user_email,\n\t\t\tfirst_name.meta_value AS 'first_name',\n\t\t\tlast_name.meta_value AS 'last_name'\n\t\t\tFROM {$wpdb->users}\n\t\t\tLEFT JOIN {$wpdb->usermeta} first_name\n\t\t\tON {$wpdb->users}.ID = first_name.user_id\n\t\t\tAND first_name.meta_key = 'first_name'\n\t\t\tLEFT JOIN {$wpdb->usermeta} last_name\n\t\t\tON {$wpdb->users}.ID = last_name.user_id\n\t\t\tAND last_name.meta_key = 'last_name'\n\t\t\tWHERE {$wpdb->users}.ID IN ({$allowed_user_ids_str});");
// add users to object
Kanban_User::get_instance()->allowed_users = Kanban_Utils::build_array_with_id_keys($users, 'ID');
// load extra data
foreach (Kanban_User::get_instance()->allowed_users as $user_id => $user) {
Kanban_User::get_instance()->allowed_users[$user_id]->caps = array('write');
// get gravatar
if (self::validate_gravatar($user->user_email)) {
Kanban_User::get_instance()->allowed_users[$user_id]->avatar = get_avatar($user->user_email);
}
// fancy name formating
Kanban_User::get_instance()->allowed_users[$user_id]->long_name_email = Kanban_User::get_username_long($user);
Kanban_User::get_instance()->allowed_users[$user_id]->short_name = Kanban_User::get_username_short($user, TRUE);
Kanban_User::get_instance()->allowed_users[$user_id]->initials = Kanban_User::get_initials($user);
}
}
return apply_filters('kanban_user_get_allowed_users_return', Kanban_User::get_instance()->allowed_users);
}
static function post_save_estimate_order()
{
if (!isset($_POST[Kanban_Utils::get_nonce()]) || !wp_verify_nonce($_POST[Kanban_Utils::get_nonce()], 'save_estimate_order') || !is_user_logged_in()) {
return;
}
$tax_key = Kanban_Utils::format_key('task', 'estimate');
$field_name = sprintf('%s_order', $tax_key);
self::update_option($field_name, $_POST[$field_name]);
Kanban::$instance->flash->add('success', 'Estimates order has been saved');
wp_redirect($_POST['_wp_http_referer']);
exit;
}
<?php
submit_button(__('Save your Settings', Kanban::get_text_domain()), 'primary', 'submit');
?>
</div><!-- tab-estimates -->
<?php
echo apply_filters(sprintf('%s_settings_tabs_content', Kanban::get_instance()->settings->basename), '');
?>
<?php
wp_nonce_field(sprintf('%s-%s', Kanban::$instance->settings->basename, Kanban_Option::table_name()), Kanban_Utils::get_nonce());
?>
</form>
</div><!-- wrap -->
<script type="text/html" id="t-status">
<?php
include sprintf('%s/t-status.php', __DIR__);
?>
static function on_activation()
{
// http://wordpress.stackexchange.com/questions/20043/inserting-taxonomy-terms-during-a-plugin-activation
Kanban_Post_Types::custom_post_types();
$is_installed_before = get_option(sprintf('_%s_is_installed_before', Kanban::$instance->settings->basename));
if (!$is_installed_before) {
foreach (Kanban_Post_Types::$post_types as $post_type_slug => $post_type_data) {
foreach ($post_type_data['taxonomies'] as $taxonomy_slug => $values) {
$taxonomy_key = Kanban_Utils::format_key($post_type_slug, $taxonomy_slug);
foreach ($values as $slug => $value) {
$term_id_arr = wp_insert_term($value, $taxonomy_key, array('slug' => $slug));
}
}
}
// add current user to board
$users_field_name = sprintf('%s_user', Kanban::$instance->settings->basename);
$user_settings = Kanban_Settings::get_option($users_field_name, null, array());
if (empty($user_settings)) {
$current_user_id = get_current_user_id();
if (!isset($user_settings['allowed_users'])) {
$user_settings['allowed_users'] = array();
}
if (!in_array($current_user_id, $user_settings['allowed_users'])) {
$user_settings['allowed_users'][$current_user_id] = $current_user_id;
}
update_option($users_field_name, $user_settings);
}
// add status order
$tax_key = Kanban_Utils::format_key('task', 'status');
$field_name = sprintf('%s_order', $tax_key);
$settings = Kanban_Settings::get_option($field_name, null, array());
if (empty($settings)) {
$slugs_in_order = array_keys(Kanban_Post_Types::$post_types['task']['taxonomies']['status']);
$term_ids_in_order = array();
foreach ($slugs_in_order as $order => $slug) {
$term = get_term_by('slug', $slug, $tax_key);
$term_ids_in_order[$term->term_id] = $order;
}
update_option($field_name, $term_ids_in_order);
}
// add estimate order
$tax_key = Kanban_Utils::format_key('task', 'estimate');
$field_name = sprintf('%s_order', $tax_key);
$settings = Kanban_Settings::get_option($field_name, null, array());
if (empty($settings)) {
$slugs_in_order = array_keys(Kanban_Post_Types::$post_types['task']['taxonomies']['estimate']);
$term_ids_in_order = array();
foreach ($slugs_in_order as $order => $slug) {
$term = get_term_by('slug', $slug, $tax_key);
$term_ids_in_order[$term->term_id] = $order;
}
update_option($field_name, $term_ids_in_order);
}
$field_name = sprintf('%s_colors', Kanban_Utils::format_key('task', 'status'));
$settings = get_option('kanban_task_status_colors');
if (empty($settings)) {
// add status colors
$colors = array('backlog' => '#8224e3', 'ready' => '#eeee22', 'in-progress' => '#81d742', 'qa' => '#dd9933', 'done' => '#1e73be', 'archive' => '#545454');
// get status tax
$taxonomies = array(Kanban_Utils::format_key('task', 'status'));
$args = array('orderby' => 'term_id', 'order' => 'ASC', 'hide_empty' => false, 'childless' => false);
$terms = get_terms($taxonomies, $args);
// build array of status id => color
$option = array();
foreach ($terms as $term) {
if (!isset($colors[$term->slug])) {
continue;
}
$option[$term->term_id] = $colors[$term->slug];
}
// save it
update_option($field_name, $option);
}
// save colors
// check for existing tasks
$args = array('post_type' => Kanban_Post_Types::format_post_type('task'));
$posts_array = get_posts($args);
// if no tasks, add a sample
if (empty($posts_array)) {
// add an example task
$post = array('post_status' => 'publish', 'post_type' => Kanban_Post_Types::format_post_type('task'), 'post_author' => $current_user_id);
$post_id = wp_insert_post($post);
}
// save that the plugin has been installed
update_option(sprintf('_%s_is_installed_before', Kanban::$instance->settings->basename), TRUE);
}
// $is_installed_before
flush_rewrite_rules();
// redirect to welcome page
// @link http://premium.wpmudev.org/blog/tabbed-interface/
set_transient(sprintf('_%s_welcome_screen_activation_redirect', Kanban::$instance->settings->basename), true, 30);
}
static function add_defaults()
{
global $wpdb;
$status_table = Kanban_Status::table_name();
$sql = "SELECT count(`id`)\n\t\t\t\tFROM `{$status_table}`\n\t\t;";
$status_count = $wpdb->get_var($sql);
if ($status_count == 0) {
$statuses = array('Backlog' => '#8224e3', 'Ready' => '#eeee22', 'In progress' => '#81d742', 'QA' => '#f7a738', 'Done' => '#1e73be', 'Archive' => '#333333');
$i = 0;
foreach ($statuses as $status => $color) {
$data = array('title' => $status, 'color_hex' => $color, 'position' => $i);
Kanban_Status::replace($data);
$i++;
}
}
$estimate_table = Kanban_Estimate::table_name();
$sql = "SELECT count(`id`)\n\t\t\t\tFROM `{$estimate_table}`\n\t\t;";
$estimate_count = $wpdb->get_var($sql);
if ($estimate_count == 0) {
$estimates = array('2' => '2h', '4' => '4h', '8' => '1d', '16' => '2d', '32' => '4d');
$i = 0;
foreach ($estimates as $hours => $title) {
$data = array('title' => $title, 'hours' => $hours, 'position' => $i);
Kanban_Estimate::replace($data);
$i++;
}
}
$boards_table = Kanban_Board::table_name();
$sql = "SELECT count(`id`)\n\t\t\t\tFROM `{$boards_table}`\n\t\t;";
$boards_count = $wpdb->get_var($sql);
if ($boards_count == 0) {
$data = array('title' => 'Your first kanban board', 'created_dt_gmt' => Kanban_Utils::mysql_now_gmt(), 'modified_dt_gmt' => Kanban_Utils::mysql_now_gmt(), 'user_id_author' => get_current_user_id(), 'is_active' => 1);
Kanban_Board::replace($data);
}
$tasks_table = Kanban_Board::table_name();
$sql = "SELECT count(`id`)\n\t\t\t\tFROM `{$tasks_table}`\n\t\t;";
$tasks_count = $wpdb->get_var($sql);
if ($tasks_count == 0) {
$sql = "SELECT `id`\n\t\t\t\t\tFROM `{$boards_table}`\n\t\t\t\t\tLIMIT 1\n\t\t\t;";
$board_id = $wpdb->get_var($sql);
$data = array('title' => 'Your first task', 'board_id' => $board_id, 'created_dt_gmt' => Kanban_Utils::mysql_now_gmt(), 'modified_dt_gmt' => Kanban_Utils::mysql_now_gmt(), 'user_id_author' => get_current_user_id(), 'is_active' => 1);
Kanban_Board::replace($data);
}
$options_table = Kanban_Option::table_name();
$sql = "SELECT *\n\t\t\t\tFROM `{$options_table}`\n\t\t;";
$options = $wpdb->get_results($sql);
$options_arr = array();
foreach ($options as $option) {
$options_arr[$option->name] = $option->value;
}
$defaults = Kanban_Option::get_defaults();
foreach ($defaults as $name => $value) {
if (isset($options_arr[$name])) {
continue;
}
$data = array('name' => $name, 'value' => $value);
Kanban_Option::replace($data);
}
}
/**
* Apply all postmeta and terms to an array of posts
* @param arr $posts array of post objects
* @return arr array of posts, with ID's as keys, and all postmeta and terms applied
*/
static function apply_postmeta_and_terms_to_posts($posts)
{
// make sure the first post has a post type
if (empty($posts[0]->post_type)) {
return $posts;
}
// build array of id's
$post_id_arr = array();
foreach ($posts as $post) {
$post_id_arr[] = $post->ID;
}
// get postmeta for all posts
$postmeta = Kanban_Post::get_postmeta_for_posts($post_id_arr, $posts[0]->post_type);
// get terms for all posts
$terms = Kanban_Terms::get_terms_for_posts($post_id_arr, $posts[0]->post_type);
// apply post meta and terms to projects
foreach ($posts as $post) {
if (isset($postmeta[$post->ID])) {
$post->postmeta = $postmeta[$post->ID];
}
if (isset($terms[$post->ID])) {
$post->terms = $terms[$post->ID];
}
}
// put get array with post id's as keys
return Kanban_Utils::build_array_with_id_keys($posts);
}
<?php
submit_button(__('Save your Settings', 'kanban'), 'primary', 'submit');
?>
</div><!-- tab-estimates -->
<?php
echo apply_filters('kanban_settings_tabs_content', '');
?>
<?php
wp_nonce_field('kanban-options', Kanban_Utils::get_nonce());
?>
</form>
</div><!-- wrap -->
<script type="text/html" id="t-status">
<?php
include sprintf('%s/t-status.php', __DIR__);
?>
</div><!-- modal -->
<div id="screen-size">
<div class="visible-xs" data-size="xs"></div>
<div class="visible-sm" data-size="sm"></div>
<div class="visible-md" data-size="md"></div>
<div class="visible-lg" data-size="lg"></div>
</div>
<?php
wp_nonce_field('kanban-save', Kanban_Utils::get_nonce());
?>
<script type="text/javascript">
var ajaxurl = '<?php
echo admin_url('admin-ajax.php');
?>
';
var alert = "<?php
echo addslashes($wp_query->query_vars['kanban']->board->alert);
?>
";
