| | |
|---|
| | | mdc_overall_equipment_efficiency t1 LEFT JOIN mdc_shift_sub t2 ON t1.shift_sub_id = t2.id |
|---|
| | | LEFT JOIN mdc_shift t3 ON t2.shift_id = t3.id |
|---|
| | | <where> |
|---|
| | | <if test="mdcOverallEquipmentEfficiency.startTime != null and mdcOverallEquipmentEfficiency.startTime != '' and mdcOverallEquipmentEfficiency.endTime != null and mdcOverallEquipmentEfficiency.endTime != ''"> |
|---|
| | | AND t1.valid_date BETWEEN #{ mdcOverallEquipmentEfficiency.startTime } AND #{ mdcOverallEquipmentEfficiency.endTime } |
|---|
| | | </if> |
|---|
| | | <if test="mdcOverallEquipmentEfficiency.shiftId != null and mdcOverallEquipmentEfficiency.shiftId != ''"> |
|---|
| | | AND t3.id = #{ mdcOverallEquipmentEfficiency.shiftId } |
|---|
| | | </if> |
|---|
