# XM_积木报表学习笔记

**Repository Path**: Yenn-2017_admin/xmblock-report-learning-notes

## Basic Information

- **Project Name**: XM_积木报表学习笔记
- **Description**: XM_积木报表学习笔记
1. 看视频:
https://www.bilibili.com/video/BV1mK4y1H7NW?p=2&vd_source=abfd1d0103ee91010f06f3bc621f2ddf

- **Primary Language**: Java
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-02-28
- **Last Updated**: 2024-02-28

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# XM_积木报表学习笔记

#### 介绍
XM_积木报表学习笔记
1. 看视频:
https://www.bilibili.com/video/BV1mK4y1H7NW?p=2&vd_source=abfd1d0103ee91010f06f3bc621f2ddf



# P2 积木报表JimuReport新特性行号条件颜色日期表达式

![image-20240228095139476](./images/视频位置1.png)

## 单元格背景

参考文档：https://help.jeecg.com/jimureport/function/condition.html

关键字: 条件表达式、颜色表达式



 =case('#{test.sex}'=='1','男','女')

color('#{jm.salse}','#ffffff','#171516')

color('#{jm.salse}','#ffffff','red')

=case('#{RESOURCE_DETAIL.production_efficiency_avg}'!='' && #{RESOURCE_DETAIL.production_efficiency_avg}>=300,'>=300',#{RESOURCE_DETAIL.production_efficiency_avg})

=case(#{RESOURCE_DETAIL.production_efficiency_avg}>=300||#{RESOURCE_DETAIL.production_efficiency_avg}<=50,color('#{RESOURCE_DETAIL.production_efficiency_avg}','#ffffff','red'),#{RESOURCE_DETAIL.production_efficiency_avg})

效率高于300%标红或低于50%



=case(#{manufacture_list.production_efficiency}<0.5||#{manufacture_list.production_efficiency}>=3,color(#{manufacture_list.production_efficiency},'#ffffff','red'),#{manufacture_list.production_efficiency})

#{manufacture_list.production_efficiency}

**注意：空值时用><=符号会报错**

## 行级背景



## 日期函数

=now()

# P44 积木报表图表篇一 5堆叠柱形图如何配置

https://www.bilibili.com/video/BV1mK4y1H7NW?p=44&vd_source=abfd1d0103ee91010f06f3bc621f2ddf

 

![image-20240228135546792](./images/堆叠柱形图1.png)