1550 lines
40 KiB
PHP
1550 lines
40 KiB
PHP
<?php
|
||
declare(strict_types = 1);
|
||
|
||
require_once dirname(__FILE__, 5) . '/test/lib/test.class.php';
|
||
|
||
class pivotModelTest extends baseTest
|
||
{
|
||
protected $moduleName = 'pivot';
|
||
protected $className = 'model';
|
||
|
||
/**
|
||
* 测试getByID。
|
||
* Test getByID.
|
||
*
|
||
* @param int $id
|
||
* @access public
|
||
* @return object|bool
|
||
*/
|
||
public function getByIDTest(int $id): object|bool
|
||
{
|
||
$result = $this->instance->getByID($id);
|
||
if(dao::isError()) return dao::getError();
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test initSql method.
|
||
*
|
||
* @param string $sql
|
||
* @param array $filters
|
||
* @param string $groupList
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function initSqlTest(string $sql, array $filters, string $groupList): array
|
||
{
|
||
$result = $this->instance->initSql($sql, $filters, $groupList);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test setFilterDefault method.
|
||
*
|
||
* @param array $filters
|
||
* @param bool $processDateVar
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function setFilterDefaultTest(array $filters, bool $processDateVar = true): array
|
||
{
|
||
$result = $this->instance->setFilterDefault($filters, $processDateVar);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getSysOptions method.
|
||
*
|
||
* @param string $type
|
||
* @param string $object
|
||
* @param string $field
|
||
* @param mixed $source
|
||
* @param string $saveAs
|
||
* @param string $driver
|
||
* @access public
|
||
* @return mixed
|
||
*/
|
||
public function getSysOptionsTest($type = '', $object = '', $field = '', $source = '', $saveAs = '', $driver = 'mysql')
|
||
{
|
||
$result = $this->instance->getSysOptions($type, $object, $field, $source, $saveAs, $driver);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* 测试 processGroupRows。
|
||
* Test processGroupRows.
|
||
*
|
||
* @param array $columns
|
||
* @param string $sql
|
||
* @param array $filterFormat
|
||
* @param array $groups
|
||
* @param string $groupList
|
||
* @param array $fieldS
|
||
* @param string $showColTotal
|
||
* @param array $cols
|
||
* @param array $langs
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function processGroupRowsTest(array $columns, string $sql, array $filterFormat, array $groups, string $groupList, array $fields, string $showColTotal, array &$cols, array $langs): array
|
||
{
|
||
return $this->instance->processGroupRows($columns, $sql, $filterFormat, $groups, $groupList, $fields, $showColTotal, $cols, $langs);
|
||
}
|
||
|
||
/**
|
||
* Test getPivotDataByID method.
|
||
*
|
||
* @param int $id
|
||
* @access public
|
||
* @return mixed
|
||
*/
|
||
public function getPivotDataByIDTest($id)
|
||
{
|
||
$result = $this->instance->getPivotDataByID($id);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getPivotSpec method.
|
||
*
|
||
* @param int $pivotID
|
||
* @param string $version
|
||
* @param bool $processDateVar
|
||
* @param bool $addDrills
|
||
* @access public
|
||
* @return mixed
|
||
*/
|
||
public function getPivotSpecTest($pivotID, $version, $processDateVar = false, $addDrills = true)
|
||
{
|
||
$result = $this->instance->getPivotSpec($pivotID, $version, $processDateVar, $addDrills);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test processNameDesc method.
|
||
*
|
||
* @param object $pivot
|
||
* @access public
|
||
* @return object
|
||
*/
|
||
public function processNameDescTest($pivot)
|
||
{
|
||
$this->instance->processNameDesc($pivot);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $pivot;
|
||
}
|
||
|
||
/**
|
||
* Test completePivot method.
|
||
*
|
||
* @param object $pivot
|
||
* @access public
|
||
* @return object
|
||
*/
|
||
public function completePivotTest($pivot)
|
||
{
|
||
// 使用反射调用私有方法completePivot
|
||
$reflectionClass = new ReflectionClass($this->instance);
|
||
$method = $reflectionClass->getMethod('completePivot');
|
||
$method->setAccessible(true);
|
||
|
||
// 调用completePivot方法，该方法会直接修改传入的对象
|
||
$method->invoke($this->instance, $pivot);
|
||
|
||
return $pivot;
|
||
}
|
||
|
||
/**
|
||
* Test processDateVar method.
|
||
*
|
||
* @param mixed $var
|
||
* @param string $type
|
||
* @access public
|
||
* @return string
|
||
*/
|
||
public function processDateVarTest($var, $type = 'date')
|
||
{
|
||
$result = $this->instance->processDateVar($var, $type);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test appendWhereFilterToSql method.
|
||
*
|
||
* @param string $sql
|
||
* @param array|false $filters
|
||
* @param string $driver
|
||
* @access public
|
||
* @return string
|
||
*/
|
||
public function appendWhereFilterToSqlTest($sql, $filters, $driver)
|
||
{
|
||
$result = $this->instance->appendWhereFilterToSql($sql, $filters, $driver);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test filterFieldsWithSettings method.
|
||
*
|
||
* @param array $fields
|
||
* @param array $groups
|
||
* @param array $columns
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function filterFieldsWithSettingsTest($fields, $groups, $columns)
|
||
{
|
||
$result = $this->instance->filterFieldsWithSettings($fields, $groups, $columns);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test generateTableCols method.
|
||
*
|
||
* @param array $fields
|
||
* @param array $groups
|
||
* @param array $langs
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function generateTableColsTest($fields, $groups, $langs)
|
||
{
|
||
$result = $this->instance->generateTableCols($fields, $groups, $langs);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getShowColPosition method.
|
||
*
|
||
* @param array|object $settings
|
||
* @access public
|
||
* @return string
|
||
*/
|
||
public function getShowColPositionTest($settings)
|
||
{
|
||
$result = $this->instance->getShowColPosition($settings);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test columnStatistics method.
|
||
*
|
||
* @param array $records
|
||
* @param string $statistic
|
||
* @param string $field
|
||
* @access public
|
||
* @return mixed
|
||
*/
|
||
public function columnStatisticsTest(array $records, string $statistic, string $field): mixed
|
||
{
|
||
$result = $this->instance->columnStatistics($records, $statistic, $field);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getGroupTreeWithKey method.
|
||
*
|
||
* @param array $data
|
||
* @access public
|
||
* @return array|string
|
||
*/
|
||
public function getGroupTreeWithKeyTest(array $data): array|string
|
||
{
|
||
$result = $this->instance->getGroupTreeWithKey($data);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test formatCellData method.
|
||
*
|
||
* @param string $key
|
||
* @param array $data
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function formatCellDataTest(string $key, array $data): array
|
||
{
|
||
$result = $this->instance->formatCellData($key, $data);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getColumnSummary method.
|
||
*
|
||
* @param array $data
|
||
* @param string $totalKey
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getColumnSummaryTest(array $data, string $totalKey): array
|
||
{
|
||
$result = $this->instance->getColumnSummary($data, $totalKey);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test addRowSummary method.
|
||
*
|
||
* @param array $groupTree
|
||
* @param array $data
|
||
* @param array $groups
|
||
* @param int $currentGroup
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function addRowSummaryTest(array $groupTree, array $data, array $groups, int $currentGroup = 0): array
|
||
{
|
||
$result = $this->instance->addRowSummary($groupTree, $data, $groups, $currentGroup);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test pureCrystalData method.
|
||
*
|
||
* @param array $records
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function pureCrystalDataTest(array $records): array
|
||
{
|
||
$result = $this->instance->pureCrystalData($records);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test flattenRow method.
|
||
*
|
||
* @param array $row
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function flattenRowTest(array $row): array
|
||
{
|
||
$result = $this->instance->flattenRow($row);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test flattenCrystalData method.
|
||
*
|
||
* @param array $crystalData
|
||
* @param bool $withGroupSummary
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function flattenCrystalDataTest(array $crystalData, bool $withGroupSummary = false): array
|
||
{
|
||
$result = $this->instance->flattenCrystalData($crystalData, $withGroupSummary);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test processRowSpan method.
|
||
*
|
||
* @param array $records
|
||
* @param array $groups
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function processRowSpanTest(array $records, array $groups): array
|
||
{
|
||
$result = $this->instance->processRowSpan($records, $groups);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getRowTotal method.
|
||
*
|
||
* @param array $row
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getRowTotalTest(array $row): array
|
||
{
|
||
$result = $this->instance->getRowTotal($row);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test setPercentage method.
|
||
*
|
||
* @param array $row
|
||
* @param array $rowTotal
|
||
* @param array $columnTotal
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function setPercentageTest(array $row, array $rowTotal, array $columnTotal): array
|
||
{
|
||
$result = $this->instance->setPercentage($row, $rowTotal, $columnTotal);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test processPercentage method.
|
||
*
|
||
* @param array $crystalData
|
||
* @param array $allSummary
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function processPercentageTest(array $crystalData, array $allSummary): array
|
||
{
|
||
$result = $this->instance->processPercentage($crystalData, $allSummary);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test groupRecords method.
|
||
*
|
||
* @param array $records
|
||
* @param array $groups
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function groupRecordsTest(array $records, array $groups): array
|
||
{
|
||
$result = $this->instance->groupRecords($records, $groups);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test setUniqueSlices method.
|
||
*
|
||
* @param string $slice
|
||
* @param array $records
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function setUniqueSlicesTest(?array $records = null, ?array $setting = null): array
|
||
{
|
||
if($records === null) {
|
||
// 构造测试数据
|
||
$records = array();
|
||
$record1 = new stdClass();
|
||
$record2 = new stdClass();
|
||
$record3 = new stdClass();
|
||
$record4 = new stdClass();
|
||
|
||
$record1->category = 'bug';
|
||
$record1->priority = '1';
|
||
$record1->id = 1;
|
||
$record2->category = 'story';
|
||
$record2->priority = '2';
|
||
$record2->id = 2;
|
||
$record3->category = 'bug';
|
||
$record3->priority = '1';
|
||
$record3->id = 3;
|
||
$record4->category = 'story';
|
||
$record4->priority = '3';
|
||
$record4->id = 4;
|
||
$records = array($record1, $record2, $record3, $record4);
|
||
}
|
||
|
||
if($setting === null) {
|
||
$setting = array('slice' => 'category');
|
||
}
|
||
|
||
$result = $this->instance->setUniqueSlices($records, $setting);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getSliceRecords method.
|
||
*
|
||
* @param array $records
|
||
* @param string $field
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getSliceRecordsTest(array $records, string $field): array
|
||
{
|
||
$result = $this->instance->getSliceRecords($records, $field);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getCellData method.
|
||
*
|
||
* @param string $columnKey
|
||
* @param array $records
|
||
* @param array $setting
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getCellDataTest(string $columnKey, array $records, array $setting): array
|
||
{
|
||
$result = $this->instance->getCellData($columnKey, $records, $setting);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test processCrystalData method.
|
||
*
|
||
* @param array $groups
|
||
* @param array $records
|
||
* @param array $settings
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function processCrystalDataTest(array $groups, array $records, array $settings): array
|
||
{
|
||
$result = $this->instance->processCrystalData($groups, $records, $settings);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test processRecordsForDisplay method.
|
||
*
|
||
* @param array $records
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function processRecordsForDisplayTest(array $records): array
|
||
{
|
||
$result = $this->instance->processRecordsForDisplay($records);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getRowSpanConfig method.
|
||
*
|
||
* @param array $records
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getRowSpanConfigTest(array $records): array
|
||
{
|
||
$result = $this->instance->getRowSpanConfig($records);
|
||
if(dao::isError()) return dao::getError();
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getDrillsFromRecords method.
|
||
*
|
||
* @param array $records
|
||
* @param array $groups
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getDrillsFromRecordsTest(array $records, array $groups): array
|
||
{
|
||
$result = $this->instance->getDrillsFromRecords($records, $groups);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test processQueryFilterDefaults method.
|
||
*
|
||
* @param array|false $filters
|
||
* @access public
|
||
* @return array|false
|
||
*/
|
||
public function processQueryFilterDefaultsTest(array|false $filters): array|false
|
||
{
|
||
$result = $this->instance->processQueryFilterDefaults($filters);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test isFiltersAllEmpty method.
|
||
*
|
||
* @param array $filters
|
||
* @access public
|
||
* @return bool
|
||
*/
|
||
public function isFiltersAllEmptyTest(array $filters): bool
|
||
{
|
||
$result = $this->instance->isFiltersAllEmpty($filters);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test genOriginSheet method.
|
||
*
|
||
* @param array $fields
|
||
* @param array $settings
|
||
* @param string $sql
|
||
* @param array|false $filters
|
||
* @param array $langs
|
||
* @param string $driver
|
||
* @access public
|
||
* @return array|string
|
||
*/
|
||
public function genOriginSheetTest($fields, $settings, $sql, $filters, $langs = array(), $driver = 'mysql')
|
||
{
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
$result = $this->instance->genOriginSheet($fields, $settings, $sql, $filters, $langs, $driver);
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getFilterFormat method.
|
||
*
|
||
* @param string $sql
|
||
* @param array $filters
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getFilterFormatTest(string $sql, array $filters): array
|
||
{
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
$result = $this->instance->getFilterFormat($sql, $filters);
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test initVarFilter method.
|
||
*
|
||
* @param array $filters
|
||
* @param string $sql
|
||
* @access public
|
||
* @return string
|
||
*/
|
||
public function initVarFilterTest(array $filters = array(), string $sql = ''): string
|
||
{
|
||
// 使用反射访问私有方法
|
||
$reflection = new ReflectionClass($this->instance);
|
||
$method = $reflection->getMethod('initVarFilter');
|
||
$method->setAccessible(true);
|
||
|
||
$result = $method->invoke($this->instance, $filters, $sql);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getColLabel method.
|
||
*
|
||
* @param string $key
|
||
* @param array $fields
|
||
* @param array $langs
|
||
* @access public
|
||
* @return string
|
||
*/
|
||
public function getColLabelTest(string $key, array $fields, array $langs = array()): string
|
||
{
|
||
$result = $this->instance->getColLabel($key, $fields, $langs);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getGroupsKey method.
|
||
*
|
||
* @param array $groups
|
||
* @param object $record
|
||
* @access public
|
||
* @return string
|
||
*/
|
||
public function getGroupsKeyTest(array $groups, object $record): string
|
||
{
|
||
$result = $this->instance->getGroupsKey($groups, $record);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test processFilters method.
|
||
*
|
||
* @param array $filters
|
||
* @param string $filterStatus
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function processFiltersTest(array $filters, string $filterStatus): array
|
||
{
|
||
$result = $this->instance->processFilters($filters, $filterStatus);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test setConditionValueWithFilters method.
|
||
*
|
||
* @param array $condition
|
||
* @param array $filters
|
||
* @access public
|
||
* @return string
|
||
*/
|
||
public function setConditionValueWithFiltersTest(array $condition, array $filters): string
|
||
{
|
||
$result = $this->instance->setConditionValueWithFilters($condition, $filters);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getFieldsFromPivot method.
|
||
*
|
||
* @param object $pivot
|
||
* @param string $key
|
||
* @param mixed $default
|
||
* @param bool $jsonDecode
|
||
* @param bool $needArray
|
||
* @access public
|
||
* @return mixed
|
||
*/
|
||
public function getFieldsFromPivotTest(object $pivot, string $key, mixed $default = null, bool $jsonDecode = false, bool $needArray = false): mixed
|
||
{
|
||
$reflection = new ReflectionClass($this->instance);
|
||
$method = $reflection->getMethod('getFieldsFromPivot');
|
||
$method->setAccessible(true);
|
||
|
||
$result = $method->invokeArgs($this->instance, array($pivot, $key, $default, $jsonDecode, $needArray));
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getFieldsOptions method.
|
||
*
|
||
* @param array $fieldSettings
|
||
* @param array $records
|
||
* @param string $driver
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getFieldsOptionsTest($fieldSettings = array(), $records = array(), $driver = 'mysql')
|
||
{
|
||
$result = $this->instance->getFieldsOptions($fieldSettings, $records, $driver);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getFieldsOptions method and return count.
|
||
*
|
||
* @param array $fieldSettings
|
||
* @param array $records
|
||
* @param string $driver
|
||
* @access public
|
||
* @return int
|
||
*/
|
||
public function getFieldsOptionsCountTest($fieldSettings = array(), $records = array(), $driver = 'mysql')
|
||
{
|
||
$result = $this->instance->getFieldsOptions($fieldSettings, $records, $driver);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return count($result);
|
||
}
|
||
|
||
/**
|
||
* Test processDTableCols method.
|
||
*
|
||
* @param array $cols
|
||
* @access public
|
||
* @return mixed
|
||
*/
|
||
public function processDTableColsTest(array $cols)
|
||
{
|
||
$result = $this->instance->processDTableCols($cols);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test processDTableData method.
|
||
*
|
||
* @param array $cols
|
||
* @param array $datas
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function processDTableDataTest(array $cols, array $datas): array
|
||
{
|
||
$result = $this->instance->processDTableData($cols, $datas);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test buildPivotTable method.
|
||
*
|
||
* @param mixed $data
|
||
* @param array $configs
|
||
* @access public
|
||
* @return string
|
||
*/
|
||
public function buildPivotTableTest($data, $configs = array())
|
||
{
|
||
ob_start();
|
||
$this->instance->buildPivotTable($data, $configs);
|
||
$result = ob_get_contents();
|
||
ob_end_clean();
|
||
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getReferSQL method.
|
||
*
|
||
* @param string $object
|
||
* @param string $whereSQL
|
||
* @param array $fields
|
||
* @access public
|
||
* @return string
|
||
*/
|
||
public function getReferSQLTest($object, $whereSQL = '', $fields = array())
|
||
{
|
||
$result = $this->instance->getReferSQL($object, $whereSQL, $fields);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getDrillSQL method.
|
||
*
|
||
* @param string $objectTable
|
||
* @param string $whereSQL
|
||
* @param array $conditions
|
||
* @access public
|
||
* @return string
|
||
*/
|
||
public function getDrillSQLTest($objectTable, $whereSQL = '', $conditions = array())
|
||
{
|
||
$result = $this->instance->getDrillSQL($objectTable, $whereSQL, $conditions);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test execDrillSQL method.
|
||
*
|
||
* @param string $object
|
||
* @param string $drillSQL
|
||
* @param int $limit
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function execDrillSQLTest($object, $drillSQL, $limit = 10)
|
||
{
|
||
$result = $this->instance->execDrillSQL($object, $drillSQL, $limit);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getDrillResult method.
|
||
*
|
||
* @param string $object
|
||
* @param string $whereSQL
|
||
* @param array $filters
|
||
* @param array $conditions
|
||
* @param bool $emptyFilters
|
||
* @param int $limit
|
||
* @access public
|
||
* @return mixed
|
||
*/
|
||
public function getDrillResultTest($object, $whereSQL, $filters = array(), $conditions = array(), $emptyFilters = true, $limit = 10)
|
||
{
|
||
$result = $this->instance->getDrillResult($object, $whereSQL, $filters, $conditions, $emptyFilters, $limit);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getPivotVersions method.
|
||
*
|
||
* @param int $pivotID
|
||
* @access public
|
||
* @return array|bool
|
||
*/
|
||
public function getPivotVersionsTest(int $pivotID)
|
||
{
|
||
$result = $this->instance->getPivotVersions($pivotID);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getMaxVersion method.
|
||
*
|
||
* @param int $pivotID
|
||
* @access public
|
||
* @return string
|
||
*/
|
||
public function getMaxVersionTest(int $pivotID): string
|
||
{
|
||
$result = $this->instance->getMaxVersion($pivotID);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getMaxVersionByIDList method.
|
||
*
|
||
* @param string|array $pivotIDList
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getMaxVersionByIDListTest(string|array $pivotIDList): array
|
||
{
|
||
$result = $this->instance->getMaxVersionByIDList($pivotIDList);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test isVersionChange method.
|
||
*
|
||
* @param array|object $pivots
|
||
* @param bool $isObject
|
||
* @access public
|
||
* @return array|object
|
||
*/
|
||
public function isVersionChangeTest(array|object $pivots, bool $isObject = true): array|object
|
||
{
|
||
$result = $this->instance->isVersionChange($pivots, $isObject);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test switchNewVersion method.
|
||
*
|
||
* @param int $pivotID
|
||
* @param string $version
|
||
* @access public
|
||
* @return mixed
|
||
*/
|
||
public function switchNewVersionTest(int $pivotID, string $version)
|
||
{
|
||
try
|
||
{
|
||
$result = $this->instance->switchNewVersion($pivotID, $version);
|
||
if(dao::isError()) return dao::getError();
|
||
return $result;
|
||
}
|
||
catch(Exception $e)
|
||
{
|
||
return false;
|
||
}
|
||
}
|
||
|
||
/**
|
||
* Test fetchPivot method.
|
||
*
|
||
* @param int $id
|
||
* @param string|null $version
|
||
* @access public
|
||
* @return object|bool
|
||
*/
|
||
public function fetchPivotTest(int $id, ?string $version = null): object|bool
|
||
{
|
||
// 使用反射访问protected方法
|
||
$reflection = new ReflectionClass($this->objectTao);
|
||
$method = $reflection->getMethod('fetchPivot');
|
||
$method->setAccessible(true);
|
||
|
||
$result = $method->invoke($this->objectTao, $id, $version);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test mergePivotSpecData method.
|
||
*
|
||
* @param mixed $pivots
|
||
* @param bool $isObject
|
||
* @access public
|
||
* @return mixed
|
||
*/
|
||
public function mergePivotSpecDataTest($pivots, $isObject = true)
|
||
{
|
||
// 使用反射访问protected方法
|
||
$reflection = new ReflectionClass($this->objectTao);
|
||
$method = $reflection->getMethod('mergePivotSpecData');
|
||
$method->setAccessible(true);
|
||
|
||
$result = $method->invoke($this->objectTao, $pivots, $isObject);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test processProductPlan method.
|
||
*
|
||
* @param array $products
|
||
* @param string $conditions
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function processProductPlanTest(array $products, string $conditions): array
|
||
{
|
||
// 使用反射访问protected方法
|
||
$reflection = new ReflectionClass($this->objectTao);
|
||
$method = $reflection->getMethod('processProductPlan');
|
||
$method->setAccessible(true);
|
||
|
||
$result = $method->invokeArgs($this->objectTao, array(&$products, $conditions));
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test processPlanStories method.
|
||
*
|
||
* @param array $products
|
||
* @param string $storyType
|
||
* @param array $plans
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function processPlanStoriesTest(array $products, string $storyType, array $plans): array
|
||
{
|
||
// 使用反射访问protected方法
|
||
$reflection = new ReflectionClass($this->objectTao);
|
||
$method = $reflection->getMethod('processPlanStories');
|
||
$method->setAccessible(true);
|
||
|
||
$result = $method->invokeArgs($this->objectTao, array(&$products, $storyType, $plans));
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getExecutionList method.
|
||
*
|
||
* @param string $begin
|
||
* @param string $end
|
||
* @param array $executionIDList
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getExecutionListTest(string $begin, string $end, array $executionIDList = array()): array
|
||
{
|
||
// 使用反射访问protected方法
|
||
$reflection = new ReflectionClass($this->objectTao);
|
||
$method = $reflection->getMethod('getExecutionList');
|
||
$method->setAccessible(true);
|
||
|
||
$result = $method->invokeArgs($this->objectTao, array($begin, $end, $executionIDList));
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getNoAssignExecution method.
|
||
*
|
||
* @param array $deptUsers
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getNoAssignExecutionTest(array $deptUsers): array
|
||
{
|
||
// 使用反射访问protected方法
|
||
$reflection = new ReflectionClass($this->objectTao);
|
||
$method = $reflection->getMethod('getNoAssignExecution');
|
||
$method->setAccessible(true);
|
||
|
||
$result = $method->invokeArgs($this->objectTao, array($deptUsers));
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getTeamTasks method.
|
||
*
|
||
* @param array $taskIDList
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getTeamTasksTest(array $taskIDList): array
|
||
{
|
||
// 使用反射访问protected方法
|
||
$reflection = new ReflectionClass($this->objectTao);
|
||
$method = $reflection->getMethod('getTeamTasks');
|
||
$method->setAccessible(true);
|
||
|
||
$result = $method->invokeArgs($this->objectTao, array($taskIDList));
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getAssignBugGroup method.
|
||
*
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getAssignBugGroupTest(): array
|
||
{
|
||
// 使用反射访问protected方法
|
||
$reflection = new ReflectionClass($this->objectTao);
|
||
$method = $reflection->getMethod('getAssignBugGroup');
|
||
$method->setAccessible(true);
|
||
|
||
$result = $method->invoke($this->objectTao);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getProductProjects method.
|
||
*
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getProductProjectsTest(): array
|
||
{
|
||
// 使用反射访问protected方法
|
||
$reflection = new ReflectionClass($this->objectTao);
|
||
$method = $reflection->getMethod('getProductProjects');
|
||
$method->setAccessible(true);
|
||
|
||
$result = $method->invoke($this->objectTao);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getAllProductsIDAndName method.
|
||
*
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getAllProductsIDAndNameTest(): array
|
||
{
|
||
// 使用反射访问protected方法
|
||
$reflection = new ReflectionClass($this->objectTao);
|
||
$method = $reflection->getMethod('getAllProductsIDAndName');
|
||
$method->setAccessible(true);
|
||
|
||
$result = $method->invoke($this->objectTao);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getProjectAndExecutionNameQuery method.
|
||
*
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getProjectAndExecutionNameQueryTest(): array
|
||
{
|
||
// 使用反射访问protected方法
|
||
$reflection = new ReflectionClass($this->objectTao);
|
||
$method = $reflection->getMethod('getProjectAndExecutionNameQuery');
|
||
$method->setAccessible(true);
|
||
|
||
$result = $method->invoke($this->objectTao);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test fetchPivotDrills method.
|
||
*
|
||
* @param int $pivotID
|
||
* @param string $version
|
||
* @param string|array $fields
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function fetchPivotDrillsTest(int $pivotID, string $version, string|array $fields): array
|
||
{
|
||
$result = $this->objectTao->fetchPivotDrills($pivotID, $version, $fields);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getBugAssign method.
|
||
*
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getBugAssign(): array
|
||
{
|
||
$result = $this->instance->getBugAssign();
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test checkIFChartInUse method.
|
||
*
|
||
* @param int $chartID
|
||
* @param string $type
|
||
* @param array $screens
|
||
* @access public
|
||
* @return bool
|
||
*/
|
||
public function checkIFChartInUseTest(int $chartID, string $type = 'chart', array $screens = array()): bool
|
||
{
|
||
$result = $this->instance->checkIFChartInUse($chartID, $type, $screens);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getConnectSQL method.
|
||
*
|
||
* @param array $filters
|
||
* @access public
|
||
* @return string
|
||
*/
|
||
public function getConnectSQLTest(array $filters): string
|
||
{
|
||
$result = $this->instance->getConnectSQL($filters);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getProjectExecutions method.
|
||
*
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getProjectExecutions(): array
|
||
{
|
||
$result = $this->instance->getProjectExecutions();
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getProjectExecutions method with different scenarios.
|
||
*
|
||
* @param string $testCase
|
||
* @access public
|
||
* @return mixed
|
||
*/
|
||
public function getProjectExecutionsTest()
|
||
{
|
||
try {
|
||
$result = $this->instance->getProjectExecutions();
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
// 如果返回空数组，返回字符串'empty'以便测试
|
||
if(is_array($result) && empty($result)) return 'empty';
|
||
|
||
// 如果返回非空数组，返回字符串'array'以便测试
|
||
if(is_array($result) && !empty($result)) return 'array';
|
||
|
||
return $result;
|
||
} catch (Exception $e) {
|
||
// 如果方法调用出错，返回空数组
|
||
return array();
|
||
}
|
||
}
|
||
|
||
/**
|
||
* Test replaceTableNames method.
|
||
*
|
||
* @param string $sql
|
||
* @access public
|
||
* @return string
|
||
*/
|
||
public function replaceTableNamesTest(string $sql): string
|
||
{
|
||
$result = $this->instance->replaceTableNames($sql);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getFirstGroup method.
|
||
*
|
||
* @param int $dimensionID
|
||
* @access public
|
||
* @return int
|
||
*/
|
||
public function getFirstGroupTest(int $dimensionID): int
|
||
{
|
||
$method = new ReflectionMethod($this->objectTao, 'getFirstGroup');
|
||
$method->setAccessible(true);
|
||
$result = $method->invoke($this->objectTao, $dimensionID);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getDrillCols method.
|
||
*
|
||
* @param string $object
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getDrillColsTest(string $object): array
|
||
{
|
||
$result = $this->instance->getDrillCols($object);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getGroupsFromSettings method.
|
||
*
|
||
* @param array $settings
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getGroupsFromSettingsTest(array $settings): array
|
||
{
|
||
$result = $this->instance->getGroupsFromSettings($settings);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getProducts method.
|
||
*
|
||
* @param string $conditions
|
||
* @param string $storyType
|
||
* @param array $filters
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getProductsTest(string $conditions = '', string $storyType = 'story', array $filters = array()): array
|
||
{
|
||
$result = $this->instance->getProducts($conditions, $storyType, $filters);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getUserWorkLoad method.
|
||
*
|
||
* @param array $projects
|
||
* @param array $teamTasks
|
||
* @param float $allHour
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getUserWorkLoadTest(array $projects, array $teamTasks, float $allHour): array
|
||
{
|
||
$result = $this->instance->getUserWorkLoad($projects, $teamTasks, $allHour);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getWorkload method.
|
||
*
|
||
* @param int $dept
|
||
* @param string $assign
|
||
* @param array $users
|
||
* @param float $allHour
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getWorkloadTest(int $dept, string $assign, array $users, float $allHour): array
|
||
{
|
||
$result = $this->instance->getWorkload($dept, $assign, $users, $allHour);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getWorkloadNoAssign method.
|
||
*
|
||
* @param array $deptUsers
|
||
* @param array $users
|
||
* @param bool $canViewExecution
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getWorkloadNoAssignTest(array $deptUsers, array $users, bool $canViewExecution): array
|
||
{
|
||
$result = $this->instance->getWorkloadNoAssign($deptUsers, $users, $canViewExecution);
|
||
if(dao::isError()) return dao::getError();
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getWorkLoadAssign method.
|
||
*
|
||
* @param array $deptUsers
|
||
* @param array $users
|
||
* @param bool $canViewExecution
|
||
* @param float $allHour
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getWorkLoadAssignTest(array $deptUsers, array $users, bool $canViewExecution, float $allHour): array
|
||
{
|
||
$result = $this->instance->getWorkLoadAssign($deptUsers, $users, $canViewExecution, $allHour);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test isShowLastRow method.
|
||
*
|
||
* @param string $showColPosition
|
||
* @access public
|
||
* @return bool
|
||
*/
|
||
public function isShowLastRowTest(string $showColPosition): bool
|
||
{
|
||
$result = $this->instance->isShowLastRow($showColPosition);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test setExecutionName method.
|
||
*
|
||
* @param object $execution
|
||
* @param bool $canViewExecution
|
||
* @access public
|
||
* @return object
|
||
*/
|
||
public function setExecutionNameTest(object $execution, bool $canViewExecution): object
|
||
{
|
||
$this->instance->setExecutionName($execution, $canViewExecution);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $execution;
|
||
}
|
||
|
||
/**
|
||
* Test getAssignTask method.
|
||
*
|
||
* @param array $deptUsers
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getAssignTaskTest(array $deptUsers = array()): array
|
||
{
|
||
$result = $this->objectTao->getAssignTask($deptUsers);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
|
||
/**
|
||
* Test getGroupsByDimensionAndPath method.
|
||
*
|
||
* @param int $dimensionID
|
||
* @param string $path
|
||
* @access public
|
||
* @return array
|
||
*/
|
||
public function getGroupsByDimensionAndPathTest(int $dimensionID, string $path): array
|
||
{
|
||
$method = new ReflectionMethod($this->objectTao, 'getGroupsByDimensionAndPath');
|
||
$method->setAccessible(true);
|
||
$result = $method->invoke($this->objectTao, $dimensionID, $path);
|
||
if(dao::isError()) return dao::getError();
|
||
|
||
return $result;
|
||
}
|
||
}
|