jimie VIP
Total posts: 531
11 Apr 2014 07:41

Hello Sergey

As you`ve seen yourself we have many sections and types, and now I just found that the setup we did for customer to read his inqueries when access as a customer "Inqueries to me" you can only see the inqueries coming from just only one section/type which is not oky as we want them to be able in there inqueries from all the sections, is it possible to do something about this to have them all in there ?

rgds

Last Modified: 22 Apr 2014


Sergey
Total posts: 13,748
11 Apr 2014 11:17

You have connected inquires to different sections?

Fixed. I did so you nca pass _rsid url parameter of few sections sepaated by coma. Eg: &_rsid=2,3.

After next update.


jimie VIP
Total posts: 531
17 Apr 2014 14:41

Sergey I`m afraid this does not work even after updating to latest version released today

rgds


Sergey
Total posts: 13,748
18 Apr 2014 04:44
  1. I could not find links to inquires anywhere.
  2. I need explain what sections also conected to inquires and direct URLs to those sections on frontend.

jimie VIP
Total posts: 531
18 Apr 2014 06:36

Hello

The links can be visible only when you are logged in as an admin or company user

and the sections are all those links in the dropdown menu items


Sergey
Total posts: 13,748
18 Apr 2014 09:45

Where exactly? I cannot fid it. Logged in as demo.

2014-04-18_15-42-04

please make screenshot and show where it is.


jimie VIP
Total posts: 531
18 Apr 2014 09:51

Simply use user Company pass Company


Sergey
Total posts: 13,748
18 Apr 2014 10:00

Sergey 2. I need explain what sections also conected to inquires and direct URLs to those sections on frontend.

You did not answer that.


jimie VIP
Total posts: 531
18 Apr 2014 10:05

See the private details on top

rgds


Sergey
Total posts: 13,748
18 Apr 2014 10:10

Anyway I have fixed it. Edit reseived inquired URL and add another sections to _rsid parameter separated by coma. I tested it works now.


jimie VIP
Total posts: 531
18 Apr 2014 10:15

Oky ya, just one thing left seams

When you check received inqueries, the link to the article which received it is not visible. looks like "inqueries for" field is missing the value


Sergey
Total posts: 13,748
18 Apr 2014 11:58

This is weird. I can see query of missed link.

SELECT r.* FROM hga_js_res_record AS r 
 WHERE r.section_id = 1 
   AND r.ctime < '2014-04-18 10:29:28' 
   AND (r.extime = '0000-00-00 00:00:00' OR r.extime > '2014-04-18 10:29:28') 
   AND r.parent_id = 0 
   AND r.published = 1 
   AND r.id IN(9,0) 
 ORDER BY r.featured DESC,r.ctime ASC

If I run this query in AceSQL it пшсуы an error. But it is good query and I can run it in other DBs. I do not know but somehow AND (r.extime = '0000-00-00 00:00:00' OR r.extime > '2014-04-18 10:29:28' part of the query is stripped by Joomla.

It is hidden in Joomla.

I updated to Joomla 3.2.3 and now have the same problem.

I'll investigate it futher.


jimie VIP
Total posts: 531
18 Apr 2014 12:06

Could it be maybe because that "inquery for" field is only have one option to select section and corresponding time ? I mean it dont let you to select multiple sections

Dont know just my idea..

rgds


Sergey
Total posts: 13,748
21 Apr 2014 06:17

This is query to get Parent article. no need for multiple sections. Article only on one section.

This is weird. Looks like somewheer in the Joomla Database Driver it simply strip those lines. I am still investigating.


Sergey
Total posts: 13,748
21 Apr 2014 06:57

I raised Joomla issue.

http://joomlacode.org/gf/project/joomla/tracker/?action=TrackerItemEdit& ;tracker_item_id=33635&start=0

Let's see what they say.


Konstantin
Total posts: 1,113
21 Apr 2014 10:16

This query is work properly on your site. Problem is somewhere else.


Sergey
Total posts: 13,748
21 Apr 2014 11:47

How to fix this issue.

Problem

The Child field is bound to one section only. that is wy it is showing only parents of default section.

Solution

To solve it, you may insert this snippet of code where you want parent article to be shown.

<?php $article = ItemsStore::getRecord($item->fields_by_id[222]->value[0]); ?>
<a href="/<?php echo JRoute::_($article->url) ?>"><?php echo $article->title ?></a>

instead of

$item->fields_by_id[222]->result

Where 222 in both examples is the ID of the field.


jimie VIP
Total posts: 531
21 Apr 2014 12:21

And where exactly should I place this code ?

the 222 id is coming from inqueries "inquery for" field or ?

Because when I try to place that code in our inqueries page, it simply brakes the page


Sergey
Total posts: 13,748
21 Apr 2014 15:49

222 is just out of nowhere. I do not know what is ID of you field. 222 should be an ID of child field in inquiry type.

Open your inquiry list template file, find where you echo this field and replace.


jimie VIP
Total posts: 531
21 Apr 2014 16:56

Hello

It dosnt work, when i put that code and replace the field id with my field id, i get a joomla 404 error which says:

nquiries

You have 0 articles to compare. Do you want to see compare view now?

dont even know what has to do compare in there

rgds


Sergey
Total posts: 13,748
22 Apr 2014 06:27

I have fixed that. I have created new output field template for Child field parent.php. And set it in the field parameters. No it works.

Powered by Cobalt