Add user column

[GoogleCodeExporter]

It would be great to be able to display a column showing which user did lastly 
upload, change, copy a file in relation to permission. 
A column like "last-modified" configurable directly from the script 
mollify.init of the file index and with options configurable from the backend 
as :
_what to do if the user (which was the last to make changes on the file) is 
delete from the group.
_which actions have to be considered to update the user of the file.

This new feature would be helpfull for the administrator or group manager to 
see who was the last one to make changes on the file.

Regards

Original issue reported on code.google.com by martin.b...@gmail.com on 3 Jun 2013 at 1:19

[GoogleCodeExporter]

The column itself is trivial, but the content not.

Not sure if I understood correctly, you would like to see with every file the 
last person doing something in each group? (what do you mean by "relation to 
permission", surely the permission value itself for example "RW" is by no means 
any grouping factor?)

For example

- document.txt
    - Group A
        - last copied: User A 10.5.2013
        - last nnn: User B nn.nn.nnnn
    - Group B
       - ... and so on
- picture.png
    - Group A
       - ...

Is this what you meant?

What actions should be shown?
 - There can be only one uploader, so there is no need to show "last uploader". So this wouldn't fit into this column
 - Copy (would this show a) who created this file by copying, or b) who copied this file somewhere else? you wouldn't know where it has been copied, and why only the last one is interesting?)
 - Delete cannot be shown, naturally, as the item is not shown anymore
 - Rename, Move (you wouldn't know what/where it was before)

And for the "what to do if user is deleted" from group, how exactly would you 
describe what to do? What kind of actions should there be? Send email? Delete 
files?

So at the moment this is too vague that I couldn't even estimate what this 
would require. And since it is very specific to your needs, unfortunately it 
would be prioritized quite low in the list, I have very little time so I must 
concentrate on things that are useful for everyone.

Original comment by samuli.j...@gmail.com on 4 Jun 2013 at 6:52

[GoogleCodeExporter]

Hello,

First, thank you for responding and sorry for the delay for my own answer.
I'm currently working on some different projects at the same time.

Let me try to be as clear as possible about what i try to implement, the
main goal is to see who was the latest to do something on a file :
  -if someone download the file : nothing change.
  -if someone upload a file : his name is shown in the column (you said
that there can be only one uploader and we want to know how is he, so we
would like to consider the uploader as the one how did the last change
until someone do a (real) change).
 -if someone copy a file : the name of the user who copy the file should be
shown on the new (copied) file and nothing have to change concerning the
original one.
  -if someone delete the file : as you said nothing to show.
  -if someone rename or move the file we would like to consider that
nothing have to change.
  -if a user is deleted from a group : the best would be to show something
like : "user deleted : id=xxx" with xxx the corresponding id of the user
who was deleted. It seems to be special but could be useful when the user
was migrate from another database (which is our case with mollify
integrated in a large Joomla application with joomla user that we connect
to mollify user). We also could not show anything as an empty last change
user name would correspond to a deleted user, but for use or for other
(with a similar use of mollify) it could be intresting to display that id
for an optimal tracking.

The main goal is to be able to track last change of content (the copy
doesn't enter in this context but as the name is already affected on the
original file it's more interesting to not duplicate the user who did the
last change and affect the name of who copy the file, in this case it could
be the same name only if the one who change lastly the file is also the one
who copied it).

My "in relation to permission" wasn't clear at all, of course permission is
by no means any grouping factor, i was just thinking about the fact that if
someone is affected to no rights to a file he shouldn't see this name of
the user which change lastly this file ( but it's already impossible to see
a file (on mollify list) if you are affected to no rigths), so it was only
confusing sorry.

As i said, i already start to implement this configuration, so if i manage
to do it entirely with success i will publish it to you, if not i will
rewrite you for some help !

I hope you could tell me if those changes seem to be possible and if the
conditions i define are logical compare to the whole mollify structure and
system running.

Original comment by martin.b...@gmail.com on 18 Jun 2013 at 4:16

[GoogleCodeExporter]

If you want to show only one (last) action, then it could be done with plugin 
similar to event logging (it can be used as an example on how to listen for 
backend events and store them into db). Once the events are in db, you could 
get the last relevant action based on the item id.

Event logging itself is not suitable because it does not store item ids as 
table column (but is stored within details meta data, and is no good for search 
criteria), instead items are stored as human readable names (because it can be 
historical data where item ids would not be valid/interesting anymore).

If you make a plugin of your own, make it so that it stores only the last entry 
(ie if row exists, update it), not all actions like event logging. This way it 
is easy to fetch last actions for every item, for example, in a folder at once 
with a query like in comments plugin (see 
backend/plugins/Comment/dao/CommentDao.class.php function 
getCommentCountForChildren).

Original comment by samuli.j...@gmail.com on 24 Jun 2013 at 11:30

[GoogleCodeExporter]

Marking this invalid, as it too specific to be added in mollify roadmap

Original comment by samuli.j...@gmail.com on 21 Sep 2013 at 5:53

• Changed state: Invalid