| | |
|---|
| | | fse.addSubDataTable(dd); |
|---|
| | | json = BaseUtil.dataTableToTreeData(dt, "code", "tricode", null, false); |
|---|
| | | } |
|---|
| | | String sql = " select count(*) sum from product_oa_cooperate_flow_node where cooperate_uuid =? and status =? "; |
|---|
| | | String sql1 = " select count(*) sum from product_oa_cooperate_flow_node where cooperate_uuid =? "; |
|---|
| | | String sql0 = " select count(*) sum from product_oa_cooperate_flow_node where cooperate_uuid =? and (status =? or status is null) "; |
|---|
| | | String sql = " select count(*) sum from product_oa_cooperate_flow_node where cooperate_uuid =? and status =? and tricode is not null"; |
|---|
| | | String sql1 = " select count(*) sum from product_oa_cooperate_flow_node where cooperate_uuid =? and tricode is not null"; |
|---|
| | | String sql0 = " select count(*) sum from product_oa_cooperate_flow_node where cooperate_uuid =? and (status =? or status is null) and tricode is not null"; |
|---|
| | | FieldSetEntity fss = baseDao.getFieldSetEntityBySQL(sql1, new Object[]{fs.getString(CmnConst.UUID)}, true); |
|---|
| | | FieldSetEntity fs0 = baseDao.getFieldSetEntityBySQL(sql0, new Object[]{fs.getString(CmnConst.UUID), 0}, true); |
|---|
| | | FieldSetEntity fs1 = baseDao.getFieldSetEntityBySQL(sql, new Object[]{fs.getString(CmnConst.UUID), 1}, true); |
|---|
| | |
|---|
| | | if (fss.getInteger("sum") == null) { |
|---|
| | | fse.setValue("totals", 0);//流程共有人数 |
|---|
| | | } else { |
|---|
| | | fse.setValue("totals", fss.getInteger("sum") - 1); |
|---|
| | | fse.setValue("totals", fss.getInteger("sum")); |
|---|
| | | } |
|---|
| | | if (fs0.getInteger("sum") == null) { |
|---|
| | | fse.setValue("uncollectd", 0);//未收未办人数 |
|---|
| | |
|---|
| | | if (fs2.getInteger("sum") == null) { |
|---|
| | | fse.setValue("done", 0);//已收已办人数 |
|---|
| | | } else { |
|---|
| | | fse.setValue("done", fs2.getInteger("sum") - 1); |
|---|
| | | fse.setValue("done", fs2.getInteger("sum")); |
|---|
| | | } |
|---|
| | | int a = fse.getInteger("totals") - fse.getInteger("uncollectd") - fse.getInteger("received") - fse.getInteger("done"); |
|---|
| | | fse.setValue("not_yet", a);//未到环节人数 |
|---|
| | |
|---|
| | | return baseDao.add(fs); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public boolean delSupplyText(FieldSetEntity fs) { |
|---|
| | | return baseDao.delete(fs.getTableName(),new String[]{fs.getUUID()}); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * @description: 协同办公催办 |
|---|
| | | * @author: ZhouJie |
|---|
