package com.yuanchu.mom.excel;

import com.alibaba.excel.annotation.ExcelProperty;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import java.time.LocalDateTime;

@Data
public class TianXianData {

    @ExcelProperty(index = 0)
    private String no;

    @ExcelProperty(index = 1)
    private String code;

    @ExcelProperty(index = 2)
    private String port;

    @ExcelProperty(index = 3)
    private String name;

    @ExcelProperty(index = 4)
    private String angle;

    @ExcelProperty(index = 5)
    private String start;

    @ExcelProperty(index = 6)
    private String end;

    @ExcelProperty(index = 7)
    private String ask;

    @ExcelProperty(index = 8)
    private String value;

    @ExcelProperty(index = 9)
    private String result;

    public String frequency() {
        return (int)Double.parseDouble(start) + "-" + (int)Double.parseDouble(end) + "MHz";
    }
}