Author Topic: Statistics by group / category  (Read 1104 times)

0 Members and 1 Guest are viewing this topic.

mksaad

  • Jr. Member
  • **
  • Posts: 3
Statistics by group / category
« on: April 01, 2020, 03:44:15 PM »
Hello,

How can I statistics by group/category?

Thanks,
Motaz 


faf

  • Mibew Staff Member
  • Native
  • *****
  • Posts: 918
    • Mibew Messenger
Re: Statistics by group / category
« Reply #1 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.

mksaad

  • Jr. Member
  • **
  • Posts: 3
Re: Statistics by group / category
« Reply #2 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

faf

  • Mibew Staff Member
  • Native
  • *****
  • Posts: 918
    • Mibew Messenger
Re: Statistics by group / category
« Reply #3 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.

mksaad

  • Jr. Member
  • **
  • Posts: 3
Re: Statistics by group / category
« Reply #4 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

faf

  • Mibew Staff Member
  • Native
  • *****
  • Posts: 918
    • Mibew Messenger
Re: Statistics by group / category
« Reply #5 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 one can take a look at Mibew:PurgeHistory plugin. And Mibew:BulkLogsOperations 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 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