zentao/module/dataview/table/testresult.php

<?php
$this->app->loadLang('testcase');
$this->app->loadLang('testtask');
$this->app->loadLang('project');
$this->app->loadLang('execution');
$this->app->loadLang('tree');
$this->app->loadLang('build');
$this->app->loadLang('caselib');
$this->app->loadLang('product');
$this->app->loadLang('dataview');

$schema = new stdclass();

$schema->primaryTable = 'testresult';

$schema->tables = array();
$schema->tables['testcase']   = 'zt_case';
$schema->tables['testrun']    = 'zt_testrun';
$schema->tables['testresult'] = 'zt_testresult';
$schema->tables['testtask']   = 'zt_testtask';
$schema->tables['project']    = 'zt_project';
$schema->tables['execution']  = 'zt_project';
$schema->tables['casemodule'] = 'zt_module';
$schema->tables['build']      = 'zt_build';
$schema->tables['caselib']    = 'zt_testsuite';
$schema->tables['product']    = 'zt_product';

$schema->joins = array();
$schema->joins['testcase']   = '`testcase`.`id`   = `testresult`.`case`';
$schema->joins['testrun']    = '`testrun`.`id`    = `testresult`.`run`';
$schema->joins['testtask']   = '`testrun`.`task`  = `testtask`.`id`';
$schema->joins['project']    = '`project`.`id`    = CAST(`testtask`.`project` AS DECIMAL)';
$schema->joins['execution']  = '`execution`.`id`  = `testtask`.`execution`';
$schema->joins['casemodule'] = '`casemodule`.`id` = `testcase`.`module`';
$schema->joins['build']      = '`build`.`id`      = CAST(`testtask`.`build` AS DECIMAL)';
$schema->joins['caselib']    = '`caselib`.`id`    = `testcase`.`lib`';
$schema->joins['product']    = '`product`.`id`    = `testcase`.`product`';

$schema->fields = array();
$schema->fields['caseResult']  = array('type' => 'option', 'name' => $this->lang->testtask->caseResult, 'options' => $this->lang->testcase->resultList);
$schema->fields['stepResults'] = array('type' => 'json',   'name' => $this->lang->testtask->stepResults);
$schema->fields['lastRunner']  = array('type' => 'user',   'name' => $this->lang->testtask->lastRunner);
$schema->fields['date']        = array('type' => 'date',   'name' => $this->lang->testtask->date);
$schema->fields['testcase']    = array('type' => 'object', 'name' => $this->lang->testcase->common, 'object' => 'testcase', 'show' => 'testcase.title');
$schema->fields['testtask']    = array('type' => 'object', 'name' => $this->lang->testtask->common, 'object' => 'testtask', 'show' => 'testtask.name');
$schema->fields['execution']   = array('type' => 'object', 'name' => $this->lang->execution->common, 'object' => 'execution', 'show' => 'execution.name');
$schema->fields['project']     = array('type' => 'object', 'name' => $this->lang->project->common, 'object' => 'project', 'show' => 'execution.name');
$schema->fields['casemodule']  = array('type' => 'object', 'name' => $this->lang->tree->common, 'object' => 'casemodule', 'show' => 'casemodule.name');
$schema->fields['build']       = array('type' => 'object', 'name' => $this->lang->build->common, 'object' => 'build', 'show' => 'build.name');
$schema->fields['caselib']     = array('type' => 'object', 'name' => $this->lang->caselib->common, 'object' => 'caselib', 'show' => 'caselib.name');

$schema->objects = array();

$schema->objects['testcase'] = array();
$schema->objects['testcase']['id']    = array('type' => 'number', 'name' => $this->lang->testcase->id);
$schema->objects['testcase']['title'] = array('type' => 'string', 'name' => $this->lang->testcase->title);

$schema->objects['testtask'] = array();
$schema->objects['testtask']['id'] = array('type' => 'number', 'name' => $this->lang->testtask->id);
$schema->objects['testtask']['name'] = array('type' => 'string', 'name' => $this->lang->testtask->name);

$schema->objects['build'] = array();
$schema->objects['build']['id']   = array('type' => 'number', 'name' => $this->lang->dataview->id);
$schema->objects['build']['name'] = array('type' => 'string', 'name' => $this->lang->build->name);

$schema->objects['project'] = array();
$schema->objects['project']['id']   = array('type' => 'number', 'name' => $this->lang->project->id);
$schema->objects['project']['name'] = array('type' => 'string', 'name' => $this->lang->project->name);

$schema->objects['execution'] = array();
$schema->objects['execution']['id']   = array('type' => 'number', 'name' => $this->lang->execution->id);
$schema->objects['execution']['name'] = array('type' => 'string', 'name' => $this->lang->execution->name);

$schema->objects['casemodule'] = array();
$schema->objects['casemodule']['id']   = array('type' => 'number', 'name' => $this->lang->dataview->id);
$schema->objects['casemodule']['name'] = array('type' => 'string', 'name' => $this->lang->dataview->name);

$schema->objects['caselib'] = array();
$schema->objects['caselib']['id']   = array('type' => 'number', 'name' => $this->lang->dataview->id);
$schema->objects['caselib']['name'] = array('type' => 'string', 'name' => $this->lang->caselib->name);

$schema->objects['product'] = array();
$schema->objects['product']['id']   = array('type' => 'number', 'name' => $this->lang->product->id);
$schema->objects['product']['name'] = array('type' => 'string', 'name' => $this->lang->product->name);