英文版网站建设方案/网络推广员

2.1 :查询开始时间在start_date与end_date之间，则肯定有交集

2.2 :查询结束时间在start_date与end_date之间，则肯定有交集

2.3：查询开始时间>=start_date,查询结束时间<=end_date，则肯定有交集

if(ObjectUtil.isNotEmpty(page.getPlanStartTime()) && ObjectUtil.isNotEmpty(page.getPlanEndTime())){wrapper.and(a->a.and(b->b.ge(LeanTradeLabourDispatchPo::getPlanStartTime,page.getPlanStartTime()).le(LeanTradeLabourDispatchPo::getPlanStartTime,page.getPlanEndTime())).or(c->c.ge(LeanTradeLabourDispatchPo::getPlanEndTime,page.getPlanStartTime()).le(LeanTradeLabourDispatchPo::getPlanEndTime,page.getPlanEndTime())).or(d->d.le(LeanTradeLabourDispatchPo::getPlanStartTime,page.getPlanStartTime()).ge(LeanTradeLabourDispatchPo::getPlanEndTime,page.getPlanEndTime())));}

SELECT COUNT( 1 ) FROM 'table' WHERE del_flag = 0 
AND (( plan_start_time >= '2020-01-02 00:00:00.0' AND plan_start_time <= '2020-02-02 00:00:00.0' ) 
OR ( plan_end_time >= '2020-01-02 00:00:00.0' AND plan_end_time <= '2020-02-02 00:00:00.0' ) 
OR ( plan_start_time <= '2020-01-02 00:00:00.0' AND plan_end_time >= '2020-02-02 00:00:00.0' )));