63 lines
1.8 KiB
PHP
63 lines
1.8 KiB
PHP
<?php
|
||
/**
|
||
* 测试物流自动更新逻辑
|
||
*/
|
||
|
||
echo "===========================================\n";
|
||
echo "物流自动更新逻辑测试\n";
|
||
echo "===========================================\n\n";
|
||
|
||
// 模拟查询条件
|
||
$conditions = [
|
||
'auto_update = 1',
|
||
'next_update_time <= ' . time(),
|
||
'is_signed = 0',
|
||
"current_state NOT IN ('3', '4', '14')", // 排除：已签收、退签、拒签
|
||
'delete_time IS NULL',
|
||
];
|
||
|
||
echo "查询条件：\n";
|
||
foreach ($conditions as $condition) {
|
||
echo " - {$condition}\n";
|
||
}
|
||
|
||
echo "\n说明：\n";
|
||
echo " 1. auto_update = 1：启用自动更新\n";
|
||
echo " 2. next_update_time <= now：到达更新时间\n";
|
||
echo " 3. is_signed = 0：未签收\n";
|
||
echo " 4. current_state NOT IN ('3','4','14')：排除终态\n";
|
||
echo " - 3: 已签收\n";
|
||
echo " - 4: 退签\n";
|
||
echo " - 14: 拒签\n";
|
||
echo " 5. delete_time IS NULL：未删除\n";
|
||
|
||
echo "\n过滤逻辑：\n";
|
||
echo " ✓ 已签收的快递不会被处理\n";
|
||
echo " ✓ 退签的快递不会被处理\n";
|
||
echo " ✓ 拒签的快递不会被处理\n";
|
||
echo " ✓ 已删除的记录不会被处理\n";
|
||
echo " ✓ 停止自动更新的不会被处理\n";
|
||
|
||
echo "\n会被处理的快递状态：\n";
|
||
echo " - 0: 在途\n";
|
||
echo " - 1: 揽收\n";
|
||
echo " - 2: 疑难\n";
|
||
echo " - 5: 派件中\n";
|
||
echo " - 6: 退回\n";
|
||
echo " - 7: 转投\n";
|
||
echo " - 8: 清关\n";
|
||
echo " - 10: 待清关\n";
|
||
echo " - 11: 清关中\n";
|
||
echo " - 12: 已清关\n";
|
||
echo " - 13: 清关异常\n";
|
||
|
||
echo "\n自动停止更新的触发条件：\n";
|
||
echo " 当快递状态变为以下任一状态时，系统会自动设置 auto_update = 0：\n";
|
||
echo " - 3: 已签收\n";
|
||
echo " - 4: 退签\n";
|
||
echo " - 14: 拒签\n";
|
||
|
||
echo "\n===========================================\n";
|
||
echo "测试完成\n";
|
||
echo "===========================================\n";
|