后端:<if test="startDate != null "> AND <![CDATA[(w.start_date,'yyyy-MM-dd') >= (#{startDate},'yyyy-MM-dd')]]></if> <if test="endDate != null "> AND <![CDATA[(w.start_date,'yyyy-MM-dd') <= (#{endDate},'yyyy-MM-dd')]]></if>
前端:
<el-form-item label="开始日期" prop="startDate">
<el-date-picker
clearable
size="small"
v-model="form.startDate"
type="date"
value-format="yyyy-MM-dd"
placeholder="选择开始日期"
>
</el-date-picker>
</el-form-item>
<el-form-item label="结束日期" prop="endDate">
<el-date-picker
clearable
size="small"
v-model="form.endDate"
type="date"
value-format="yyyy-MM-dd"
placeholder="选择结束日期"
>
</el-date-picker>
</el-form-item>