• Hello Fabrik Community

    Fabrik is now in the hands of the development team that brought you Fabrik for Joomla 4. We have recently transitioned the Fabrik site over to a new server and are busy trying to clean it up. We have upgraded the site to Joomla 4 and are running the latest version of Fabrik 4. We have also upgraded the Xenforo forum software to the latest version. Many of the widgets you might have been used to on the forum are no longer operational, many abandoned by the developers. We hope to bring back some of the important ones as we have time.

    Exciting times to be sure.

    The Fabrik 4.0 Official release is now available. In addition, the Fabrik codebase is now available in a public repository. See the notices about these in the announcements section

    We wish to shout out a very big Thank You to all of you who have made donations. They have really helped. But we can always use more...wink..wink..

    Also a big Thank You to those of you who have been assisting others in the forum. This takes a very big burden off of us as we work on bugs, the website and the future of Fabrik.

How to set up a shop

ok, thanks!
I set up a new example here with the db join element for the product:
http://joit.de/privat/fabrikshop/index.php/add-order
Now what i don't like about the db join is that the client doesn't see all products at once.
I think it would be great to see all product at once. 1 product per line with a quantity element next to it.
1. Is it possible with a repeat group to prefill the db join value with the repeat group's id?
2. Or is there a better way? Actually the ordering in a list done by j2store plugin is very nice.
 
Last edited:
should I make it more clear?
Is one of these images possible to implement?
 

Attachments

  • 1.png
    1.png
    12.8 KB · Views: 304
  • 2.png
    2.png
    7.4 KB · Views: 311
2.png with j2store

1.png:
I assume it's possible to pre-fill a repeated group (with elements dbjoin to products + a quantity field/dropdown) via php plugin on form load (but I don't know how).
 
2: I'd be really happy if I could achieve that without j2store!!!
1: could somebody push me in the right direction pls? maybe a field plugin would render nicer than the db join, just to get rid of the down pointing arrows...
 
Hi guys,

is @rob back? I could really need some help on this one. It is suppoesed to be the heart of the site that I want to build.
 
I tried to work this out by myself but my php knowledge is just to weak.
But I don't think it would'nt need much php code.
So this is the pseudocode I came up with

onLoad:
for 0 to MaxRecords in ProductsTable
ProductValue = ProductValue + 1
next

Would that work? Could somebody translate this to real php?
I'd appreciate that.
 
1.png:
I assume it's possible to pre-fill a repeated group (with elements dbjoin to products + a quantity field/dropdown) via php plugin on form load (but I don't know how).

I've doing that with a dbjoin element, and an autofill plugin.
 
great! I didn't work with the autofill plugin so far. Can you help me what to put into the Map Data field?
 
list= products table
lookup field= product_id
field to observe= repeat_table___product_id (the dbjoin element)

{"products_tables___price":"repeat_table___price", etc... }
 
I think I entered everything as you described and in the wiki I dodn't find other information. But the form just won't autofill ;(
here it is:
http://joit.de/privat/fabrikshop/index.php/add-order

I attached 2 scrennshots of the autofill settings, can you please have a look at them?

data:
List: The table of my products
Lookup field: the primary id of the products list
Field to obeserve: the dbjoin element of the products in the orders list
I left map data empty for now and enter prices etc. later

options:
trigger: I left that one empty because the form should autofill on load
edit original record: no
autofill confirmation: no
autofill on load: yes

The problem is that nothing happens when I load the form.
 

Attachments

  • data.png
    data.png
    44.3 KB · Views: 233
  • options.png
    options.png
    46.9 KB · Views: 238
If you left map data empty, there's nothing to fill...
You need to say to autofill which product field goes to which repeat data field
 
Aha, so I did this for products (the dbjoin element) like this
{"products___item":"orders_4_repeat___product"}
But it just won't autofill...
 
which data want you autofill?

with that:
{"products___item":"orders_4_repeat___product"}

you fill product field with product field (and as i see on your site autofill plugin do the job...)

Can you put your table structure here?
 
Shure, this is my products table:

products___date_time [date]
products___id [internalid]
products___item [field]

and this is my orders table:
orders___id [internalid]
orders___date_time [date]
orders_4_repeat___id [internalid]
orders_4_repeat___parent_id [field]
orders_4_repeat___product [databasejoin]
orders_4_repeat___quantity [dropdown]


somehow I don't get it....
 
the value of the database join should be
0 for repeat group 0
1 for repeat group 1
2 for repeat group 1
etc.
depending on how many records are in products list
 
Sorry, but i don't understand what you want to do...
And finally not sure my proposition is good!
You want pre-fill the dbjoin with product_id= repeat row_id?
 
it would be great to
1. create as many repeat groups as there are records in list products
2. prefill the db join element's value incrementally with the internal id from products
3. autofill other fields like price, description,... with the according products attributes

is this possible with autofill plugin?
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top