Java Code Examples for com.ruoyi.common.utils.poi.ExcelUtil#exportExcel()

The following examples show how to use com.ruoyi.common.utils.poi.ExcelUtil#exportExcel() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: StoreGoodsCateController.java    From supplierShop with MIT License 5 votes vote down vote up
/**
 * 导出商城商品分类列表
 */
@RequiresPermissions("shop:cate:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(StoreGoodsCate storeGoodsCate)
{
    List<StoreGoodsCate> list = storeGoodsCateService.selectStoreGoodsCateList(storeGoodsCate);
    ExcelUtil<StoreGoodsCate> util = new ExcelUtil<StoreGoodsCate>(StoreGoodsCate.class);
    return util.exportExcel(list, "cate");
}
 
Example 2
Source File: SysDictTypeController.java    From RuoYi-Vue with MIT License 5 votes vote down vote up
@Log(title = "字典类型", businessType = BusinessType.EXPORT)
@PreAuthorize("@ss.hasPermi('system:dict:export')")
@GetMapping("/export")
public AjaxResult export(SysDictType dictType)
{
    List<SysDictType> list = dictTypeService.selectDictTypeList(dictType);
    ExcelUtil<SysDictType> util = new ExcelUtil<SysDictType>(SysDictType.class);
    return util.exportExcel(list, "字典类型");
}
 
Example 3
Source File: SysUserController.java    From ruoyiplus with MIT License 5 votes vote down vote up
@Log(title = "用户管理", businessType = BusinessType.EXPORT)
@RequiresPermissions("system:user:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(SysUser user)
{
    List<SysUser> list = userService.selectUserList(user);
    ExcelUtil<SysUser> util = new ExcelUtil<SysUser>(SysUser.class);
    return util.exportExcel(list, "用户数据");
}
 
Example 4
Source File: SysJobController.java    From RuoYi-Vue with MIT License 5 votes vote down vote up
/**
 * 导出定时任务列表
 */
@PreAuthorize("@ss.hasPermi('monitor:job:export')")
@Log(title = "定时任务", businessType = BusinessType.EXPORT)
@GetMapping("/export")
public AjaxResult export(SysJob sysJob)
{
    List<SysJob> list = jobService.selectJobList(sysJob);
    ExcelUtil<SysJob> util = new ExcelUtil<SysJob>(SysJob.class);
    return util.exportExcel(list, "定时任务");
}
 
Example 5
Source File: SysPostController.java    From supplierShop with MIT License 5 votes vote down vote up
@Log(title = "岗位管理", businessType = BusinessType.EXPORT)
@RequiresPermissions("system:post:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(SysPost post)
{
    List<SysPost> list = postService.selectPostList(post);
    ExcelUtil<SysPost> util = new ExcelUtil<SysPost>(SysPost.class);
    return util.exportExcel(list, "岗位数据");
}
 
Example 6
Source File: SysDictTypeController.java    From supplierShop with MIT License 5 votes vote down vote up
@Log(title = "字典类型", businessType = BusinessType.EXPORT)
@RequiresPermissions("system:dict:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(SysDictType dictType)
{

    List<SysDictType> list = dictTypeService.selectDictTypeList(dictType);
    ExcelUtil<SysDictType> util = new ExcelUtil<SysDictType>(SysDictType.class);
    return util.exportExcel(list, "字典类型");
}
 
Example 7
Source File: SysConfigController.java    From supplierShop with MIT License 5 votes vote down vote up
@Log(title = "参数管理", businessType = BusinessType.EXPORT)
@RequiresPermissions("system:config:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(SysConfig config)
{
    List<SysConfig> list = configService.selectConfigList(config);
    ExcelUtil<SysConfig> util = new ExcelUtil<SysConfig>(SysConfig.class);
    return util.exportExcel(list, "参数数据");
}
 
Example 8
Source File: SysDictDataController.java    From ruoyiplus with MIT License 5 votes vote down vote up
@Log(title = "字典数据", businessType = BusinessType.EXPORT)
@RequiresPermissions("system:dict:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(SysDictData dictData)
{
    List<SysDictData> list = dictDataService.selectDictDataList(dictData);
    ExcelUtil<SysDictData> util = new ExcelUtil<SysDictData>(SysDictData.class);
    return util.exportExcel(list, "字典数据");
}
 
Example 9
Source File: SysPostController.java    From ruoyiplus with MIT License 5 votes vote down vote up
@Log(title = "岗位管理", businessType = BusinessType.EXPORT)
@RequiresPermissions("system:post:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(SysPost post)
{
    List<SysPost> list = postService.selectPostList(post);
    ExcelUtil<SysPost> util = new ExcelUtil<SysPost>(SysPost.class);
    return util.exportExcel(list, "岗位数据");
}
 
Example 10
Source File: SysOperlogController.java    From ruoyiplus with MIT License 5 votes vote down vote up
@Log(title = "操作日志", businessType = BusinessType.EXPORT)
@RequiresPermissions("monitor:operlog:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(SysOperLog operLog)
{
    List<SysOperLog> list = operLogService.selectOperLogList(operLog);
    ExcelUtil<SysOperLog> util = new ExcelUtil<SysOperLog>(SysOperLog.class);
    return util.exportExcel(list, "操作日志");
}
 
Example 11
Source File: DemoOperateController.java    From supplierShop with MIT License 5 votes vote down vote up
/**
 * 导出
 */
@PostMapping("/export")
@ResponseBody
public AjaxResult export(UserOperateModel user)
{
    List<UserOperateModel> list = new ArrayList<UserOperateModel>(users.values());
    ExcelUtil<UserOperateModel> util = new ExcelUtil<UserOperateModel>(UserOperateModel.class);
    return util.exportExcel(list, "用户数据");
}
 
Example 12
Source File: SysOperlogController.java    From RuoYi-Vue with MIT License 5 votes vote down vote up
@Log(title = "操作日志", businessType = BusinessType.EXPORT)
@PreAuthorize("@ss.hasPermi('monitor:operlog:export')")
@GetMapping("/export")
public AjaxResult export(SysOperLog operLog)
{
    List<SysOperLog> list = operLogService.selectOperLogList(operLog);
    ExcelUtil<SysOperLog> util = new ExcelUtil<SysOperLog>(SysOperLog.class);
    return util.exportExcel(list, "操作日志");
}
 
Example 13
Source File: StoreOrderController.java    From supplierShop with MIT License 5 votes vote down vote up
/**
 * 导出订单主列表
 */
@RequiresPermissions("shop:order:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(StoreOrder storeOrder)
{
    List<StoreOrder> list = storeOrderService.selectStoreOrderList(storeOrder);
    ExcelUtil<StoreOrder> util = new ExcelUtil<StoreOrder>(StoreOrder.class);
    return util.exportExcel(list, "order");
}
 
Example 14
Source File: StoreGoodsAttributeController.java    From supplierShop with MIT License 5 votes vote down vote up
/**
 * 导出商品的属性(独立)列表
 */
@RequiresPermissions("shop:attribute:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(StoreGoodsAttribute storeGoodsAttribute)
{
    List<StoreGoodsAttribute> list = storeGoodsAttributeService.selectStoreGoodsAttributeList(storeGoodsAttribute);
    ExcelUtil<StoreGoodsAttribute> util = new ExcelUtil<StoreGoodsAttribute>(StoreGoodsAttribute.class);
    return util.exportExcel(list, "attribute");
}
 
Example 15
Source File: SysLogininforController.java    From ruoyiplus with MIT License 5 votes vote down vote up
@Log(title = "登陆日志", businessType = BusinessType.EXPORT)
@RequiresPermissions("monitor:logininfor:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(SysLogininfor logininfor)
{
    List<SysLogininfor> list = logininforService.selectLogininforList(logininfor);
    ExcelUtil<SysLogininfor> util = new ExcelUtil<SysLogininfor>(SysLogininfor.class);
    return util.exportExcel(list, "登陆日志");
}
 
Example 16
Source File: StoreMemberController.java    From supplierShop with MIT License 5 votes vote down vote up
/**
 * 导出商城会员信息列表
 */
@RequiresPermissions("shop:member:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(StoreMember storeMember)
{
    List<StoreMember> list = storeMemberService.selectStoreMemberList(storeMember);
    ExcelUtil<StoreMember> util = new ExcelUtil<StoreMember>(StoreMember.class);
    return util.exportExcel(list, "member");
}
 
Example 17
Source File: StoreGoodsBrandController.java    From supplierShop with MIT License 5 votes vote down vote up
/**
 * 导出产品品牌列表
 */
@RequiresPermissions("shop:brand:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(StoreGoodsBrand storeGoodsBrand)
{
    List<StoreGoodsBrand> list = storeGoodsBrandService.selectStoreGoodsBrandList(storeGoodsBrand);
    ExcelUtil<StoreGoodsBrand> util = new ExcelUtil<StoreGoodsBrand>(StoreGoodsBrand.class);
    return util.exportExcel(list, "brand");
}
 
Example 18
Source File: StoreCouponController.java    From supplierShop with MIT License 5 votes vote down vote up
/**
 * 导出优惠券主列表
 */
@RequiresPermissions("shop:coupon:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(StoreCoupon storeCoupon)
{
    List<StoreCoupon> list = storeCouponService.selectStoreCouponList(storeCoupon);
    ExcelUtil<StoreCoupon> util = new ExcelUtil<StoreCoupon>(StoreCoupon.class);
    return util.exportExcel(list, "coupon");
}
 
Example 19
Source File: SysLogininforController.java    From supplierShop with MIT License 5 votes vote down vote up
@Log(title = "登陆日志", businessType = BusinessType.EXPORT)
@RequiresPermissions("monitor:logininfor:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(SysLogininfor logininfor)
{
    List<SysLogininfor> list = logininforService.selectLogininforList(logininfor);
    ExcelUtil<SysLogininfor> util = new ExcelUtil<SysLogininfor>(SysLogininfor.class);
    return util.exportExcel(list, "登陆日志");
}
 
Example 20
Source File: SysOperlogController.java    From supplierShop with MIT License 5 votes vote down vote up
@Log(title = "操作日志", businessType = BusinessType.EXPORT)
@RequiresPermissions("monitor:operlog:export")
@PostMapping("/export")
@ResponseBody
public AjaxResult export(SysOperLog operLog)
{
    List<SysOperLog> list = operLogService.selectOperLogList(operLog);
    ExcelUtil<SysOperLog> util = new ExcelUtil<SysOperLog>(SysOperLog.class);
    return util.exportExcel(list, "操作日志");
}