moqui / hivemind Goto Github PK

When opening the FindTask screen (https://demo.moqui.org/apps/hm/Task/FindTask), the page footer appears before the table with the main content.

If I go to HM Admin > Projects, it will paginate all projects. The dashboard will only display in-progress projects. But, it does no pagination. If there are hundreds to thousands of in-progress projects, it will send that much pre-rendered html from the server, and the browser struggles to display that much content.

I started to create new projects on demo.moqui.org, and never got a paginator to display(but hadn't gotten it up to 10 yet). The project list tho, was displaying a paginator with only 3 items on it(well below the per-page setting).

qapps/hm/Project/FindProject, shows all projects for me. Good. I then click "Project Up or Down" error. That gives a parameter orderByField=^workEffortId. The '^' gets converted to UPPER(workEffortId) in the generated sql. However, component/HiveMind/screen/HiveMindRoot/Project/FindProject.xml, the actions/WorkEffortParty has distinct=true, and that conflicts, as I get this postgresql error: Caused by: org.postgresql.util.PSQLException: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list

The generated SQL looks like this:

SELECT DISTINCT WEFF.WORK_EFFORT_ID, WEFF.WORK_EFFORT_NAME, WEFF.PRIORITY, WEFF.STATUS_ID, WEFF.ESTIMATED_COMPLETION_DATE, WEFF.ESTIMATED_WORK_TIME, WEFF.ACTUAL_WORK_TIME FROM (public.WORK_EFFORT WEFF LEFT OUTER JOIN public.WORK_EFFORT_PARTY WEP ON WEFF.WORK_EFFORT_ID = WEP.WORK_EFFORT_ID) WHERE (WEFF.WORK_EFFORT_TYPE_ENUM_ID = $1 AND (WEFF.VISIBILITY_ENUM_ID IN ($2, $3) OR (((WEP.FROM_DATE IS NULL OR WEP.FROM_DATE <= $4) AND (WEP.THRU_DATE IS NULL OR WEP.THRU_DATE > $5)) AND WEP.PARTY_ID = $6))) ORDER BY WEFF.WORK_EFFORT_ID ASC NULLS LAST, UPPER(WEFF.WORK_EFFORT_ID) DESC NULLS LAST OFFSET 0 ROWS FETCH FIRST 20 ROWS ONLY

Note the doubled-up order by entries.

This is further conflicted by the show-order-by=case-insenstive in that same xml file.

I'm not sure where to go about fixing this, but it super easy to replicate.

Problem 1:

1. Open an existing wiki spage: http://localhost:8080/apps/hm/wiki/DEMO
   currently, the root page of this wiki has content

2. choose Edit Page for the root page
   the EditWikiPage screen opened with url: http://localhost:8080/apps/hm/EditWikiPage?wikiSpaceId=DEMO&pagePath=DEMO

Issue: this screen shows empty page

If I fill content and save, system creates new page DEMO under the root (has path wiki/DEMO/DEMO)

Problem 2:

1. Open EditWikiPage directly with url: http://localhost:8080/apps/hm/EditWikiPage?wikiSpaceId=DEMO
   it will shows the exact content of the Root Page of DEMO wiki

2. Save this page, system creates update content to page DEMO under the root (has path wiki/DEMO/DEMO)

The issue may be because of parameter pagePath returned from service org.moqui.impl.WikiServices.get#WikiPageInfo. As I remembered correctly, when opening a wiki root page, the pagePath must be empty.

I am finding 2 problems when creating / updating project-party relations in /apps/hmadmin/User/EditProjects. Both seem to be related to timezone. Not sure whether this is a HiveMind, Mantle or Moqui issue but as it comes up in HiveMind I have added this issue here.

1. When creating a new association of a party to a project, the from_date is in the future, so the project does not appear in the users' project list.
2. When trying to modify an existing association of a party to a project, e.g. modifying the status, the entity-auto update service does not find the value. I assume this is due to a mismatch in the from_date field of the PK.

In the first case, I am not sure whether it could be a configuration issue because of a timezone mismatch between the users and the server's. But in the second case, regardless of the configured timezones, if I do not change the from_date (which I also cannot, because it is a PK of the table), I should be able to modify the values.

I added an Edit and Delete button on Task Comments.

The underlying TaskService updates are in sssonline's TaskServices.xml.

HMpatch.diff.zip

Manufacturing/Production Management or JobShop functionality seems only partially supported in ManufacturingServices so I've been working on filling in the gaps for personal needs. HiveMind's description indicates that it is designed for Service industries and is geared more toward project management rather than production.

To avoid "muddying" HiveMind, does it make more sense to have manufacturing management handled with a separate component (something called JobShop or, to distinguish from Ofbiz and have a cool name like HiveMind, something like MakerShop)?

This article https://en.wikipedia.org/wiki/Tertiary_sector_of_the_economy suggests that HiveMind is designed to support the third sector of the economy. So a JobShop/MakerShop component would be designed to support the second sector (manufacturing raw materials to finished products). I'm not sure if the first sector of the economy would require its own component because I don't have much experience with it but I vaguely remember a discussion years back about how agriculture couldn't be handled very easily in OFBiz or at least not OOTB so perhaps a separate component would have helped.

I'm really just looking for guidance on how to go about providing manufacturing capabilities in Moqui. I'm open to any suggestions.