Hi at this page, I'm trying to use a repeater area, but I've some issue appear load data from database:
http://ciccr.f14web.pro/livelli-lago-riepilogo
How you can see the load data are stored into extralaghi array but I don't understand why the repeater area don't read this data.
Please could you help me to resolve this issue?
Regards.
Emanuele
http://ciccr.f14web.pro/livelli-lago-riepilogo
How you can see the load data are stored into extralaghi array but I don't understand why the repeater area don't read this data.
Please could you help me to resolve this issue?
Regards.
Emanuele
[var] => Array
(
[0] => Array
(
[extralaghi] => Array
(
[aid] => 1
[user_id] => 31
[created] => 2018-06-08 14:52:19
[data] => 2018-06-08 16:52:00
[lago] => Lago di Como
[idro] => 20
[note] => PIENA STRAORDINARIA
)
)
[1] => Array
(
[extralaghi] => Array
(
[aid] => 2
[user_id] => 31
[created] => 2018-06-08 14:59:59
[data] => 08/06/2018
[lago] => Lago di Como
[idro] => 20
[note] =>
)
)
replace {data:extralaghal} in the repeater area data provider with {var:read_data4}
Then all the values will need to be {var:area_repeater5.row.extralaghi.valueYouWant}
Great! Work fine!
I've another question:
If I try to modify the record loaded work fine, instead when I insert a new record the system don't save into db. Why?
This configuration into footer area repeter
Rergards
Emanuele
I've another question:
If I try to modify the record loaded work fine, instead when I insert a new record the system don't save into db. Why?
This configuration into footer area repeter
Rergards
Emanuele
Post your debug
The link of page is
http://ciccr.f14web.pro/accedi-2
Here the debug:
http://ciccr.f14web.pro/accedi-2
Here the debug:
Array
(
[_ga] => GA1.2.371091234.1528460153
[adcf749bbd5f64903947be2e21155320] => vimi1egl5q9dnf718ei13jotr2
[Itemid] => 117
[option] => com_chronoforms6
[view] => form
)
Array
(
[read_data4] => Array
(
[log] => Array
(
[0] => SELECT COUNT(`extralaghi`.`aid`) AS `extralaghi.count` FROM `u53uf_chronoforms_data_rilievi-idrometrici-laghi-inserimento` AS `extralaghi`;
[1] => SELECT `extralaghi`.`aid` AS `extralaghi.aid`, `extralaghi`.`user_id` AS `extralaghi.user_id`, `extralaghi`.`created` AS `extralaghi.created`, `extralaghi`.`modified` AS `extralaghi.modified`, `extralaghi`.`data` AS `extralaghi.data`, `extralaghi`.`lago` AS `extralaghi.lago`, `extralaghi`.`idro` AS `extralaghi.idro`, `extralaghi`.`note` AS `extralaghi.note` FROM `u53uf_chronoforms_data_rilievi-idrometrici-laghi-inserimento` AS `extralaghi` ORDER BY `extralaghi.aid` DESC LIMIT 3;
)
[var] => Array
(
[0] => Array
(
[extralaghi] => Array
(
[aid] => 11408
[user_id] => 31
[created] => 2018-05-24 00:00:00
[modified] => 2018-06-12 02:19:56
[data] => 24/05/2018
[lago] => Lago di Iseo
[idro] => 108.5
[note] => aid
)
)
[1] => Array
(
[extralaghi] => Array
(
[aid] => 11407
[user_id] => 31
[created] => 2018-05-24 00:00:00
[modified] => 2018-06-12 02:19:56
[data] => 24/05/2018
[lago] => Lago di Como
[idro] => 63.3
[note] =>
)
)
[2] => Array
(
[extralaghi] => Array
(
[aid] => 11406
[user_id] => 31
[created] => 2018-05-23 00:00:00
[modified] => 2018-06-12 02:19:56
[data] => 25/05/2018
[lago] => Lago di Como
[idro] => 105.2
[note] => prova al 25 maggio
)
)
)
)
)
I need the debug from the submit event, not the load event.
Ok!🙂
Array
(
[chronoform] => rilievi-idrometrici-laghi-tabella
[event] => submit
[Model] => Array
(
[0] => Array
(
[data] => 24/05/2018
[lago] => Lago di Iseo
[idro] => 108.5
[aid] => 11408
[note] => aid
)
[1] => Array
(
[data] => 24/05/2018
[lago] => Lago di Como
[idro] => 63.3
[aid] => 11407
[note] =>
)
[2] => Array
(
[data] => 25/05/2018
[lago] => Lago di Como
[idro] => 105.2
[aid] => 11406
[note] => prova al 25 maggio
)
)
[data] => 13/06/2018
[lago] =>
[idro] =>
[note] =>
[button7] =>
[_ga] => GA1.2.371091234.1528460153
[78f1bfe75faa4fc86eec21112d3f6c0e] => 4rv98t0r6hbb79i47sn4qdfmb6
[adcf749bbd5f64903947be2e21155320] => oc45anqdcr5tsg5gnre4gcava1
[Itemid] => 117
[option] => com_chronoforms6
[view] => form
)
Array
(
[save_data11] => Array
(
[data] => Array
(
[data] => 25/05/2018
[lago] => Lago di Como
[idro] => 105.2
[aid] => 11406
[note] => prova al 25 maggio
[modified] => 2018-06-13 09:52:32
)
[_success] => Data saved successfully
[log] => Array
(
[0] => UPDATE `u53uf_chronoforms_data_rilievi-idrometrici-laghi-inserimento` AS `Data11` SET `data` = '25/05/2018', `lago` = 'Lago di Como', `idro` = '105.2', `note` = 'prova al 25 maggio ', `modified` = '2018-06-13 09:52:32' WHERE `aid` = '11406';
)
[var] => Array
(
[data] => 25/05/2018
[lago] => Lago di Como
[idro] => 105.2
[note] => prova al 25 maggio
[modified] => 2018-06-13 09:52:32
)
)
)
So what's happening, it updates existing entries but it doesn't insert new ones?
If that's the case try splitting it into 3 segments:
a read_data action that looks for an entry where aid:{var:loop_event14.row.aid}
In the FOUND event, have a save data set to UPDATE
In the NOT FOUND event, have a save data set to INSERT
If that's the case try splitting it into 3 segments:
a read_data action that looks for an entry where aid:{var:loop_event14.row.aid}
In the FOUND event, have a save data set to UPDATE
In the NOT FOUND event, have a save data set to INSERT
This topic is locked and no more replies can be posted.
