34 lines
973 B
JavaScript
34 lines
973 B
JavaScript
// last execution: Fri Nov 06 2020 14:11:17 GMT+0100 (Midden-Europese standaardtijd)
|
|
|
|
$year = 2019;
|
|
|
|
logAdd(log);
|
|
|
|
$t_rows = record\fetchManyHash('Nascholingstotaal',
|
|
'id, jaar, contactName, dagenHomeopathie, dagen',
|
|
'jaar', 'asc',
|
|
'jaar<=', $year
|
|
);
|
|
|
|
$n = array\length($t_rows);
|
|
$i = 0;
|
|
while($i < $n,
|
|
$row = array\at($t_rows, $i);
|
|
|
|
$id = hash\get($row, 'id');
|
|
$jaar = hash\get($row, 'jaar');
|
|
$name = hash\get($row, 'contactName');
|
|
$hom = hash\get($row, 'dagenHomeopathie');
|
|
$dg = hash\get($row, 'dagen');
|
|
|
|
logAdd(log, 'id=', $id, ', jaar=', $jaar, ', naam=', $name, ', homeopathie=', $hom, ', overig=', $dg);
|
|
|
|
ifThen($hom <= 0,
|
|
$hom = $dg;
|
|
$dg = 0;
|
|
record\update('Nascholingstotaal', $id, 'dagenHomeopathie', $hom, 'dagen', $dg);
|
|
);
|
|
|
|
$i = $i + 1;
|
|
);
|