fix(backend,website): calculate status counts efficiently & request only aggregates for submission portal

fix(backend,website): calculate status counts efficiently & request only aggregates for submission portal #8462