Last connection of item's creator

1 year 8 months ago #75925 by templar
Hi,

As in the title of this thread, I would like to show, on a category list of items, the last connection of the creator's item.
I've tried to add a date field, but I'm unable to show the last connection of the creator (not surprising).

How can I achieve that ?

Thanks !

Please Log in or Create an account to join the conversation.

1 year 8 months ago #75926 by micker
hello, last connexion last edition ? where ?

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

1 year 8 months ago - 1 year 8 months ago #75927 by templar
Each user has a "last connected" field.
I would like to show for any item, the item's creator corresponding field.

Please Log in or Create an account to join the conversation.

1 year 8 months ago #75928 by micker
but you want to mix an user table data to item type data ...

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

1 year 8 months ago #75929 by templar
That's why I need some help.
Is that even possible ?

Please Log in or Create an account to join the conversation.

1 year 8 months ago #75930 by ggppdk
Hello

you can even do it inside template files

item.php
category_items.php

loop through $items to get put ->created_by into an array

then you can make a single query to get the needed data from DB table
#__session


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

1 year 8 months ago #75931 by micker
maybe you can do a select field with an sql request like this (its an exemple need to adapt to your bdd)
SELECT id, name AS text, lastvisitDate AS value FROM #__user WHERE id = item->create_by
if it works you can use this by defaut, and hide in form

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

1 year 8 months ago #75973 by templar
Hello,

After some tries, the solution of Micker is working, but there is still a problem.
The field is not dynamic, it is recorded during the creation or the modification of an item and stay "as is" until further modification.
Second problem, the process is not transparent for the user of the website, as they are forced to select manually the field.

So here ara my two questions :
- How to show the last visit date dynamically ?
- How to autmatically fill the field and hide it from the creation/.modification form ?

Thank you guys, your extension is awesome !

Please Log in or Create an account to join the conversation.

1 year 8 months ago #75975 by micker
hello
you can add defaut value with option to autofill (not empty without save)
after you can hide field in form

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

1 year 8 months ago #75976 by templar
Ok, so I need the pro version ?

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
© 2018 Flexicontent. All Rights Reserved.