| | |
|---|
| | | SELECT i.departmentid, |
|---|
| | | i.enterpriseName, |
|---|
| | | IFNULL(D.znum, 0) AS znum, |
|---|
| | | IFNULL(d.num, 0) AS fwnum, |
|---|
| | | IFNULL(F.num, 0) AS fwnum, |
|---|
| | | IFNULL(B.cznum, 0) AS cznum, |
|---|
| | | IFNULL(C.sbnum, 0) AS sbnum |
|---|
| | | FROM sys_information i |
|---|
| | |
|---|
| | | AND is_deleted = 0 |
|---|
| | | GROUP BY dept_id |
|---|
| | | ) D ON D.dept_id = i.departmentid |
|---|
| | | LEFT JOIN (SELECT COUNT(*) num, dept_id FROM sys_dispatcher_unit GROUP BY dept_id) d |
|---|
| | | LEFT JOIN (SELECT COUNT(*) num, dept_id FROM sys_dispatcher_unit GROUP BY dept_id) F |
|---|
| | | ON i.departmentid = d.dept_id |
|---|
| | | LEFT JOIN ( |
|---|
| | | SELECT COUNT(*) AS cznum, |
|---|
