problem looping through selected items to save them

st

stikkimorey 04 Sep, 2018

I have a form which uses a repeater area to display items with a checkbox next to each item. called book_it. When the checkbox is ticked, I want only the selected items to save.

Here is part of the array returned when I click submit if only the first item is checked:

 [assets] => Array
        (
            [99] => Array
                (
                    [book_it] => 1
                    [delivery] => Yes
                    [dropcrate_id] => OhBot crate 1
                    [description] => Dropcrate of 15 blue OhBots
                )

            [100] => Array
                (
                    [description] => Dropcrate of 15 blue OhBots
                )

            [101] => Array
                (
                    [description] => Dropcrate of 15 blue OhBots
                )

        )

On the submit event, I have a loop - loop_event67 with the data source of {data:assets} and in the body of the loop I have an event switcher which has a data provider of {var:loop_event67.row.book_it}

The Events I set up are 1,0 to match the values of the checkbox for book_it

In event 1 I have put the Save Data expecting it to only run when the item is checked and book_it is equal to 1

But when I select the checkbox for the first item - as above then all of the items are saved

If I select the last item then only the last item is saved as I expected

Can anyone help me understand what I'm doing wrong here please - or maybe suggest a better way to go about it?

Many thanks

he

healyhatman 04 Sep, 2018

Disable the save data action, and in the loop event body put {debug:loop_event67.row} and you should see the structure of each iteration.

st

stikkimorey 05 Sep, 2018

Thanks - here is the debug. Both of the debugs are the same on both iterations.

My data source for the loop is {data:assets} - I was expecting it to look at that array and then loop on the elements inside, so first [83] and then [84], like it does int he example in the manual but that doesn't seem to be happening.

I'm sure I've missed something fundamental here, but the more I stare at it the more I can't see it.

debug loop event start

Array
(
    [option] => com_chronoforms6
    [cont] => manager
    [chronoform] => Booking1-0
    [event] => submit
    [start_date] => 2018-09-20
    [end_date] => 2018-09-21
    [assets] => Array
        (
            [83] => Array
                (
                    [book_it] => 1
                    [delivery] => No
                    [dropcrate_id] => iPad1
                    [description] => Dropcrate of 14 iPads
                )

            [84] => Array
                (
                    [description] => Dropcrate of 14 iPads
                )

        )

    [location] => Ribston
    [Start_date] => 
    [End_date] => 
    [button78] => 
    [cookieAcceptanceCookie] => accepted
    [__atuvc] => 4|29,0|30,1|31
    [cfac6951893bdd7d18b2bc234b98e90c] => 5374d3c1e7d1df06b997a814c43f75dd
    [65d2c9358065e947a77e674ebbe3f65f] => 9730a40e0fb635ae2ea6fa297abcae11
    [joomla_user_state] => logged_in
)

Array
(
    [validate_fields2] => Array
        (
            [log] => Automatic validation enabled.
            [var] => 1
        )

)

debug loop event end

Array
(
    [option] => com_chronoforms6
    [cont] => manager
    [chronoform] => Booking1-0
    [event] => submit
    [start_date] => 2018-09-20
    [end_date] => 2018-09-21
    [assets] => Array
        (
            [83] => Array
                (
                    [book_it] => 1
                    [delivery] => No
                    [dropcrate_id] => iPad1
                    [description] => Dropcrate of 14 iPads
                )

            [84] => Array
                (
                    [description] => Dropcrate of 14 iPads
                )

        )

    [location] => Ribston
    [Start_date] => 
    [End_date] => 
    [button78] => 
    [cookieAcceptanceCookie] => accepted
    [__atuvc] => 4|29,0|30,1|31
    [cfac6951893bdd7d18b2bc234b98e90c] => 5374d3c1e7d1df06b997a814c43f75dd
    [65d2c9358065e947a77e674ebbe3f65f] => 9730a40e0fb635ae2ea6fa297abcae11
    [joomla_user_state] => logged_in
)

Array
(
    [validate_fields2] => Array
        (
            [log] => Automatic validation enabled.
            [var] => 1
        )

)

debug loop event start

Array
(
    [option] => com_chronoforms6
    [cont] => manager
    [chronoform] => Booking1-0
    [event] => submit
    [start_date] => 2018-09-20
    [end_date] => 2018-09-21
    [assets] => Array
        (
            [83] => Array
                (
                    [book_it] => 1
                    [delivery] => No
                    [dropcrate_id] => iPad1
                    [description] => Dropcrate of 14 iPads
                )

            [84] => Array
                (
                    [description] => Dropcrate of 14 iPads
                )

        )

    [location] => Ribston
    [Start_date] => 
    [End_date] => 
    [button78] => 
    [cookieAcceptanceCookie] => accepted
    [__atuvc] => 4|29,0|30,1|31
    [cfac6951893bdd7d18b2bc234b98e90c] => 5374d3c1e7d1df06b997a814c43f75dd
    [65d2c9358065e947a77e674ebbe3f65f] => 9730a40e0fb635ae2ea6fa297abcae11
    [joomla_user_state] => logged_in
)

debug loop event end

Array
(
    [option] => com_chronoforms6
    [cont] => manager
    [chronoform] => Booking1-0
    [event] => submit
    [start_date] => 2018-09-20
    [end_date] => 2018-09-21
    [assets] => Array
        (
            [83] => Array
                (
                    [book_it] => 1
                    [delivery] => No
                    [dropcrate_id] => iPad1
                    [description] => Dropcrate of 14 iPads
                )

            [84] => Array
                (
                    [description] => Dropcrate of 14 iPads
                )

        )

    [location] => Ribston
    [Start_date] => 
    [End_date] => 
    [button78] => 
    [cookieAcceptanceCookie] => accepted
    [__atuvc] => 4|29,0|30,1|31
    [cfac6951893bdd7d18b2bc234b98e90c] => 5374d3c1e7d1df06b997a814c43f75dd
    [65d2c9358065e947a77e674ebbe3f65f] => 9730a40e0fb635ae2ea6fa297abcae11
    [joomla_user_state] => logged_in
)

Array
(
    [validate_fields2] => Array
        (
            [log] => Automatic validation enabled.
            [var] => 1
        )

he

healyhatman 05 Sep, 2018

Try just {var:loop_event67.row} in the body, that debug code wasn't right (showing you everything each time which is not helpful).

st

stikkimorey 05 Sep, 2018

That helps. Here is what I get:

debug loop event start
{"book_it":"1","delivery":"Yes","dropcrate_id":"iPad1","description":"Dropcrate of 14 iPads"}
debug loop event end
debug loop event start{"book_it":"0","description":"Dropcrate of 14 iPads"}
debug loop event end

So on the first iteration, book_it is 1 and I would expect the event switcher to see that and run the save event. On the second iteration, book_it is 0 so I expected it to run the 0 block in the event switcher,

Is there a problem with the event switcher?

Or the save data?

Forums

problem looping through selected items to save them