zentao/module/block/zen.php

<?php
class blockZen extends block
{
    /**
     * 初始化用户某个仪表盘下的区块数据。
     * Init block when account use first.
     *
     * @param  string $dashboard
     * @access public
     * @return bool
     */
    public function initBlock($dashboard)
    {
        if(!$dashboard) return false;

        $flow    = isset($this->config->global->flow) ? $this->config->global->flow : 'full';
        $account = $this->app->user->account;
        $vision  = $this->config->vision;

        /* 获取该仪表盘下的初始化默认布局。 */
        $blocks      = $dashboard == 'my' ? $this->lang->block->default[$flow][$dashboard] : $this->lang->block->default[$dashboard];
        $closedBlock = isset($this->config->block->closed) ? $this->config->block->closed : '';
        foreach($blocks as $block)
        {
            if(strpos(",{$closedBlock},", ",{$block['module']}|{$block['code']},") !== false) continue;

            /* 根据module和code生成区块的宽度和高度。 */
            $sizeConfig = !empty($this->config->block->size[$block['module']][$block['code']]) ? $this->config->block->size[$block['module']][$block['code']] : $this->config->block->defaultSize;
            if(empty($block['width'])) $block['width'] = reset(array_keys($sizeConfig));
            $block['height'] = zget($sizeConfig, $block['width'], reset($sizeConfig));

            $block['account']   = $account;   // 所属用户。
            $block['dashboard'] = $dashboard; // 所属仪表盘。
            $block['params']    = isset($block['params']) ? helper::jsonEncode($block['params']) : ''; // 配置项信息。
            $block['vision']    = $this->config->vision;                         // 所属用户界面。
            $block['left']      = $block['width'] == 1 ? 2 : 0;                  // 距左侧宽度。
            $block['top']       = $this->block->computeBlockTop((object)$block); // 距顶部高度。

            $this->block->create((object)$block);
        }
        if(dao::isError()) return false;

        /* 保存当前区块已经被初始化过的记录。 */
        $this->loadModel('setting')->setItem("$account.$dashboard.common.blockInited@$vision", '1');
        $this->loadModel('setting')->setItem("$account.$dashboard.block.initVersion", (string)$this->config->block->version);

        return true;
    }

    /**
     * 根据仪表盘获取可使用的模块列表。
     * Get module options when adding or editing blocks.
     *
     * @param  string    $dashboard
     * @access protected
     * @return string[]
     */
    protected function getAvailableModules($dashboard)
    {
        /* 只有在我的地盘仪表盘中添加区块才会选择对应模块，否则直接使用对应仪表盘所在的模块。*/
        /* Only when adding blocks to my dashboard can I select the corresponding module, otherwise I will directly use the module where the corresponding dashboard is located.*/
        if($dashboard != 'my') return array();

        $modules = $this->lang->block->moduleList;

        /* Unable to display the doc module on my dashboard. */
        unset($modules['doc']);

        if($this->config->global->flow != 'full') unset($modules['guide']);
        if($this->config->vision != 'rnd')        unset($modules['contribute']);

        /* 从配置项中取出不同模块的首页对应的控制器方法。*/
        /* Retrieve the controller method corresponding to the homepage of different modules from the configuration item.*/
        list($programModule, $programMethod)     = explode('-', $this->config->programLink);
        list($productModule, $productMethod)     = explode('-', $this->config->productLink);
        list($projectModule, $projectMethod)     = explode('-', $this->config->projectLink);
        list($executionModule, $executionMethod) = explode('-', $this->config->executionLink);

        $closedBlock = isset($this->config->block->closed) ? $this->config->block->closed : '';
        foreach($modules as $moduleKey => $moduleName)
        {
            if($moduleKey == 'todo') continue;
            /* Determine if the user has permission for the current module. */
            if(in_array($moduleKey, $this->app->user->rights['acls'])) unset($modules[$moduleKey]);

            $method = 'index';
            if($moduleKey == 'program')   $method = $programMethod;
            if($moduleKey == 'product')   $method = $productMethod;
            if($moduleKey == 'project')   $method = $projectMethod;
            if($moduleKey == 'execution') $method = $executionMethod;

            /* After obtaining module permissions, it is necessary to verify whether there is permission for the module homepage. */
            if(in_array($moduleKey, array('product', 'project', 'execution', 'qa')) && !common::hasPriv($moduleKey, $method)) unset($modules[$moduleKey]);

            /* 被永久关闭的区块删除对应选项。 */
            /* Delete corresponding options for blocks that have been permanently closed. */
            if(strpos(",$closedBlock,", ",$moduleKey|$moduleKey,") !== false) unset($modules[$moduleKey]);
            if(isset($this->lang->block->modules[$moduleKey]) && !$this->getAvailableCodes($moduleKey)) unset($modules[$moduleKey]);
        }

        return $modules;
    }

    /**
     * 根据模块获取可使用的区块列表。
     * Get block options when adding or editing blocks.
     *
     * @param  string        $module
     * @access protected
     * @return string[]|true
     */
    protected function getAvailableCodes($module)
    {
        $blocks = array();
        /* 获取当前模块下的所有区块列表。 */
        if($module && isset($this->lang->block->modules[$module]))
        {
            $blocks = $this->lang->block->modules[$module]->availableBlocks;
        }

        /* 过滤掉永久关闭的区块。 */
        if(isset($this->config->block->closed))
        {
            foreach($blocks as $blockKey => $blockName)
            {
                if(strpos(",{$this->config->block->closed},", ",{$module}|{$blockKey},") !== false) unset($blocks[$blockKey]);
            }
        }

        return $blocks;
    }

    /**
     * 根据区块获取区块相关可配置参数列表。
     * Get other form items when adding or editing blocks.
     *
     * @param  string    $module
     * @param  string    $code
     * @access protected
     * @return array
     */
    protected function getAvailableParams($module = '', $code = '')
    {
        /* 特殊的模块对code特殊处理。 */
        if($code == 'todo' || $code == 'list' || $module == 'assigntome')
        {
            $code = $module;
        }
        elseif($code == 'statistic')
        {
            $code = $module . $code;
        }

        $params = zget($this->config->block->params, $code, array());
        $params = json_decode(json_encode($params), true);

        return $params;
    }

    /**
     * 自动生成区块的默认标题。
     * Get block default title.
     *
     * @param mixed[] $modules
     * @param  string    $module
     * @param  array     $codes
     * @param  string    $code
     * @param  array     $params
     * @access protected
     * @return string
     */
    protected function getBlockTitle($modules, $module, $codes, $code, $params)
    {
        $blockTitle = zget($codes, $code, ''); // 标快的标题默认是区块列表下拉选中的内容。

        /* scrumtest以外的区块标题前面要根据选中的类型填充标题内容。 如：产品列表 => 已关闭的产品列表。 */
        if($module != 'scrumtest' || $code == 'all')
        {
            $options = isset($params['type']['options']) ? $params['type']['options'] : array();
            if(!empty($options)) $blockTitle = vsprintf($this->lang->block->blockTitle, array(reset($options), $blockTitle));
            if(empty($blockTitle) && !in_array($module, array('product', 'project', 'execution', 'qa'))) $blockTitle = zget($modules, $module, ''); // 特殊的区块标题使用模块列表选中的文本内容。 如：欢迎总览区块。
        }

        return $blockTitle;
    }

    /**
     * 处理每个区块以渲染 UI。
     * Process each block for render UI.
     *
     * @param  array     $blocks
     * @param  int       $projectID
     * @access protected
     * @return array
     */
    protected function processBlockForRender($blocks, $projectID)
    {
        /* 根据用户的权限，和当前系统开启的权限 处理区块列表。*/
        $acls = $this->app->user->rights['acls'];
        foreach($blocks as $key => $block)
        {
            /* 将没有开启功能区块过虑。 */
            if(!helper::hasFeature('project_risk') && ($block->code == 'waterfallrisk'  || $block->code == 'scrumrisk'))
            {
                unset($blocks[$key]);
                continue;
            }

            if(!helper::hasFeature('project_issue') && ($block->code == 'waterfallissue' || $block->code == 'scrumissue'))
            {
                unset($blocks[$key]);
                continue;
            }

            /* 过滤目前已经不存在的区块。 */
            if(!isset($this->lang->block->moduleList[$block->code]) && !isset($this->lang->block->modules[$block->module]->availableBlocks[$block->code]))
            {
                unset($blocks[$key]);
                continue;
            }

            /* 将没有视图权限的区块过滤。 */
            $module = $block->module;
            if(in_array($module, array('scrumproject', 'waterfallproject', 'waterfallplusproject', 'agileplusproject', 'ipdproject'))) $module = 'project';
            if($module == 'singleproduct') $module = 'product';
            if(!empty($module) && !in_array($module, array('welcome', 'guide', 'assigntome', 'zentaodynamic', 'teamachievement', 'dynamic', 'html')) && !empty($acls['views']) && !isset($acls['views'][$module]))
            {
                unset($blocks[$key]);
                continue;
            }

            /* 处理 params 信息中  count 的值，当没有  count 字段时 ，将 num 字段赋值给 count。 */
            $block->params = json_decode($block->params);
            if(isset($block->params->num) && !isset($block->params->count)) $block->params->count = $block->params->num;

            /* 生成更多链接。 */
            $this->createMoreLink($block, $projectID);

            $sizeConfig = !empty($this->config->block->size[$block->module][$block->code]) ? $this->config->block->size[$block->module][$block->code] : $this->config->block->defaultSize;

            /* 设置区块的默认宽度和高度。 */
            if(empty($block->width))  $block->width  = reset(array_keys($sizeConfig));
            if(empty($block->height)) $block->height = zget($sizeConfig, $block->width, reset($sizeConfig));

            /* 设置区块距离左侧的宽度和距离顶部的高度。 */
            if($block->left === '') $block->left = $block->width == 1 ? 2 : 0;
            if($block->top  === 0)  $block->top  = -1; // -1 将会自动计算高度。

            $block->width  = (int)$block->width;
            $block->height = (int)$block->height;
            $block->left   = (int)$block->left;
            $block->top    = (int)$block->top;
        }

        return $blocks;
    }

    /**
     * 补全区块的加载更多链接。
     * Get the more link of the block.
     *
     * @param  object    $block
     * @param  int       $projectID
     * @access protected
     * @return object
     */
    protected function createMoreLink($block, $projectID)
    {
        $module = empty($block->module) ? 'common' : $block->module;
        $params = helper::safe64Encode("module={$block->module}&projectID={$projectID}");

        $block->blockLink = $this->createLink('block', 'printBlock', "id=$block->id&params=$params");
        $block->moreLink  = '';
        if(isset($this->config->block->modules[$module]->moreLinkList->{$block->code}))
        {
            list($moduleName, $method, $vars) = explode('|', sprintf($this->config->block->modules[$module]->moreLinkList->{$block->code}, isset($block->params->type) ? $block->params->type : ''));

            /* The list assigned to me jumps to the work page when click more button. */
            $block->moreLink = $this->createLink($moduleName, $method, $vars);
            if($moduleName == 'my' && strpos($this->config->block->workMethods, $method) !== false)
            {
                /* 处理研发需求或任务列表区块点击更多后的跳转连接。 */
                if($moduleName == 'my' && $method == 'task' && $block->params->type != 'assignedTo' || $moduleName == 'my' && $method == 'story' && $block->params->type != 'assignedTo' && $block->params->type != 'reviewBy')
                {
                    $block->moreLink = $this->createLink('my', 'contribute', "module={$method}&type={$block->params->type}");
                }
                else
                {
                    $block->moreLink = $this->createLink($moduleName, 'work', 'mode=' . $method . '&' . $vars);
                }
            }
            elseif($moduleName == 'project' && $method == 'dynamic')
            {
                $block->moreLink = $this->createLink('project', 'dynamic', "projectID=$projectID&type=all");
            }
            elseif($moduleName == 'project' && $method == 'execution')
            {
                $block->moreLink = $this->createLink('project', 'execution', "status=all&projectID=$projectID");
            }
            elseif($moduleName == 'project' && $method == 'testtask')
            {
                $block->moreLink = $this->createLink('project', 'testtask', "projectID=$projectID");
            }
            elseif($moduleName == 'testtask' && $method == 'browse')
            {
                $block->moreLink = $this->createLink('testtask', 'browse', 'productID=0&branch=0&type=all,totalStatus');
            }
            elseif($block->code == 'recentproject' || $block->code == 'project')
            {
                $block->moreLink = $this->config->vision == 'or' ? $this->createLink('marketresearch', 'all') : $this->createLink('project', 'browse');
            }
        }
        elseif($block->code == 'dynamic')
        {
            $block->moreLink = $this->createLink('my', 'dynamic');
        }

        return $block;
    }

    /**
     * 打印动态区块。
     * latest dynamic.
     *
     * @access protected
     * @return void
     */
    protected function printDynamicBlock()
    {
        $this->view->actions = $this->loadModel('action')->getDynamic('all', 'today', 'date_desc', 30);
        $this->view->users   = $this->loadModel('user')->getPairs('nodeleted|noletter|all', '', 0, array_unique(array_column($this->view->actions, 'actor')));
    }

    /**
     * 打印禅道官网最新动态。
     * Latest dynamic by zentao official.
     *
     * @access protected
     * @return void
     */
    protected function printZentaoDynamicBlock()
    {
        $this->view->dynamics = array();

        $this->app->loadModuleConfig('admin');

        /* 检查服务端是否联网。 */
        $hasInternet = $this->session->hasInternet;
        if(empty($hasInternet))
        {
            $hasInternet = $this->loadModel('admin')->checkInternet();
            $this->session->set('hasInternet', $hasInternet);
            if(!$hasInternet) return;
        }
        if($this->session->isSlowNetwork) return;

        /* 调取接口获取数据。 */
        $startTime = microtime(true);
        $result    = json_decode(preg_replace('/[[:cntrl:]]/mu', '', common::http(sprintf($this->config->admin->dynamicAPIURL, $this->config->version))));

        /* 请求超过一定时间后判断为网络请求缓慢。 */
        if(microtime(true) - $startTime > $this->config->timeout / 1000) $this->session->set('isSlowNetwork', true);

        $dynamics = array();
        if(!empty($result->data))
        {
            $data = $result->data;
            /* 如果存在活动时间大于当前时间的禅道中国行的动态，则优先展示此类动态。 */
            if(!empty($data->zentaosalon) && time() < strtotime($data->zentaosalon->time))
            {
                $data->zentaosalon->title     = $this->lang->block->zentaodynamic->zentaosalon;
                $data->zentaosalon->label     = formatTime($data->zentaosalon->time, DT_DATE4) . ' ' . $data->zentaosalon->name;
                $data->zentaosalon->linklabel = $this->lang->block->zentaodynamic->registration;
                $dynamics[] = $data->zentaosalon;
            }

            /* 如果存在活动时间大于当前时间的禅道公开课的动态，则次优先展示此类动态。 */
            if(!empty($data->publicclass) && time() < strtotime($data->zentaosalon->time))
            {
                $data->publicclass->title     = $this->lang->block->zentaodynamic->publicclass;
                $data->publicclass->label     = formatTime($data->publicclass->time, DT_DATE4) . ' ' . $this->lang->datepicker->dayNames[date('w', strtotime($data->publicclass->time))] . ' ' . formatTime($data->publicclass->time, 'H:i');
                $data->publicclass->linklabel = $this->lang->block->zentaodynamic->reservation;
                $dynamics[] = $data->publicclass;
            }

            /* 啥都没有就展示禅道的发布动态。 */
            if(!empty($data->release))
            {
                foreach($data->release as $release)
                {
                    $releaseLength      = strpos($release->content, $this->lang->release->common);
                    $release->title     = $this->lang->block->zentaodynamic->release;
                    $release->label     = $releaseLength > 0 && $releaseLength <= 30 ? mb_strcut($release->content, 0, $releaseLength + 8) : formatTime($release->time, DT_DATE4) . ' ' . $this->lang->datepicker->dayNames[date('w', strtotime($release->time))];
                    $release->linklabel = false;

                    $dynamics[] = $release;
                }
            }
        }
        $this->view->dynamics = $dynamics;
    }

    /**
     * 打印欢迎总览区块。
     * Welcome block.
     *
     * @access protected
     * @return void
     */
    protected function printWelcomeBlock()
    {
        /* 计算当前时间是早上还是中午还是下午还是晚上。 */
        $time = date('H:i');
        $welcomeType = '19:00';
        foreach($this->lang->block->welcomeList as $type => $name) $welcomeType = $time >= $type ? $type : $welcomeType;

        $usageDays = '';
        $dateUsed  = $this->loadModel('admin')->genDateUsed();
        if(!empty($dateUsed->year))  $usageDays .= $dateUsed->year  . ' ' . $this->lang->year  . ' ';
        if(!empty($dateUsed->month)) $usageDays .= $dateUsed->month . ' ' . $this->lang->month . ' ';
        if(!empty($dateUsed->day))   $usageDays .= $dateUsed->day   . ' ' . $this->lang->day   . ' ';
        if(!$usageDays) $usageDays = "0 {$this->lang->day}";
        if(strpos($this->app->getClientLang(), 'zh') !== false) $usageDays = str_replace(' ', '', $usageDays);

        $yesterday = strtotime("-1 day");
        $year  = date('Y', $yesterday);
        $month = date('m', $yesterday);
        $day   = date('d', $yesterday);

        /* 获取昨日完成的任务数。 */
        $finishTask      = 0;
        $finishTaskGroup = $this->loadModel('metric')->getResultByCodeWithArray('count_of_daily_finished_task_in_user', array('user' => $this->app->user->account, 'year' => $year, 'month' => $month, 'day' => $day), 'cron', null, $this->config->vision);
        if(!empty($finishTaskGroup))
        {
            foreach($finishTaskGroup as $finishTaskData)
            {
                if($finishTaskData['user'] == $this->app->user->account && $year == $finishTaskData['year'] && $month == $finishTaskData['month'] && $day == $finishTaskData['day'])
                {
                    $finishTask = $finishTaskData['value'];
                    break;
                }
            }
        }

        /* 获取昨日解决的Bug数。 */
        $fixBug      = 0;
        $fixBugGroup = $this->metric->getResultByCodeWithArray('count_of_daily_fixed_bug_in_user', array('user' => $this->app->user->account, 'year' => $year, 'month' => $month, 'day' => $day), 'cron', null, $this->config->vision);
        if(!empty($fixBugGroup))
        {
            foreach($fixBugGroup as $fixBugData)
            {
                if($fixBugData['user'] == $this->app->user->account && $year == $fixBugData['year'] && $month == $fixBugData['month'] && $day == $fixBugData['day'])
                {
                    $fixBug = $fixBugData['value'];
                    break;
                }
            }
        }

        /* 根据完成任务和修复bug的数量给与称号。 */
        $honorary = '';
        if($finishTask || $fixBug)
        {
            $honorary = $finishTask > $fixBug ? 'task' : 'bug';
            $honorary = zget($this->lang->block->honorary, $honorary, '');
        }

        /* 生成指派给我的数据。 */
        $assignToMe = array();
        foreach($this->lang->block->welcome->assignList as $field => $label)
        {
            $type = 'assignedTo';
            if($field == 'testcase') $type = 'assigntome';
            if($field == 'ticket')   $type = 'assignedtome';

            /* 根据不同的模块生成不同的度量项查询码。 */
            $code = "assigned_{$field}";
            if($field == 'story')    $code = "pending_story";
            if($field == 'testcase') $code = "assigned_case";

            /* 查询当前指派给当前用户的不同数据。 */
            $assignedGroup = $this->metric->getResultByCode("count_of_{$code}_in_user", array('user' => $this->app->user->account), 'realtime', null, $field != 'feedback' ? $this->config->vision : '');
            $count = 0;
            if(!empty($assignedGroup))
            {
                $assignedGroup = reset($assignedGroup);
                $count         = zget($assignedGroup, 'value', 0);
            }
            $assignToLink = '';
            if(common::hasPriv('my', 'work')       && $this->config->vision != 'lite') $assignToLink = helper::createLink('my', 'work',       "mode=$field&type=$type");
            if(common::hasPriv('my', 'contribute') && $this->config->vision == 'lite') $assignToLink = helper::createLink('my', 'contribute', "mode=$field&type=$type");
            $assignToMe[$field] = array('number' => $count, 'href' => $assignToLink);
        }

        /* 生成待我审批的数据。 */
        $reviewList = $this->loadModel('my')->getReviewingList('all');
        $reviewByMe['reviewByMe'] = array('number' => count($reviewList), 'href' => common::hasPriv('my', 'audit') && $this->config->vision != 'lite' ? helper::createLink('my', 'audit') : '');

        $isEn = $this->app->getClientLang() == 'en';
        /* 生成欢迎语。 */
        $yesterdaySummary = '';
        if($finishTask || $fixBug)
        {

            $separator = $isEn ? ', ' : '、';
            $comma     = $isEn ? ' ' : $this->lang->comma;
            if($finishTask) $yesterdaySummary .= sprintf($this->lang->block->summary->finishTask, $finishTask) . ($fixBug ? $separator : $comma);
            if($isEn)
            {
                if($finishTask && $fixBug)  $yesterdaySummary .= sprintf($this->lang->block->summary->fixBugEn, $fixBug) ;
                if($fixBug && !$finishTask) $yesterdaySummary .= sprintf($this->lang->block->summary->fixBug, $fixBug);
            }
            else
            {
                if($fixBug) $yesterdaySummary .= sprintf($this->lang->block->summary->fixBug, $fixBug) . $this->lang->comma;
            }
        }
        else
        {
            $yesterdaySummary .= $this->lang->block->summary->noWork;
        }

        if($isEn)
        {
            $yesterdaySummary = $yesterdaySummary . ' ' . $this->lang->block->summary->yesterday;
        }
        else
        {
            $yesterdaySummary = $this->lang->block->summary->yesterday . $yesterdaySummary;
        }

        $welcomeSummary   = sprintf($this->lang->block->summary->welcome, $usageDays, $yesterdaySummary);

        $this->view->todaySummary   = date(DT_DATE3, time()) . ' ' . $this->lang->datepicker->dayNames[date('w', time())]; // 当前年月日 星期几。
        $this->view->welcomeType    = $welcomeType;
        $this->view->usageDays      = $usageDays;
        $this->view->finishTask     = $finishTask;
        $this->view->fixBug         = $fixBug;
        $this->view->honorary       = $honorary;
        $this->view->assignToMe     = $assignToMe;
        $this->view->reviewByMe     = $reviewByMe;
        $this->view->welcomeSummary = $welcomeSummary;
    }

    /**
     * 打印任务列表区块。
     * Print task block.
     *
     * @params object     $block
     * @access protected
     * @return void
     * @param object $block
     */
    protected function printTaskBlock($block)
    {
        $this->session->set('taskList',  $this->createLink('my', 'index'), 'execution');
        if(preg_match('/[^a-zA-Z0-9_]/', $block->params->type)) return;

        $account = $this->app->user->account;
        $type    = $block->params->type;

        $this->app->loadLang('execution');
        $this->view->tasks = $this->loadModel('task')->getUserTasks($account, $type, $this->viewType == 'json' ? 0 : (int)$block->params->count, null, $block->params->orderBy);;
    }

    /**
     * 打印Bug列表区块。
     * Print bug block.
     *
     * @params object     $block
     * @access protected
     * @return void
     * @param object $block
     */
    protected function printBugBlock($block)
    {
        $this->session->set('bugList', $this->createLink('my', 'index'), 'qa');
        if(preg_match('/[^a-zA-Z0-9_]/', $block->params->type)) return;

        /* 如果是我的地盘则展示所有项目， 否则展示当前项目数据。 */
        $projectID = $this->lang->navGroup->qa  == 'project' ? $this->session->project : 0;
        $projectID = $block->dashboard == 'my' ? 0 : $projectID;

        $this->view->bugs = $this->loadModel('bug')->getUserBugs($this->app->user->account, $block->params->type, $block->params->orderBy, $this->viewType == 'json' ? 0 : (int)$block->params->count, null, $projectID);
    }

    /**
     * 打印用例列表区块。
     * Print case block.
     *
     * @params object     $block
     * @access protected
     * @return void
     * @param object $block
     */
    protected function printCaseBlock($block)
    {
        $this->session->set('caseList', $this->createLink('my', 'index'), 'qa');
        $this->app->loadLang('testcase');
        $this->app->loadLang('testtask');

        /* 如果是我的地盘则展示所有项目， 否则展示当前项目数据。 */
        $projectID = $this->lang->navGroup->qa  == 'project' ? $this->session->project : 0;
        $projectID = $block->dashboard == 'my' ? 0 : $projectID;

        $cases = array();
        if($block->params->type == 'assigntome')
        {
            $cases = $this->dao->select('t1.assignedTo AS assignedTo, t2.*')->from(TABLE_TESTRUN)->alias('t1')
                ->leftJoin(TABLE_CASE)->alias('t2')->on('t1.case = t2.id')
                ->leftJoin(TABLE_TESTTASK)->alias('t3')->on('t1.task = t3.id')
                ->Where('t1.assignedTo')->eq($this->app->user->account)
                ->andWhere('t1.status')->ne('done')
                ->andWhere('t3.status')->ne('done')
                ->andWhere('t3.deleted')->eq(0)
                ->andWhere('t2.deleted')->eq(0)
                ->beginIF($projectID)->andWhere('t2.project')->eq($projectID)->fi()
                ->orderBy($block->params->orderBy)
                ->beginIF($this->viewType != 'json')->limit((int)$block->params->count)->fi()
                ->fetchAll();
        }
        elseif($block->params->type == 'openedbyme')
        {
            $cases = $this->dao->findByOpenedBy($this->app->user->account)->from(TABLE_CASE)
                ->andWhere('deleted')->eq(0)
                ->beginIF($projectID)->andWhere('project')->eq($projectID)->fi()
                ->orderBy($block->params->orderBy)
                ->beginIF($this->viewType != 'json')->limit((int)$block->params->count)->fi()
                ->fetchAll();
        }
        $this->view->cases = $cases;
    }

    /**
     * 打印测试单区块。
     * Print testtask block.
     *
     * @params object $block
     * @access public
     * @return void
     * @param object $block
     */
    public function printTesttaskBlock($block)
    {
        $this->app->loadLang('testtask');

        $uri = $this->createLink('my', 'index');
        $this->session->set('productList',  $uri, 'product');
        $this->session->set('testtaskList', $uri, 'qa');
        $this->session->set('buildList',    $uri, 'execution');
        if(preg_match('/[^a-zA-Z0-9_]/', $block->params->type)) return;

        $this->view->projects  = $this->loadModel('project')->getPairsByProgram();
        $this->view->testtasks = $this->dao->select("DISTINCT t1.*,t2.name as productName,t2.shadow,t3.name as buildName,t4.name as projectName, CONCAT(t4.name, '/', t3.name) as executionBuild")->from(TABLE_TESTTASK)->alias('t1')
            ->leftJoin(TABLE_PRODUCT)->alias('t2')->on('t1.product=t2.id')
            ->leftJoin(TABLE_BUILD)->alias('t3')->on('t1.build=t3.id')
            ->leftJoin(TABLE_PROJECT)->alias('t4')->on('t1.execution=t4.id')
            ->leftJoin(TABLE_PROJECTPRODUCT)->alias('t5')->on('t1.execution=t5.project')
            ->where('t1.deleted')->eq('0')
            ->andWhere('t1.auto')->ne('unit')
            ->beginIF(!$this->app->user->admin)->andWhere('t1.product')->in($this->app->user->view->products)->fi()
            ->beginIF(!$this->app->user->admin)->andWhere('t1.execution')->in($this->app->user->view->sprints)->fi()
            ->andWhere('t1.product = t5.product')
            ->beginIF($block->params->type != 'all')->andWhere('t1.status')->eq($block->params->type)->fi()
            ->orderBy('t1.id desc')
            ->beginIF($this->viewType != 'json')->limit((int)$block->params->count)->fi()
            ->fetchAll();
    }

    /**
     * 打印研发需求区块。
     * Print story block.
     *
     * @params object     $block
     * @access protected
     * @return void
     * @param object $block
     */
    protected function printStoryBlock($block)
    {
        $this->session->set('storyList', $this->createLink('my', 'index'), 'product');
        if(preg_match('/[^a-zA-Z0-9_]/', $block->params->type)) return;

        $this->app->loadClass('pager', true);
        $count   = isset($block->params->count) ? (int)$block->params->count : 0;
        $pager   = pager::init(0, $count , 1);
        $type    = isset($block->params->type) ? $block->params->type : 'assignedTo';
        $orderBy = isset($block->params->type) ? $block->params->orderBy : 'id_asc';

        $this->view->stories = $this->loadModel('story')->getUserStories($this->app->user->account, $type, $orderBy, $this->viewType != 'json' ? $pager : '', 'story');
    }

    /**
     * 打印产品计划列表区块。
     * Print plan block.
     *
     * @param  object    $block
     * @access protected
     * @return bool
     */
    protected function printPlanBlock($block)
    {
        $uri = $this->createLink('my', 'index');
        $this->session->set('productList', $uri, 'product');
        $this->session->set('productPlanList', $uri, 'product');

        $this->app->loadClass('pager', true);
        $count = isset($block->params->count) ? (int)$block->params->count : 0;
        $pager = pager::init(0, $count , 1);

        $this->view->products = $this->loadModel('product')->getPairs();
        $this->view->plans    = $this->loadModel('productplan')->getList(0, 0, 'all', $pager, 'begin_desc', 'noproduct|' . zget($block->params, 'type', ''));
    }

    /**
     * 打印产品发布列表区块数据。
     * Print releases block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printReleaseBlock($block)
    {
        $uri = $this->createLink('my', 'index');
        $this->session->set('releaseList', $uri, 'product');
        $this->session->set('buildList', $uri, 'execution');

        $type = $block->params->type;
        $this->app->loadLang('release');
        $this->view->releases = $this->dao->select('t1.*,t2.name as productName')->from(TABLE_RELEASE)->alias('t1')
            ->leftJoin(TABLE_PRODUCT)->alias('t2')->on('t1.product=t2.id')
            ->where('t1.deleted')->eq('0')
            ->andWhere('t2.shadow')->eq(0)
            ->beginIF(strpos($type, 'noclosed') !== false)->andWhere('t2.status')->ne('closed')->fi()
            ->beginIF(strpos("|$type|", '|closed|') !== false)->andWhere('t2.status')->eq('closed')->fi()
            ->beginIF(!$this->app->user->admin)->andWhere('t1.product')->in($this->app->user->view->products)->fi()
            ->orderBy('t1.id desc')
            ->beginIF($this->viewType != 'json')->limit((int)$block->params->count)->fi()
            ->fetchAll();
        $this->view->builds = $this->dao->select('id,name')->from(TABLE_BUILD)->where('deleted')->eq(0)->fetchPairs();
    }

    /**
     * 打印产品路线图区块数据。
     * Print roadmap block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printRoadmapBlock($block)
    {
        $productID = $this->session->product;
        $product   = $this->loadModel('product')->getByID($productID);

        $roadmaps = $this->product->getRoadmap($productID, 'all');
        $branches = $product->type == 'normal' ? array(0 => '') : $this->loadModel('branch')->getPairs($productID, 'active');

        /* Assign view data. */
        $this->view->title    = $product->name . $this->lang->hyphen . $this->lang->product->roadmap;
        $this->view->product  = $product;
        $this->view->roadmaps = $roadmaps;
        $this->view->branches = $branches;
    }

    /**
     * 打印产品发布统计区块数据。
     * Print product release statistic block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printReleaseStatisticBlock($block)
    {
        /* 获取最近六个月的年月数组。 */
        $years  = array();
        $months = array();
        $dates  = array();
        for($i = 5; $i >= 0; $i --)
        {
            $years[]  = date('Y',   strtotime("first day of -{$i} month"));
            $months[] = date('m',   strtotime("first day of -{$i} month"));
            $dates[]  = date('Y-m', strtotime("first day of -{$i} month"));
        }

        /* 从度量项获取所有产品的月度发布次数的数据。 */
        $monthRelease = $this->loadModel('metric')->getResultByCodeWithArray('count_of_monthly_created_release', array('year' => join(',', $years), 'month' => join(',', $months)), 'cron');

        /* 获取各个产品的年度(今年)发布次数。 */
        $products      = $this->loadModel('product')->getOrderedProducts('all', 0, 0, 'all');
        $productIdList = array_keys($products);
        $releaseGroup  = $this->metric->getResultByCodeWithArray('count_of_annual_created_release_in_product', array('product' => join(',', $productIdList), 'year' => date('Y')), 'cron');

        foreach($dates as $date)
        {
            $releaseData[$date]  = 0;
            if(!empty($monthRelease))
            {
                foreach($monthRelease as $release)
                {
                    if($date == "{$release['year']}-{$release['month']}") $releaseData[$date] = $release['value'];
                }
            }
        }

        /* 组装成由产品名称和发布次数组成的数组。 */
        $releases = array();
        foreach($products as $product)
        {
            $releases[$product->name] = 0;
            if(!empty($releaseGroup))
            {
                foreach($releaseGroup as $release)
                {
                    if($product->id == $release['product'] && date('Y') == $release['year']) $releases[$product->name] = $release['value'];
                }
            }
        }
        arsort($releases); // 按发布次数从高到低排序。

        $this->view->releaseData = $releaseData;
        $this->view->releases    = $releases;
    }

    /**
     * 打印版本区块。
     * Print Build block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printBuildBlock($block)
    {
        $this->session->set('buildList', $this->createLink('my', 'index'), 'execution');
        $this->app->loadLang('build');

        $builds = $this->dao->select('t1.*, t2.name AS productName, t2.shadow, t3.name AS projectName')->from(TABLE_BUILD)->alias('t1')
            ->leftJoin(TABLE_PRODUCT)->alias('t2')->on('t1.product=t2.id')
            ->leftJoin(TABLE_PROJECT)->alias('t3')->on('t1.project=t3.id')
            ->where('t1.deleted')->eq('0')
            ->beginIF(!$this->app->user->admin)->andWhere('t1.execution')->in($this->app->user->view->sprints)->fi()
            ->beginIF($block->dashboard != 'my' && $this->session->project)->andWhere('t1.project')->eq((int)$this->session->project)->fi()
            ->orderBy('t1.id desc')
            ->beginIF($this->viewType != 'json')->limit((int)$block->params->count)->fi()
            ->fetchAll();

        $this->view->builds = $builds;
    }

    /**
     * 打印项目列表区块。
     * Print project block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printProjectBlock($block)
    {
        $this->app->loadLang('execution');
        $this->app->loadLang('task');
        $count   = isset($block->params->count)   ? $block->params->count   : 15;
        $type    = isset($block->params->type)    ? $block->params->type    : 'all';
        $orderBy = isset($block->params->orderBy) ? $block->params->orderBy : 'id_desc';

        $this->view->projects = $this->loadModel('project')->getOverviewList($type, 0, $orderBy, $count);
        $this->view->users    = $this->loadModel('user')->getPairs('noletter', '', 0, array_unique(array_column($this->view->projects, 'PM')));
    }

    /**
     * 打印产品列表区块。
     * Print product block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printProductListBlock($block)
    {
        $this->app->loadClass('pager', true);
        $count = isset($block->params->count) ? (int)$block->params->count : 0;
        $type  = isset($block->params->type) ? $block->params->type : '';
        $pager = pager::init(0, $count , 1);

        $products = $this->loadModel('product')->getList(0, $type);
        $productStats = $this->product->getStats(array_keys($products), 'order_desc', $this->viewType != 'json' ? $pager : '');
        $this->view->productStats = $productStats;

        $this->view->users      = $this->loadModel('user')->getPairs('noletter');
        $this->view->avatarList = $this->user->getAvatarPairs();
    }

    /**
     * 打印项目概况区块。
     * Get data of the project overview block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printProjectOverviewBlock($block)
    {
        $this->loadModel('metric');

        /* 通过度量项获取项目总量数据。 */
        $projectCount = 0;
        $projectCountGroup = $this->metric->getResultByCodeWithArray('count_of_project', array(), 'cron');
        if(!empty($projectCountGroup))
        {
            $projectCountGroup = reset($projectCountGroup);
            $projectCount      = zget($projectCountGroup, 'value', 0);
        }

        /* 通过度量项获取最近三年完成的项目数据。 */
        $years = array();
        $i     = 3;
        foreach(array('lastTwoYear', 'lastYear', 'thisYear') as $year)
        {
            $i --;
            $years[$year] = date('Y', strtotime("first day of -{$i} year"));
        }
        $finishedProjectGroup = $this->metric->getResultByCodeWithArray('count_of_annual_finished_project', array('year' => join(',', $years)), 'cron');
        if($finishedProjectGroup) $finishedProjectGroup = array_column($finishedProjectGroup, null, 'year');

        /* 组装前台所需的cards数组。 */
        $cards = array();
        $cards[0] = new stdclass();
        $cards[0]->value = $projectCount;
        $cards[0]->class = 'text-primary';
        $cards[0]->label = $this->lang->block->projectoverview->totalProject;
        $cards[0]->url   = common::hasPriv('project', 'browse') ? helper::createLink('project', 'browse', 'programID=0&browseType=all') : null;

        $cards[1] = new stdclass();
        $cards[1]->value = isset($finishedProjectGroup[date('Y')]['value']) ? $finishedProjectGroup[date('Y')]['value'] : 0;
        $cards[1]->label = $this->lang->block->projectoverview->thisYear;

        $cardGroup = new stdclass();
        $cardGroup->type  = 'cards';
        $cardGroup->cards = $cards;

        /* 获取最近三年最多完成的项目数量。 */
        $maxCount = 0;
        if($finishedProjectGroup)
        {
            foreach($finishedProjectGroup as $data)
            {
                if($maxCount < $data['value']) $maxCount = $data['value'];
            }

        }

        /* 组将前台柱状图所需的bars数组。 */
        $bars = array();
        foreach($years as $code => $year)
        {
            $bar = new stdclass();
            $bar->label = $year;
            $bar->value = isset($finishedProjectGroup[$year]['value']) ? $finishedProjectGroup[$year]['value'] : 0;;
            $bar->rate  = $maxCount ? round($bar->value / $maxCount * 100) . '%' : '0%';

            $bars[] = $bar;
        }

        $barGroup = new stdclass();
        $barGroup->type  = 'barChart';
        $barGroup->title = $this->lang->block->projectoverview->lastThreeYear;
        $barGroup->bars  = $bars;

        $this->view->groups = array($cardGroup, $barGroup);
    }

    /**
     * 打印项目统计区块。
     * Print project statistic block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printProjectStatisticBlock($block)
    {
        if(!empty($block->params->type) && preg_match('/[^a-zA-Z0-9_]/', $block->params->type)) return;

        /* Set project status and count. */
        $status = isset($block->params->type)  ? $block->params->type       : 'all';
        $count  = isset($block->params->count) ? (int)$block->params->count : 15;

        /* Get projects. */
        $excludedModel = ($this->config->edition == 'max' or $this->config->edition == 'ipd') ? '' : 'waterfall,waterfallplus';
        $projects      = $this->loadModel('project')->getProjectList($status, 'order_asc', $count, '');
        $projectIdList = array_keys($projects);

        /* Get metric data. */
        $data = $this->getProjectsStatisticData($projectIdList);

        /* 将获取的度量数据塞入项目列表数据中。 */
        $this->app->loadClass('pager', true);
        $pager = pager::init(0, 3, 1);
        foreach($projects as $project) $project = $this->buildProjectStatistic($project, $data, $pager);

        $this->view->projects = $projects;
        $this->view->users    = $this->loadModel('user')->getPairs('noletter');
    }

    /**
     * 打印产品统计区块。
     * Print product statistic block.
     *
     * @param  object    $block
     * @access protected
     * @return bool
     */
    protected function printProductStatisticBlock($block)
    {
        /* 获取需要统计的产品列表。 */
        /* Obtain a list of products that require statistics. */
        $status         = isset($block->params->type)  ? $block->params->type  : '';
        $count          = isset($block->params->count) ? $block->params->count : '';
        $products       = $this->loadModel('product')->getOrderedProducts($status, (int)$count, 0, 'all');
        $productIdList  = array_keys($products);

        $this->loadModel('metric');
        /* 按照产品分组获取产品需求交付率度量项。 */
        $storyDeliveryRate = $this->metric->getResultByCodeWithArray('rate_of_delivery_story_in_product',   array('product' => join(',', $productIdList)), 'cron');

        /* 按照产品分组获取产品有效需求数度量项。 */
        $totalStories      = $this->metric->getResultByCodeWithArray('count_of_valid_story_in_product',     array('product' => join(',', $productIdList)), 'cron');

        /* 按照产品分组获取产品已交付需求数度量项。 */
        $closedStories     = $this->metric->getResultByCodeWithArray('count_of_delivered_story_in_product', array('product' => join(',', $productIdList)), 'cron');

        /* 按照产品分组获取产品未关闭需求数度量项。 */
        $unclosedStories   = $this->metric->getResultByCodeWithArray('count_of_unclosed_story_in_product',  array('product' => join(',', $productIdList)), 'cron');

        if(!empty($storyDeliveryRate)) $storyDeliveryRate = array_column($storyDeliveryRate, null, 'product');
        if(!empty($totalStories))      $totalStories      = array_column($totalStories,      null, 'product');
        if(!empty($closedStories))     $closedStories     = array_column($closedStories,     null, 'product');
        if(!empty($unclosedStories))   $unclosedStories   = array_column($unclosedStories,   null, 'product');

        /* 按照产品和日期分组获取产品每月新增和完成的需求数度量项。 */
        $years  = array();
        $months = array();
        $dates  = array();
        for($i = 5; $i >= 0; $i --)
        {
            $years[]  = date('Y',   strtotime("first day of -{$i} month"));
            $months[] = date('m',   strtotime("first day of -{$i} month"));
            $dates[]  = date('Y-m', strtotime("first day of -{$i} month"));
        }
        $monthFinish  = $this->metric->getResultByCodeWithArray('count_of_monthly_finished_story_in_product', array('product' => join(',', $productIdList), 'year' => join(',', $years), 'month' => join(',', $months)), 'cron');
        $monthCreated = $this->metric->getResultByCodeWithArray('count_of_monthly_created_story_in_product',  array('product' => join(',', $productIdList), 'year' => join(',', $years), 'month' => join(',', $months)), 'cron');

        /* 根据产品列表获取预计开始日期距离现在最近且预计开始日期大于当前日期的未开始状态计划。 */
        /* Obtain an unstarted status plan based on the product list, with an expected start date closest to the current date and an expected start date greater than the current date. */
        $newPlan = $this->dao->select('*')->from(TABLE_PRODUCTPLAN)
            ->where('deleted')->eq('0')
            ->andWhere('product')->in($productIdList)
            ->andWhere('begin')->ge(date('Y-m-d'))
            ->andWhere('status')->eq('wait')
            ->orderBy('begin_desc,id_desc')
            ->fetchGroup('product');

        /* 根据产品列表获取实际开始日期距离当前最近的进行中状态的执行。 */
        /* Obtain the execution of the current in progress status closest to the actual start date based on the product list. */
        $newExecution = $this->dao->select('execution.*,relation.product')->from(TABLE_EXECUTION)->alias('execution')
            ->leftJoin(TABLE_PROJECTPRODUCT)->alias('relation')->on('execution.id=relation.project')
            ->where('execution.deleted')->eq('0')
            ->andWhere('execution.type')->eq('sprint')
            ->andWhere('relation.product')->in($productIdList)
            ->andWhere('execution.status')->eq('doing')
            ->orderBy('realBegan_desc,id_desc')
            ->fetchGroup('product');

        /* 根据产品列表获取发布日期距离现在最近且发布日期小于当前日期的发布。 */
        /* Retrieve releases with the latest release date from the product list and a release date earlier than the current date. */
        $newRelease = $this->dao->select('*')->from(TABLE_RELEASE)
            ->where('deleted')->eq('0')
            ->andWhere('product')->in($productIdList)
            ->andWhere('date')->le(date('Y-m-d'))
            ->orderBy('date_desc,id_desc')
            ->fetchGroup('product');

        /* 将按照产品分组的统计数据放入产品列表中。 */
        /* Place statistical data grouped by product into the product list. */
        foreach($products as $productID => $product)
        {
            $product->storyDeliveryRate = isset($storyDeliveryRate[$productID]['value']) ? $storyDeliveryRate[$productID]['value'] * 100 : 0;
            $product->totalStories      = isset($totalStories[$productID]['value'])      ? $totalStories[$productID]['value']            : 0;
            $product->closedStories     = isset($closedStories[$productID]['value'])     ? $closedStories[$productID]['value']           : 0;
            $product->unclosedStories   = isset($unclosedStories[$productID]['value'])   ? $unclosedStories[$productID]['value']         : 0;
            $product->newPlan           = isset($newPlan[$productID])      ? current($newPlan[$productID])      : '';
            $product->newExecution      = isset($newExecution[$productID]) ? current($newExecution[$productID]) : '';
            $product->newRelease        = isset($newRelease[$productID])   ? current($newRelease[$productID])   : '';

            foreach($dates as $date)
            {
                if(strtotime($date) < strtotime(substr($product->createdDate, 0, 7))) continue;

                $product->monthFinish[$date]  = 0;
                $product->monthCreated[$date] = 0;
                if(!empty($monthFinish))
                {
                    foreach($monthFinish as $story)
                    {
                        if($date == "{$story['year']}-{$story['month']}" && $productID == $story['product']) $product->monthFinish[$date] = $story['value'];
                    }
                }
                if(!empty($monthCreated))
                {
                    foreach($monthCreated as $story)
                    {
                        if($date == "{$story['year']}-{$story['month']}" && $productID == $story['product']) $product->monthCreated[$date] = $story['value'];
                    }
                }
            }
        }

        $this->view->products = $products;
    }

    /**
     * 打印执行统计区块。
     * Print execution statistic block.
     *
     * @param  object    $block
     * @param  array     $params
     * @access protected
     * @return void
     */
    protected function printExecutionStatisticBlock($block, $params = array())
    {
        if(!empty($block->params->type) && preg_match('/[^a-zA-Z0-9_]/', $block->params->type)) return;

        $status  = isset($block->params->type)  ? $block->params->type : 'undone';
        $count   = isset($block->params->count) ? (int)$block->params->count : 0;

        /* Get projects. */
        $projectID = $block->dashboard == 'my' ? 0 : (int)$this->session->project;
        if(isset($params['project'])) $projectID = (int)$params['project'];

        $executions    = $this->loadModel('execution')->getOrderedExecutions($projectID, $status, $count, 'skipparent');
        $projectIdList = $this->loadModel('project')->getProjectExecutionPairs('1', $status);
        if(empty($executions))
        {
            $this->view->chartData        = array('labels' => array(), 'baseLine' => array(), 'burnLine' => array());
            $this->view->executions       = array();
            $this->view->projects         = $this->project->getPairsByIdList(array_keys($projectIdList));
            $this->view->currentProjectID = $projectID;
            return;
        }

        $executionID = isset($params['active']) && isset($executions[$params['active']]) ? $params['active'] : key($executions);
        $execution   = $executions[$executionID];

        $this->loadModel('metric');
        $estimateGroup       = $this->metric->getResultByCodeWithArray('estimate_of_task_in_execution',              array('execution' => $executionID), 'cron'); // 从度量项获取执行的预计工时。
        $consumeGroup        = $this->metric->getResultByCodeWithArray('consume_of_task_in_execution',               array('execution' => $executionID), 'cron'); // 从度量项获取执行的消耗工时。
        $leftGroup           = $this->metric->getResultByCodeWithArray('left_of_task_in_execution',                  array('execution' => $executionID), 'cron'); // 从度量项获取执行的剩余工时。
        $developedStoryGroup = $this->metric->getResultByCodeWithArray('count_of_developed_story_in_execution',      array('execution' => $executionID), 'cron'); // 从度量项获取执行的已完成需求。
        $totalStoryGroup     = $this->metric->getResultByCodeWithArray('count_of_story_in_execution',                array('execution' => $executionID), 'cron'); // 从度量项获取执行的总需求数量。
        $yesterday           = strtotime("-1 day");
        $totalTaskGroup      = $this->metric->getResultByCodeWithArray('count_of_task_in_execution',                 array('execution' => $executionID), 'cron'); // 从度量项获取执行的任务总数。
        $unfinishedTaskGroup = $this->metric->getResultByCodeWithArray('count_of_unfinished_task_in_execution',      array('execution' => $executionID), 'cron'); // 从度量项获取执行的未完成任务。
        $dailyFinishedGroup  = $this->metric->getResultByCodeWithArray('count_of_daily_finished_task_in_execution ', array('execution' => $executionID, 'year' => date('Y', $yesterday), 'month' => date('m', $yesterday), 'day' => date('d', $yesterday)), 'cron'); // 从度量项获取执行的昨日完成任务数。

        if(!empty($estimateGroup))       $estimateGroup       = array_column($estimateGroup,       null, 'execution');
        if(!empty($consumeGroup))        $consumeGroup        = array_column($consumeGroup,        null, 'execution');
        if(!empty($leftGroup))           $leftGroup           = array_column($leftGroup,           null, 'execution');
        if(!empty($developedStoryGroup)) $developedStoryGroup = array_column($developedStoryGroup, null, 'execution');
        if(!empty($totalStoryGroup))     $totalStoryGroup     = array_column($totalStoryGroup,     null, 'execution');
        if(!empty($totalTaskGroup))      $totalTaskGroup      = array_column($totalTaskGroup,      null, 'execution');
        if(!empty($unfinishedTaskGroup)) $unfinishedTaskGroup = array_column($unfinishedTaskGroup, null, 'execution');
        if(!empty($dailyFinishedGroup))  $dailyFinishedGroup  = array_column($dailyFinishedGroup,  null, 'execution');

        /* 将从度量项获取的数据塞入执行列表中。 */
        $execution->totalEstimate     = 0;
        $execution->totalConsumed     = 0;
        $execution->totalLeft         = 0;
        $execution->doneStory         = 0;
        $execution->totalStory        = 0;
        $execution->totalTask         = 0;
        $execution->undoneTask        = 0;
        $execution->yesterdayDoneTask = 0;

        if(!empty($estimateGroup[$executionID]))       $execution->totalEstimate     = zget($estimateGroup[$executionID],       'value', 0);
        if(!empty($consumeGroup[$executionID]))        $execution->totalConsumed     = zget($consumeGroup[$executionID],        'value', 0);
        if(!empty($leftGroup[$executionID]))           $execution->totalLeft         = zget($leftGroup[$executionID],           'value', 0);
        if(!empty($developedStoryGroup[$executionID])) $execution->doneStory         = zget($developedStoryGroup[$executionID], 'value', 0);
        if(!empty($totalStoryGroup[$executionID]))     $execution->totalStory        = zget($totalStoryGroup[$executionID],     'value', 0);
        if(!empty($totalTaskGroup[$executionID]))      $execution->totalTask         = zget($totalTaskGroup[$executionID],      'value', 0);
        if(!empty($unfinishedTaskGroup[$executionID])) $execution->undoneTask        = zget($unfinishedTaskGroup[$executionID], 'value', 0);
        if(!empty($dailyFinishedGroup[$executionID]))  $execution->yesterdayDoneTask = zget($dailyFinishedGroup[$executionID],  'value', 0);

        $execution->totalHours = $execution->totalLeft + $execution->totalConsumed;
        if($execution->type == 'kanban')
        {
            /* Process the cfd. */
            $this->app->loadClass('date');
            list($begin, $end) = $this->execution->getBeginEnd4CFD($execution);
            $dateList  = date::getDateList($begin, $end, 'Y-m-d', 'noweekend');
            $chartData = $this->execution->buildCFDData($executionID, $dateList, 'task');
            if(isset($chartData['line'])) $chartData['line'] = array_reverse($chartData['line']);
            $this->view->chartData = $chartData;
        }
        else
        {
            /* Process the burns. */
            $execution->burns = array();
            $burnData = isset($burns[$execution->id]) ? $burns[$execution->id] : array();
            $deadline = $execution->status == 'closed' ? substr($execution->closedDate, 0, 10) : $execution->suspendedDate;
            $today    = helper::today();
            if(strpos('closed,suspended', $execution->status) === false) $deadline = $today > $execution->end ? $today : $execution->end;
            list($dateList, $interval) = $this->execution->getDateList($execution->begin, $deadline, 'noweekend', 0, 'Y-m-d', $execution->end);

            foreach($burnData as $data) $execution->burns[] = $data->value;
            $this->view->chartData = $this->execution->buildBurnData($executionID, $dateList, 'left', $execution->end);
        }

        $this->view->executions       = $executions;
        $this->view->projects         = $this->project->getPairsByIdList(array_keys($projectIdList));
        $this->view->currentProjectID = $projectID;
    }

    /**
     * 打印瀑布项目统计区块。
     * Print waterfall report block.
     *
     * @access protected
     * @return void
     */
    protected function printWaterfallReportBlock()
    {
        $this->app->loadLang('programplan');
        $project = $this->loadModel('project')->getByID(common::isTutorialMode() ? 2 : $this->session->project);

        /* Get metric data. */
        $data    = $this->getProjectsStatisticData(array($project->id));
        $project = $this->buildProjectStatistic($project, $data);

        $this->view->project  = $project;
        $this->view->users    = $this->loadModel('user')->getPairs('noletter');

    }

    /**
     * 打印瀑布项目统计区块。
     * Print waterfall general report block.
     *
     * @access protected
     * @return void
     */
    protected function printWaterfallGeneralReportBlock()
    {
        $this->app->loadLang('programplan');
        $this->loadModel('project');
        $this->loadModel('weekly');

        $data = $this->project->getWaterfallPVEVAC($this->session->project);
        $this->view->pv = (float)$data['PV'];
        $this->view->ev = (float)$data['EV'];
        $this->view->ac = sprintf("%.2f", (float)$data['AC']);
        $this->view->sv = $this->weekly->getSV($this->view->ev, $this->view->pv);
        $this->view->cv = $this->weekly->getCV($this->view->ev, $this->view->ac);

        $left     = (float)$data['left'];
        $progress = (!empty($this->view->ac) || !empty($left)) ? floor($this->view->ac / ($this->view->ac + $left) * 1000) / 1000 * 100 : 0;
        $this->view->progress = $progress > 100 ? 100 : $progress;
    }

    /**
     * 打印瀑布项目计划甘特图区块。
     * Print waterfall gantt block.
     *
     * @param  object    $block
     * @param  array     $params
     * @access protected
     * @return void
     */
    protected function printWaterfallGanttBlock($block, $params = array())
    {
        $products  = $this->loadModel('product')->getProductPairsByProject($this->session->project);
        $productID = $this->session->product ? $this->session->product : 0;
        if(isset($params['productID'])) $productID = (int)$params['productID'];

        $productID = isset($products[$productID]) ? $productID : key($products);
        $productID = !empty($productID) ? $productID : 0;

        /* Get program plans. */
        $plans         = $this->loadModel('programplan')->getStage($this->session->project, $productID, 'all', 'order');
        $plans         = $this->programplan->initGanttPlans($plans);
        $plansProgress = $this->loadModel('metric')->getResultByCodeWithArray('progress_of_task_in_execution', array('execution' => implode(',', $plans['planIdList'])), 'cron'); // Get plan progress by metric.
        $plans         = $plans['datas'] ? $plans['datas']['data'] : array();

        /* Set progress from metric. */
        foreach($plansProgress as $metric)
        {
            if(isset($plans[$metric['execution']])) $plans[$metric['execution']]->taskProgress = ($metric['value'] * 100) . '%';
        }
        $project = $this->loadModel('project')->getByID(common::isTutorialMode() ? 2 : $this->session->project);

        $this->view->plans     = $plans ? $plans : array();
        $this->view->products  = $project->hasProduct ? $products : array();
        $this->view->productID = $productID;
    }

    /**
     * 打印瀑布项目问题列表区块。
     * Print waterfall issue block.
     *
     * @access protected
     * @param  object    $block
     * @return void
     */
    protected function printWaterfallIssueBlock($block)
    {
        $this->printIssueBlock($block);
    }

    /**
     * 打印瀑布项目风险列表区块。
     * Print waterfall risk block.
     *
     * @access protected
     * @param  object    $block
     * @return void
     */
    protected function printWaterfallRiskBlock($block)
    {
        $this->printRiskBlock($block);
    }

    /**
     * 打印瀑布项目工时统计区块。
     * Print waterfall estimate block.
     *
     * @access protected
     * @return void
     */
    protected function printWaterfallEstimateBlock()
    {
        $this->app->loadLang('durationestimation');
        $this->loadModel('project');

        $projectID = $this->session->project;
        $members   = $this->loadModel('user')->getTeamMemberPairs($projectID, 'project');
        $budget    = $this->loadModel('workestimation')->getBudget($projectID);
        $workhour  = $this->loadModel('project')->getWorkhour($projectID);
        if(empty($budget)) $budget = new stdclass();

        $consumed = $this->dao->select('sum(consumed) as consumed')->from(TABLE_TASK)->where('project')->eq($projectID)->andWhere('deleted')->eq(0)->andWhere('isParent')->eq('0')->fetch('consumed');

        $this->view->people    = $this->dao->select('sum(people) as people')->from(TABLE_DURATIONESTIMATION)->where('project')->eq($this->session->project)->fetch('people');
        $this->view->members   = count($members) ? count($members) - 1 : 0;
        $this->view->consumed  = sprintf("%.2f", $consumed);
        $this->view->budget    = $budget;
        $this->view->totalLeft = (float)$workhour->totalLeft;
    }

    /**
     * 打印瀑布项目进度区块。
     * Print waterfall progress block.
     *
     * @access protected
     * @return void
     */
    protected function printWaterfallProgressBlock()
    {
        $this->loadModel('milestone');
        $this->loadModel('weekly');
        $this->app->loadLang('execution');

        $projectID     = $this->session->project;
        $projectWeekly = $this->dao->select('*')->from(TABLE_WEEKLYREPORT)->where('project')->eq($projectID)->orderBy('weekStart_asc')->fetchAll('weekStart');

        $charts = array('pv' => array(), 'ev' => array(), 'ac' => array());
        foreach($projectWeekly as $weekStart => $data)
        {
            $charts['pv'][$weekStart] = $data->pv;
            $charts['ev'][$weekStart] = $data->ev;
            $charts['ac'][$weekStart] = $data->ac;
        }

        $this->view->charts = $charts;
    }

    /**
     * 打印敏捷项目概况区块。
     * Print srcum project block.
     *
     * @access protected
     * @return void
     */
    protected function printScrumOverviewBlock()
    {
        $projectID = $this->session->project;
        $this->app->loadLang('bug');

        /* Get metric data. */
        $projectIdList = array($projectID);
        $data          = $this->getProjectsStatisticData($projectIdList);

        /* Get base project. */
        $project = $this->loadModel('project')->getByID(common::isTutorialMode() ? 2 : $projectID);

        /* Build project statistic data. */
        $this->app->loadClass('pager', true);
        $pager   = pager::init(0, 3, 1);
        $project = $project ? $this->buildProjectStatistic($project, $data, $pager) : new stdclass();

        $this->view->projectID = $projectID;
        $this->view->project   = $project;
    }

    /**
     * 打印敏捷项目列表区块。
     * Print srcum project list block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printScrumListBlock($block)
    {
        if(!empty($block->params->type) && preg_match('/[^a-zA-Z0-9_]/', $block->params->type)) return;
        $count = isset($block->params->count) ? (int)$block->params->count : 15;
        $type  = isset($block->params->type) ? $block->params->type : 'undone';

        $this->app->loadClass('pager', true);
        $pager = pager::init(0, $count, 1);
        $this->loadModel('execution');
        $this->view->executionStats = !commonModel::isTutorialMode() ? $this->execution->getStatData($this->session->project, $type, 0, 0, false, '', '', $pager) : array($this->loadModel('tutorial')->getExecution());
    }

    /**
     * 打印敏捷项目产品概况。
     * Print srcum product block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printScrumProductBlock($block)
    {
        $stories  = array();
        $bugs     = array();
        $releases = array();
        $count    = isset($block->params->count) ? (int)$block->params->count : 15;

        $products      = $this->dao->select('id, name')->from(TABLE_PRODUCT)->where('program')->eq($this->session->program)->limit($count)->fetchPairs();
        $productIdList = array_keys($products);
        if(!empty($productIdList))
        {
            $fields   = 'product, COUNT(1) AS total';
            $stories  = $this->dao->select($fields)->from(TABLE_STORY)->where('product')->in($productIdList)->andWhere('deleted')->eq('0')->groupBy('product')->fetchPairs();
            $bugs     = $this->dao->select($fields)->from(TABLE_BUG)->where('product')->in($productIdList)->andWhere('deleted')->eq('0')->groupBy('product')->fetchPairs();
            $releases = $this->dao->select($fields)->from(TABLE_RELEASE)->where('product')->in($productIdList)->andWhere('deleted')->eq('0')->groupBy('product')->fetchPairs();
        }

        $this->view->products = $products;
        $this->view->stories  = $stories;
        $this->view->bugs     = $bugs;
        $this->view->releases = $releases;
    }

    /**
     * 打印敏捷项目问题列表区块。
     * Print scrum issue block.
     *
     * @access protected
     * @param  object    $block
     * @return void
     */
    protected function printScrumIssueBlock($block)
    {
        $this->printIssueBlock($block);
    }

    /**
     * 打印敏捷项目风险列表区块。
     * Print scrum risk block.
     *
     * @access protected
     * @param  object    $block
     * @return void
     */
    protected function printScrumRiskBlock($block)
    {
        $this->printRiskBlock($block);
    }

    /**
     * 打印问题列表区块。
     * Print issue block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    private function printIssueBlock($block)
    {
        $uri = $this->app->tab == 'my' ? $this->createLink('my', 'index') : $this->server->http_referer;
        $this->session->set('issueList', $uri, 'project');
        if(preg_match('/[^a-zA-Z0-9_]/', $block->params->type)) return;
        $this->view->users  = $this->loadModel('user')->getPairs('noletter');
        $this->view->issues = $this->loadModel('issue')->getBlockIssues($this->session->project, $block->params->type, $this->viewType == 'json' ? 0 : (int)$block->params->count, $block->params->orderBy);
    }

    /**
     * 打印风险列表区块。
     * Print risk block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    private function printRiskBlock($block)
    {
        $uri = $this->app->tab == 'my' ? $this->createLink('my', 'index') : $this->server->http_referer;
        $this->session->set('riskList', $uri, 'project');
        $this->view->users = $this->loadModel('user')->getPairs('noletter');
        $this->view->risks = $this->loadModel('risk')->getBlockRisks($this->session->project, $block->params->type, $this->viewType == 'json' ? 0 : (int)$block->params->count, $block->params->orderBy);
    }

    /**
     * 打印单个项目下的迭代总览区块。
     * Print sprint block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printSprintBlock($block)
    {
        $this->printExecutionOverviewBlock($block, array(), 'sprint', (int)$this->session->project, true);
    }

    /**
     * 打印项目动态区块。
     * Print project dynamic block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printProjectDynamicBlock($block)
    {
        $projectID = $this->session->project;
        $count     = isset($block->params->count) ? (int)$block->params->count : 10;

        $this->view->actions = $this->loadModel('action')->getDynamic('all', 'all', 'date_desc', $count, 'all', $projectID);
        $this->view->users   = $this->loadModel('user')->getPairs('noletter', '', 0, array_unique(array_column($this->view->actions, 'actor')));
    }

    /**
     * 打印敏捷项目路线图区块。
     * Print srcum road map block.
     *
     * @param  int    $productID
     * @param  int    $roadMapID
     * @access protected
     * @return void
     */
    protected function printScrumRoadMapBlock($productID = 0, $roadMapID = 0)
    {
        $uri = $this->app->tab == 'my' ? $this->createLink('my', 'index') : $this->server->http_referer;
        $this->session->set('releaseList',     $uri, 'product');
        $this->session->set('productPlanList', $uri, 'product');

        $products  = $this->loadModel('product')->getPairs('', $this->session->project);
        if(!is_numeric($productID)) $productID = key($products);

        $this->view->roadmaps  = $this->product->getRoadmap($productID, 0, 6);
        $this->view->productID = $productID;
        $this->view->roadMapID = $roadMapID;
        $this->view->products  = $products;
        $this->view->sync      = 1;

        if($_POST)
        {
            $this->view->sync = 0;
            $this->display('block', 'scrumroadmapblock');
        }
    }

    /**
     * 打印敏捷项目的测试统计区块。
     * Print srcum test block.
     *
     * @param  object $block
     * @access public
     * @return void
     */
    public function printScrumTestBlock($block)
    {
        $uri = $this->app->tab == 'my' ? $this->createLink('my', 'index') : $this->server->http_referer;
        $this->session->set('testtaskList', $uri, 'qa');
        $this->session->set('productList',  $uri, 'product');
        $this->session->set('projectList',  $uri, 'project');
        $this->session->set('buildList',    $uri, 'execution');
        $this->app->loadLang('testtask');

        $this->view->project   = $this->loadModel('project')->getByID($this->session->project);
        $this->view->testtasks = $this->dao->select("DISTINCT t1.*,t2.name as productName,t2.shadow,t3.name as buildName,t4.name as executionName, CONCAT(t4.name, '/', t3.name) as executionBuild")->from(TABLE_TESTTASK)->alias('t1')
            ->leftJoin(TABLE_PRODUCT)->alias('t2')->on('t1.product=t2.id')
            ->leftJoin(TABLE_BUILD)->alias('t3')->on('t1.build=t3.id')
            ->leftJoin(TABLE_PROJECT)->alias('t4')->on('t1.execution=t4.id')
            ->leftJoin(TABLE_PROJECTPRODUCT)->alias('t5')->on('t1.project=t5.project')
            ->where('t1.deleted')->eq('0')
            ->andWhere('t1.auto')->ne('unit')
            ->beginIF(!$this->app->user->admin)->andWhere('t1.product')->in($this->app->user->view->products)->fi()
            ->beginIF(!$this->app->user->admin)->andWhere('t1.execution')->in($this->app->user->view->sprints)->fi()
            ->andWhere('t1.project')->eq($this->session->project)->fi()
            ->andWhere('t1.product = t5.product')
            ->beginIF($block->params->type != 'all')->andWhere('t1.status')->eq($block->params->type)->fi()
            ->orderBy('t1.id desc')
            ->beginIF($this->viewType != 'json')->limit((int)$block->params->count)->fi()
            ->fetchAll();
    }

    /**
     * 打印测试统计区块。
     * Print qa statistic block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printQaStatisticBlock($block)
    {
        if(!empty($block->params->type) && preg_match('/[^a-zA-Z0-9_]/', $block->params->type)) return;

        $this->app->loadLang('bug');
        $status = isset($block->params->type)  ? $block->params->type : '';
        $count  = isset($block->params->count) ? (int)$block->params->count : 0;

        /* 测试统计是按产品分组统计的。 */
        $products          = $this->loadModel('product')->getOrderedProducts($status, $count, 0, 'all');
        $shadowProductList = array();
        foreach($products as $productID => $product) if($product->shadow) $shadowProductList[] = $productID;
        $productProject    = $this->dao->select('t1.product, t1.project')->from(TABLE_PROJECTPRODUCT)->alias('t1')
            ->leftJoin(TABLE_PROJECT)->alias('t2')->on('t1.project = t2.id')
            ->where('t1.product')->in(array_values($shadowProductList))
            ->andWhere('t2.type')->eq('project')
            ->fetchPairs();

        $productIdList = array_keys($products);
        $projectIdList = array_values($productProject);

        /* 计算昨日和今日可能包含的日期情况。 */
        $years  = array();
        $months = array();
        for($i = 0; $i <= 1; $i ++)
        {
            $years[] = date('Y', strtotime("-{$i} day"));
            $months[] = date('m', strtotime("-{$i} day"));
        }

        $this->loadModel('metric');
        $createdBugGroup       = $this->metric->getResultByCodeWithArray('count_of_daily_created_bug_in_product',  array('product' => join(',', $productIdList), 'year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 获取昨日和今日新增的Bug数。
        $shadowCreatedBugGroup = $this->metric->getResultByCodeWithArray('count_of_daily_created_bug_in_project',  array('project' => join(',', $projectIdList), 'year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 获取昨日和今日新增的Bug数。

        $resolvedBugGroup       = $this->metric->getResultByCodeWithArray('count_of_daily_resolved_bug_in_product', array('product' => join(',', $productIdList), 'year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 获取昨日和今日解决的Bug数。
        $shadowResolvedBugGroup = $this->metric->getResultByCodeWithArray('count_of_daily_resolved_bug_in_project', array('project' => join(',', $projectIdList), 'year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 获取影子产品昨日和今日解决的Bug数。

        $closedBugGroup       = $this->metric->getResultByCodeWithArray('count_of_daily_closed_bug_in_product',   array('product' => join(',', $productIdList), 'year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 获取昨日和今日关闭的Bug数。
        $shadowClosedBugGroup = $this->metric->getResultByCodeWithArray('count_of_daily_closed_bug_in_project',   array('project' => join(',', $projectIdList), 'year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 获取影子产品昨日和今日关闭的Bug数。

        $bugFixRate       = $this->metric->getResultByCodeWithArray('rate_of_fixed_bug_in_product',           array('product' => join(',', $productIdList)), 'cron'); // 获取Bug修复率。
        $shadowBugFixRate = $this->metric->getResultByCodeWithArray('rate_of_fixed_bug_in_project',           array('project' => join(',', $projectIdList)), 'cron'); // 获取影子产品Bug修复率。

        $effectiveBug       = $this->metric->getResultByCodeWithArray('count_of_effective_bug_in_product',      array('product' => join(',', $productIdList)), 'cron'); // 获取有效Bug总数。
        $shadowEffectiveBug = $this->metric->getResultByCodeWithArray('count_of_effective_bug_in_project',      array('project' => join(',', $projectIdList)), 'cron'); // 获取影子产品有效Bug总数。

        $fixedBug       = $this->metric->getResultByCodeWithArray('count_of_fixed_bug_in_product',          array('product' => join(',', $productIdList)), 'cron'); // 获取Bug修复数。
        $shadowFixedBug = $this->metric->getResultByCodeWithArray('count_of_fixed_bug_in_project',          array('project' => join(',', $projectIdList)), 'cron'); // 获取影子产品Bug修复数。

        $activatedBug       = $this->metric->getResultByCodeWithArray('count_of_activated_bug_in_product',      array('product' => join(',', $productIdList)), 'cron'); // 获取Bug激活数。
        $shadowActivatedBug = $this->metric->getResultByCodeWithArray('count_of_activated_bug_in_project',      array('project' => join(',', $projectIdList)), 'cron'); // 获取影子产品Bug激活数。

        if(!empty($bugFixRate))         $bugFixRate         = array_column($bugFixRate,   null, 'product');
        if(!empty($shadowBugFixRate))   $shadowBugFixRate   = array_column($shadowBugFixRate,   null, 'project');
        if(!empty($effectiveBug))       $effectiveBug       = array_column($effectiveBug, null, 'product');
        if(!empty($shadowEffectiveBug)) $shadowEffectiveBug = array_column($shadowEffectiveBug, null, 'project');
        if(!empty($fixedBug))           $fixedBug           = array_column($fixedBug,     null, 'product');
        if(!empty($shadowFixedBug))     $shadowFixedBug     = array_column($shadowFixedBug,     null, 'project');
        if(!empty($activatedBug))       $activatedBug       = array_column($activatedBug, null, 'product');
        if(!empty($shadowActivatedBug)) $shadowActivatedBug = array_column($shadowActivatedBug, null, 'project');

        $productIdList     = array_keys($products);
        $unclosedTesttasks = $this->dao->select('product,id,name')->from(TABLE_TESTTASK)
            ->where('product')->in($productIdList)
            ->andWhere('project')->ne(0)
            ->andWhere('status')->ne('done')
            ->andWhere('deleted')->eq(0)
            ->orderBy('id_desc')
            ->fetchGroup('product');

        /* 将获取出的度量项数据塞入产品列表数据中。 */
        foreach($products as $productID => $product)
        {
            $isShadow    = $product->shadow;
            $useObjectID = !$isShadow ? $productID : (isset($productProject[$productID]) ? $productProject[$productID] : $productID); // 如果是影子产品，用项目查询
            $useDataKey  = !$isShadow ? 'product' : 'project';

            $product->addToday          = 0;
            $product->addYesterday      = 0;
            $product->resolvedToday     = 0;
            $product->resolvedYesterday = 0;
            $product->closedToday       = 0;
            $product->closedYesterday   = 0;

            $useCreatedBug = !$isShadow ? 'createdBugGroup' : 'shadowCreatedBugGroup';
            if(!empty($$useCreatedBug))
            {
                foreach($$useCreatedBug as $data)
                {
                    $objectEQ = $useObjectID == $data[$useDataKey];
                    $currentDay = "{$data['year']}-{$data['month']}-{$data['day']}";
                    if($currentDay == date('Y-m-d') && $objectEQ)                      $product->addToday     = $data['value'];
                    if($currentDay == date('Y-m-d', strtotime("-1 day")) && $objectEQ) $product->addYesterday = $data['value'];
                }
            }

            $useResolvedBug = !$isShadow ? 'resolvedBugGroup' : 'shadowResolvedBugGroup';
            if(!empty($$useResolvedBug))
            {
                foreach($$useResolvedBug as $data)
                {
                    $objectEQ = $useObjectID == $data[$useDataKey];

                    $currentDay = "{$data['year']}-{$data['month']}-{$data['day']}";
                    if($currentDay == date('Y-m-d') && $objectEQ)                      $product->resolvedToday     = $data['value'];
                    if($currentDay == date('Y-m-d', strtotime("-1 day")) && $objectEQ) $product->resolvedYesterday = $data['value'];
                }
            }

            $useClosedBug = !$isShadow ? 'closedBugGroup' : 'shadowClosedBugGroup';
            if(!empty($$useClosedBug))
            {
                foreach($$useClosedBug as $data)
                {
                    $objectEQ = $useObjectID == $data[$useDataKey];

                    $currentDay = "{$data['year']}-{$data['month']}-{$data['day']}";
                    if($currentDay == date('Y-m-d') && $objectEQ)                      $product->closedToday     = $data['value'];
                    if($currentDay == date('Y-m-d', strtotime("-1 day")) && $objectEQ) $product->closedYesterday = $data['value'];
                }
            }

            $useBugFixRate   = !$isShadow ? 'bugFixRate' : 'shadowBugFixRate';
            $useEffectiveBug = !$isShadow ? 'effectiveBug' : 'shadowEffectiveBug';
            $useFixedBug     = !$isShadow ? 'fixedBug' : 'shadowFixedBug';
            $useActivatedBug = !$isShadow ? 'activatedBug' : 'shadowActivatedBug';

            $product->fixedBugRate      = isset($$useBugFixRate[$useObjectID]['value'])   ? $$useBugFixRate[$useObjectID]['value'] * 100 : 0;
            $product->totalBug          = isset($$useEffectiveBug[$useObjectID]['value']) ? $$useEffectiveBug[$useObjectID]['value']     : 0;
            $product->fixedBug          = isset($$useFixedBug[$useObjectID]['value'])     ? $$useFixedBug[$useObjectID]['value']         : 0;
            $product->activatedBug      = isset($$useActivatedBug[$useObjectID]['value']) ? $$useActivatedBug[$useObjectID]['value']     : 0;
            $product->unclosedTesttasks = isset($unclosedTesttasks[$productID])           ? $unclosedTesttasks[$productID]               : '';
        }

        $this->view->products = $products;
    }

    /**
     * 传递产品总览区块页面数据。
     * Transfer product overview block page data.
     *
     * @param  object $block
     * @param  array  $params
     * @access protected
     * @return bool
     */
    protected function printProductOverviewBlock($block, $params = array())
    {
        if($block->width == 1) $this->printShortProductOverview();
        if($block->width == 3) $this->printLongProductOverview($params);
    }

    /**
     * 传递产品总览短区块页面数据。
     * Transfer short product overview block page data.
     *
     * @access protected
     * @return void
     */
    protected function printShortProductOverview()
    {
        $data = new stdclass();
        $data->productCount   = 0;
        $data->releaseCount   = 0;
        $data->milestoneCount = 0;

        $this->loadModel('metric');

        /* 从度量项获取产品总数量。 */
        $productCount = $this->metric->getResultByCodeWithArray('count_of_product', array(), 'cron', null, $this->config->vision == 'or' ? 'rnd,or' : 'rnd');
        if(!empty($productCount))
        {
            $productCount = reset($productCount);
            $data->productCount = zget($productCount, 'value', 0);
        }

        /* 从度量项获取发布次数。 */
        $releaseCount = $this->metric->getResultByCodeWithArray('count_of_annual_created_release', array('year' => date('Y')), 'cron');
        if(!empty($releaseCount))
        {
            $releaseCount = reset($releaseCount);
            $data->releaseCount = zget($releaseCount, 'value', 0);
        }

        /* 从度量项获取发布里程碑数。 */
        $milestoneCount = $this->metric->getResultByCodeWithArray('count_of_marker_release', array(), 'cron');
        if(!empty($milestoneCount))
        {
            $milestoneCount = reset($milestoneCount);
            $data->milestoneCount = zget($milestoneCount, 'value', 0);
        }

        $this->view->data = $data;
    }

    /**
     * 传递产品总览长区块页面数据。
     * Transfer long product overview block page data.
     *
     * @param  array $params
     * @access protected
     * @return void
     */
    protected function printLongProductOverview($params = array())
    {
        $year = isset($params['year']) ? (int)$params['year'] : date('Y');

        /* 初始化报表数据为0。 */
        $data = new stdclass();
        $data->productLineCount             = 0;
        $data->productCount                 = 0;
        $data->unfinishedPlanCount          = 0;
        $data->unclosedStoryCount           = 0;
        $data->activeBugCount               = 0;
        $data->finishedReleaseCount['year'] = 0;
        $data->finishedReleaseCount['week'] = 0;
        $data->finishedStoryCount['year']   = 0;
        $data->finishedStoryCount['week']   = 0;
        $data->finishedStoryPoint['year']   = 0;
        $data->finishedStoryPoint['week']   = 0;

        $this->loadModel('metric');
        $productLineCount = $this->metric->getResultByCodeWithArray('count_of_line', array(), 'cron'); // 产品线总量。
        if(!empty($productLineCount))
        {
            $productLineCount = reset($productLineCount);
            $data->productLineCount = zget($productLineCount, 'value', 0);
        }

        $productCount = $this->metric->getResultByCodeWithArray('count_of_product', array(), 'cron'); // 产品总量。
        if(!empty($productCount))
        {
            $productCount = reset($productCount);
            $data->productCount = zget($productCount, 'value', 0);
        }

        $unfinishedPlanCount = $this->metric->getResultByCodeWithArray('count_of_unfinished_productplan', array(), 'cron'); // 未完成计划数。
        if(!empty($unfinishedPlanCount))
        {
            $unfinishedPlanCount = reset($unfinishedPlanCount);
            $data->unfinishedPlanCount = zget($unfinishedPlanCount, 'value', 0);
        }

        $unclosedStoryCount = $this->metric->getResultByCodeWithArray('count_of_unclosed_story', array(), 'cron'); // 未关闭需求数。
        if(!empty($unclosedStoryCount))
        {
            $unclosedStoryCount = reset($unclosedStoryCount);
            $data->unclosedStoryCount = zget($unclosedStoryCount, 'value', 0);
        }

        $activeBugCount = $this->metric->getResultByCodeWithArray('count_of_activated_bug', array(), 'cron'); // 激活Bug数。
        if(!empty($activeBugCount))
        {
            $activeBugCount = reset($activeBugCount);
            $data->activeBugCount = zget($activeBugCount, 'value', 0);
        }

        $createdReleaseGroup = $this->metric->getResultByCodeWithArray('count_of_annual_created_release', array(), 'cron'); // 已完成发布数。
        $finishedStoryGroup  = $this->metric->getResultByCodeWithArray('count_of_annual_finished_story', array(), 'cron');  // 已完成需求数。
        $storyScaleGroup     = $this->metric->getResultByCodeWithArray('scale_of_annual_finished_story', array(), 'cron');  // 已完成需求规模。

        if($createdReleaseGroup) $createdReleaseGroup = array_column($createdReleaseGroup, null, 'year');
        if($finishedStoryGroup)  $finishedStoryGroup  = array_column($finishedStoryGroup,  null, 'year');
        if($storyScaleGroup)     $storyScaleGroup     = array_column($storyScaleGroup,     null, 'year');

        if(!empty($createdReleaseGroup[$year])) $data->finishedReleaseCount['year'] = zget($createdReleaseGroup[$year], 'value', 0);
        if(!empty($finishedStoryGroup[$year]))  $data->finishedStoryCount['year']   = zget($finishedStoryGroup[$year],  'value', 0);
        if(!empty($storyScaleGroup[$year]))     $data->finishedStoryPoint['year']   = zget($storyScaleGroup[$year],     'value', 0);

        /* 获取有数据的年份，默认显示今年。 */
        $years = array(date('Y') => 0);
        if($createdReleaseGroup || $finishedStoryGroup || $storyScaleGroup) $years = $years + $createdReleaseGroup + $finishedStoryGroup + $storyScaleGroup;
        $years = array_keys($years);
        rsort($years);

        $this->view->years       = $years;
        $this->view->currentYear = $year;
        $this->view->data        = $data;
    }

    /**
     * 打印迭代总览区块。
     * Print execution overview block.
     *
     * @param  object    $block
     * @param  array     $params
     * @param  string    $code          executionoverview|sprint
     * @param  int       $project
     * @param  bool      $showClosed    true|false
     * @access protected
     * @return void
     */
    protected function printExecutionOverviewBlock($block, $params = array(), $code = 'executionoverview', $project = 0, $showClosed = false)
    {
        $this->loadModel('metric');

        /* 通过度量项获取迭代总量。 */
        $executionCount = 0;
        $executionCountGroup = $project ? $this->metric->getResultByCodeWithArray('count_of_execution_in_project', array('project' => $project)) : $this->metric->getResultByCodeWithArray('count_of_execution', array(), 'cron', null, $this->config->vision);
        if(!empty($executionCountGroup))
        {
            $executionCountGroup = reset($executionCountGroup);
            $executionCount      = zget($executionCountGroup, 'value', 0);
        }

        /* 通过度量项获取今年完成的迭代数量。 */
        $finishedExecution      = 0;
        $finishedExecutionGroup = $project ? $this->metric->getResultByCodeWithArray('count_of_annual_finished_execution_in_project', array('project' => $project, 'year' => date('Y')), 'cron') : $this->metric->getResultByCodeWithArray('count_of_annual_finished_execution', array('year' => date('Y')), 'cron', null, $this->config->vision);
        if(!empty($finishedExecutionGroup))
        {
            $finishedExecutionGroup = reset($finishedExecutionGroup);
            $finishedExecution      = zget($finishedExecutionGroup, 'value', 0);
        }

        /* 通过度量项获取未开始的迭代数量。 */
        $waitExecution = 0;
        $waitExecutionGroup = $project ? $this->metric->getResultByCodeWithArray('count_wait_execution_in_project', array('project' => $project), 'cron') : $this->metric->getResultByCodeWithArray('count_of_wait_execution', array(), 'cron', null, $this->config->vision);
        if(!empty($waitExecutionGroup))
        {
            $waitExecutionGroup = reset($waitExecutionGroup);
            $waitExecution      = zget($waitExecutionGroup, 'value', 0);
        }

        /* 通过度量项获取进行中的迭代数量。 */
        $doingExecution = 0;
        $doingExecutionGroup = $project ? $this->metric->getResultByCodeWithArray('count_of_doing_execution_in_project', array('project' => $project), 'cron') : $this->metric->getResultByCodeWithArray('count_of_doing_execution', array(), 'cron', null, $this->config->vision);
        if(!empty($doingExecutionGroup))
        {
            $doingExecutionGroup = reset($doingExecutionGroup);
            $doingExecution      = zget($doingExecutionGroup, 'value', 0);
        }

        /* 通过度量项获取已挂起的迭代数量。 */
        $suspendedExecution = 0;
        $suspendedExecutionGroup = $project ? $this->metric->getResultByCodeWithArray('count_of_suspended_execution_in_project', array('project' => $project), 'cron') : $this->metric->getResultByCodeWithArray('count_of_suspended_execution', array(), 'cron', null, $this->config->vision);
        if(!empty($suspendedExecutionGroup))
        {
            $suspendedExecutionGroup = reset($suspendedExecutionGroup);
            $suspendedExecution      = zget($suspendedExecutionGroup, 'value', 0);
        }

        /* 如果是地盘下的区块跳转到执行列表，如果是单项目下的区块跳转到项目的迭代列表。 */
        $url = common::hasPriv('execution', 'all') && $this->config->vision != 'lite' ? helper::createLink('execution', 'all', 'status=all') : null;
        if($project) $url = common::hasPriv('project', 'execution') ? helper::createLink('project', 'execution', "status=all&projectID=$project") : null;

        /* 组装区块左侧的数据。 */
        $cards = array();
        $cards[0] = new stdclass();
        $cards[0]->value = $executionCount;
        $cards[0]->class = 'text-primary';
        $cards[0]->label = $this->lang->block->{$code}->totalExecution;
        $cards[0]->url   = $url;

        $cards[1] = new stdclass();
        $cards[1]->value = $finishedExecution;
        $cards[1]->label = $this->lang->block->{$code}->thisYear;

        $cardGroup = new stdclass();
        $cardGroup->type  = 'cards';
        $cardGroup->cards = $cards;

        /* 组装区块右侧的柱状图数据。 */
        $max  = max($waitExecution, $doingExecution, $suspendedExecution);
        $bars = array();
        $bars[0] = new stdclass();
        $bars[0]->label = $this->lang->block->typeList->projectAll['wait'];
        $bars[0]->value = $waitExecution;
        $bars[0]->rate  = $max ? round($waitExecution / $max, 4) * 100 . '%' : '0%';

        $bars[1] = new stdclass();
        $bars[1]->label = $this->lang->block->typeList->projectAll['doing'];
        $bars[1]->value = $doingExecution;
        $bars[1]->rate  = $max ? round($doingExecution / $max, 4) * 100 . '%' : '0%';

        $bars[2] = new stdclass();
        $bars[2]->label = $this->lang->block->typeList->projectAll['suspended'];
        $bars[2]->value = $suspendedExecution;
        $bars[2]->rate  = $max ? round($suspendedExecution / $max, 4) * 100 . '%' : '0%';

        $barGroup = new stdclass();
        $barGroup->type  = 'barChart';
        $barGroup->title = $this->lang->block->{$code}->statusCount;
        $barGroup->bars  = $bars;

        $this->view->groups = array($cardGroup, $barGroup);
    }

    /**
     * 打印测试概况区块。
     * Print qa overview block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printQaOverviewBlock($block)
    {
        $casePairs = $this->dao->select('lastRunResult, COUNT(1) AS count')->from(TABLE_CASE)
            ->where('1=1')
            ->beginIF($block->module != 'my' && $this->session->project)->andWhere('project')->eq((int)$this->session->project)->fi()
            ->groupBy('lastRunResult')
            ->fetchPairs();

        $total = array_sum($casePairs);

        $this->app->loadLang('testcase');
        foreach($this->lang->testcase->resultList as $result => $label)
        {
            if(!isset($casePairs[$result])) $casePairs[$result] = 0;
        }

        $casePercents = array();
        foreach($casePairs as $result => $count)
        {
            $casePercents[$result] = $total ? round($count / $total * 100, 2) : 0;
        }

        $this->view->total        = $total;
        $this->view->casePairs    = $casePairs;
        $this->view->casePercents = $casePercents;
    }

    /**
     * 打印执行列表区块。
     * Print execution block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printExecutionListBlock($block)
    {
        if(!empty($block->params->type) && preg_match('/[^a-zA-Z0-9_]/', $block->params->type)) return;

        $count  = isset($block->params->count) ? (int)$block->params->count : 0;
        $status = isset($block->params->type)  ? $block->params->type : 'all';

        $this->loadModel('execution');
        $this->app->loadClass('pager', true);
        $pager = pager::init(0, $count, 1);

        $projectID = $block->dashboard == 'my' ? 0 : (int)$this->session->project;

        $executions = $this->execution->getStatData($projectID, $status, 0, 0, false, 'skipParent', 'id_asc', $pager);
        if($executions)
        {
            foreach($executions as $execution)
            {
                $execution->totalEstimate  = !empty($execution->hours) ? $execution->hours->totalEstimate : 0;
                $execution->totalLeft      = !empty($execution->hours) ? $execution->hours->totalLeft : 0;
                $execution->progress       = !empty($execution->hours) ? $execution->hours->progress : 0;
                $execution->burns          = !empty($execution->burns) ? join(',', $execution->burns) : array();
            }
        }
        $this->view->executions = $executions ? $executions : array();
    }

    /**
     * 打印指派给的我区块。
     * Print assign to me block.
     *
     * @param  object    $block
     * @access protected
     * @return array
     */
    protected function printAssignToMeBlock($block)
    {
        $hasIssue    = helper::hasFeature('issue');
        $hasRisk     = helper::hasFeature('risk');
        $hasMeeting  = helper::hasFeature('meeting');
        $hasViewPriv = array();

        $count          = array();
        $params         = $block->params;
        $limitCount     = zget($params, 'count', $this->config->block->params['assigntome']->count['default']);
        $shadowProducts = $this->dao->select('id')->from(TABLE_PRODUCT)->where('deleted')->eq('0')->andWhere('shadow')->eq(1)->fetchPairs();

        $this->app->loadClass('pager', true);
        $pager   = new pager(0, $limitCount, 1);
        $reviews = $this->loadModel('my')->getReviewingList('all', 'time_desc', $pager);
        if($reviews)
        {
            $hasViewPriv['review'] = true;
            $count['review']       = count($reviews);

            foreach($reviews as $review)
            {
                if($review->type == 'story') $review->isShadowProduct = isset($shadowProducts[$review->product]) ? 1 : 0;
            }

            $this->view->reviews = $reviews;
            if($this->config->edition != 'open')
            {
                $this->app->loadLang('approval');
                $this->app->loadLang('projectchange');
                $this->view->flows = $this->dao->select('module,name')->from(TABLE_WORKFLOW)->where('buildin')->eq(0)->fetchPairs('module', 'name');
            }
        }

        if(common::hasPriv('todo',  'view'))                                                                      $hasViewPriv['todo']        = true;
        if(common::hasPriv('demand', 'view') && $this->config->edition == 'ipd' && $this->config->vision == 'or') $hasViewPriv['demand']      = true;
        if((common::hasPriv('task',  'view') && $this->config->vision == 'rnd') || (common::hasPriv('researchtask', 'view') && $this->config->vision == 'or')) $hasViewPriv['task'] = true;
        if(common::hasPriv('story', 'view') && $this->config->vision != 'lite')                                   $hasViewPriv['story']       = true;
        if($this->config->URAndSR && common::hasPriv('story', 'view') && $this->config->vision != 'lite')         $hasViewPriv['requirement'] = true;
        if(common::hasPriv('bug',   'view')       && !in_array($this->config->vision, array('lite', 'or')))       $hasViewPriv['bug']         = true;
        if(common::hasPriv('testcase', 'view')    && !in_array($this->config->vision, array('lite', 'or')))       $hasViewPriv['testcase']    = true;
        if(common::hasPriv('testtask', 'cases')   && !in_array($this->config->vision, array('lite', 'or')))       $hasViewPriv['testtask']    = true;
        if(common::hasPriv('risk', 'view')        && in_array($this->config->edition, array('max', 'ipd')) && !in_array($this->config->vision, array('lite', 'or')) && $hasRisk)    $hasViewPriv['risk']        = true;
        if(common::hasPriv('reviewissue', 'view') && in_array($this->config->edition, array('max', 'ipd')) && !in_array($this->config->vision, array('lite', 'or')) && $hasRisk)    $hasViewPriv['reviewissue'] = true;
        if(common::hasPriv('issue', 'view')       && in_array($this->config->edition, array('max', 'ipd')) && !in_array($this->config->vision, array('lite', 'or')) && $hasIssue)   $hasViewPriv['issue']       = true;
        if(common::hasPriv('meeting', 'view')     && in_array($this->config->edition, array('max', 'ipd')) && !in_array($this->config->vision, array('lite', 'or')) && $hasMeeting) $hasViewPriv['meeting']     = true;
        if((common::hasPriv('feedback', 'view') || common::hasPriv('feedback', 'adminView')) && in_array($this->config->edition, array('max', 'biz', 'ipd')))                       $hasViewPriv['feedback']    = true;
        if(common::hasPriv('ticket', 'view')    && in_array($this->config->edition, array('max', 'biz', 'ipd')) && $this->config->vision != 'or') $hasViewPriv['ticket']   = true;

        $objectList = array('todo' => 'todos', 'task' => 'tasks', 'bug' => 'bugs', 'story' => 'stories', 'requirement' => 'requirements');
        if($this->config->edition == 'max' or $this->config->edition == 'ipd')
        {
            if($hasRisk) $objectList += array('risk' => 'risks');
            if($hasIssue) $objectList += array('issue' => 'issues');
            $objectList += array('feedback' => 'feedbacks', 'ticket' => 'tickets', 'reviewissue' => 'reviewissues');
            if($this->config->edition == 'ipd' && $this->config->vision == 'or') $objectList += array('demand' => 'demands');
        }

        if($this->config->edition == 'biz') $objectList += array('feedback' => 'feedbacks', 'ticket' => 'tickets');

        $tasks = $this->loadModel('task')->getUserSuspendedTasks($this->app->user->account);
        foreach(array_keys($objectList) as $objectType)
        {
            if(!isset($hasViewPriv[$objectType])) continue;

            $table   = $objectType == 'requirement' ? TABLE_STORY : $this->config->objectTables[$objectType];
            $orderBy = $objectType == 'todo' ? '`date` desc' : 'id_desc';
            $objects = $this->dao->select('t1.*')->from($table)->alias('t1')
                ->beginIF($objectType == 'story' || $objectType == 'requirement')->leftJoin(TABLE_PRODUCT)->alias('t2')->on('t1.product=t2.id')->fi()
                ->beginIF($objectType == 'bug')->leftJoin(TABLE_PRODUCT)->alias('t2')->on('t1.product=t2.id')->fi()
                ->beginIF($objectType == 'task')->leftJoin(TABLE_PROJECT)->alias('t2')->on('t1.execution=t2.id')->fi()
                ->beginIF(in_array($objectType, array('issue', 'risk', 'reviewissue')))->leftJoin(TABLE_PROJECT)->alias('t2')->on('t1.project=t2.id')->fi()
                ->beginIF($objectType == 'ticket')->leftJoin(TABLE_USER)->alias('t2')->on('t1.openedBy = t2.account')->fi()
                ->beginIF($objectType == 'demand')->leftJoin(TABLE_DEMANDPOOL)->alias('t2')->on('t1.pool = t2.id')->fi()
                ->where('t1.deleted')->eq(0)
                ->andWhere('t1.assignedTo')->eq($this->app->user->account)->fi()
                ->beginIF($objectType == 'story')->andWhere('t1.type')->eq('story')->andWhere('t2.deleted')->eq('0')->andWhere('t1.vision')->eq($this->config->vision)->fi()
                ->beginIF($objectType == 'requirement')->andWhere('t1.type')->eq('requirement')->andWhere('t2.deleted')->eq('0')->andWhere("FIND_IN_SET('{$this->config->vision}', t1.vision)")->fi()
                ->beginIF($objectType == 'bug')->andWhere('t2.deleted')->eq('0')->fi()
                ->beginIF($objectType == 'story' || $objectType == 'requirement')->andWhere('t2.deleted')->eq('0')->fi()
                ->beginIF($objectType == 'todo')->andWhere('t1.cycle')->eq(0)->andWhere('t1.status')->eq('wait')->andWhere('t1.vision')->eq($this->config->vision)->fi()
                ->beginIF($objectType != 'todo')->andWhere('t1.status')->ne('closed')->fi()
                ->beginIF($objectType == 'feedback')->andWhere('t1.status')->in('wait, noreview')->fi()
                ->beginIF(in_array($objectType, array('issue', 'risk', 'reviewissue')))->andWhere('t2.deleted')->eq(0)->fi()
                ->beginIF($objectType == 'ticket')->andWhere('t1.status')->in('wait,doing,done')->fi()
                ->beginIF($objectType == 'demand')->andWhere('t2.deleted')->eq(0)->fi()
                ->orderBy($orderBy)
                ->beginIF($limitCount)->limit($limitCount)->fi()
                ->fetchAll('id', false);

            if($objectType == 'todo')
            {
                $this->app->loadClass('date');
                $this->app->loadLang('todo');
                foreach($objects as $key => $todo)
                {
                    if($todo->status == 'done' && $todo->finishedBy == $this->app->user->account)
                    {
                        unset($objects[$key]);
                        continue;
                    }
                    if($todo->type == 'task' && isset($tasks[$todo->objectID]))
                    {
                        unset($objects[$key]);
                        continue;
                    }

                    $todo->begin = date::formatTime($todo->begin);
                    $todo->end   = date::formatTime($todo->end);
                }
            }

            if($objectType == 'task')
            {
                $this->app->loadLang('task');
                $this->app->loadLang('execution');

                $objects = $this->loadModel('task')->getUserTasks($this->app->user->account, 'assignedTo');

                foreach($objects as $k => $task)
                {
                    if(in_array($task->status, array('closed', 'cancel'))) unset($objects[$k]);
                    if($task->deadline) $task->deadline = date('m-d', strtotime($task->deadline));
                    $task->estimate .= 'h';
                    $task->left     .= 'h';
                }
                if($limitCount > 0) $objects = array_slice($objects, 0, $limitCount);
            }

            if($objectType == 'story')
            {
                foreach($objects as $key => $story)
                {
                    $story->isShadowProduct = isset($shadowProducts[$story->product]) ? 1 : 0;
                    $story->storyType       = $story->type;
                }
            }

            if($objectType == 'bug')         $this->app->loadLang('bug');
            if($objectType == 'risk')        $this->app->loadLang('risk');
            if($objectType == 'reviewissue') $this->app->loadLang('reviewissue');
            if($objectType == 'issue')       $this->app->loadLang('issue');

            if($objectType == 'feedback' || $objectType == 'ticket')
            {
                $this->app->loadLang('feedback');
                $this->app->loadLang('ticket');
            }

            $count[$objectType] = count($objects);
            $this->view->{$objectList[$objectType]} = $objects;
        }
        if(isset($hasViewPriv['testcase'])) $this->view->testcases = $this->loadModel('testcase')->getByAssignedTo($this->app->user->account, 'skip|run', 'id_desc', $pager);
        if(isset($hasViewPriv['testtask'])) $this->view->testtasks = $this->loadModel('testtask')->getByUser($this->app->user->account, $pager, 'id_desc', 'wait');

        if(isset($hasViewPriv['meeting']))
        {
            $this->app->loadLang('meeting');
            $today = helper::today();
            $now   = date('H:i:s', strtotime(helper::now()));

            $meetings = $this->dao->select('t1.*')->from(TABLE_MEETING)->alias('t1')
                ->leftJoin(TABLE_PROJECT)->alias('t2')->on('t1.project = t2.id')
                ->where('t1.deleted')->eq('0')
                ->andWhere('t2.deleted')->eq('0')
                ->andWhere('(t1.date')->gt($today)
                ->orWhere('(t1.begin')->gt($now)
                ->andWhere('t1.date')->eq($today)
                ->markRight(2)
                ->andwhere('(t1.host')->eq($this->app->user->account)
                ->orWhere('t1.participant')->in($this->app->user->account)
                ->markRight(1)
                ->orderBy('t1.id_desc')
                ->beginIF($limitCount)->limit($limitCount)->fi()
                ->fetchAll();

            $count['meeting'] = count($meetings);
            $this->view->meetings = $meetings;
            $this->view->depts    = $this->loadModel('dept')->getOptionMenu();
        }

        /* Compatible with the logic of the back button on the old page. */
        $this->session->set('demandList', $this->createLink('my', 'index'), 'my');

        $this->view->users          = $this->loadModel('user')->getPairs('all,noletter');
        $this->view->isExternalCall = $this->isExternalCall();
        $this->view->hasViewPriv    = $hasViewPriv;
        $this->view->products       = $this->dao->select('id, name')->from(TABLE_PRODUCT)->where('deleted')->eq('0')->fetchPairs('id', 'name');
        $this->view->projects       = $this->dao->select('id, name')->from(TABLE_PROJECT)->where('deleted')->eq('0')->fetchPairs('id', 'name');
        $this->view->count          = $count;
        return $count;
    }

    /**
     * 打印最近项目区块。
     * Print recent project block.
     *
     * @access protected
     * @return void
     */
    protected function printRecentProjectBlock()
    {
        $this->app->loadLang('program');

        /* load pager. */
        $this->app->loadClass('pager', true);
        $pager = new pager(0, 3, 1);

        $projects = $this->loadModel('project')->getList('all', 'id_desc', true, $pager);
        foreach($projects as $project)
        {
            $recentExecution = '';
            $executions      = $project->executions;
            foreach($executions as $execution)
            {
                if($execution->status == 'doing' && (empty($recentExecution) || $execution->realBegan > $recentExecution->realBegan))
                {
                    $recentExecution = $execution;
                }
            }
            $project->recentExecution = $recentExecution;
        }

        $this->view->projects = $projects;
    }

    /**
     * 打印项目团队区块。
     * Print project team block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printProjectTeamBlock($block)
    {
        $count   = isset($block->params->count)   ? $block->params->count   : 15;
        $status  = isset($block->params->type)    ? $block->params->type    : 'all';
        $orderBy = isset($block->params->orderBy) ? $block->params->orderBy : 'id_desc';

        /* Get projects. */
        $this->app->loadLang('task');
        $this->app->loadLang('program');
        $this->app->loadLang('execution');
        $this->view->projects = $this->loadModel('project')->getOverviewList($status, 0, $orderBy, $count);
    }

    /**
     * 打印文档统计区块。
     * Print document statistic block.
     *
     * @access protected
     * @return void
     */
    protected function printDocStatisticBlock()
    {
        $this->view->statistic = $this->loadModel('doc')->getStatisticInfo();
    }

    /**
     * 打印文档动态区块。
     * Print document dynamic block.
     *
     * @access protected
     * @return void
     */
    protected function printDocDynamicBlock()
    {
        /* Load pager. */
        $this->app->loadClass('pager', true);
        $pager = new pager(0, 30, 1);

        $this->view->actions = $this->loadModel('doc')->getDynamic($pager);
        $this->view->users   = $this->loadModel('user')->getPairs('nodeleted|noletter|all', '', 0, array_unique(array_column($this->view->actions, 'actor')));
    }

    /**
     * 打印我创建的文档区块。
     * Print my collection of documents block.
     *
     * @access protected
     * @return void
     */
    protected function printDocMyCreatedBlock()
    {
        /* Load pager. */
        $this->app->loadClass('pager', true);
        $pager = new pager(0, 6, 1);

        $docList = $this->loadModel('doc')->getDocsByBrowseType('openedbyme', 0, 0, 'addedDate_desc', $pager);
        $libList = array();
        foreach($docList as $doc)
        {
            $doc->editedDate   = substr($doc->editedDate, 0, 10);
            $doc->editInterval = helper::getDateInterval($doc->editedDate);

            $libList[] = $doc->lib;
        }

        $this->view->docList = $docList;
    }

    /**
     * 打印我关注的文档区块。
     * Print my collection of documents block.
     *
     * @access protected
     * @return void
     */
    protected function printDocMyCollectionBlock()
    {
        /* Load pager. */
        $this->app->loadClass('pager', true);
        $pager = new pager(0, 6, 1);

        $docList = $this->loadModel('doc')->getDocsByBrowseType('collectedbyme', 0, 0, 'editedDate_desc', $pager);
        $libList = array();
        foreach($docList as $doc)
        {
            $doc->editedDate   = substr($doc->editedDate, 0, 10);
            $doc->editInterval = helper::getDateInterval($doc->editedDate);

            $libList[] = $doc->lib;
        }

        $this->view->docList  = $docList;
    }

    /**
     * 打印最近更新的文档区块。
     * Print recent update block.
     *
     * @access protected
     * @return void
     */
    protected function printDocRecentUpdateBlock()
    {
        /* Load pager. */
        $this->app->loadClass('pager', true);
        $pager = new pager(0, 6, 1);

        $docList = $this->loadModel('doc')->getDocsByBrowseType('byediteddate', 0, 0, 'editedDate_desc', $pager);
        $libList = array();
        foreach($docList as $doc)
        {
            $doc->editedDate   = substr($doc->editedDate, 0, 10);
            $doc->editInterval = helper::getDateInterval($doc->editedDate);

            $libList[] = $doc->lib;
        }

        $this->view->docList  = $docList;
    }

    /**
     * 打印文档浏览排行区块。
     * Print view list block.
     *
     * @access protected
     * @return void
     */
    protected function printDocViewListBlock()
    {
        /* Load pager. */
        $this->app->loadClass('pager', true);
        $pager = new pager(0, 6, 1);

        $this->view->docList = $this->loadModel('doc')->getDocsByBrowseType('all', 0, 0,'views_desc', $pager);
    }

    /**
     * 打印文档关注排行区块。
     * Print collect list block.
     *
     * @access protected
     * @return void
     */
    protected function printDocCollectListBlock()
    {
        /* Load pager. */
        $this->app->loadClass('pager', true);
        $pager = new pager(0, 6, 1);

        $docList = $this->loadModel('doc')->getDocsByBrowseType('all', 0, 0, 'collects_desc', $pager);
        foreach($docList as $docID => $doc)
        {
            if(empty($doc->collects)) unset($docList[$docID]);
        }

        $this->view->docList = $docList;
    }

    /**
     * 打拼产品文档统计区块。
     * Print product's document block.
     *
     * @param  object    $block
     * @param  array     $params
     * @access protected
     * @return void
     */
    protected function printProductDocBlock($block, $params = array())
    {
        $type = 'involved';
        if(isset($params['type'])) $type = $params['type'];

        $this->loadModel('doc');
        $this->session->set('docList', $this->createLink('doc', 'index'), 'doc');

        /* Set project status and count. */
        $count         = isset($block->params->count) ? (int)$block->params->count : 15;
        $products      = $this->loadModel('product')->getOrderedProducts('all', 0, 0, 'all');
        $involveds     = $this->product->getOrderedProducts('involved', 0, 0, 'all');
        $productIdList = array_merge(array_keys($products), array_keys($involveds));

        $stmt = $this->dao->select('id,product,lib,title,type,addedBy,addedDate,editedDate,status,acl,`groups`,readGroups,users,readUsers,deleted')->from(TABLE_DOC)->alias('t1')
            ->where('deleted')->eq(0)
            ->andWhere('product')->in($productIdList)
            ->beginIF($this->config->doc->notArticleType)->andWhere('t1.type')->notIN($this->config->doc->notArticleType)->fi()
            ->orderBy('product,status,editedDate_desc')
            ->query();
        $docGroup = array();
        while($doc = $stmt->fetch())
        {
            if(!isset($docGroup[$doc->product])) $docGroup[$doc->product] = array();
            if(count($docGroup[$doc->product]) >= $count) continue;
            if($this->doc->checkPrivDoc($doc)) $docGroup[$doc->product][$doc->id] = $doc;
        }

        $hasDataProducts = $hasDataInvolveds = array();
        foreach($products as $productID => $product)
        {
            if(isset($docGroup[$productID]) && count($docGroup[$productID]) > 0)
            {
                $hasDataProducts[$productID] = $product;
                if(isset($involveds[$productID])) $hasDataInvolveds[$productID] = $product;
            }
        }

        $this->view->type     = $type;
        $this->view->users    = $this->loadModel('user')->getPairs('noletter');
        $this->view->products = $type == 'involved' ? $hasDataInvolveds : $hasDataProducts;
        $this->view->docGroup = $docGroup;
    }

    /**
     * 打印项目文档统计区块。
     * Print project's document block.
     *
     * @param  object    $block
     * @param  array     $params
     * @access protected
     * @return void
     */
    protected function printProjectDocBlock($block, $params = array())
    {
        $type = 'involved';
        if(isset($params['type'])) $type = $params['type'];

        $this->loadModel('doc');
        $this->app->loadLang('project');
        $this->session->set('docList', $this->createLink('doc', 'index'), 'doc');

        /* Set project status and count. */
        $count    = isset($block->params->count) ? (int)$block->params->count : 15;
        $projects = $this->dao->select('*')->from(TABLE_PROJECT)
            ->where('deleted')->eq('0')
            ->andWhere('vision')->eq($this->config->vision)
            ->andWhere('type')->eq('project')
            ->beginIF($this->config->vision == 'rnd')->andWhere('model')->ne('kanban')->fi()
            ->beginIF(!$this->app->user->admin)->andWhere('id')->in($this->app->user->view->projects)->fi()
            ->orderBy('order_asc,id_desc')
            ->fetchAll('id');

        $involveds = $this->dao->select('t1.*')->from(TABLE_PROJECT)->alias('t1')
            ->leftJoin(TABLE_TEAM)->alias('t2')->on('t1.id=t2.root')
            ->where('t1.deleted')->eq('0')
            ->andWhere('t1.vision')->eq($this->config->vision)
            ->andWhere('t1.type')->eq('project')
            ->beginIF($this->config->vision == 'rnd')->andWhere('t1.model')->ne('kanban')->fi()
            ->andWhere('t2.type')->eq('project')
            ->beginIF(!$this->app->user->admin)->andWhere('t1.id')->in($this->app->user->view->projects)->fi()
            ->andWhere('t1.openedBy', true)->eq($this->app->user->account)
            ->orWhere('t1.PM')->eq($this->app->user->account)
            ->orWhere('t2.account')->eq($this->app->user->account)
            ->markRight(1)
            ->orderBy('t1.order_asc,t1.id_desc')
            ->fetchAll('id');

        $projectIdList = array_keys($projects);

        $stmt = $this->dao->select('t1.id,t1.lib,t1.title,t1.type,t1.addedBy,t1.addedDate,t1.editedDate,t1.status,t1.acl,t1.groups,t1.readGroups,t1.users,t1.readUsers,t1.deleted,if(t1.project = 0, t2.project, t1.project) as project')->from(TABLE_DOC)->alias('t1')
            ->leftJoin(TABLE_EXECUTION)->alias('t2')->on('t1.execution=t2.id')
            ->where('t1.deleted')->eq(0)
            ->beginIF($this->config->doc->notArticleType)->andWhere('t1.type')->notIN($this->config->doc->notArticleType)->fi()
            ->andWhere('t2.deleted', true)->eq(0)
            ->orWhere('t2.deleted is null')
            ->markRight(1)
            ->andWhere('t1.project', true)->in($projectIdList)
            ->orWhere('t2.project')->in($projectIdList)
            ->markRight(1)
            ->orderBy('project,t1.status,t1.editedDate_desc')
            ->query();
        $docGroup = array();
        while($doc = $stmt->fetch())
        {
            if(!isset($docGroup[$doc->project])) $docGroup[$doc->project] = array();
            if(count($docGroup[$doc->project]) >= $count) continue;
            if($this->doc->checkPrivDoc($doc)) $docGroup[$doc->project][$doc->id] = $doc;
        }

        $hasDataProjects = $hasDataInvolveds = array();
        foreach($projects as $projectID => $project)
        {
            if(isset($docGroup[$projectID]) && count($docGroup[$projectID]) > 0)
            {
                $hasDataProjects[$projectID] = $project;
                if(isset($involveds[$projectID])) $hasDataInvolveds[$projectID] = $project;
            }
        }

        $this->view->type     = $type;
        $this->view->users    = $this->loadModel('user')->getPairs('noletter');
        $this->view->projects = $type == 'involved' ? $hasDataInvolveds : $hasDataProjects;
        $this->view->docGroup = $docGroup;
    }

    /**
     * 打印帮助区块。
     * Print guide block
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printGuideBlock($block)
    {
        $this->app->loadLang('custom');
        $this->app->loadLang('my');
        $this->loadModel('setting');

        $this->view->blockID       = $block->id;
        $this->view->programs      = $this->loadModel('program')->getTopPairs('noclosed', true);
        $this->view->programID     = isset($this->config->global->defaultProgram) ? $this->config->global->defaultProgram : 0;
        $this->view->URSRList      = $this->loadModel('custom')->getURSRPairs();
        $this->view->URSR          = $this->setting->getURSR();
        $this->view->programLink   = isset($this->config->programLink)   ? $this->config->programLink   : 'program-browse';
        $this->view->productLink   = isset($this->config->productLink)   ? $this->config->productLink   : 'product-all';
        $this->view->projectLink   = isset($this->config->projectLink)   ? $this->config->projectLink   : 'project-browse';
        $this->view->executionLink = isset($this->config->executionLink) ? $this->config->executionLink : 'execution-task';
    }

    /**
     * 打印产品月度推进分析区块。
     * Print product monthly progress block.
     *
     * @access protected
     * @return void
     */
    protected function printMonthlyProgressBlock()
    {
        /* 获取最近6个月的年月数组组合。 */
        $years  = array();
        $months = array();
        $dates  = array();
        for($i = 5; $i >= 0; $i --)
        {
            $years[]  = date('Y',   strtotime("first day of -{$i} month"));
            $months[] = date('m',   strtotime("first day of -{$i} month"));
            $dates[]  = date('Y-m', strtotime("first day of -{$i} month"));
        }

        $this->loadModel('metric');
        $monthFinishedScale = $this->metric->getResultByCodeWithArray('scale_of_monthly_finished_story', array('year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 从度量项获取月度完成需求规模数。
        $monthCreatedStory  = $this->metric->getResultByCodeWithArray('count_of_monthly_created_story',  array('year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 从度量项获取月度新增需求数。
        $monthFinishedStory = $this->metric->getResultByCodeWithArray('count_of_monthly_finished_story', array('year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 从度量项获取月度完成需求数。
        $monthCreatedBug    = $this->metric->getResultByCodeWithArray('count_of_monthly_created_bug',    array('year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 从度量项获取月度新增Bug数。
        $monthFinishedBug   = $this->metric->getResultByCodeWithArray('count_of_monthly_fixed_bug',      array('year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 从度量项获取月度解决Bug数。

        /* 重新组装度量项数据为年月和数据的数组。 */
        foreach($dates as $date)
        {
            $doneStoryEstimate[$date] = 0;
            $doneStoryCount[$date]    = 0;
            $createStoryCount[$date]  = 0;
            $fixedBugCount[$date]     = 0;
            $createBugCount[$date]    = 0;

            if(!empty($monthFinishedScale))
            {
                foreach($monthFinishedScale as $scale)
                {
                    if($date == "{$scale['year']}-{$scale['month']}") $doneStoryEstimate[$date] = $scale['value'];
                }
            }

            if(!empty($monthCreatedStory))
            {
                foreach($monthCreatedStory as $story)
                {
                    if($date == "{$story['year']}-{$story['month']}") $doneStoryCount[$date] = $story['value'];
                }
            }

            if(!empty($monthFinishedStory))
            {
                foreach($monthFinishedStory as $story)
                {
                    if($date == "{$story['year']}-{$story['month']}") $createStoryCount[$date] = $story['value'];
                }
            }

            if(!empty($monthCreatedBug))
            {
                foreach($monthCreatedBug as $bug)
                {
                    if($date == "{$bug['year']}-{$bug['month']}") $fixedBugCount[$date] = $bug['value'];
                }
            }

            if(!empty($monthFinishedBug))
            {
                foreach($monthFinishedBug as $bug)
                {
                    if($date == "{$bug['year']}-{$bug['month']}") $createBugCount[$date] = $bug['value'];
                }
            }
        }

        $this->view->doneStoryEstimate = $doneStoryEstimate;
        $this->view->doneStoryCount    = $doneStoryCount;
        $this->view->createStoryCount  = $createStoryCount;
        $this->view->fixedBugCount     = $fixedBugCount;
        $this->view->createBugCount    = $createBugCount;
    }

    /**
     * 打印产品年度工作量统计区块。
     * Print product annual workload statisitc block.
     *
     * @access protected
     * @return void
     */
    protected function printAnnualWorkloadBlock()
    {
        /* 获取产品列表， 按照产品分组展示数据。 */
        $products      = $this->loadModel('product')->getPairs();
        $productIdList = array_keys($products);

        $this->loadModel('metric');
        $finishEstimateGroup = $this->metric->getResultByCodeWithArray('scale_of_annual_finished_story_in_product', array('product' => join(',', $productIdList), 'year' => date('Y')), 'cron'); // 从度量项获取今年各产品完成的需求规模数。
        $doneStoryGroup      = $this->metric->getResultByCodeWithArray('count_of_annual_finished_story_in_product', array('product' => join(',', $productIdList), 'year' => date('Y')), 'cron'); // 从度量项获取今年各产品完成的需求数。
        $resolvedBugGroup    = $this->metric->getResultByCodeWithArray('count_of_annual_fixed_bug_in_product',   array('product' => join(',', $productIdList), 'year' => date('Y')), 'cron'); // 从度量项获取今年各产品修复的Bug数。

        if(!empty($finishEstimateGroup)) $finishEstimateGroup = array_column($finishEstimateGroup, null, 'product');
        if(!empty($doneStoryGroup))      $doneStoryGroup      = array_column($doneStoryGroup,      null, 'product');
        if(!empty($resolvedBugGroup))    $resolvedBugGroup    = array_column($resolvedBugGroup,    null, 'product');

        /* 组装数据成产品ID和度量数据的数组。*/
        $doneStoryEstimate = array();
        $doneStoryCount    = array();
        $resolvedBugCount  = array();
        foreach($products as $productID => $productName)
        {
            $doneStoryEstimate[$productID] = isset($finishEstimateGroup[$productID]['value']) ? $finishEstimateGroup[$productID]['value'] : 0;
            $doneStoryCount[$productID]    = isset($doneStoryGroup[$productID]['value'])      ? $doneStoryGroup[$productID]['value']      : 0;
            $resolvedBugCount[$productID]  = isset($resolvedBugGroup[$productID]['value'])    ? $resolvedBugGroup[$productID]['value']    : 0;
        }

        /* 从大到小排序。 */
        arsort($doneStoryEstimate);
        arsort($doneStoryCount);
        arsort($resolvedBugCount);

        $this->view->products          = $products;
        $this->view->doneStoryEstimate = $doneStoryEstimate;
        $this->view->doneStoryCount    = $doneStoryCount;
        $this->view->resolvedBugCount  = $resolvedBugCount;

        /* 获取各个分组中最大的值， 用来计算各个值所占的比例。 */
        $this->view->maxStoryEstimate  = !empty($doneStoryEstimate) ? max($doneStoryEstimate) : 0;
        $this->view->maxStoryCount     = !empty($doneStoryCount)    ? max($doneStoryCount)    : 0;
        $this->view->maxBugCount       = !empty($resolvedBugCount)  ? max($resolvedBugCount)  : 0;
    }

    /**
     * 打印产品的Bug数据区块。
     * Print bug statistic block.
     *
     * @param  object    $block
     * @param  array     $param
     * @access protected
     * @return void
     * @param mixed[] $params
     */
    protected function printBugStatisticBlock($block, $params = array())
    {
        /* 获取需要统计的产品列表。 */
        /* Obtain a list of products that require statistics. */
        $status     = isset($block->params->type)  ? $block->params->type  : '';
        $count      = isset($block->params->count) ? $block->params->count : '';
        $products   = $this->loadModel('product')->getOrderedProducts($status, (int)$count, 0, 'all');
        $productID  = !empty($params['active']) ? $params['active'] : key($products);
        if(empty($productID)) $productID = 0;

        $isShadow    = $productID ? (bool)$products[$productID]->shadow : false;
        $projectID   = $isShadow ? $this->dao->select('project')->from(TABLE_PROJECTPRODUCT)->where('product')->eq($productID)->fetch('project') : 0;
        $useObjectID = $isShadow ? $projectID : $productID;
        $useDataKey  = $isShadow ? 'project' : 'product';

        $this->loadModel('metric');
        $bugFixedRate      = $this->metric->getResultByCodeWithArray('rate_of_fixed_bug_in_product',      array('product' => $productID), 'cron'); // 从度量项获取各个产品的Bug修复率。
        $shadowBugFixRate  = $this->metric->getResultByCodeWithArray('rate_of_fixed_bug_in_project',      array('project' => $projectID), 'cron'); // 获取影子产品Bug修复率。

        $effectiveBugGroup  = $this->metric->getResultByCodeWithArray('count_of_effective_bug_in_product', array('product' => $productID), 'cron'); // 从度量项获取各个产品的有效Bug数。
        $shadowEffectiveBug = $this->metric->getResultByCodeWithArray('count_of_effective_bug_in_project', array('project' => $projectID), 'cron'); // 获取影子产品有效Bug总数。

        $fixedBugGroup       = $this->metric->getResultByCodeWithArray('count_of_fixed_bug_in_product',     array('product' => $productID), 'cron'); // 从度量项获取各个产品的Bug修复数。
        $shadowFixedBugGroup = $this->metric->getResultByCodeWithArray('count_of_fixed_bug_in_project',     array('project' => $projectID), 'cron'); // 获取影子产品Bug修复数。

        $activatedBugGroup       = $this->metric->getResultByCodeWithArray('count_of_activated_bug_in_product', array('product' => $productID), 'cron'); // 从度量项获取各个产品的Bug激活数。
        $shadowActivatedBugGroup = $this->metric->getResultByCodeWithArray('count_of_activated_bug_in_project', array('project' => $projectID), 'cron'); // 获取影子产品Bug激活数。

        if(!empty($bugFixedRate))            $bugFixedRate            = array_column($bugFixedRate,            null, 'product');
        if(!empty($shadowBugFixRate))        $shadowBugFixRate        = array_column($shadowBugFixRate,        null, 'project');
        if(!empty($effectiveBugGroup))       $effectiveBugGroup       = array_column($effectiveBugGroup,       null, 'product');
        if(!empty($shadowEffectiveBug))      $shadowEffectiveBug      = array_column($shadowEffectiveBug,      null, 'project');
        if(!empty($fixedBugGroup))           $fixedBugGroup           = array_column($fixedBugGroup,           null, 'product');
        if(!empty($shadowFixedBugGroup))     $shadowFixedBugGroup     = array_column($shadowFixedBugGroup,     null, 'project');
        if(!empty($activatedBugGroup))       $activatedBugGroup       = array_column($activatedBugGroup,       null, 'product');
        if(!empty($shadowActivatedBugGroup)) $shadowActivatedBugGroup = array_column($shadowActivatedBugGroup, null, 'project');

        /* 按照产品和日期分组获取产品每月新增和完成的需求数度量项。 */
        $years  = array();
        $months = array();
        $dates  = array();
        for($i = 5; $i >= 0; $i --)
        {
            $years[]  = date('Y',   strtotime("first day of -{$i} month"));
            $months[] = date('m',   strtotime("first day of -{$i} month"));
            $dates[]  = date('Y-m', strtotime("first day of -{$i} month"));
        }

        $monthCreatedBugGroup       = $this->metric->getResultByCodeWithArray('count_of_monthly_created_bug_in_product', array('product' => $productID, 'year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 从度量项获取每月的激活Bug数。
        $shadowMonthCreatedBugGroup = $this->metric->getResultByCodeWithArray('count_of_monthly_created_bug_in_project', array('project' => $projectID, 'year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 从度量项获取每月的激活Bug数。
        $monthClosedBugGroup        = $this->metric->getResultByCodeWithArray('count_of_monthly_closed_bug_in_product',  array('product' => $productID, 'year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 从度量项获取每月的关闭Bug数。
        $shadowMonthClosedBugGroup  = $this->metric->getResultByCodeWithArray('count_of_monthly_closed_bug_in_project',  array('project' => $projectID, 'year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 从度量项获取每月的关闭Bug数。

        /* 组装页面所需的度量项数组。 */
        $useClosedBug      = $isShadow ? 'shadowFixedBugGroup' : 'fixedBugGroup';
        $useUnresovledBugs = $isShadow ? 'shadowActivatedBugGroup' : 'activatedBugGroup';
        $useTotalBugs      = $isShadow ? 'shadowEffectiveBug' : 'effectiveBugGroup';
        $useResolvedRate   = $isShadow ? 'shadowBugFixRate' : 'bugFixedRate';

        $closedBugs     = isset($$useClosedBug[$useObjectID]['value'])      ? $$useClosedBug[$useObjectID]['value']          : 0;
        $unresovledBugs = isset($$useUnresovledBugs[$useObjectID]['value']) ? $$useUnresovledBugs[$useObjectID]['value']     : 0;
        $totalBugs      = isset($$useTotalBugs[$useObjectID]['value'])      ? $$useTotalBugs[$useObjectID]['value']          : 0;
        $resolvedRate   = isset($$useResolvedRate[$useObjectID]['value'])   ? $$useResolvedRate[$useObjectID]['value'] * 100 : 0;

        $useMonthCreate = $isShadow ? 'shadowMonthCreatedBugGroup' : 'monthCreatedBugGroup';
        $useMonthClose  = $isShadow ? 'shadowMonthClosedBugGroup'  : 'monthClosedBugGroup';
        foreach($dates as $date)
        {
            $activateBugs[$date] = 0;
            $resolveBugs[$date]  = 0;
            $closeBugs[$date]    = 0;

            if(!empty($$useMonthCreate))
            {
                foreach($$useMonthCreate as $data)
                {
                    if($date == "{$data['year']}-{$data['month']}" && $useObjectID == $data[$useDataKey]) $activateBugs[$date] = $data['value'];
                }
            }

            if(!empty($$useMonthClose))
            {
                foreach($$useMonthClose as $data)
                {
                    if($date == "{$data['year']}-{$data['month']}" && $useObjectID == $data[$useDataKey]) $closeBugs[$date] = $data['value'];
                }
            }
        }

        $this->view->months         = $months;
        $this->view->products       = $products;
        $this->view->totalBugs      = $totalBugs;
        $this->view->closedBugs     = $closedBugs;
        $this->view->unresovledBugs = $unresovledBugs;
        $this->view->resolvedRate   = $resolvedRate;
        $this->view->activateBugs   = $activateBugs;
        $this->view->resolveBugs    = $resolveBugs;
        $this->view->closeBugs      = $closeBugs;
    }

    /**
     * 打印团队成就区块。
     * Print Team Achievement block.
     *
     * @access protected
     * @return void
     */
    protected function printTeamAchievementBlock()
    {
        /* 获取昨日和今日可能的年月组合。 */
        $years  = array();
        $months = array();
        for($i = 0; $i <= 1; $i ++)
        {
            $years[] = date('Y', strtotime("-{$i} day"));
            $months[] = date('m', strtotime("-{$i} day"));
        }

        $this->loadModel('metric');
        $finishedTaskGroup = $this->metric->getResultByCodeWithArray('count_of_daily_finished_task', array('year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 完成任务数。
        $createdStoryGroup = $this->metric->getResultByCodeWithArray('count_of_daily_created_story', array('year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 创建需求数。
        $closedBugGroup    = $this->metric->getResultByCodeWithArray('count_of_daily_closed_bug',    array('year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 关闭Bug数。
        $runCaseGroup      = $this->metric->getResultByCodeWithArray('count_of_daily_run_case',      array('year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 执行用例数。
        $consumedGroup     = $this->metric->getResultByCodeWithArray('hour_of_daily_effort',         array('year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 消耗工时。

        /* 获取今日完成任务数和昨日完成任务数。 */
        $finishedTasks  = 0;
        $yesterdayTasks = 0;
        if($finishedTaskGroup)
        {
            foreach($finishedTaskGroup as $data)
            {
                $currentDay = "{$data['year']}-{$data['month']}-{$data['day']}";
                if($currentDay == date('Y-m-d'))                      $finishedTasks  = $data['value'];
                if($currentDay == date('Y-m-d', strtotime("-1 day"))) $yesterdayTasks = $data['value'];
            }
        }

        /* 获取今日创建需求数和昨日创建需求数。 */
        $createdStories   = 0;
        $yesterdayStories = 0;
        if($createdStoryGroup)
        {
            foreach($createdStoryGroup as $data)
            {
                $currentDay = "{$data['year']}-{$data['month']}-{$data['day']}";
                if($currentDay == date('Y-m-d'))                      $createdStories   = $data['value'];
                if($currentDay == date('Y-m-d', strtotime("-1 day"))) $yesterdayStories = $data['value'];
            }
        }

        /* 获取今日关闭Bug数和昨日关闭Bug数。 */
        $closedBugs    = 0;
        $yesterdayBugs = 0;
        if($closedBugGroup)
        {
            foreach($closedBugGroup as $data)
            {
                $currentDay = "{$data['year']}-{$data['month']}-{$data['day']}";
                if($currentDay == date('Y-m-d'))                      $closedBugs    = $data['value'];
                if($currentDay == date('Y-m-d', strtotime("-1 day"))) $yesterdayBugs = $data['value'];
            }
        }

        /* 获取今日执行用例数和昨日执行用例数。 */
        $runCases       = 0;
        $yesterdayCases = 0;
        if($runCaseGroup)
        {
            foreach($runCaseGroup as $data)
            {
                $currentDay = "{$data['year']}-{$data['month']}-{$data['day']}";
                if($currentDay == date('Y-m-d'))                      $runCases       = $data['value'];
                if($currentDay == date('Y-m-d', strtotime("-1 day"))) $yesterdayCases = $data['value'];
            }
        }

        /* 获取今日消耗工时和昨日消耗工时。 */
        $consumedHours  = 0;
        $yesterdayHours = 0;
        if($consumedGroup)
        {
            foreach($consumedGroup as $data)
            {
                $currentDay = "{$data['year']}-{$data['month']}-{$data['day']}";
                if($currentDay == date('Y-m-d'))                      $consumedHours  = $data['value'];
                if($currentDay == date('Y-m-d', strtotime("-1 day"))) $yesterdayHours = $data['value'];
            }
        }

        $this->view->finishedTasks    = $finishedTasks;
        $this->view->yesterdayTasks   = $yesterdayTasks;
        $this->view->createdStories   = $createdStories;
        $this->view->yesterdayStories = $yesterdayStories;
        $this->view->closedBugs       = $closedBugs;
        $this->view->yesterdayBugs    = $yesterdayBugs;
        $this->view->runCases         = $runCases;
        $this->view->yesterdayCases   = $yesterdayCases;
        $this->view->consumedHours    = $consumedHours;
        $this->view->yesterdayHours   = $yesterdayHours;
    }

    /**
     * 打印单个产品统计区块。
     * Print product statistic block.
     *
     * @param  object    $block
     * @access protected
     * @return bool
     */
    protected function printSingleStatisticBlock($block)
    {
        /* 获取需要统计的产品列表。 */
        /* Obtain a list of product that require statistics. */
        $status    = isset($block->params->type)  ? $block->params->type  : '';
        $count     = isset($block->params->count) ? $block->params->count : '';
        $productID = $this->session->product;

        $this->loadModel('metric');
        $storyDeliveryRate = $this->metric->getResultByCodeWithArray('rate_of_delivery_story_in_product',   array('product' => $productID), 'cron');
        $totalStories      = $this->metric->getResultByCodeWithArray('count_of_valid_story_in_product',     array('product' => $productID), 'cron');
        $closedStories     = $this->metric->getResultByCodeWithArray('count_of_delivered_story_in_product', array('product' => $productID), 'cron');
        $unclosedStories   = $this->metric->getResultByCodeWithArray('count_of_unclosed_story_in_product',  array('product' => $productID), 'cron');

        if(!empty($storyDeliveryRate)) $storyDeliveryRate = array_column($storyDeliveryRate, null, 'product');
        if(!empty($totalStories))      $totalStories      = array_column($totalStories,      null, 'product');
        if(!empty($closedStories))     $closedStories     = array_column($closedStories,     null, 'product');
        if(!empty($unclosedStories))   $unclosedStories   = array_column($unclosedStories,   null, 'product');

        /* 按照产品和日期分组获取产品每月新增和完成的需求数度量项。 */
        $years  = array();
        $months = array();
        $dates  = array();
        for($i = 5; $i >= 0; $i --)
        {
            $years[]  = date('Y',   strtotime("first day of -{$i} month"));
            $months[] = date('m',   strtotime("first day of -{$i} month"));
            $dates[]  = date('Y-m', strtotime("first day of -{$i} month"));
        }
        $monthFinish  = $this->metric->getResultByCodeWithArray('count_of_monthly_finished_story_in_product', array('product' => $productID, 'year' => join(',', $years), 'month' => join(',', $months)), 'cron');
        $monthCreated = $this->metric->getResultByCodeWithArray('count_of_monthly_created_story_in_product',  array('product' => $productID, 'year' => join(',', $years), 'month' => join(',', $months)), 'cron');

        /* 根据产品列表获取预计开始日期距离现在最近且预计开始日期大于当前日期的未开始状态计划。 */
        /* Obtain an unstarted status plan based on the product list, with an expected start date closest to the current date and an expected start date greater than the current date. */
        $newPlan = $this->dao->select('*')->from(TABLE_PRODUCTPLAN)
            ->where('deleted')->eq('0')
            ->andWhere('product')->eq($productID)
            ->andWhere('begin')->ge(date('Y-m-d'))
            ->andWhere('status')->eq('wait')
            ->orderBy('begin_desc,id_desc')
            ->fetch();

        /* 根据产品列表获取实际开始日期距离当前最近的进行中状态的执行。 */
        /* Obtain the execution of the current in progress status closest to the actual start date based on the product list. */
        $newExecution = $this->dao->select('execution.*,relation.product')->from(TABLE_EXECUTION)->alias('execution')
            ->leftJoin(TABLE_PROJECTPRODUCT)->alias('relation')->on('execution.id=relation.project')
            ->where('execution.deleted')->eq('0')
            ->andWhere('execution.type')->eq('sprint')
            ->andWhere('relation.product')->eq($productID)
            ->andWhere('execution.status')->eq('doing')
            ->orderBy('realBegan_desc,id_desc')
            ->fetch();

        /* 根据产品列表获取发布日期距离现在最近且发布日期小于当前日期的发布。 */
        /* Retrieve releases with the latest release date from the product list and a release date earlier than the current date. */
        $newRelease = $this->dao->select('*')->from(TABLE_RELEASE)
            ->where('deleted')->eq('0')
            ->andWhere('product')->eq($productID)
            ->andWhere('date')->le(date('Y-m-d'))
            ->orderBy('date_desc,id_desc')
            ->fetch();

        $product = $this->loadModel('product')->getByID($productID);

        $product->storyDeliveryRate = !empty($storyDeliveryRate) && !empty($storyDeliveryRate[$productID]) ? zget($storyDeliveryRate[$productID], 'value') * 100 : 0;
        $product->totalStories      = !empty($totalStories)      && !empty($totalStories[$productID])      ? zget($totalStories[$productID], 'value') : 0;
        $product->closedStories     = !empty($closedStories)     && !empty($closedStories[$productID])     ? zget($closedStories[$productID], 'value') : 0;
        $product->unclosedStories   = !empty($unclosedStories)   && !empty($unclosedStories[$productID])   ? zget($unclosedStories[$productID], 'value') : 0;
        $product->newPlan           = $newPlan;
        $product->newExecution      = $newExecution;
        $product->newRelease        = $newRelease;

        /* 将按照产品分组的统计数据放入产品列表中。 */
        /* Place statistical data grouped by product into the product list. */
        foreach($dates as $date)
        {
            $product->monthFinish[$date]  = 0;
            $product->monthCreated[$date] = 0;
            if(!empty($monthFinish))
            {
                foreach($monthFinish as $story)
                {
                    if($date == "{$story['year']}-{$story['month']}" && $productID == $story['product']) $product->monthFinish[$date] = $story['value'];
                }
            }
            if(!empty($monthCreated))
            {
                foreach($monthCreated as $story)
                {
                    if($date == "{$story['year']}-{$story['month']}" && $productID == $story['product']) $product->monthCreated[$date] = $story['value'];
                }
            }
        }

        $this->view->product = $product;
    }

    /**
     * 打印单个产品的bug统计区块。
     * Print single product bug statistic block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printSingleBugStatisticBlock($block)
    {
        /* 获取需要统计的产品列表。 */
        /* Obtain a list of products that require statistics. */
        $status    = isset($block->params->type)  ? $block->params->type  : '';
        $count     = isset($block->params->count) ? $block->params->count : '';
        $productID = $this->session->product;

        $this->loadModel('metric');
        $bugFixedRate      = $this->metric->getResultByCodeWithArray('rate_of_fixed_bug_in_product',      array('product' => $productID), 'cron'); // 从度量项获取各个产品的Bug修复率。
        $effectiveBugGroup = $this->metric->getResultByCodeWithArray('count_of_effective_bug_in_product', array('product' => $productID), 'cron'); // 从度量项获取各个产品的有效Bug数。
        $fixedBugGroup     = $this->metric->getResultByCodeWithArray('count_of_fixed_bug_in_product',     array('product' => $productID), 'cron'); // 从度量项获取各个产品的Bug修复数。
        $activatedBugGroup = $this->metric->getResultByCodeWithArray('count_of_activated_bug_in_product', array('product' => $productID), 'cron'); // 从度量项获取各个产品的Bug激活数。

        if(!empty($bugFixedRate))      $bugFixedRate      = array_column($bugFixedRate,      null, 'product');
        if(!empty($effectiveBugGroup)) $effectiveBugGroup = array_column($effectiveBugGroup, null, 'product');
        if(!empty($fixedBugGroup))     $fixedBugGroup     = array_column($fixedBugGroup,     null, 'product');
        if(!empty($fixedBugGroup))     $activatedBugGroup = array_column($activatedBugGroup, null, 'product');

        /* 按照产品和日期分组获取产品每月新增和完成的需求数度量项。 */
        $years  = array();
        $months = array();
        $dates  = array();
        for($i = 5; $i >= 0; $i --)
        {
            $years[]  = date('Y',   strtotime("first day of -{$i} month"));
            $months[] = date('m',   strtotime("first day of -{$i} month"));
            $dates[]  = date('Y-m', strtotime("first day of -{$i} month"));
        }

        $monthCreatedBugGroup = $this->metric->getResultByCodeWithArray('count_of_monthly_created_bug_in_product', array('product' => $productID, 'year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 从度量项获取每月的激活Bug数。
        $monthClosedBugGroup  = $this->metric->getResultByCodeWithArray('count_of_monthly_closed_bug_in_product',  array('product' => $productID, 'year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 从度量项获取每月的关闭Bug数。

        /* 组装页面所需的度量项数组。 */
        $activateBugs   = array();
        $resolveBugs    = array();
        $closeBugs      = array();
        $closedBugs     = isset($fixedBugGroup[$productID]['value'])     ? $fixedBugGroup[$productID]['value']      : 0;
        $unresovledBugs = isset($activatedBugGroup[$productID]['value']) ? $activatedBugGroup[$productID]['value']  : 0;
        $totalBugs      = isset($effectiveBugGroup[$productID]['value']) ? $effectiveBugGroup[$productID]['value']  : 0;
        $resolvedRate   = isset($bugFixedRate[$productID]['value'])      ? $bugFixedRate[$productID]['value'] * 100 : 0;
        foreach($dates as $date)
        {
            $activateBugs[$date] = 0;
            $resolveBugs[$date]  = 0;
            $closeBugs[$date]    = 0;

            if(!empty($monthCreatedBugGroup))
            {
                foreach($monthCreatedBugGroup as $data)
                {
                    if($date == "{$data['year']}-{$data['month']}") $activateBugs[$date] = $data['value'];
                }
            }

            if(!empty($monthClosedBugGroup))
            {
                foreach($monthClosedBugGroup as $data)
                {
                    if($date == "{$data['year']}-{$data['month']}") $closeBugs[$date] = $data['value'];
                }
            }
        }

        $this->view->productID      = $productID;
        $this->view->months         = $months;
        $this->view->totalBugs      = $totalBugs;
        $this->view->closedBugs     = $closedBugs;
        $this->view->unresovledBugs = $unresovledBugs;
        $this->view->resolvedRate   = $resolvedRate;
        $this->view->activateBugs   = $activateBugs;
        $this->view->resolveBugs    = $resolveBugs;
        $this->view->closeBugs      = $closeBugs;
    }

    /**
     * 打印单个产品的需求列表区块。
     * Print single product story block.
     *
     * @params object     $block
     * @access protected
     * @return void
     * @param object $block
     */
    protected function printSingleStoryBlock($block)
    {
        $this->session->set('storyList', $this->createLink('product', 'dashboard'), 'product');
        if(preg_match('/[^a-zA-Z0-9_]/', $block->params->type)) return;

        $this->app->loadClass('pager', true);
        $count     = isset($block->params->count) ? (int)$block->params->count : 0;
        $pager     = pager::init(0, $count , 1);
        $type      = isset($block->params->type) ? $block->params->type : 'assignedTo';
        $orderBy   = isset($block->params->type) ? $block->params->orderBy : 'id_asc';
        $productID = $this->session->product;

        $this->view->stories = $this->loadModel('story')->getUserStories($this->app->user->account, $type, $orderBy, $this->viewType != 'json' ? $pager : '', 'story', true, 0, $productID);
    }

    /**
     * 打印单个产品发布列表区块数据。
     * Print releases block.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function printSingleReleaseBlock($block)
    {
        $uri = $this->createLink('product', 'dashboard');
        $this->session->set('releaseList', $uri, 'product');
        $this->session->set('buildList', $uri, 'execution');

        $productID = $this->session->product;

        $this->app->loadLang('release');
        $this->view->releases = $this->dao->select('t1.*,t2.name as productName')->from(TABLE_RELEASE)->alias('t1')
            ->leftJoin(TABLE_PRODUCT)->alias('t2')->on('t1.product=t2.id')
            ->where('t1.deleted')->eq('0')
            ->andWhere('t1.product')->eq($productID)
            ->orderBy('t1.id desc')
            ->beginIF($this->viewType != 'json')->limit((int)$block->params->count)->fi()
            ->fetchAll();
        $this->view->builds = $this->dao->select('id,name')->from(TABLE_BUILD)->where('deleted')->eq(0)->andWhere('product')->eq($productID)->fetchPairs();
    }

    /**
     * 打印单个产品计划列表区块。
     * Print single product plan block.
     *
     * @param  object    $block
     * @access protected
     * @return bool
     */
    protected function printSinglePlanBlock($block)
    {
        $uri = $this->createLink('product', 'dashboard');
        $this->session->set('productList', $uri, 'product');
        $this->session->set('productPlanList', $uri, 'product');

        $this->app->loadClass('pager', true);
        $count     = isset($block->params->count) ? (int)$block->params->count : 0;
        $pager     = pager::init(0, $count , 1);
        $productID = $this->session->product;
        $product   = $this->loadModel('product')->getByID($productID);

        $this->view->plans    = $this->loadModel('productplan')->getList($productID, 0, 'all', $pager, 'begin_desc', 'noproduct');
        $this->view->products = array($productID => $product->name);
    }

    /**
     * Print single product latest dynamic.
     *
     * @access protected
     * @return void
     */
    protected function printSingleDynamicBlock()
    {
        $productID = $this->session->product;

        $this->view->productID = $productID;
        $this->view->actions   = $this->loadModel('action')->getDynamic('all', 'all', 'date_desc', 30, $productID);
        $this->view->users     = $this->loadModel('user')->getPairs('nodeleted|noletter|all');
    }

    /**
     * 打印产品月度推进分析区块.
     * Print monthly progress for the product.
     *
     * @access protected
     * @return void
     */
    protected function printSingleMonthlyProgressBlock()
    {
        $productID = $this->session->product;

        /* 按照产品和日期分组获取产品每月新增和完成的需求数度量项。 */
        $years  = array();
        $months = array();
        $dates  = array();
        for($i = 5; $i >= 0; $i --)
        {
            $years[]  = date('Y',   strtotime("first day of -{$i} month"));
            $months[] = date('m',   strtotime("first day of -{$i} month"));
            $dates[]  = date('Y-m', strtotime("first day of -{$i} month"));
        }

        $this->loadModel('metric');
        $monthStroyScaleGroup     = $this->metric->getResultByCodeWithArray('scale_of_monthly_finished_story_in_product',  array('product' => $productID, 'year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 从度量项获取每月的完成需求数。
        $monthCreatedStroyGroup   = $this->metric->getResultByCodeWithArray('count_of_monthly_created_story_in_product',   array('product' => $productID, 'year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 从度量项获取每月的新增需求数。
        $monthFinishedStoryGroup  = $this->metric->getResultByCodeWithArray('count_of_monthly_finished_story_in_product',  array('product' => $productID, 'year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 从度量项获取每月的完成需求数。
        $monthCreatedBugGroup     = $this->metric->getResultByCodeWithArray('count_of_monthly_created_bug_in_product',     array('product' => $productID, 'year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 从度量项获取每月的新增Bug数。
        $monthFixedBugGroup       = $this->metric->getResultByCodeWithArray('count_of_monthly_fixed_bug_in_product',       array('product' => $productID, 'year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 从度量项获取每月的修复Bug数。
        $monthCreatedReleaseGroup = $this->metric->getResultByCodeWithArray('count_of_monthly_created_release_in_product', array('product' => $productID, 'year' => join(',', $years), 'month' => join(',', $months)), 'cron'); // 从度量项获取每月的发布数。

        $months            = array();
        $doneStoryEstimate = array();
        $doneStoryCount    = array();
        $createStoryCount  = array();
        $fixedBugCount     = array();
        $createBugCount    = array();
        $releaseCount      = array();
        foreach($dates as $date)
        {
            $doneStoryEstimate[$date] = 0;
            $doneStoryCount[$date]    = 0;
            $createStoryCount[$date]  = 0;
            $fixedBugCount[$date]     = 0;
            $createBugCount[$date]    = 0;
            $releaseCount[$date]      = 0;

            if(!empty($monthStroyScaleGroup))
            {
                foreach($monthStroyScaleGroup as $data)
                {
                    if($date == "{$data['year']}-{$data['month']}") $doneStoryEstimate[$date] = $data['value'];
                }
            }

            if(!empty($monthCreatedStroyGroup))
            {
                foreach($monthCreatedStroyGroup as $data)
                {
                    if($date == "{$data['year']}-{$data['month']}") $createStoryCount[$date] = $data['value'];
                }
            }
            if(!empty($monthFinishedStoryGroup))
            {
                foreach($monthFinishedStoryGroup as $data)
                {
                    if($date == "{$data['year']}-{$data['month']}") $doneStoryCount[$date] = $data['value'];
                }
            }
            if(!empty($monthCreatedBugGroup))
            {
                foreach($monthCreatedBugGroup as $data)
                {
                    if($date == "{$data['year']}-{$data['month']}") $createBugCount[$date] = $data['value'];
                }
            }
            if(!empty($monthFixedBugGroup))
            {
                foreach($monthFixedBugGroup as $data)
                {
                    if($date == "{$data['year']}-{$data['month']}") $fixedBugCount[$date] = $data['value'];
                }
            }
            if(!empty($monthCreatedReleaseGroup))
            {
                foreach($monthCreatedReleaseGroup as $data)
                {
                    if($date == "{$data['year']}-{$data['month']}") $releaseCount[$date] = $data['value'];
                }
            }
        }

        $this->view->months            = $months;
        $this->view->doneStoryEstimate = $doneStoryEstimate;
        $this->view->doneStoryCount    = $doneStoryCount;
        $this->view->createStoryCount  = $createStoryCount;
        $this->view->fixedBugCount     = $fixedBugCount;
        $this->view->createBugCount    = $createBugCount;
        $this->view->releaseCount      = $releaseCount;
    }

    /**
     * 判断是否为内部调用。
     * Check request client is chandao or not.
     *
     * @access protected
     * @return bool
     */
    protected function isExternalCall()
    {
        return isset($_GET['hash']);
    }

    /**
     * 为control 层 printBlock 方法返回json 格式数据。
     * Return json data for printBlock.
     *
     * @access protected
     * @return string
     */
    protected function printBlock4Json()
    {
        unset($this->view->app);
        unset($this->view->config);
        unset($this->view->lang);
        unset($this->view->header);
        unset($this->view->position);
        unset($this->view->moduleTree);

        $output['status'] = is_object($this->view) ? 'success' : 'fail';
        $output['data']   = json_encode($this->view);
        $output['md5']    = md5(json_encode($this->view));
        return print(json_encode($output));
    }

    /**
     * 组织外部数据。
     * Organiza external data.
     *
     * @param  object    $block
     * @access protected
     * @return void
     */
    protected function organizaExternalData($block)
    {
        $lang = isset($this->get->lang) ? $this->get->lang : 'zh-cn';
        $lang = str_replace('_', '-', $lang);
        $this->app->setClientLang($lang);
        $this->app->loadLang('common');

        if(!isset($block->params) && !isset($block->params->account))
        {
            $this->app->user = new stdclass();
            $this->app->user->account = 'guest';
            $this->app->user->realname= 'guest';
        }
        else
        {
            $this->app->user = $this->dao->select('*')->from(TABLE_USER)->where('ranzhi')->eq($block->params->account)->fetch();
            if(empty($this->app->user))
            {
                $this->app->user = new stdclass();
                $this->app->user->account = 'guest';
                $this->app->user->realname= 'guest';
            }
        }
        $this->app->user->admin  = strpos($this->app->company->admins, ",{$this->app->user->account},") !== false;
        $this->app->user->rights = $this->loadModel('user')->authorize($this->app->user->account);
        $this->app->user->groups = $this->user->getGroups($this->app->user->account);
        $this->app->user->view   = $this->user->grantUserView($this->app->user->account, $this->app->user->rights['acls']);

        $sso = isset($this->get->sso) ? base64_decode($this->get->sso) : '';
        $this->view->sso  = $sso;
        $this->view->sign = strpos($sso, '?') === false ? '?' : '&';
    }

    /**
     * 获取项目总览相关数据。
     * Get project overview related data.
     *
     * @param  array     $projectIdList
     * @access protected
     * @return array
     */
    protected function getProjectsStatisticData($projectIdList)
    {
        $vision = $this->config->vision;
        /* 敏捷和瀑布相关目的统计信息。 */
        $riskCountGroup  = $this->loadModel('metric')->getResultByCodeWithArray('count_of_opened_risk_in_project',  array('project' => join(',', $projectIdList)), 'cron', null, $vision);
        $issueCountGroup = $this->metric->getResultByCodeWithArray('count_of_opened_issue_in_project', array('project' => join(',', $projectIdList)), 'cron', null, $vision);
        if($riskCountGroup)  $riskCountGroup  = array_column($riskCountGroup,  null, 'project');
        if($issueCountGroup) $issueCountGroup = array_column($issueCountGroup, null, 'project');

        $modelType    = $this->block->getModelType4Projects($projectIdList);
        $getScrum     = in_array($modelType, array('all', 'scrum'));
        $getWaterfall = in_array($modelType, array('all', 'waterfall'));

        $investedGroup      = array();
        $consumeTaskGroup   = array();
        $leftTaskGroup      = array();
        $countStoryGroup    = array();
        $finishedStoryGroup = array();
        $unclosedStoryGroup = array();
        $countTaskGroup     = array();
        $waitTaskGroup      = array();
        $doingTaskGroup     = array();
        $countBugGroup      = array();
        $closedBugGroup     = array();
        $activatedBugGroup  = array();
        $SVGroup            = array();
        $PVGroup            = array();
        $EVGroup            = array();
        $CVGroup            = array();
        $ACGroup            = array();
        if($getScrum)
        {
            /* 敏捷项目的统计信息。 */
            $investedGroup      = $this->metric->getResultByCodeWithArray('day_of_invested_in_project',         array('project' => join(',', $projectIdList)), 'cron', null, $vision);
            $consumeTaskGroup   = $this->metric->getResultByCodeWithArray('consume_of_task_in_project',         array('project' => join(',', $projectIdList)), 'cron', null, $vision);
            $leftTaskGroup      = $this->metric->getResultByCodeWithArray('left_of_task_in_project',            array('project' => join(',', $projectIdList)), 'cron', null, $vision);
            $countStoryGroup    = $this->metric->getResultByCodeWithArray('scale_of_story_in_project',          array('project' => join(',', $projectIdList)), 'cron', null, $vision);
            $finishedStoryGroup = $this->metric->getResultByCodeWithArray('count_of_finished_story_in_project', array('project' => join(',', $projectIdList)), 'cron', null, $vision);
            $unclosedStoryGroup = $this->metric->getResultByCodeWithArray('count_of_unclosed_story_in_project', array('project' => join(',', $projectIdList)), 'cron', null, $vision);
            $countTaskGroup     = $this->metric->getResultByCodeWithArray('count_of_task_in_project',           array('project' => join(',', $projectIdList)), 'cron', null, $vision);
            $waitTaskGroup      = $this->metric->getResultByCodeWithArray('count_of_wait_task_in_project',      array('project' => join(',', $projectIdList)), 'cron', null, $vision);
            $doingTaskGroup     = $this->metric->getResultByCodeWithArray('count_of_doing_task_in_project',     array('project' => join(',', $projectIdList)), 'cron', null, $vision);
            $countBugGroup      = $this->metric->getResultByCodeWithArray('count_of_bug_in_project',            array('project' => join(',', $projectIdList)), 'cron', null, $vision);
            $closedBugGroup     = $this->metric->getResultByCodeWithArray('count_of_closed_bug_in_project ',    array('project' => join(',', $projectIdList)), 'cron', null, $vision);
            $activatedBugGroup  = $this->metric->getResultByCodeWithArray('count_of_activated_bug_in_project',  array('project' => join(',', $projectIdList)), 'cron', null, $vision);
            if($investedGroup)      $investedGroup      = array_column($investedGroup,      null, 'project');
            if($consumeTaskGroup)   $consumeTaskGroup   = array_column($consumeTaskGroup,   null, 'project');
            if($leftTaskGroup)      $leftTaskGroup      = array_column($leftTaskGroup,      null, 'project');
            if($countStoryGroup)    $countStoryGroup    = array_column($countStoryGroup,    null, 'project');
            if($finishedStoryGroup) $finishedStoryGroup = array_column($finishedStoryGroup, null, 'project');
            if($unclosedStoryGroup) $unclosedStoryGroup = array_column($unclosedStoryGroup, null, 'project');
            if($countTaskGroup)     $countTaskGroup     = array_column($countTaskGroup,     null, 'project');
            if($waitTaskGroup)      $waitTaskGroup      = array_column($waitTaskGroup,      null, 'project');
            if($doingTaskGroup)     $doingTaskGroup     = array_column($doingTaskGroup,     null, 'project');
            if($countBugGroup)      $countBugGroup      = array_column($countBugGroup,      null, 'project');
            if($closedBugGroup)     $closedBugGroup     = array_column($closedBugGroup,     null, 'project');
            if($activatedBugGroup)  $activatedBugGroup  = array_column($activatedBugGroup,  null, 'project');
        }

        if($getWaterfall)
        {
            /* 瀑布项目的统计信息。 */
            $SVGroup           = $this->metric->getResultByCodeWithArray('sv_weekly_in_waterfall',                  array('project' => join(',', $projectIdList), 'week' => substr(date('oW'), -2)), 'cron', null, $vision);
            $PVGroup           = $this->metric->getResultByCodeWithArray('pv_of_weekly_task_in_waterfall',          array('project' => join(',', $projectIdList), 'week' => substr(date('oW'), -2)), 'cron', null, $vision);
            $EVGroup           = $this->metric->getResultByCodeWithArray('ev_of_weekly_finished_task_in_waterfall', array('project' => join(',', $projectIdList), 'week' => substr(date('oW'), -2)), 'cron', null, $vision);
            $CVGroup           = $this->metric->getResultByCodeWithArray('cv_weekly_in_waterfall',                  array('project' => join(',', $projectIdList), 'week' => substr(date('oW'), -2)), 'cron', null, $vision);
            $ACGroup           = $this->metric->getResultByCodeWithArray('ac_of_weekly_all_in_waterfall',           array('project' => join(',', $projectIdList), 'week' => substr(date('oW'), -2)), 'cron', null, $vision);
            if($SVGroup)           $SVGroup           = array_column($SVGroup,           null, 'project');
            if($PVGroup)           $PVGroup           = array_column($PVGroup,           null, 'project');
            if($EVGroup)           $EVGroup           = array_column($EVGroup,           null, 'project');
            if($CVGroup)           $CVGroup           = array_column($CVGroup,           null, 'project');
            if($ACGroup)           $ACGroup           = array_column($ACGroup,           null, 'project');
        }

        return array('riskCountGroup' => $riskCountGroup, 'issueCountGroup' => $issueCountGroup, 'investedGroup' => $investedGroup, 'consumeTaskGroup' => $consumeTaskGroup, 'leftTaskGroup' => $leftTaskGroup, 'countStoryGroup' => $countStoryGroup, 'finishedStoryGroup' => $finishedStoryGroup, 'unclosedStoryGroup' => $unclosedStoryGroup, 'countTaskGroup' => $countTaskGroup, 'waitTaskGroup' => $waitTaskGroup, 'doingTaskGroup' => $doingTaskGroup, 'countBugGroup' => $countBugGroup, 'closedBugGroup' => $closedBugGroup, 'activatedBugGroup' => $activatedBugGroup) + ($getWaterfall ? array('SVGroup' => $SVGroup, 'PVGroup' => $PVGroup, 'EVGroup' => $EVGroup, 'CVGroup' => $CVGroup, 'ACGroup' => $ACGroup) : array());
    }

    /**
     * 构建项目统计信息。
     * Build project statistic.
     *
     * @param  object    $project
     * @param  array     $data
     * @param  object    $pager
     * @access protected
     * @return object
     */
    protected function buildProjectStatistic($project, $data, $pager = null)
    {
        extract($data);
        $projectID = $project->id;

        if(in_array($project->model, array('scrum', 'kanban', 'agileplus')))
        {
            $project->executions   = $this->loadModel('execution')->getStatData($projectID, 'all', 0, 0, false, '', 'id_desc', $pager);
            $project->costs        = isset($investedGroup[$projectID]['value'])      ? $investedGroup[$projectID]['value']      : 0;
            $project->consumed     = isset($consumeTaskGroup[$projectID]['value'])   ? $consumeTaskGroup[$projectID]['value']   : 0;
            $project->remainder    = isset($leftTaskGroup[$projectID]['value'])      ? $leftTaskGroup[$projectID]['value']      : 0;
            $project->storyPoints  = isset($countStoryGroup[$projectID]['value'])    ? $countStoryGroup[$projectID]['value']    : 0;
            $project->done         = isset($finishedStoryGroup[$projectID]['value']) ? $finishedStoryGroup[$projectID]['value'] : 0;
            $project->undone       = isset($unclosedStoryGroup[$projectID]['value']) ? $unclosedStoryGroup[$projectID]['value'] : 0;
            $project->tasks        = isset($countTaskGroup[$projectID]['value'])     ? $countTaskGroup[$projectID]['value']     : 0;
            $project->wait         = isset($waitTaskGroup[$projectID]['value'])      ? $waitTaskGroup[$projectID]['value']      : 0;
            $project->doing        = isset($doingTaskGroup[$projectID]['value'])     ? $doingTaskGroup[$projectID]['value']     : 0;
            $project->bugs         = isset($countBugGroup[$projectID]['value'])      ? $countBugGroup[$projectID]['value']      : 0;
            $project->closed       = isset($closedBugGroup[$projectID]['value'])     ? $closedBugGroup[$projectID]['value']     : 0;
            $project->activated    = isset($activatedBugGroup[$projectID]['value'])  ? $activatedBugGroup[$projectID]['value']  : 0;
        }
        elseif(in_array($project->model, array('waterfall', 'waterfallplus', 'ipd')))
        {
            $project->pv = isset($PVGroup[$projectID]['value']) ? sprintf('%.2f', $PVGroup[$projectID]['value']) : 0;
            $project->ev = isset($EVGroup[$projectID]['value']) ? sprintf('%.2f', $EVGroup[$projectID]['value']) : 0;
            $project->ac = isset($ACGroup[$projectID]['value']) ? sprintf('%.2f', $ACGroup[$projectID]['value']) : 0;
            $project->sv = isset($SVGroup[$projectID]['value']) ? sprintf('%.4f', $SVGroup[$projectID]['value']) * 100 : 0;
            $project->cv = isset($CVGroup[$projectID]['value']) ? sprintf('%.4f', $CVGroup[$projectID]['value']) * 100 : 0;
        }
        if($project->end != LONG_TIME) $project->remainingDays = helper::diffDate($project->end, helper::today());
        $project->risks  = isset($riskCountGroup[$projectID]['value']) ? (int)$riskCountGroup[$projectID]['value'] : 0;
        $project->issues = isset($issueCountGroup[$projectID]['value']) ? (int)$issueCountGroup[$projectID]['value'] : 0;

        return $project;
    }
}