Serials Dropdown list

  • Posts: 21
  • Thank you received: 0
5 years 11 months ago #291677

-- url of the page with the problem -- : associazioneformatori.it
-- Joomla version -- : 3.8.7
-- PHP version -- : 7.1.0

Hello,
I should create a dropdown list of the serials for each user in a form. I built the form with Fabrik Joomla Component, but I have a problem to filter the serials by user.
I tried by the follow code:
WHERE {thistable}.`serial_id`
IN (SELECT nu8cw_hikaserial_serial.serial_id FROM nu8cw_hikaserial_serial LEFT JOIN nu8cw_users ON (nu8cw_hikaserial_serial.serial_user_id = nu8cw_users.id))

But I see all serials that users bought in the list.
Thank you in advance,
Vito

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

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
5 years 11 months ago #291678

Hello,

I don't understand your message.
Please clarify


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 21
  • Thank you received: 0
5 years 11 months ago #291724

Hello Jerome,
I explain the form sense:
Each member fill in a personal report with some info including a serial number.
I created the form with all fields with Fabrik, including a dropdown menù where member should see his serials.
The dropdown menù is connected with hikaserial_serial table, but it's not filtered by the user login. After login each member goes in his personal page and see his serials, it's fine, but when open the page to fill in the report, all the serials appear in the dropdown menù.
Also the best solution should be that the member use the serial just one time.
Thanks,
Vito

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

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
5 years 11 months ago #291727

Hello,

Your query link the HikaSerial "serial" table with the Joomla user one ; that relation is incorrect since HikaSerial is an HikaShop add-on and is based on HikaShop users (so HikaShop user id). Table which also have a "user_cms_id".

Afterwards I don't know how is working Fabrik, so I can't tell you how retrieve the current Joomla user ID ; you should ask them for that.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 21
  • Thank you received: 0
5 years 11 months ago #291747

Ok I will check it.
Thank you.

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

  • Posts: 21
  • Thank you received: 0
5 years 10 months ago #292355

Hi Jerome,
is it possible to view the user's serials in a dropdown list? At moment I can see these list in a table.
Thank you,
Vito

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

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
5 years 10 months ago #292368

Hello,

There is no "type" or "namebox" in HikaSerial which allow to do that since there is no need of selecting a serial.
It requires a custom development.
But if you look at the HikaSerial code ; specially the front-end serial listing ; you will have the necessary elements.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

Moderators: Obsidev
Time to create page: 0.064 seconds
Powered by Kunena Forum