';
echo '
';
include 'admin_add_task.php';
echo '
';
}
function get_description_subject($description, $description_length=50) {
$lines = split("[\n|\r]", $description);
$firstline = $lines[0];
if(strlen($firstline)>$description_length) {
$firstline = substr($firstline, 0, $description_length-2).'..';
}
return $firstline;
}
function table_setup() {
$this->create_table_status();
$this->create_table_priority();
$this->create_table_tasks();
}
function create_table_tasks() {
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
global $wpdb;
$table_name = $this->get_table_name('tasks');
$sql = 'CREATE TABLE ' . $table_name . ' (
id mediumint(9) NOT NULL AUTO_INCREMENT,
assigned bigint(20) not null,
created_by bigint(20) not null,
created TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
description text NOT NULL,
status_id mediumint(9),
priority_id mediumint(9),
UNIQUE KEY id (id)
);';
dbDelta($sql);
}
function create_table_status() {
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
global $wpdb;
$table_name = $this->get_table_name('status');
if($wpdb->get_var("show tables like '$table_name'") != $table_name) {
$sql = 'CREATE TABLE ' . $table_name . ' (
id mediumint(9) NOT NULL,
name varchar (50) NOT NULL,
UNIQUE KEY id (id)
);';
dbDelta($sql);
$status = array(1=>'open', 2=>'in progress', 3=>'test', 4=>'closed', 5=>'deleted');
foreach($status as $key => $value) {
$wpdb->insert( $table_name, array('id'=>$key, 'name' => $value), array( '%d', '%s') );
}
}
}
function create_table_priority() {
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
global $wpdb;
$table_name = $this->get_table_name('priority');
if($wpdb->get_var("show tables like '$table_name'") != $table_name) {
$sql = 'CREATE TABLE ' . $table_name . ' (
id mediumint(9) NOT NULL,
name varchar (50) NOT NULL,
UNIQUE KEY id (id)
);';
dbDelta($sql);
$status = array(10=>'low', 20=>'medium', 30=>'high');
foreach($status as $key => $value) {
$wpdb->insert( $table_name, array('id'=>$key, 'name' => $value), array( '%d', '%s') );
}
}
}
function get_status_array() {
global $wpdb;
$table_name = $this->get_table_name('status');
$status_array = $wpdb->get_results('SELECT id, name FROM '.$table_name);
$return = array();
foreach($status_array as $status) {
$return[$status->id] = $status->name;
}
return $return;
}
function get_priority_array() {
global $wpdb;
$table_name = $this->get_table_name('priority');
$status_array = $wpdb->get_results('SELECT id, name FROM '.$table_name);
$return = array();
foreach($status_array as $status) {
$return[$status->id] = $status->name;
}
return $return;
}
function get_filtered_tasks_array($paging) {
global $wpdb;
$table_name = $this->get_table_name('tasks');
$tasks_array = $wpdb->get_results('SELECT id, assigned, created, description, status_id, priority_id FROM '.$table_name.' where status_id not in (4,5) order by priority_id desc, status_id desc limit '.$paging->get_start_record().','.$paging->records_per_page);
return $tasks_array;
}
function get_filtered_tasks_array_size() {
global $wpdb;
$table_name = $this->get_table_name('tasks');
$count = $wpdb->get_var('SELECT count(*) FROM '.$table_name.' where status_id not in (4,5)');
return $count;
}
function get_all_tasks_array($paging) {
global $wpdb;
$table_name = $this->get_table_name('tasks');
$tasks_array = $wpdb->get_results('SELECT id, assigned, created_by, created, description, status_id, priority_id FROM '.$table_name.' order by priority_id desc, status_id asc limit '.$paging->get_start_record().','.$paging->records_per_page);
return $tasks_array;
}
function get_all_tasks_array_size() {
global $wpdb;
$table_name = $this->get_table_name('tasks');
$count = $wpdb->get_var('SELECT count(*) FROM '.$table_name);
return $count;
}
function get_tasks_array() {
global $wpdb;
$table_name = $this->get_table_name('tasks');
$tasks_array = $wpdb->get_results('SELECT id, assigned, created, description, status_id, priority_id FROM '.$table_name);
return $tasks_array;
}
function get_users_array() {
global $wpdb;
$table_name = $wpdb->prefix.'users';
$users_array = $wpdb->get_results('SELECT ID, display_name FROM '.$table_name);
$return = array();
foreach($users_array as $user) {
$return[$user->ID] = $user->display_name;
}
return $return;
}
function get_table_name($name) {
global $wpdb;
$table_name = $wpdb->prefix.self::$TABLE_PREFIX.$name;
return $table_name;
}
function get_task($task_id){
global $wpdb;
$table_name = $this->get_table_name('tasks');
$sql = 'select * from '.$table_name.' where id='.$task_id;
$task = $wpdb->get_row($sql);
return $task;
}
function add_task($description, $status_id, $priority_id, $assigned) {
global $current_user,$wpdb;
$table_name = $wpdb->prefix.'gt_tasks';
$insert = "INSERT INTO " . $table_name ." (assigned,created_by,status_id,priority_id,description) VALUES (".$assigned.",'.$current_user->ID.','.$status_id.','.$priority_id.','".$description."')";
$results = $wpdb->query( $insert );
}
function updateStatus($task_id, $status_id) {
global $wpdb;
$table_name = $this->get_table_name('tasks');
$wpdb->update( $table_name, array( 'status_id' => $status_id), array( 'id' => $task_id ), array( '%s'), array( '%d' ) );
}
function updatePriority($task_id, $priority_id) {
global $wpdb;
$table_name = $this->get_table_name('tasks');
$wpdb->update( $table_name, array( 'priority_id' => $priority_id), array( 'id' => $task_id ), array( '%s'), array( '%d' ) );
}
function updateAssigned($task_id, $assigned) {
global $wpdb;
$table_name = $this->get_table_name('tasks');
$wpdb->update( $table_name, array( 'assigned' => $assigned), array( 'id' => $task_id ), array( '%d'), array( '%d' ) );
}
function updateDescription($task_id, $description) {
global $wpdb;
$table_name = $this->get_table_name('tasks');
$wpdb->update( $table_name, array( 'description' => $description), array( 'id' => $task_id ), array( '%s'), array( '%d' ) );
}
function updateTask($task_id, $description, $status, $priority, $assigned) {
global $wpdb;
$table_name = $this->get_table_name('tasks');
$values = array( 'description' => $description, 'status_id'=> $status, 'priority_id'=>$priority, 'assigned'=>$assigned);
$wpdb->update( $table_name, $values, array( 'id' => $task_id ), array( '%s'), array( '%d' ) );
}
function getDescriptionDetails($task_id) {
global $wpdb;
$table_name = $this->get_table_name('tasks');
$description = $wpdb->get_var('SELECT description FROM '.$table_name.' where id='.$task_id);
return $description;
}
function get_stats() {
global $wpdb;
$table_name = $this->get_table_name('tasks');
$stats['Current Tasks'] = $wpdb->get_var('select count(*) from wp_gt_tasks where status_id in (1, 2, 3)');
$stats['Total Tasks'] = $wpdb->get_var('select count(*) from wp_gt_tasks');
$stats['Closed or Deleted Tasks'] = $wpdb->get_var('select count(*) from wp_gt_tasks where status_id in (4, 5)');
// current high
$stats['Current Tasks: High-Priority'] = $wpdb->get_var('select count(*) from wp_gt_tasks where status_id in (1, 2, 3) and priority_id=30');
$stats['Current Tasks: Medium-Priority'] = $wpdb->get_var('select count(*) from wp_gt_tasks where status_id in (1, 2, 3) and priority_id=20');
$stats['Current Tasks: Low-Priority'] = $wpdb->get_var('select count(*) from wp_gt_tasks where status_id in (1, 2, 3) and priority_id=10');
return $stats;
}
}
?>