I need to know something about models in cf V7 and V8.
I have a piece of code with some value calculated with datas which are stored in a model named Carac_d model retrieved by a db read action. These calculated datas are not stored directly in the database because they have nothing to do in because they are calculated.
After the db read i use this code in a custom php action . but the datas are stored in another model and not in the same as the read db action.
Both models have the same name I need to use them and store them in the same model array to use the in a xlsx export action and in a email action .
When i use this code in an email action, i can use both of the field directly in the mail body.
But i need a xlsx export of these data as attachement. So i try to add these with a custom php action before the xlsx export to made them as columns.how to modify these lines to achieve this and store the datas in new fields in model Carac_d?
$this->data("Carac_d[$i].dev", $dev, true);
$this->set("Carac_d.dev", $dev, true);
$this->data("Carac_d[$i].nbplis", $nbplis, true);
$this->data("Carac_d.dev", $dev, true);I try with these lines but the values are stored in a new Carac_d array, not in the existing one, and i can't access them as columns in my export.
The piece of code i use to créate the data .
$uniqueRows = [];
$i = 0;
foreach ($this->get("Carac_d") as $row) {
$uniqueKey = $row['a'] . '_' . $row['b'] . '_' . $row['c'] . '_' . $row['d'] . '_' . $row['e'];
if (!isset($uniqueRows[$uniqueKey])) {
$uniqueRows[$uniqueKey] = $row;
$dev = $row['a'] + $row['b'] + $row['c'] + $row['d'] + $row['e'];
echo "dev = " . $dev;
$this->data("Carac_d.dev", $dev, true);
$this->set("Carac_d.dev", $dev, true);
$nbplis = 0;
if ($row['a'] != 0) {
$nbplis = $nbplis + 1;
}
if ($row['b'] != 0) {
$nbplis = $nbplis + 1;
}
if ($row['c'] != 0) {
$nbplis = $nbplis + 1;
}
if ($row['d'] != 0) {
$nbplis = $nbplis + 1;
}
if ($row['e'] != 0) {
$nbplis = $nbplis + 1;
}
$nbplis = $nbplis - 1;
echo "nbplis = " . $nbplis;
$i++;
}
}
I think this what you should use:
$this->data("Carac_d.$i.dev", $dev, true);Please try that and let me know
This doesnt semms to work the data are stroed in a carac_d array but not in the model of the db read.
I make a workaround in my case with a db save action in the previous page and a db in the page where i need these datas. I use the two db read actions as data source for my xslx export and in my email actions.
[Carac_d] => Array
(
[0] => Array
(
[ddev] => 1000
)
)
)
