前端

<el-col :md="6" v-if="advanced">
                        <el-form-item :label="$t('inRecord.column.createTime')">
                      <el-date-picker
                        style="width: 100%;"
                        v-model="daterangeCreateTime"
                        value-format="yyyy-MM-dd"
                        type="daterange"
                        range-separator="-"
                        start-placeholder="开始日期"
                        end-placeholder="结束日期"
                      ></el-date-picker>
                    </el-form-item>
                  </el-col>

参数形式

sql

        <if test="params.beginOrderDate != null and params.beginOrderDate != ''">
            <!-- 开始时间检索 -->
            AND DATEDIFF(day,#{params.beginOrderDate},b.order_date) >= 0
        </if>
        <if test="params.endOrderDate != null and params.endOrderDate != ''">
            <!-- 结束时间检索 -->
            AND DATEDIFF(day,#{params.endOrderDate},b.order_date) &lt;= 0
        </if>