PHP task::get_list方法代码示例

function show_task_children($template)
{
    global $TPL;
    global $task;
    if ($task->get_value("taskTypeID") == "Parent") {
        $options["parentTaskID"] = $task->get_id();
        $options["taskView"] = "byProject";
        $task->get_value("projectID") and $options["projectIDs"][] = $task->get_value("projectID");
        $options["showDates"] = true;
        #$options["showCreator"] = true;
        $options["showAssigned"] = true;
        $options["showPercent"] = true;
        $options["showHeader"] = true;
        $options["showTimes"] = true;
        $options["showTaskID"] = true;
        $options["showTotals"] = true;
        $options["showStatus"] = true;
        $options["showEdit"] = true;
        $options["showPriorityFactor"] = true;
        $options["returnURL"] = $TPL["url_alloc_task"] . "taskID=" . $task->get_id();
        $_GET["media"] == "print" and $options["showDescription"] = true;
        $_GET["media"] == "print" and $options["showComments"] = true;
        $TPL["taskListRows"] = task::get_list($options);
        $TPL["taskListOptions"] = $options;
        include_template($template);
    }
}

 function get_tasks_for_email()
 {
     $options = array();
     #$options["projectType"] = "mine";
     $options["limit"] = 3;
     $options["current_user"] = $this->get_id();
     $options["personID"] = $this->get_id();
     $options["taskView"] = "prioritised";
     $options["taskStatus"] = "open";
     $tasks = task::get_list($options);
     foreach ($tasks as $task) {
         $s[] = "";
         $s[] = "";
         $s[] = "Project: " . $task["project_name"];
         $s[] = "Task: " . $task["taskName"];
         $s[] = $task["taskStatusLabel"];
         $s[] = $task["taskURL"];
     }
     $summary = implode("\n", $s);
     if ($summary) {
         $topThree = "\n\nTop Three Tasks";
         $topThree .= $summary;
     }
     unset($summary, $s);
     unset($options["limit"]);
     $options["taskDate"] = "due_today";
     $tasks = task::get_list($options);
     foreach ($tasks as $task) {
         $s[] = "";
         $s[] = "";
         $s[] = "Project: " . $task["project_name"];
         $s[] = "Task: " . $task["taskName"];
         $s[] = $task["taskStatusLabel"];
         $s[] = $task["taskURL"];
     }
     $summary = implode("\n", $s);
     if ($summary) {
         $dueToday = "\n\nTasks Due Today";
         $dueToday .= $summary;
     }
     unset($summary, $s);
     unset($options["limit"]);
     $options["taskDate"] = "new";
     $tasks = task::get_list($options);
     foreach ($tasks as $task) {
         $s[] = "";
         $s[] = "";
         $s[] = "Project: " . $task["project_name"];
         $s[] = "Task: " . $task["taskName"];
         $s[] = $task["taskStatusLabel"];
         $s[] = $task["taskURL"];
     }
     $summary = implode("\n", $s);
     if ($summary) {
         $newTasks = "\n\nNew Tasks";
         $newTasks .= $summary;
     }
     return $topThree . $dueToday . $newTasks;
 }

 function render()
 {
     global $TPL;
     $defaults = array("showHeader" => true, "showTaskID" => true, "taskView" => "prioritised", "showStatus" => "true", "url_form_action" => $TPL["url_alloc_home"], "form_name" => "taskListHome_filter");
     $current_user =& singleton("current_user");
     if (!$current_user->prefs["taskListHome_filter"]) {
         $defaults["taskStatus"] = "open";
         $defaults["personID"] = $current_user->get_id();
         $defaults["showStatus"] = true;
         $defaults["showProject"] = true;
         $defaults["limit"] = 10;
         $defaults["applyFilter"] = true;
     }
     $_FORM = task::load_form_data($defaults);
     $TPL["taskListRows"] = task::get_list($_FORM);
     $TPL["_FORM"] = $_FORM;
     return true;
 }

 * FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public
 * License for more details.
 * 
 * You should have received a copy of the GNU Affero General Public License
 * along with allocPSA. If not, see <http://www.gnu.org/licenses/>.
*/
require_once "../alloc.php";
include "lib/task_graph.inc.php";
$current_user =& singleton("current_user");
global $show_weeks;
global $for_home_item;
$options = unserialize(stripslashes($_GET["FORM"]));
$options["return"] = "array";
$options["padding"] = 0;
$options["debug"] = 0;
$tasks = task::get_list($options) or $tasks = array();
foreach ($tasks as $task) {
    $objects[$task["taskID"]] = $task["object"];
}
$task_graph = new task_graph();
$task_graph->set_title($_GET["graphTitle"]);
$task_graph->set_width($_GET["graphWidth"]);
$task_graph->init($objects);
$task_graph->draw_grid();
foreach ($tasks as $task) {
    $task_graph->draw_task($task);
}
$task_graph->draw_milestones();
$task_graph->draw_today();
$task_graph->draw_legend();
$task_graph->output();

 * your option) any later version.
 * 
 * allocPSA is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
 * FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public
 * License for more details.
 * 
 * You should have received a copy of the GNU Affero General Public License
 * along with allocPSA. If not, see <http://www.gnu.org/licenses/>.
*/
require_once "../alloc.php";
$TPL["main_alloc_title"] = "Task List - " . APPLICATION_NAME;
$defaults = array("showHeader" => true, "showTaskID" => true, "showEdit" => true, "taskView" => "byProject", "showStatus" => "true", "showTotals" => "true", "padding" => 1, "url_form_action" => $TPL["url_alloc_taskList"], "form_name" => "taskList_filter");
// Load task list
$_FORM = task::load_form_data($defaults);
$TPL["taskListRows"] = task::get_list($_FORM);
$TPL["_FORM"] = $_FORM;
// Load filter
$arr = task::load_task_filter($_FORM);
is_array($arr) and $TPL = array_merge($TPL, $arr);
// Check for updates
if ($_POST["mass_update"]) {
    if ($_POST["select"]) {
        $allowed_auto_fields = array("dateTargetStart", "dateTargetCompletion", "dateActualStart", "dateActualCompletion", "managerID", "timeLimit", "timeBest", "timeWorst", "timeExpected", "priority", "taskTypeID", "taskStatus", "personID");
        foreach ($_POST["select"] as $taskID => $selected) {
            $task = new task();
            $task->set_id($taskID);
            $task->select();
            // Special case: projectID and parentTaskID have to be done together
            if ($_POST["update_action"] == "projectIDAndParentTaskID") {
                // Can't set self to be parent

 function get_task_list_dropdown($status, $timeSheetID, $taskID = "")
 {
     if (is_object($this)) {
         $personID = $this->get_value('personID');
         $projectID = $this->get_value('projectID');
     } else {
         if ($timeSheetID) {
             $t = new timeSheet();
             $t->set_id($timeSheetID);
             $t->select();
             $personID = $t->get_value('personID');
             $projectID = $t->get_value('projectID');
         }
     }
     $options["projectID"] = $projectID;
     $options["personID"] = $personID;
     $options["taskView"] = "byProject";
     $options["return"] = "array";
     $options["taskTimeSheetStatus"] = $status;
     $taskrows = task::get_list($options);
     foreach ((array) $taskrows as $tid => $row) {
         $tasks[$tid] = str_repeat("    ", $row["padding"]) . $tid . " " . $row["taskName"];
     }
     if ($taskID) {
         $t = new task();
         $t->set_id($taskID);
         $t->select();
         $tasks[$taskID] = $t->get_id() . " " . $t->get_name();
     }
     $dropdown_options = page::select_options((array) $tasks, $taskID, 100);
     return "<select name=\"timeSheetItem_taskID\" style=\"width:400px\"><option value=\"\">" . $dropdown_options . "</select>";
 }

function show_tasks()
{
    global $TPL;
    global $project;
    $options["showHeader"] = true;
    $options["taskView"] = "byProject";
    $options["projectIDs"] = array($project->get_id());
    $options["taskStatus"] = array("open", "pending");
    $options["showTaskID"] = true;
    $options["showAssigned"] = true;
    $options["showStatus"] = true;
    $options["showManager"] = true;
    $options["showDates"] = true;
    #$options["showTimes"] = true; // performance hit
    $options["return"] = "html";
    // $TPL["taskListRows"] is used for the budget estimatation outside of this function
    $options = ace_augment("project_page_task_list_options", $options);
    $TPL["taskListRows"] = task::get_list($options);
    $TPL["_FORM"] = $options;
    include_template("templates/projectTaskS.tpl");
}

function export_csv($projectID)
{
    $project = new project();
    $project->set_id($projectID);
    $project->select();
    $retstr = '"Task Name","Estimated Time","Assignee"';
    // Export all tasks in the project
    $taskOptions["projectIDs"] = array($project->get_id());
    $taskOptions["return"] = "array";
    $taskOptions["taskView"] = "byProject";
    $tasks = task::get_list($taskOptions);
    // Sort by taskID--we assume taskIDs were assigned linearly on import/creation--so as to produce an identical file
    foreach ($tasks as $task) {
        $taskIDs[] = $task['taskID'];
    }
    array_multisort($taskIDs, $tasks);
    foreach ($tasks as $task) {
        $assignee = new person();
        $assignee->set_id($task['personID']);
        $assignee->select();
        $estimatedHours = $task['timeExpected'];
        is_numeric($estimatedHours) or $estimatedHours = 0;
        $retstr .= "\n" . export_escape_csv($task['taskName']) . ',' . export_escape_csv($estimatedHours) . ',' . export_escape_csv($assignee->get_name(array("format" => "nick")));
    }
    return $retstr;
}

$_FORM["showAssigned"] and $fields["assignee_name"] = "Assigned To";
$_FORM["showDate1"] and $fields["dateTargetStart"] = "Targ Start";
$_FORM["showDate2"] and $fields["dateTargetCompletion"] = "Targ Compl";
$_FORM["showDate3"] and $fields["dateActualStart"] = "Start";
$_FORM["showDate4"] and $fields["dateActualCompletion"] = "Compl";
$_FORM["showDate5"] and $fields["dateCreated"] = "Created";
$_FORM["showTimes"] and $fields["timeBestLabel"] = "Best";
$_FORM["showTimes"] and $fields["timeExpectedLabel"] = "Likely";
$_FORM["showTimes"] and $fields["timeWorstLabel"] = "Worst";
$_FORM["showTimes"] and $fields["timeActualLabel"] = "Actual";
$_FORM["showTimes"] and $fields["timeLimitLabel"] = "Limit";
$_FORM["showPercent"] and $fields["percentComplete"] = "%";
$_FORM["showStatus"] and $fields["taskStatusLabel"] = "Status";
$taskPriorities = config::get_config_item("taskPriorities");
$projectPriorities = config::get_config_item("projectPriorities");
$rows = task::get_list($_FORM);
$taskListRows = array();
foreach ((array) $rows as $row) {
    $row["taskPriority"] = $taskPriorities[$row["priority"]]["label"];
    $row["projectPriority"] = $projectPriorities[$row["projectPriority"]]["label"];
    $row["taskDateStatus"] = strip_tags($row["taskDateStatus"]);
    $row["percentComplete"] = strip_tags($row["percentComplete"]);
    $taskListRows[] = $row;
}
if ($taskListRows) {
    header('Content-Type: text/csv');
    header('Content-Disposition: attachment;filename=tasklist' . time() . '.csv');
    $fp = fopen('php://output', 'w');
    // header row
    fputcsv($fp, array_keys(current($taskListRows)));
    foreach ($taskListRows as $row) {

 function get_printable_file($_FORM = array())
 {
     global $TPL;
     $db = new db_alloc();
     $TPL["companyName"] = config::get_config_item("companyName");
     $TPL["companyNos1"] = config::get_config_item("companyACN");
     $TPL["companyNos2"] = config::get_config_item("companyABN");
     $TPL["img"] = config::get_config_item("companyImage");
     $TPL["companyContactAddress"] = config::get_config_item("companyContactAddress");
     $TPL["companyContactAddress2"] = config::get_config_item("companyContactAddress2");
     $TPL["companyContactAddress3"] = config::get_config_item("companyContactAddress3");
     $email = config::get_config_item("companyContactEmail");
     $email and $TPL["companyContactEmail"] = "Email: " . $email;
     $web = config::get_config_item("companyContactHomePage");
     $web and $TPL["companyContactHomePage"] = "Web: " . $web;
     $phone = config::get_config_item("companyContactPhone");
     $fax = config::get_config_item("companyContactFax");
     $phone and $TPL["phone"] = "Ph: " . $phone;
     $fax and $TPL["fax"] = "Fax: " . $fax;
     $taskPriorities = config::get_config_item("taskPriorities");
     $projectPriorities = config::get_config_item("projectPriorities");
     // Add requested fields to pdf
     $_FORM["showEdit"] = false;
     $fields["taskID"] = "ID";
     $fields["taskName"] = "Task";
     $_FORM["showProject"] and $fields["projectName"] = "Project";
     $_FORM["showPriority"] || $_FORM["showPriorityFactor"] and $fields["priorityFactor"] = "Pri";
     $_FORM["showPriority"] and $fields["taskPriority"] = "Task Pri";
     $_FORM["showPriority"] and $fields["projectPriority"] = "Proj Pri";
     $_FORM["showCreator"] and $fields["creator_name"] = "Creator";
     $_FORM["showManager"] and $fields["manager_name"] = "Manager";
     $_FORM["showAssigned"] and $fields["assignee_name"] = "Assigned To";
     $_FORM["showDate1"] and $fields["dateTargetStart"] = "Targ Start";
     $_FORM["showDate2"] and $fields["dateTargetCompletion"] = "Targ Compl";
     $_FORM["showDate3"] and $fields["dateActualStart"] = "Start";
     $_FORM["showDate4"] and $fields["dateActualCompletion"] = "Compl";
     $_FORM["showDate5"] and $fields["dateCreated"] = "Created";
     $_FORM["showTimes"] and $fields["timeBestLabel"] = "Best";
     $_FORM["showTimes"] and $fields["timeExpectedLabel"] = "Likely";
     $_FORM["showTimes"] and $fields["timeWorstLabel"] = "Worst";
     $_FORM["showTimes"] and $fields["timeActualLabel"] = "Actual";
     $_FORM["showTimes"] and $fields["timeLimitLabel"] = "Limit";
     $_FORM["showPercent"] and $fields["percentComplete"] = "%";
     $_FORM["showStatus"] and $fields["taskStatusLabel"] = "Status";
     $rows = task::get_list($_FORM);
     $taskListRows = array();
     foreach ((array) $rows as $row) {
         $row["taskPriority"] = $taskPriorities[$row["priority"]]["label"];
         $row["projectPriority"] = $projectPriorities[$row["projectPriority"]]["label"];
         $row["taskDateStatus"] = strip_tags($row["taskDateStatus"]);
         $row["percentComplete"] = strip_tags($row["percentComplete"]);
         $taskListRows[] = $row;
     }
     if ($_FORM["format"] != "html" && $_FORM["format"] != "html_plus") {
         // Build PDF document
         $font1 = ALLOC_MOD_DIR . "util/fonts/Helvetica.afm";
         $font2 = ALLOC_MOD_DIR . "util/fonts/Helvetica-Oblique.afm";
         $pdf_table_options = array("showLines" => 0, "shaded" => 0, "showHeadings" => 0, "xPos" => "left", "xOrientation" => "right", "fontSize" => 10, "rowGap" => 0, "fontSize" => 10);
         $pdf_table_options3 = array("showLines" => 2, "shaded" => 0, "width" => 750, "xPos" => "center", "fontSize" => 10, "lineCol" => array(0.8, 0.8, 0.8), "splitRows" => 1, "protectRows" => 0);
         $pdf = new Cezpdf(null, 'landscape');
         $pdf->ezSetMargins(40, 40, 40, 40);
         $pdf->selectFont($font1);
         $pdf->ezStartPageNumbers(436, 30, 10, 'center', 'Page {PAGENUM} of {TOTALPAGENUM}');
         $pdf->ezSetY(560);
         $TPL["companyContactAddress"] and $contact_info[] = array($TPL["companyContactAddress"]);
         $TPL["companyContactAddress2"] and $contact_info[] = array($TPL["companyContactAddress2"]);
         $TPL["companyContactAddress3"] and $contact_info[] = array($TPL["companyContactAddress3"]);
         $TPL["companyContactEmail"] and $contact_info[] = array($TPL["companyContactEmail"]);
         $TPL["companyContactHomePage"] and $contact_info[] = array($TPL["companyContactHomePage"]);
         $TPL["phone"] and $contact_info[] = array($TPL["phone"]);
         $TPL["fax"] and $contact_info[] = array($TPL["fax"]);
         $pdf->selectFont($font2);
         $y = $pdf->ezTable($contact_info, false, "", $pdf_table_options);
         $pdf->selectFont($font1);
         $line_y = $y - 10;
         $pdf->setLineStyle(1, "round");
         $pdf->line(40, $line_y, 801, $line_y);
         $pdf->ezSetY(570);
         $image_jpg = ALLOC_LOGO;
         if (file_exists($image_jpg)) {
             $pdf->ezImage($image_jpg, 0, sprintf("%d", config::get_config_item("logoScaleX")), 'none');
             $y = 700;
         } else {
             $y = $pdf->ezText($TPL["companyName"], 27, array("justification" => "right"));
         }
         $nos_y = $line_y + 22;
         $TPL["companyNos2"] and $nos_y = $line_y + 34;
         $pdf->ezSetY($nos_y);
         $TPL["companyNos1"] and $y = $pdf->ezText($TPL["companyNos1"], 10, array("justification" => "right"));
         $TPL["companyNos2"] and $y = $pdf->ezText($TPL["companyNos2"], 10, array("justification" => "right"));
         $pdf->ezSetY($line_y - 10);
         $y = $pdf->ezText("Task List", 20, array("justification" => "center"));
         $pdf->ezSetY($y - 20);
         $y = $pdf->ezTable($taskListRows, $fields, "", $pdf_table_options3);
         $pdf->ezSetY($y - 20);
         $pdf->ezStream();
         // Else HTML format
     } else {
         echo task::get_list_html($taskListRows, $_FORM);
     }
//.........这里部分代码省略.........