| | |
| | | <if test="deptid!=null and deptid!=''"> |
| | | and u.dept_id =#{deptid} |
| | | </if> |
| | | <if test="type=1"> |
| | | <if test="type!=null and type=='1'"> |
| | | and to_days(u.update_time) = to_days(now()); |
| | | </if> |
| | | <if test="type=2"> |
| | | <if test="type!=null and type=='2'"> |
| | | and DATE_FORMAT(u.update_time, '%Y%m' ) = DATE_FORMAT( CURDATE( ) , '%Y%m' ) |
| | | </if> |
| | | GROUP BY d.dept_name, |
| | |
| | | <if test="deptid!=null and deptid!=''"> |
| | | and u.departmentid =#{deptid} |
| | | </if> |
| | | <if test="type=1"> |
| | | <if test="type!=null and type=='1'"> |
| | | and to_days(u.time) = to_days(now()); |
| | | </if> |
| | | <if test="type=2"> |
| | | <if test="type!=null and type=='2'"> |
| | | and DATE_FORMAT(u.time, '%Y%m' ) = DATE_FORMAT( CURDATE( ) , '%Y%m' ) |
| | | </if> |
| | | GROUP BY d.dept_name, |