コード例 #1
0
ファイル: ajax.php プロジェクト: drupalconnect/finsearches
if (isset($_GET['loadLists'])) {
    $t = array();
    $field_id = (int) $_GET['fid'];
    $t['total'] = 0;
    $q = $db->dq("SELECT * FROM {mytinytodo_lists} WHERE field_id = ? ORDER BY ow ASC, id ASC", array($field_id));
    while ($r = $q->fetch_assoc($q)) {
        $t['total']++;
        $t['list'][] = prepareList($r);
    }
    jsonExit($t);
} elseif (isset($_GET['loadTasks'])) {
    stop_gpc($_GET);
    $listId = (int) _get('list');
    $sqlWhere = $inner = '';
    if ($listId == -1) {
        $userLists = getUserListsSimple();
        foreach ($userLists as $userList) {
            check_read_access($userList);
        }
        $sqlWhere .= " AND {mytinytodo_todos}.list_id IN (" . implode(array_keys($userLists), ',') . ") ";
    } else {
        check_read_access($listId);
        $sqlWhere .= " AND {mytinytodo_todos}.list_id=" . $listId;
    }
    if (_get('compl') == 0) {
        $sqlWhere .= ' AND compl=0';
    }
    $tag = trim(_get('t'));
    if ($tag != '') {
        $at = explode(',', $tag);
        $tagIds = array();
コード例 #2
0
ファイル: ajax.php プロジェクト: jmcclenon/yourTinyTodo
function loadTasks($listId, $compl = 0, $tag = '', $s = '', $sort = 0, $setCompl = 0, $setNotification = null)
{
    $db = DBConnection::instance();
    $sqlWhere = $inner = '';
    if ($listId == -1) {
        $userLists = getUserListsSimple();
        $sqlWhere .= " AND {$db->prefix}todolist.list_id IN (" . implode(array_keys($userLists), ',') . ") ";
    } else {
        $sqlWhere .= " AND {$db->prefix}todolist.list_id=" . $listId;
    }
    if ($compl == 0) {
        $sqlWhere .= ' AND compl=0';
    }
    $tag = trim($tag);
    if ($tag != '') {
        $at = explode(',', $tag);
        $tagIds = array();
        $tagExIds = array();
        foreach ($at as $i => $atv) {
            $atv = trim($atv);
            if ($atv == '' || $atv == '^') {
                continue;
            }
            if (substr($atv, 0, 1) == '^') {
                $tagExIds[] = getTagId(substr($atv, 1));
            } else {
                $tagIds[] = getTagId($atv);
            }
        }
        if (sizeof($tagIds) > 1) {
            $inner .= "INNER JOIN (SELECT task_id, COUNT(tag_id) AS c FROM {$db->prefix}tag2task WHERE list_id={$listId} AND tag_id IN (" . implode(',', $tagIds) . ") GROUP BY task_id) AS t2t ON id=t2t.task_id";
            $sqlWhere = " AND c=" . sizeof($tagIds);
            //overwrite sqlWhere!
        } elseif ($tagIds) {
            $inner .= "INNER JOIN {$db->prefix}tag2task ON {$db->prefix}todolist.id={$db->prefix}tag2task.task_id";
            $sqlWhere .= " AND {$db->prefix}tag2task.tag_id = " . $tagIds[0];
        }
        if ($tagExIds) {
            $sqlWhere .= " AND id NOT IN (SELECT DISTINCT task_id FROM {$db->prefix}tag2task WHERE list_id={$listId} AND tag_id IN (" . implode(',', $tagExIds) . "))";
            //DISTINCT ?
        }
    }
    $s = trim($s);
    if ($s != '') {
        $sqlWhere .= " AND (title LIKE " . $db->quoteForLike("%%%s%%", $s) . " OR note LIKE " . $db->quoteForLike("%%%s%%", $s) . ")";
    }
    $sort = $sort;
    $sqlSort = "ORDER BY compl ASC, ";
    if ($sort == 1) {
        $sqlSort .= "prio DESC, ddn ASC, duedate ASC, ow ASC";
    } elseif ($sort == 101) {
        $sqlSort .= "prio ASC, ddn DESC, duedate DESC, ow DESC";
    } elseif ($sort == 2) {
        $sqlSort .= "ddn ASC, duedate ASC, prio DESC, ow ASC";
    } elseif ($sort == 102) {
        $sqlSort .= "ddn DESC, duedate DESC, prio ASC, ow DESC";
    } elseif ($sort == 3) {
        $sqlSort .= "d_created ASC, prio DESC, ow ASC";
    } elseif ($sort == 103) {
        $sqlSort .= "d_created DESC, prio ASC, ow DESC";
    } elseif ($sort == 4) {
        $sqlSort .= "d_edited ASC, prio DESC, ow ASC";
    } elseif ($sort == 104) {
        $sqlSort .= "d_edited DESC, prio ASC, ow DESC";
    } else {
        $sqlSort .= "ow ASC";
    }
    $t = array();
    $t['total'] = 0;
    $t['list'] = array();
    $q = $db->dq("SELECT *, duedate IS NULL AS ddn FROM {$db->prefix}todolist {$inner} WHERE 1=1 {$sqlWhere} {$sqlSort}");
    while ($r = $q->fetch_assoc($q)) {
        $t['total']++;
        $t['list'][] = prepareTaskRow($r);
    }
    if ($setCompl && have_write_access($listId)) {
        $bitwise = $compl == 0 ? 'taskview & ~1' : 'taskview | 1';
        $db->dq("UPDATE {$db->prefix}lists SET taskview={$bitwise} WHERE id={$listId}");
    }
    if (($setNotification === '0' || $setNotification === '1') && have_write_access($listId)) {
        if ($setNotification == 1) {
            NotificationListener::enableNotification(NotificationListener::LISTENER_TYPE_LIST, $listId);
        } else {
            NotificationListener::disableNotification(NotificationListener::LISTENER_TYPE_LIST, $listId);
        }
    }
    return $t;
}