public function todolists_progressbar_shortcode($atts)
{
require_once "form_todolist_user.php";
$form = new WPTodoList_FormTodoList();
extract(shortcode_atts(array('id' => '0'), $atts));
return $form->get_progressbar($id);
}
public function todolists_wp_ajax_nopriv_updatetask()
{
global $wpdb, $ip_id, $todolist_task_disappear;
$userid = get_current_user_id();
$task_id = $_POST['taskid'];
$status = $_POST["status"];
if ($todolist_task_disappear == "on" && is_super_admin($userid)) {
$type = 'draft';
$disappear = "yes";
} else {
$type = 'publish';
$disappear = "no";
}
if (is_user_logged_in()) {
$select_task = $wpdb->get_results("SELECT user_id FROM " . $wpdb->prefix . "todolists_usertask WHERE user_id = '" . $userid . "' AND task_id = '" . $task_id . "'");
$update_task = "UPDATE " . $wpdb->prefix . "todolists_usertask SET status='true', type='{$type}', completiondate=NOW() where user_id='{$userid}' AND task_id='{$task_id}'";
$insert_task = "INSERT IGNORE INTO " . $wpdb->prefix . "todolists_usertask SET user_id='{$userid}', task_id='{$task_id}', status='{$status}', type='{$type}', completiondate=NOW()";
$delete_task = "DELETE FROM " . $wpdb->prefix . "todolists_usertask WHERE user_id='{$userid}' AND task_id='{$task_id}'";
} else {
$select_task = $wpdb->get_results("SELECT ip_id FROM " . $wpdb->prefix . "todolists_iptask WHERE ip_id = '" . $ip_id . "' AND task_id = '" . $task_id . "'");
$update_task = "UPDATE " . $wpdb->prefix . "todolists_iptask SET status='true', type='{$type}', completiondate=NOW() where ip_id='{$ip_id}' AND task_id='{$task_id}'";
$insert_task = "INSERT IGNORE INTO " . $wpdb->prefix . "todolists_iptask SET ip_id='{$ip_id}', task_id='{$task_id}', status='{$status}',type='{$type}', completiondate=NOW()";
$delete_task = "DELETE FROM " . $wpdb->prefix . "todolists_iptask WHERE ip_id='{$ip_id}' AND task_id='{$task_id}'";
}
if ($status == "true") {
if (count($result) > 0) {
$wpdb->query($update_task);
} else {
$wpdb->query($insert_task);
}
//insert
} else {
$wpdb->query($delete_task);
//delete
}
require_once "code/form_todolist_user.php";
$form = new WPTodoList_FormTodoList();
$listid = $form->get_tasklistid($task_id);
$taskcountdetails = $form->get_taskcountdetails($listid);
echo $taskcountdetails["completed"] . "_" . $taskcountdetails["total"] . "_" . $taskcountdetails["percent"] . "_" . $listid . "_" . $disappear;
die;
}
