| | |
| | | /* |
| | | * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. |
| | | * |
| | | * Redistribution and use in source and binary forms, with or without |
| | | * modification, are permitted provided that the following conditions are met: |
| | | * |
| | | * Redistributions of source code must retain the above copyright notice, |
| | | * this list of conditions and the following disclaimer. |
| | | * Redistributions in binary form must reproduce the above copyright |
| | | * notice, this list of conditions and the following disclaimer in the |
| | | * documentation and/or other materials provided with the distribution. |
| | | * Neither the name of the dreamlu.net developer nor the names of its |
| | | * contributors may be used to endorse or promote products derived from |
| | | * this software without specific prior written permission. |
| | | * Author: Chill 庄骞 (smallchill@163.com) |
| | | */ |
| | | |
| | | package org.springblade.modules.grid.excel; |
| | | |
| | | import com.alibaba.excel.annotation.ExcelIgnore; |
| | | import com.alibaba.excel.annotation.ExcelProperty; |
| | | import com.alibaba.excel.annotation.write.style.ColumnWidth; |
| | | import com.alibaba.excel.annotation.write.style.ContentRowHeight; |
| | | import com.alibaba.excel.annotation.write.style.HeadRowHeight; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * UserExcel |
| | | * GridExcel |
| | | * |
| | | * @author Chill |
| | | */ |
| | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | @ColumnWidth(15) |
| | | @ExcelProperty("租户编号") |
| | | private String tenantId; |
| | | |
| | | @ExcelIgnore |
| | | @ExcelProperty("用户平台") |
| | | private String userType; |
| | | |
| | | @ColumnWidth(20) |
| | | @ExcelProperty("用户平台名称") |
| | | private String userTypeName; |
| | | @ExcelProperty("社区网格名称") |
| | | private String gridName; |
| | | |
| | | @ColumnWidth(15) |
| | | @ExcelProperty("账户") |
| | | private String account; |
| | | @ExcelProperty("网格编号") |
| | | private String gridCode; |
| | | |
| | | @ColumnWidth(10) |
| | | @ExcelProperty("昵称") |
| | | private String name; |
| | | |
| | | @ColumnWidth(10) |
| | | @ExcelProperty("姓名") |
| | | private String realName; |
| | | |
| | | @ExcelProperty("邮箱") |
| | | private String email; |
| | | |
| | | @ColumnWidth(15) |
| | | @ExcelProperty("手机") |
| | | private String phone; |
| | | |
| | | @ExcelIgnore |
| | | @ExcelProperty("角色ID") |
| | | private String roleId; |
| | | |
| | | @ExcelIgnore |
| | | @ExcelProperty("部门ID") |
| | | private String deptId; |
| | | |
| | | @ExcelIgnore |
| | | @ExcelProperty("岗位ID") |
| | | private String postId; |
| | | |
| | | @ExcelProperty("角色名称") |
| | | private String roleName; |
| | | |
| | | @ExcelProperty("部门名称") |
| | | private String deptName; |
| | | |
| | | @ExcelProperty("岗位名称") |
| | | private String postName; |
| | | |
| | | @ColumnWidth(20) |
| | | @ExcelProperty("生日") |
| | | private Date birthday; |
| | | @ColumnWidth(100) |
| | | @ExcelProperty("区域") |
| | | private String geom; |
| | | |
| | | } |