package com.ruoyi.order.mapper;

import org.junit.jupiter.api.Test;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.nio.charset.StandardCharsets;
import java.util.stream.Collectors;

import static org.junit.jupiter.api.Assertions.assertFalse;
import static org.junit.jupiter.api.Assertions.assertNotNull;
import static org.junit.jupiter.api.Assertions.assertTrue;

class VinChargingOrderMapperStructureTest {

    @Test
    void usesOnlyVinOrderTablesAndSupportsRequiredFilters() throws IOException {
        InputStream input = getClass().getClassLoader().getResourceAsStream("mapper/order/TVinChargingOrderMapper.xml");
        assertNotNull(input);
        String mapper;
        try (BufferedReader reader = new BufferedReader(new InputStreamReader(input, StandardCharsets.UTF_8))) {
            mapper = reader.lines().collect(Collectors.joining("\n")).toLowerCase();
        }
        assertTrue(mapper.contains("from t_vin_charging_order o"));
        assertTrue(mapper.contains("from t_vin_charging_order_accounting_strategy"));
        assertTrue(mapper.contains("query.vin"));
        assertTrue(mapper.contains("query.platenum"));
        assertTrue(mapper.contains("query.phone"));
        assertTrue(mapper.contains("query.siteids"));
        assertTrue(mapper.contains("query.companyid"));
        assertTrue(mapper.contains("query.fleetid"));
        assertTrue(mapper.contains("o.company_id = #{query.companyid}"));
        assertTrue(mapper.contains("o.fleet_id = #{query.fleetid}"));
        assertTrue(mapper.contains("countaccountingstrategies"));
        assertTrue(mapper.contains("group by charging_order_id"));
        assertTrue(mapper.contains("pageappletorders"));
        assertTrue(mapper.contains("o.vin_id in"));
        assertTrue(mapper.contains("o.app_user_id = #{appuserid}"));
        assertTrue(mapper.contains("order by o.create_time desc, o.id desc"));
        assertTrue(mapper.contains("limit #{offset}, #{pagesize}"));
        assertTrue(mapper.contains("getchargingvinstatus"));
        assertTrue(mapper.contains("o.status = 3"));
        assertTrue(mapper.contains("group by o.vin_id"));
        assertFalse(mapper.contains("t_vin_management"));
        assertFalse(mapper.contains("t_card_"));
        assertFalse(mapper.contains("from t_charging_order "));
    }
}