| | |
|---|
| | | " ${ew.customSqlSegment} ") |
|---|
| | | List<MeetingListResponse> meetingList(@Param(Constants.WRAPPER) Wrapper wrapper); |
|---|
| | | |
|---|
| | | @Select(" select a.id , a.START_TIME , a.END_TIME , b.id as roomId, b.`NAME` as roomName , a.`NAME` as meetingName ,date_format(a.START_TIME,'%Y年%m月%d日') as meetingDate ," + |
|---|
| | | @Select(" select a.id ,a.ISDELETED, a.START_TIME , a.END_TIME , b.id as roomId, b.`NAME` as roomName , a.`NAME` as meetingName ,date_format(a.START_TIME,'%Y年%m月%d日') as meetingDate ," + |
|---|
| | | " CONCAT(date_format(a.START_TIME,'%H:%i') , ' ~ ',date_format(a.END_TIME,'%H:%i')) as meetingTime, c.REALNAME as bookingUserName ," + |
|---|
| | | //" CASE WHEN a.START_TIME > now() AND a.`STATUS` = 0 THEN 1 WHEN a.END_TIME < now() AND a.`STATUS` = 0 THEN 3 WHEN a.`STATUS` = 1 THEN 5 ELSE 2 END meetingStatus ," + |
|---|
| | | " CASE WHEN a.START_TIME_REAL IS NULL AND a.`STATUS` = 0 THEN 1 WHEN ( a.status = 2 ) THEN 3 WHEN a.`STATUS` = 1 THEN 5 ELSE 2 END meetingStatus ," + |
|---|
| | |
|---|
| | | " left join system_user c on a.CREATOR = c.id " + |
|---|
| | | " left join system_department_user d on c.id = d.USER_ID " + |
|---|
| | | " left JOIN system_department e on d.DEPARTMENT_ID = e.ID " + |
|---|
| | | " where a.id = #{id} ") |
|---|
| | | " where a.id = #{id} and a.isdeleted=0") |
|---|
| | | MeetingDetailResponse meetingDetail(@Param("id") Integer id); |
|---|
| | | |
|---|
| | | |
|---|
| | |
|---|
| | | "SUM( CONVERT( (UNIX_TIMESTAMP(b.END_TIME) - UNIX_TIMESTAMP(b.START_TIME))/(60*60),DECIMAL(5,1))) c\n" + |
|---|
| | | "FROM meeting_book b\n" + |
|---|
| | | "LEFT JOIN meeting_rooms r ON r.ID = b.ROOM_ID \n" + |
|---|
| | | "WHERE DATE_FORMAT(b.START_TIME,'%Y') = #{yearNum} AND b.STATUS in(0,2) \n" + |
|---|
| | | "WHERE DATE_FORMAT(b.START_TIME,'%Y') = #{yearNum} AND b.STATUS in(0,2) and b.isdeleted=0\n" + |
|---|
| | | "GROUP BY b.ROOM_ID , DATE_FORMAT(b.START_TIME,'%m')\n" + |
|---|
| | | ") t) t1 GROUP BY t1.name") |
|---|
| | | List<RoomStatisticsVo> getRoomStatistics(@Param("yearNum") Integer yearNum); |
|---|
| | |
|---|
| | | "meeting_user_rel ur\n" + |
|---|
| | | "LEFT JOIN `SYSTEM_USER` su ON ur.USER_ID = su.id \n" + |
|---|
| | | "LEFT JOIN meeting_book b ON ur.OBJ_ID = b.id \n" + |
|---|
| | | "WHERE DATE_FORMAT(b.START_TIME,'%Y') = #{yearNum} AND b.STATUS in(0,2)" + |
|---|
| | | "WHERE DATE_FORMAT(b.START_TIME,'%Y') = #{yearNum} AND b.STATUS in(0,2) and b.isdeleted=0" + |
|---|
| | | "<if test='userId != null'>"+ |
|---|
| | | "and ur.USER_ID = #{userId}\n" + |
|---|
| | | "</if>"+ |
|---|
