package com.rongyichuang.tools;

import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.jdbc.core.JdbcTemplate;

import java.util.List;
import java.util.Map;

@SpringBootTest
public class RatingTemplateVerifier {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Test
    public void verifyRatingTemplateData() {
        System.out.println("=== 验证评分模板数据 ===");
        
        // 查询评分模板
        String schemeSql = "SELECT * FROM t_rating_scheme WHERE id = 1";
        List<Map<String, Object>> schemes = jdbcTemplate.queryForList(schemeSql);
        
        System.out.println("评分模板数据:");
        for (Map<String, Object> scheme : schemes) {
            System.out.println(scheme);
        }
        
        // 查询所有评分项目
        String allItemSql = "SELECT * FROM t_rating_item ORDER BY id";
        List<Map<String, Object>> allItems = jdbcTemplate.queryForList(allItemSql);
        
        System.out.println("\n所有评分项目数据:");
        for (Map<String, Object> item : allItems) {
            System.out.println(item);
        }
        
        // 查询特定scheme_id的评分项目
        String itemSql = "SELECT * FROM t_rating_item WHERE scheme_id = 1 ORDER BY order_no";
        List<Map<String, Object>> items = jdbcTemplate.queryForList(itemSql);
        
        System.out.println("\nscheme_id=1的评分项目数据:");
        for (Map<String, Object> item : items) {
            System.out.println(item);
        }
        
        // 查询活动的评分模板配置
        String activitySql = "SELECT id, name, rating_scheme_id FROM t_activity WHERE id = 1";
        List<Map<String, Object>> activities = jdbcTemplate.queryForList(activitySql);
        
        System.out.println("\n活动评分模板配置:");
        for (Map<String, Object> activity : activities) {
            System.out.println(activity);
        }
        
        System.out.println("\n✅ 评分模板数据验证完成！");
    }
}