• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: submission directory - filter items

submission directory - filter items 6 years 8 months ago #38381

Hi guys,
I tried to figure it out on my own but after 2 day I'm giving up and hope maybe somebody here would help me.

What I'm trying to do is filter submissions based on user id. User id is not submitter in this case. My form recognize 4 users group. Group 1 creating sumissions, Group 2 assigning user (always one user only) from Group 3 to submission. I already have everything working as expected except 1 thing.
Once user from Group 3 will login to check submissions I'd like him to see only submissions that been assigned to him (he will be never submitter so can't filter directory items agains 'login').

I found something that seems like a right way but can't figure out how to adapt it as I'm not programmer.

I will really appreciate help.
thank you
Last Edit: 6 years 8 months ago by suchan.paul.
The administrator has disabled public write access.

submission directory - filter items 6 years 8 months ago #38389

if there are no people who can help to make that thing works then maybe someone of you can help me with updating directory view table within received result.

for now I'm collecting data right data within
$db = JFactory::getDBO();
$user = JFactory::getUser();
$userId = $user->id;
 
$db->setQuery("SELECT (rsv.`FieldValue`) FROM #__rsform_submission_values AS rsv  LEFT JOIN #__rsform_submissions AS rs ON rsv.SubmissionId = rs.SubmissionId WHERE rsv.`FieldName`='VVVVV' AND `FieldValue`='".$user->id."' AND rsv.`FormId`='5' ");
$results = $db->loadObjectList();
$directoryLayout .= 'This user ID: ' .$db->loadResult();

directory layout in this case it's just to preview result as I'm newbie in php and need to see what's happening.
once I'm changing SELECT to SELECT COUNT I'm receiving correct amount of rows.
I dont know how I can rebuild directory table view with select result.

Can somebody help me or help me for a beer (orange juice if underaged)?

If it might be help full I added already table id so maybe there is some way just to drive it in css.
I read lots of solutions but can't make work any of them.
If nobody's fancy to help then maybe just write right direction.

thanks
Last Edit: 6 years 8 months ago by suchan.paul.
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!