znt/module/pivot/test/model/getcelldata.php

81 lines
3.1 KiB
PHP
Executable file
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

#!/usr/bin/env php
<?php
/**
title=测试 pivotModel::getCellData();
timeout=0
cid=17374
- 步骤1sum统计属性value @35
- 步骤2count统计属性value @3
- 步骤3max统计属性value @20
- 步骤4min统计属性value @5
- 步骤5showOrigin=1返回原始数据属性isGroup @~~
- 步骤6空数组处理属性value @0
- 步骤7单条记录求平均值属性value @15
*/
// 1. 导入依赖(路径固定,不可修改)
// 尝试加载完整环境,如果失败则使用简化模式
$useFullEnvironment = true;
try {
include dirname(__FILE__, 5) . '/test/lib/init.php';
} catch (Exception $e) {
$useFullEnvironment = false;
// 简化模式:检查是否已经定义了必要的常量和类
if(!defined('RUN_MODE')) define('RUN_MODE', 'test');
if(!class_exists('baseRouter', false)) {
include dirname(__FILE__, 5) . '/framework/router.class.php';
}
if(!class_exists('model', false)) {
include dirname(__FILE__, 5) . '/framework/model.class.php';
}
if(!class_exists('baseHelper', false)) {
include dirname(__FILE__, 5) . '/framework/helper.class.php';
}
// 创建基本配置对象
if(!isset($config)) {
$config = new stdClass();
$config->db = new stdClass();
}
}
include dirname(__FILE__, 2) . '/lib/model.class.php';
// 2. 用户登录(选择合适角色)
// 如果完整环境可用,使用标准用户切换
if($useFullEnvironment && function_exists('su')) {
try {
su('admin');
} catch (Exception $e) {
// 登录失败,继续测试
}
}
// 3. 创建测试实例(变量名与模块名一致)
$pivotTest = new pivotModelTest();
// 4. 准备测试数据
$records = array(
array('id' => 1, 'score' => 10, 'status' => 'active'),
array('id' => 2, 'score' => 20, 'status' => 'active'),
array('id' => 3, 'score' => 5, 'status' => 'inactive')
);
$emptyRecords = array();
$singleRecord = array(
array('id' => 1, 'score' => 15, 'status' => 'active')
);
// 5. 🔴 强制要求必须包含至少5个测试步骤
r($pivotTest->getCellDataTest('col1', $records, array('field' => 'score', 'stat' => 'sum'))) && p('value') && e('35'); // 步骤1sum统计
r($pivotTest->getCellDataTest('col2', $records, array('field' => 'score', 'stat' => 'count'))) && p('value') && e('3'); // 步骤2count统计
r($pivotTest->getCellDataTest('col3', $records, array('field' => 'score', 'stat' => 'max'))) && p('value') && e('20'); // 步骤3max统计
r($pivotTest->getCellDataTest('col4', $records, array('field' => 'score', 'stat' => 'min'))) && p('value') && e('5'); // 步骤4min统计
r($pivotTest->getCellDataTest('col5', $records, array('field' => 'score', 'showOrigin' => 1))) && p('isGroup') && e('~~'); // 步骤5showOrigin=1返回原始数据
r($pivotTest->getCellDataTest('col6', $emptyRecords, array('field' => 'score', 'stat' => 'count'))) && p('value') && e('0'); // 步骤6空数组处理
r($pivotTest->getCellDataTest('col7', $singleRecord, array('field' => 'score', 'stat' => 'avg'))) && p('value') && e('15'); // 步骤7单条记录求平均值