开发经常时间选择的问题,有2个时间点需要选择。
后端mybatis处理的问题的
1.前端
import { DatePicker} from 'antd';
const { RangePicker } = DatePicker;
//查询
onSearch = () => {
const { form, onSearch } = this.props;
let _this = this;
form.validateFields((err, values) => {
if (!err) {
let param = { ...values }
if (param.editDay) {
param.beginTime = _this.changeBeginDate(param.editDay[0]);
param.endTime = _this.changeEndDate(param.editDay[1]);
delete param.editDay
}
onSearch({param});
}
});
};
//转换时间格式(开始)
changeBeginDate = (date) => {
var d = new Date(date);
var month = (d.getMonth() + 1) > 9 ? (d.getMonth() + 1) : '0' + (d.getMonth() + 1);
var day = d.getDate() > 9 ? d.getDate() : '0' + d.getDate();
var nowdate = d.getFullYear() + '-' + month + '-' + day + ' 00:00:00';
return nowdate
}
//转换时间格式(结束)
changeEndDate = (date) => {
var d = new Date(date);
var month = (d.getMonth() + 1) > 9 ? (d.getMonth() + 1) : '0' + (d.getMonth() + 1);
var day = d.getDate() > 9 ? d.getDate() : '0' + d.getDate();
var nowdate = d.getFullYear() + '-' + month + '-' + day + ' 23:59:59';
return nowdate
}
//时间选择器
<FormItem {...formItemLayout} label="修改日期">
{getFieldDecorator("editDay")
(
<RangePicker showTime format='YYYY-MM-DD' />
)
}
</FormItem>
后端
1.dto
/**
* 修改时间(开始)
*/
@ApiModelProperty("修改时间(开始)")
private java.lang.String beginTime;
/**
* 修改时间(结束)
*/
@ApiModelProperty("修改时间(结束)")
private java.lang.String endTime;
2.mapper.xml
<if test="beginTime != null and beginTime != '' ">
<![CDATA[ and CJSJ >= to_date(#{beginTime},'yyyy-MM-dd hh24:mi:ss')]]>
</if>
<if test="endTime != null and endTime != '' ">
<![CDATA[ and XGSJ <= to_date(#{endTime},'yyyy-MM-dd hh24:mi:ss')]]>
</if>