ID, ITEM_USER_ID, ITEM_USER_NAME, ITEM_DEPARTMENTNAME, ITEM_DEPARTMENTID, ITEM_APPLICATION_TIME, ITEM_START_TIME, ITEM_STOP_TIME, ITEM_DIFF_TIME, STATELABEL, select from tlk_business_travel and ITEM_USER_ID in #{item} and #{schedulDate} between date_format(ITEM_START_TIME,'%Y-%m-%d') and ITEM_STOP_TIME and STATELABEL = '审批通过' where ID = #{id} SELECT FROM `tlk_business_travel` WHERE ID in #{item.id} select ITEM_USER_ID, ITEM_APPLICATION_TIME, ITEM_START_TIME, ITEM_STOP_TIME, ITEM_DIFF_TIME, '3' as 'dictType' from tlk_business_travel and ITEM_USER_ID = #{tlkPerId,jdbcType=VARCHAR} and #{schedulDate} BETWEEN date_format(ITEM_START_TIME, '%Y-%m') AND date_format(ITEM_STOP_TIME, '%Y-%m') and STATELABEL = '审批通过'