package com.zy.crm.manager.entity;
import com.core.common.Cools;import com.baomidou.mybatisplus.annotations.TableId;
import com.baomidou.mybatisplus.enums.IdType;
import com.baomidou.mybatisplus.annotations.TableField;
import java.text.SimpleDateFormat;
import java.util.Date;

import com.core.common.SpringUtils;
import com.zy.crm.manager.service.ItemService;
import com.zy.crm.system.entity.User;
import com.zy.crm.system.service.UserService;
import org.springframework.format.annotation.DateTimeFormat;

import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import com.baomidou.mybatisplus.annotations.TableName;
import java.io.Serializable;

@Data
@TableName("man_pri_quote_budget")
public class PriQuoteBudget implements Serializable {

    private static final long serialVersionUID = 1L;

    /**
     * ID
     */
    @ApiModelProperty(value= "ID")
    @TableId(value = "id", type = IdType.AUTO)
    private Long id;

    /**
     * excel表标题
     */
    @ApiModelProperty(value= "excel表标题")
    private String title;

    /**
     * excel表数据
     */
    @ApiModelProperty(value= "excel表数据")
    @TableField("sheet_data")
    private String sheetData;

    @ApiModelProperty(value= "文件保存地址")
    private String filepath;

    /**
     * 创建时间
     */
    @ApiModelProperty(value= "创建时间")
    @TableField("create_time")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    private Date createTime;

    @ApiModelProperty(value= "项目id{man_item}")
    @TableField("item_id")
    private Long itemId;

    @ApiModelProperty(value= "订单号")
    @TableField("order_num")
    private String orderNum;

    @ApiModelProperty(value= "模板名")
    @TableField("template_name")
    private String templateName;

    @ApiModelProperty(value= "创建人员")
    @TableField("user_id")
    private Long userId;

    @ApiModelProperty(value= "更新人员")
    @TableField("update_user_id")
    private Long updateUserId;

    @ApiModelProperty(value= "更新时间")
    @TableField("update_time")
    private Date updateTime;

    @ApiModelProperty(value= "内部编号")
    @TableField("in_order_num")
    private String inOrderNum;

    @ApiModelProperty(value= "业务员")
    @TableField("member_id")
    private Long memberId;

    public PriQuoteBudget() {}

    public PriQuoteBudget(String title,String sheetData,Date createTime,String filepath) {
        this.title = title;
        this.sheetData = sheetData;
        this.createTime = createTime;
        this.filepath = filepath;
    }

    public String getCreateTime$(){
        if (Cools.isEmpty(this.createTime)){
            return "";
        }
        return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.createTime);
    }

    public String getItemId$() {
        ItemService itemService = SpringUtils.getBean(ItemService.class);
        Item item = itemService.selectById(this.itemId);
        if (!Cools.isEmpty(item)){
            return String.valueOf(item.getName());
        }
        return null;
    }

    public String getUpdateTime$(){
        if (Cools.isEmpty(this.updateTime)){
            return "";
        }
        return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.updateTime);
    }

    public String getUserId$() {
        UserService userService = SpringUtils.getBean(UserService.class);
        User user = userService.selectById(this.userId);
        if (!Cools.isEmpty(user)){
            return String.valueOf(user.getNickname());
        }
        return null;
    }

    public String getUpdateUserId$() {
        UserService userService = SpringUtils.getBean(UserService.class);
        User user = userService.selectById(this.updateUserId);
        if (!Cools.isEmpty(user)){
            return String.valueOf(user.getNickname());
        }
        return null;
    }

    public String getMemberId$() {
        UserService userService = SpringUtils.getBean(UserService.class);
        User user = userService.selectById(this.memberId);
        if (!Cools.isEmpty(user)){
            return String.valueOf(user.getNickname());
        }
        return null;
    }

}