| | |
| | | package com.ruoyi.basic.pojo; |
| | | |
| | | import java.io.Serializable; |
| | | import java.time.LocalDate; |
| | | import java.time.LocalDateTime; |
| | | import java.util.Date; |
| | | |
| | |
| | | /** |
| | | * 跟进程度 |
| | | */ |
| | | @Excel(name = "跟进程度") |
| | | // @Excel(name = "跟进程度") |
| | | @TableField(exist = false) |
| | | private String followUpLevel; |
| | | |
| | | /** |
| | | * 跟进时间 |
| | | */ |
| | | @Excel(name = "跟进时间") |
| | | // @Excel(name = "跟进时间" , width = 30, dateFormat = "yyyy-MM-dd") |
| | | @TableField(exist = false) |
| | | private LocalDateTime followUpTime; |
| | | private Date followUpTime; |
| | | |
| | | @Excel(name = "客户分类") |
| | | private String customerType; |
| | |
| | | /** |
| | | * 联系电话 |
| | | */ |
| | | @Excel(name = "联系电话") |
| | | @Excel(name = "联系电话",cellType = Excel.ColumnType.STRING) |
| | | private String contactPhone; |
| | | |
| | | /** |
| | |
| | | @ApiModelProperty(value = "租户ID") |
| | | @TableField(fill = FieldFill.INSERT) |
| | | private Long tenantId; |
| | | |
| | | @ApiModelProperty(value = "供应商类型") |
| | | @TableField(value = "supplier_type") |
| | | private String supplierType; |
| | | } |
| | |
| | | package com.ruoyi.basic.service.impl; |
| | | |
| | | |
| | | import cn.hutool.core.date.DateUtil; |
| | | import cn.hutool.core.date.LocalDateTimeUtil; |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | |
| | | import org.springframework.util.CollectionUtils; |
| | | import org.springframework.web.multipart.MultipartFile; |
| | | |
| | | import java.util.Arrays; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.Objects; |
| | | import java.time.LocalDate; |
| | | import java.time.ZoneId; |
| | | import java.util.*; |
| | | import java.util.stream.Collectors; |
| | | |
| | | |
| | |
| | | |
| | | if (followUp != null) { |
| | | c.setFollowUpLevel(followUp.getFollowUpLevel()); |
| | | c.setFollowUpTime(followUp.getFollowUpTime()); |
| | | c.setFollowUpTime( |
| | | Date.from( |
| | | followUp.getFollowUpTime().atZone(ZoneId.systemDefault()).toInstant() |
| | | ) |
| | | ); |
| | | } |
| | | }) |
| | | .collect(Collectors.toList()); |
| | |
| | | T1.update_user, |
| | | T1.tenant_id, |
| | | T1.is_white, |
| | | T2.nick_name AS maintainUserName |
| | | T2.nick_name AS maintainUserName, |
| | | T1.supplier_type |
| | | FROM supplier_manage T1 |
| | | LEFT JOIN sys_user T2 ON T1.maintain_user_id = T2.user_id |
| | | <where> |