| | |
|---|
| | | ) H |
|---|
| | | LEFT JOIN( |
|---|
| | | SELECT |
|---|
| | | COUNT( * ) AS thisnum,real_name,paper_time, |
|---|
| | | COUNT( * ) AS thisnum, |
|---|
| | | group_concat(real_name) AS czname, |
|---|
| | | group_concat(IFNULL(paper_time,0)) AS czptime, |
|---|
| | | dept_id |
|---|
| | |
|---|
| | | AND is_deleted = 0 |
|---|
| | | AND hold = 1 |
|---|
| | | GROUP BY |
|---|
| | | dept_id,real_name,paper_time |
|---|
| | | dept_id |
|---|
| | | ) A ON A.dept_id=H.departmentid |
|---|
| | | LEFT JOIN ( |
|---|
| | | SELECT |
|---|
| | | COUNT(*) AS lastnum,real_name,paper_time, |
|---|
| | | COUNT(*) AS lastnum, |
|---|
| | | group_concat(real_name) AS wczname, |
|---|
| | | group_concat(IFNULL(paper_time,0)) AS wczptime, |
|---|
| | | dept_id |
|---|
| | |
|---|
| | | AND is_deleted = 0 |
|---|
| | | AND hold = 2 |
|---|
| | | GROUP BY |
|---|
| | | dept_id,real_name,paper_time |
|---|
| | | dept_id |
|---|
| | | ) B ON B.dept_id=H.departmentid |
|---|
| | | where 1=1 |
|---|
| | | <if test="deptid!=null and deptid!=''"> |
|---|
