Python与PHP交互：正确传递JSON数组的实践指南

{"key": "SWAT-107", "assignee": "Unassigned"} {"key": "SWAT-98", "assignee": "Unassigned"} ...

import json
# 假设 Jira 类和 get_fields, get_jql_search_issues 方法已定义
# from PyJira.Jira import Jira 

if __name__ == "__main__":
    # jira = Jira() # 假设 Jira 实例已创建
    output_data_list = [] # 用于存储所有数据字典的列表

    # 模拟获取Jira问题数据
    # fields = jira.get_fields()
    # jql_issues = jira.get_jql_search_issues(jql_search="project = SWAT AND resolution = Unresolved ORDER BY priority DESC, updated DESC")

    # 模拟一些问题数据
    jql_issues = [
        type('obj', (object,), {'key': 'SWAT-107', 'fields': type('obj', (object,), {'assignee': type('obj', (object,), {'display_name': 'Unassigned'})})})(),
        type('obj', (object,), {'key': 'SWAT-98', 'fields': type('obj', (object,), {'assignee': type('obj', (object,), {'display_name': 'Unassigned'})})})(),
        type('obj', (object,), {'key': 'SWAT-100', 'fields': type('obj', (object,), {'assignee': type('obj', (object,), {'display_name': 'Admin'})})})(),
    ]

    for issue in jql_issues:
        data_item = {}
        data_item['key'] = issue.key
        # 假设 assignee 字段可能为空
        assignee_name = issue.fields.assignee.display_name if issue.fields.assignee else "Unassigned"
        data_item['assignee'] = assignee_name
        output_data_list.append(data_item) # 将字典添加到列表

    # 将整个列表序列化为JSON数组字符串并打印
    print(json.dumps(output_data_list))
    # exit() # 通常不需要在脚本末尾显式调用 exit()

[{"key": "SWAT-107", "assignee": "Unassigned"}, {"key": "SWAT-98", "assignee": "Unassigned"}, {"key": "SWAT-100", "assignee": "Admin"}]

<?php
// 假设您的Python脚本路径和执行环境配置正确
$python_script_command = "cd .. && cd python/pyjira && pipenv run python PyJira/Jira.py";
$output_json_string = shell_exec($python_script_command);

// 确保 shell_exec 没有返回错误或空字符串
if ($output_json_string === null || $output_json_string === false) {
    die("Error executing Python script or no output received.");
}

// 第一次解码：将整个JSON数组字符串解码为PHP数组
// 此时 $decoded_output 会是一个PHP数组，其中每个元素是PHP对象
$decoded_output = json_decode($output_json_string);

if (json_last_error() !== JSON_ERROR_NONE) {
    die("JSON decode error (first stage): " . json_last_error_msg());
}

if (!is_array($decoded_output)) {
    die("Python script did not return a valid JSON array.");
}

echo "<h2>Jira Issues:</h2>";
foreach ($decoded_output as $jira_item_object) {
    // 第二次解码：将每个PHP对象（代表一个Jira问题）转换为关联数组
    // 'true' 参数确保将对象转换为关联数组
    $jira_data = (array) $jira_item_object; // 或者 json_decode(json_encode($jira_item_object), true); 更通用但稍慢

    // 检查是否成功转换为数组且包含预期的键
    if (is_array($jira_data) && isset($jira_data['key']) && isset($jira_data['assignee'])) {
        echo "Key: " . htmlspecialchars($jira_data['key']) . " - Assignee: " . htmlspecialchars($jira_data['assignee']) . "<br>";
    } else {
        echo "Invalid item structure encountered.<br>";
    }
}
?>