Mibew Messenger Community

General => Support => Topic started by: mksaad on April 01, 2020, 03:44:15 PM

Title: Statistics by group / category
Post by: mksaad on April 01, 2020, 03:44:15 PM
Hello,

How can I statistics by group/category?

Thanks,
Motaz 
Title: Re: Statistics by group / category
Post by: faf on April 02, 2020, 08:59:47 AM
Hi,

The answer is short. There are no such feature in the core of Mibew Messenger, so one will have to write a special plugin for that.
Title: Re: Statistics by group / category
Post by: mksaad on April 14, 2020, 06:50:16 AM
Thank you so much for your answer,

I would be very nice if you provide the SQL statement to get the report

I appreciate your help
Motaz
Title: Re: Statistics by group / category
Post by: faf on April 15, 2020, 09:17:02 AM
It doesn't work that way. :)

I can try to help you by answering some concrete questions, i.e. 'how can one get the list of groups?", or "how can one get the number of closed threads for a given day?", etc. But I will not do all the job for you. Two reasons: it's boring (I've got much more interesting things to do) and it's unfair (you did nothing neither for the project, nor for me personally). Moreover, I have serious doubts that you'll open your source code once it will be written.
Title: Re: Statistics by group / category
Post by: mksaad on April 18, 2020, 09:25:00 AM
Thanks for clarifications, and I got your point

We are open to contributing. Please let me know where I can find the DB schema so I can write the SQL by myself. and I will contribute it back to you.


I want to let you know that we have done most of the missing translations into Arabic and we are happy to contribute it back to you but we do not know-how. I checked https://github.com/Mibew/i18n but there are no instructions to contribute.

Kind regards,
Motaz
Title: Re: Statistics by group / category
Post by: faf on April 18, 2020, 03:44:00 PM
We are open to contributing. Please let me know where I can find the DB schema so I can write the SQL by myself. and I will contribute it back to you.

That's great. :)

The database schema described in yaml is available here: https://github.com/Mibew/mibew/blob/master/src/mibew/configs/database_schema.yml

To get some basic ideas on how to work with the database in plugin using cron events (https://docs.mibew.org/development/server-side-events.html#cron-events) one can take a look at Mibew:PurgeHistory plugin (https://mibew.org/plugins#mibew-purge-history). And Mibew:BulkLogsOperations (https://mibew.org/plugins#mibew-bulk-logs-operations) can be used as an example of modifying existing administrative interfaces.

I want to let you know that we have done most of the missing translations into Arabic and we are happy to contribute it back to you but we do not know-how. I checked https://github.com/Mibew/i18n but there are no instructions to contribute.

The POT file with all localization constants in Mibew Messenger is available here: https://mibew.org/download2#pot

And the simpliest way to contribute to translation is to fork an i18n repo (https://github.com/Mibew/i18n/) on Github, modify an existing translation, and then make a pull request.

Also, you can just export the translation from the existing Mibew Messenger installation and send it to support: https://mibew.org/contacts