PHP DBQuery::includeCount方法代码示例

$q->clear();
$filter_options = array();
$filter_module_tables = array();
$denied_tables = '';
foreach ($available_modules as $my_mod => $my_mod_data) {
    $my_mod_table = $my_mod_data['permissions_item_table'];
    $filter_options[$my_mod]['Name'] = $my_mod_data['mod_name'];
    $filter_options[$my_mod]['Table'] = $my_mod_table;
    $filter_options[$my_mod]['Table_ID'] = $my_mod_data['permissions_item_field'];
    $filter_options[$my_mod]['Table_ID_Name'] = $my_mod_data['permissions_item_label'];
    $filter_module_tables[$my_mod] = $my_mod_table;
    if ($my_mod_table && !getPermission($my_mod, 'view')) {
        $denied_tables .= ($denied_module_list ? "','" : '') . $my_mod_table;
    }
}
$q->includeCount();
$q->addTable('history', 'h');
$q->leftJoin('users', 'u', 'u.user_id = h.history_user');
$q->addQuery('h.*, u.*');
if ($in_filter) {
    $filter .= ($filter ? ' AND ' : '') . "(h.`history_table` LIKE '" . $in_filter . "%')";
}
if ($denied_tables) {
    $filter .= ($filter ? ' AND ' : '') . "(NOT h.`history_table` IN ('" . $denied_tables . "'))";
}
if (!empty($_REQUEST['project_id'])) {
    $project_id = $_REQUEST['project_id'];
    $r = new DBQuery();
    $r->addTable('tasks');
    $r->addQuery('task_id');
    $r->addWhere('task_project = ' . $project_id);

if ($category_filter) {
    $q3->addWhere($category_filter);
}
if ($company_id) {
    $q3->addWhere('p.project_company = ' . $company_id);
}
if ($project_id) {
    $q3->addWhere('f.file_project = ' . $project_id);
}
if ($task_id) {
    $q3->addWhere('f.file_task = ' . $task_id);
}
$files = array();
$file_versions = array();
if ($canRead) {
    $q2->includeCount();
    $files = $q2->loadList();
    $xpg_totalrecs = $q2->foundRows();
    $file_versions = $q3->loadHashList('file_id');
}
$r->dropTemp('files_count_max');
$r->exec();
// How many pages are we dealing with here ??
$xpg_total_pages = $xpg_totalrecs > $xpg_pagesize ? ceil($xpg_totalrecs / $xpg_pagesize) : 1;
shownavbar($xpg_totalrecs, $xpg_pagesize, $xpg_total_pages, $page);
?>
<script type="text/JavaScript">
function expand(id) {
  var element = document.getElementById(id);
  element.style.display = (element.style.display == '' || element.style.display == "none") ? "block" : "none";
}

function process_dependencies($i)
{
    global $tasks, $option_advance_if_possible;
    if ($tasks[$i]["fixed"]) {
        return;
    }
    log_info("<div style='padding-left: 1em'>Dependecies for '" . $tasks[$i]["task_name"] . "':<br />");
    // query dependencies for this task
    $q = new DBQuery();
    $q->addTable('tasks', 't');
    $q->addTable('task_dependencies', 'td');
    $q->addQuery('t.*');
    $q->addWhere('task_id=dependencies_req_task_id and dependencies_task_id=' . (int) $tasks[$i]['task_id']);
    $q->includeCount();
    $q->exec();
    if ($q->foundRows() != 0) {
        $all_fixed = true;
        $latest_end_date = null;
        // store dependencies in an array (for adding more entries on the fly)
        $dependencies = array();
        while ($row = $q->fetchRow()) {
            array_push($dependencies, $row);
        }
        $d = 0;
        while ($d < count($dependencies)) {
            $row = $dependencies[$d];
            $index = search_task($row["task_id"]);
            if ($index == -1) {
                // task is not listed => it's a task group
                // => $i depends on all its subtasks
                // => add all subtasks to the dependencies array
                log_info("- task '" . $row["task_name"] . "' is a task group (processing subtask's dependencies)");
                $children = get_last_children($row);
                // replace this taskgroup with all its subtasks
                array_splice($dependencies, $d, 1, $children);
                continue;
            }
            log_info(" - '" . $tasks[$index]["task_name"] . ($tasks[$index]["fixed"] ? " (FIXED)" : "") . "'");
            // TODO: Detect dependencies loops (A->B, B->C, C->A)
            process_dependencies($index);
            if (!$tasks[$index]["fixed"]) {
                $all_fixed = false;
            } else {
                // ignore dependencies of finished tasks if option is enabled
                if (!$option_advance_if_possible || $tasks[$index]["task_percent_complete"] != 100) {
                    // get latest end_date
                    $end_date = db_dateTime2unix($tasks[$index]["task_end_date"]);
                    if (!$latest_end_date || $end_date > $latest_end_date) {
                        $latest_end_date = $end_date;
                        $dep_on_task = $row;
                    }
                } else {
                    log_info("this task is complete => don't check dependency");
                }
                $d++;
            }
        }
        if ($all_fixed) {
            // this task depends only on fixated tasks
            log_info("all dependencies are fixed");
            fixate_task($i, $latest_end_date, $dep_on_task);
        } else {
            log_error("task has not fixed dependencies");
        }
    } else {
        // task has no dependencies
        log_info("no dependencies => ");
        fixate_task($i, time(), "");
    }
    log_info("</div><br />\n");
}