| | |
|---|
| | | import com.product.quartz.service.impl.SysJobService; |
|---|
| | | import com.product.util.BaseUtil; |
|---|
| | | import com.product.util.SystemParamReplace; |
|---|
| | | import com.product.util.UnifySQLFunction; |
|---|
| | | |
|---|
| | | import org.quartz.SchedulerException; |
|---|
| | | import org.springframework.beans.factory.annotation.Autowired; |
|---|
| | | import org.springframework.stereotype.Service; |
|---|
| | |
|---|
| | | //公司或部门uuid |
|---|
| | | } else { |
|---|
| | | StringBuffer sql = new StringBuffer(); |
|---|
| | | sql.append(" SELECT * FROM product_sys_staffs WHERE org_level_uuid = ( ") |
|---|
| | | .append(" SELECT IFNULL(org_level_uuid,uuid) org_level_uuid FROM product_sys_org_levels WHERE uuid = ? ) ") |
|---|
| | | .append(" and is_org_manager = 1 "); |
|---|
| | | sql.append("\nSELECT * FROM product_sys_staffs ") |
|---|
| | | .append("\nWHERE org_level_uuid = ( ") |
|---|
| | | .append("\n SELECT ").append(UnifySQLFunction.ifnull("org_level_uuid", "uuid")).append(" AS org_level_uuid ") |
|---|
| | | .append("\n FROM product_sys_org_levels WHERE uuid = ? ") |
|---|
| | | .append("\n) ") |
|---|
| | | .append("\nAND is_org_manager = 1 "); |
|---|
| | | dataTableEntity = baseDao.listTable(sql.toString(), new String[]{responsible}); |
|---|
| | | } |
|---|
| | | if (!BaseUtil.dataTableIsEmpty(dataTableEntity)) { |
|---|
