link forms by province

[wezetel]

$company='{$my->id}';
$db = \Joomla\CMS\Factory::getContainer()->get('DatabaseDriver');
$query = $db->getQuery(true);
$query->select('province');
$query ->from('company');
$query -> where('companyid =' . $company)  ;
$db->setQuery($query);
$result = $db->loadResult();
return $result;

 

[presupuesto]

Gracias por la ayuda pero sigue pasando lo mismo, no filtra provincias ni profesiones. Todo está en la misma lista que la imagen anterior. También recibo este error al seleccionar "Registrador o Público", al aplicar en el prefiltro

 

[wezetel]

Did you copy and paste the code I provided? Seems there is a space in your code before the '>'

 

[presupuesto]

Good morning, yes I have copied it as is, same error in public and registered.thank you

 

[troester]

Did you set Type=Eval?
SQL errors line 3 sounds like Type=Query

 

[presupuesto]

Did you set Type=Eval?
SQL errors line 3 sounds like Type=Query

if it is in eval

 

[troester]

{$my->id} will only be replaced it there's a "my", i.e. if you are logged in.
If you calling the list as guest it will keep the unreplaced string and this will create a SQL error because it's not quoted in the query.

So to fix the SQL error do
$query -> where('companyid =' . $db->quote($company) ) ;

This will give you the syntactically correct query ...WHERE companyid ='{$my->id}' ...
but I assume this is not what you want in case of a guest.

So if company should be 0 in this case you can do
$company='{$my->id}';
$company=!is_int($company) ? 0 : $company;
...

 

[wezetel]

My base assumption for the code was, that anybody can create a request, but the (filtered) request list is only visible for registered / logged in companies and therefore there is always a valid ID available.

Else probably private contact information of the requestors would be visible to the world (except those would be handled with element access levels). But the question would be: what is the sense for showing guests a list of anonymous requests?

 

[wezetel]

Do us a favour please: https://www.deepl.com/translator

Strange: even the quotes are in Spanish. Have you an automatic Translator?

 

[presupuesto]

{$my->id} will only be replaced it there's a "my", i.e. if you are logged in.
If you calling the list as guest it will keep the unreplaced string and this will create a SQL error because it's not quoted in the query.

So to fix the SQL error do
$query -> where('companyid =' . $db->quote($company) ) ;

This will give you the syntactically correct query ...WHERE companyid ='{$my->id}' ...
but I assume this is not what you want in case of a guest.

So if company should be 0 in this case you can do
$company='{$my->id}';
$company=!is_int($company) ? 0 : $company;
...

Thank you very much for your interest in helping me. Now I understand a little better how it works, although the error is not identified from what it tells me, what is not clear to me is:"So if company should be 0 in this case you can do$company='{$my->id}';$company=!is_int($company) ? 0 : $company;"Furthermore, the form does not reach the company that has registered with the same province and profession. Thank you

 

[presupuesto]

My base assumption for the code was, that anybody can create a request, but the (filtered) request list is only visible for registered / logged in companies and therefore there is always a valid ID available.

Else probably private contact information of the requestors would be visible to the world (except those would be handled with element access levels). But the question would be: what is the sense for showing guests a list of anonymous requests?

Sorry for the language mix. It is not an automatic translator.What you indicate is precisely what I want, but the filtering does not work for me. When creating a new user with the same province and profession, that request does not appear in the list. What I need is for the user to register in their private panel to have the requests that match their province and profession.

 

[wezetel]

Are you developing on a local server or is there the possibilty to check online. Maybe you can send me access details via PM

 

[presupuesto]

Are you developing on a local server or is there the possibilty to check online. Maybe you can send me access details via PM

 

[presupuesto]

Are you developing on a local server or is there the possibilty to check online. Maybe you can send me access details via PM

I have it on a test server, but I don't know how to send the keys privately.

 

[wezetel]

If you click on my picture a small popup appears, where at the bottom a button 'start conversation' appears

 

[presupuesto]

This form works perfectly. The question I have is if I want to give direct access to several tabs in the frontend. Do I need to create a new list for each form?

 

[wezetel]

Can you please explain a bit more. In general you have two forms: Company and requests. But there are no tabs.
Basically you can always create a (fabrik list) menu item with specific pre-filters, so there is no need for a new (copied) list.
But if you can give more information, what you want to achive, more specific help can be provided

 

[presupuesto]

Can you please explain a bit more. In general you have two forms: Company and requests. But there are no tabs.
Basically you can always create a (fabrik list) menu item with specific pre-filters, so there is no need for a new (copied) list.
But if you can give more information, what you want to achive, more specific help can be provided

Thanks for the help. I need to create a form with direct links, some of these forms have only one filter (province), and not two like the previous ones, although the operation would be the same, the end is the same, it must reach the company registered with that province.Example form with direct link (only for electricians), with the only province filter.Just as you say, Fabrik, do you have a simpler option to achieve this?

 

[wezetel]

To be honest: I still don't get what you want

I need to create a form with direct links

Do mean a fabrik form or a Joomla article?
Direct links to a filtered list or to a specific form (there may be more than one company according the filter; so I would assume a list)?
Your screenshot (or the website address) doesn't tell me much about whatyou want to achieve...

 

[wezetel]

If your 'portal page' is a joomla article you may think about creating fabrik menu items for each of the portal items with the according pre-filter (you can hide them in the menu settings to avoid appearing on the page) and then create a link in each of the portal items to this menu items.