150 lines
7.6 KiB
PHP
150 lines
7.6 KiB
PHP
|
#!/usr/bin/env php
|
||
|
|
<?php
|
||
|
|
|
||
|
|
/**
|
||
|
|
|
||
|
|
title=测试pivotModel->getTableHeader();
|
||
|
|
timeout=0
|
||
|
|
cid=17404
|
||
|
|
|
||
|
|
- 获取合并列头
|
||
|
|
- 第0条的name属性 @id
|
||
|
|
- 第0条的isGroup属性 @1
|
||
|
|
- 第0条的label属性 @编号
|
||
|
|
- 获取合并列头
|
||
|
|
- 第1条的name属性 @id
|
||
|
|
- 第1条的isGroup属性 @~~
|
||
|
|
- 第1条的label属性 @编号的计数(总计百分比)
|
||
|
|
- 获取子列头
|
||
|
|
- 第0条的name属性 @0
|
||
|
|
- 第0条的isGroup属性 @~~
|
||
|
|
- 第0条的label属性 @空
|
||
|
|
- 获取子列头
|
||
|
|
- 第1条的name属性 @1
|
||
|
|
- 第1条的isGroup属性 @~~
|
||
|
|
- 第1条的label属性 @1
|
||
|
|
- 获取子列头
|
||
|
|
- 第2条的name属性 @2
|
||
|
|
- 第2条的isGroup属性 @~~
|
||
|
|
- 第2条的label属性 @2
|
||
|
|
|
||
|
|
*/
|
||
|
|
include dirname(__FILE__, 5) . '/test/lib/init.php';
|
||
|
|
|
||
|
|
zenData('program')->gen(0);
|
||
|
|
zenData('product')->gen(20);
|
||
|
|
|
||
|
|
global $tester;
|
||
|
|
|
||
|
|
$columnRows = $tester->dao->select('*')->from(TABLE_PRODUCT)->fetchAll('', false);
|
||
|
|
|
||
|
|
$dirll = new stdclass();
|
||
|
|
$dirll->pivot = 1029;
|
||
|
|
$dirll->version = 1;
|
||
|
|
$dirll->field = 'id';
|
||
|
|
$dirll->object = 'product';
|
||
|
|
$dirll->whereSql = '';
|
||
|
|
$dirll->condition = array
|
||
|
|
(
|
||
|
|
'0' => array
|
||
|
|
(
|
||
|
|
'drillObject' => 'zt_product',
|
||
|
|
'drillAlias' => 't1',
|
||
|
|
'drillField' => 'id',
|
||
|
|
'queryField' => 'id'
|
||
|
|
),
|
||
|
|
'1' => array
|
||
|
|
(
|
||
|
|
'drillObject' => 'zt_product',
|
||
|
|
'drillAlias' => 't1',
|
||
|
|
'drillField' => 'program',
|
||
|
|
'queryField' => 'program'
|
||
|
|
)
|
||
|
|
);
|
||
|
|
$dirll->status = 'published';
|
||
|
|
$dirll->account = '';
|
||
|
|
$dirll->type = 'auto';
|
||
|
|
|
||
|
|
$settings = Array
|
||
|
|
(
|
||
|
|
'field' => 'id', 'slice' => 'program', 'stat' => 'count', 'showTotal' => 'sum', 'showMode' => 'total', 'monopolize' => 1, 'showOrigin' => 0,
|
||
|
|
'drill' => $dirll
|
||
|
|
);
|
||
|
|
|
||
|
|
$productFields = array
|
||
|
|
(
|
||
|
|
'id' => array( 'object' => 'product', 'field' => 'id', 'type' => 'number'),
|
||
|
|
'program' => array( 'object' => 'product', 'field' => 'program', 'type' => 'string'),
|
||
|
|
'name' => array( 'object' => 'product', 'field' => 'name', 'type' => 'string'),
|
||
|
|
'code' => array( 'object' => 'product', 'field' => 'code', 'type' => 'string'),
|
||
|
|
'shadow' => array( 'object' => 'product', 'field' => 'shadow', 'type' => 'number'),
|
||
|
|
'bind' => array( 'object' => 'product', 'field' => 'bind', 'type' => 'string'),
|
||
|
|
'line' => array( 'object' => 'product', 'field' => 'line', 'type' => 'string'),
|
||
|
|
'type' => array( 'object' => 'product', 'field' => 'type', 'type' => 'option'),
|
||
|
|
'status' => array( 'object' => 'product', 'field' => 'status', 'type' => 'option'),
|
||
|
|
'subStatus' => array( 'object' => 'product', 'field' => 'subStatus', 'type' => 'string'),
|
||
|
|
'desc' => array( 'object' => 'product', 'field' => 'desc', 'type' => 'string'),
|
||
|
|
'PO' => array( 'object' => 'product', 'field' => 'PO', 'type' => 'user'),
|
||
|
|
'QD' => array( 'object' => 'product', 'field' => 'QD', 'type' => 'user'),
|
||
|
|
'RD' => array( 'object' => 'product', 'field' => 'RD', 'type' => 'user'),
|
||
|
|
'feedback' => array( 'object' => 'product', 'field' => 'feedback', 'type' => 'string'),
|
||
|
|
'ticket' => array( 'object' => 'product', 'field' => 'ticket', 'type' => 'string'),
|
||
|
|
'workflowGroup' => array( 'object' => 'product', 'field' => 'workflowGroup', 'type' => 'number'),
|
||
|
|
'acl' => array( 'object' => 'product', 'field' => 'acl', 'type' => 'string'),
|
||
|
|
'groups' => array( 'object' => 'product', 'field' => 'groups', 'type' => 'string'),
|
||
|
|
'whitelist' => array( 'object' => 'product', 'field' => 'whitelist', 'type' => 'string'),
|
||
|
|
'reviewer' => array( 'object' => 'product', 'field' => 'reviewer', 'type' => 'string'),
|
||
|
|
'PMT' => array( 'object' => 'product', 'field' => 'PMT', 'type' => 'string'),
|
||
|
|
'draftEpics' => array( 'object' => 'product', 'field' => 'draftEpics', 'type' => 'number'),
|
||
|
|
'activeEpics' => array( 'object' => 'product', 'field' => 'activeEpics', 'type' => 'number'),
|
||
|
|
'changingEpics' => array( 'object' => 'product', 'field' => 'changingEpics', 'type' => 'number'),
|
||
|
|
'reviewingEpics' => array( 'object' => 'product', 'field' => 'reviewingEpics', 'type' => 'number'),
|
||
|
|
'finishedEpics' => array( 'object' => 'product', 'field' => 'finishedEpics', 'type' => 'number'),
|
||
|
|
'closedEpics' => array( 'object' => 'product', 'field' => 'closedEpics', 'type' => 'number'),
|
||
|
|
'totalEpics' => array( 'object' => 'product', 'field' => 'totalEpics', 'type' => 'number'),
|
||
|
|
'draftRequirements' => array( 'object' => 'product', 'field' => 'draftRequirements', 'type' => 'number'),
|
||
|
|
'activeRequirements' => array( 'object' => 'product', 'field' => 'activeRequirements', 'type' => 'number'),
|
||
|
|
'changingRequirements' => array( 'object' => 'product', 'field' => 'changingRequirements', 'type' => 'number'),
|
||
|
|
'reviewingRequirements' => array( 'object' => 'product', 'field' => 'reviewingRequirements', 'type' => 'number'),
|
||
|
|
'finishedRequirements' => array( 'object' => 'product', 'field' => 'finishedRequirements', 'type' => 'number'),
|
||
|
|
'closedRequirements' => array( 'object' => 'product', 'field' => 'closedRequirements', 'type' => 'number'),
|
||
|
|
'totalRequirements' => array( 'object' => 'product', 'field' => 'totalRequirements', 'type' => 'number'),
|
||
|
|
'draftStories' => array( 'object' => 'product', 'field' => 'draftStories', 'type' => 'number'),
|
||
|
|
'activeStories' => array( 'object' => 'product', 'field' => 'activeStories', 'type' => 'number'),
|
||
|
|
'changingStories' => array( 'object' => 'product', 'field' => 'changingStories', 'type' => 'number'),
|
||
|
|
'reviewingStories' => array( 'object' => 'product', 'field' => 'reviewingStories', 'type' => 'number'),
|
||
|
|
'finishedStories' => array( 'object' => 'product', 'field' => 'finishedStories', 'type' => 'number'),
|
||
|
|
'closedStories' => array( 'object' => 'product', 'field' => 'closedStories', 'type' => 'number'),
|
||
|
|
'totalStories' => array( 'object' => 'product', 'field' => 'totalStories', 'type' => 'number'),
|
||
|
|
'unresolvedBugs' => array( 'object' => 'product', 'field' => 'unresolvedBugs', 'type' => 'number'),
|
||
|
|
'closedBugs' => array( 'object' => 'product', 'field' => 'closedBugs', 'type' => 'number'),
|
||
|
|
'fixedBugs' => array( 'object' => 'product', 'field' => 'fixedBugs', 'type' => 'number'),
|
||
|
|
'totalBugs' => array( 'object' => 'product', 'field' => 'totalBugs', 'type' => 'number'),
|
||
|
|
'plans' => array( 'object' => 'product', 'field' => 'plans', 'type' => 'number'),
|
||
|
|
'releases' => array( 'object' => 'product', 'field' => 'releases', 'type' => 'number'),
|
||
|
|
'createdBy' => array( 'object' => 'product', 'field' => 'createdBy', 'type' => 'user'),
|
||
|
|
'createdDate' => array( 'object' => 'product', 'field' => 'createdDate', 'type' => 'date'),
|
||
|
|
'createdVersion' => array( 'object' => 'product', 'field' => 'createdVersion', 'type' => 'string'),
|
||
|
|
'closedDate' => array( 'object' => 'product', 'field' => 'closedDate', 'type' => 'date'),
|
||
|
|
'order' => array( 'object' => 'product', 'field' => 'order', 'type' => 'number'),
|
||
|
|
'vision' => array( 'object' => 'product', 'field' => 'vision', 'type' => 'string'),
|
||
|
|
'deleted' => array( 'object' => 'product', 'field' => 'deleted', 'type' => 'string')
|
||
|
|
);
|
||
|
|
|
||
|
|
$col = new stdclass();
|
||
|
|
$col->name = 'id';
|
||
|
|
$col->field = 'id';
|
||
|
|
$col->isGroup = '1';
|
||
|
|
$col->label = '编号';
|
||
|
|
|
||
|
|
$cols = array(array($col));
|
||
|
|
$sql = 'select * from zt_product';
|
||
|
|
|
||
|
|
$cols = $tester->loadModel('pivot')->getTableHeader($columnRows, $settings, $productFields, $cols, $sql);
|
||
|
|
|
||
|
|
r($cols[0]) && p('0:name,isGroup,label') && e('id,1,编号'); // 获取合并列头
|
||
|
|
r($cols[0]) && p('1:name,isGroup,label') && e('id,~~,编号的计数(总计百分比)'); // 获取合并列头
|
||
|
|
r($cols[1]) && p('0:name,isGroup,label') && e('0,~~,空'); // 获取子列头
|
||
|
|
r($cols[1]) && p('1:name,isGroup,label') && e('1,~~,1'); // 获取子列头
|
||
|
|
r($cols[1]) && p('2:name,isGroup,label') && e('2,~~,2'); // 获取子列头
|