Hello all
Im not experienced in Fabrik, php or mysql but im trying to do some joomla site based on Fabrik. So i have 2 tables and list Reports and workinghours. in first i have one value "hours" which is how many hours was spended and on the second table i have price for one hour in month/year.
What i need is to display based on list filter from first table Reports per month/year with calculations
price*hours with filter included and propably store this value in db for future use.
I have try:
$ilosc = '{Raporty___godzin}';
$wartosc = '{roboczogodziny___wartosc_rg}';
$wynik = ($losc*$wartosc);
return (int)$wynik;
where "roboczogodziny" is the second table
My calculation element works only for one table and i don't know how to get values from second table based on filter applyed?
Sorry for my english...
Im not experienced in Fabrik, php or mysql but im trying to do some joomla site based on Fabrik. So i have 2 tables and list Reports and workinghours. in first i have one value "hours" which is how many hours was spended and on the second table i have price for one hour in month/year.
What i need is to display based on list filter from first table Reports per month/year with calculations
price*hours with filter included and propably store this value in db for future use.
I have try:
$ilosc = '{Raporty___godzin}';
$wartosc = '{roboczogodziny___wartosc_rg}';
$wynik = ($losc*$wartosc);
return (int)$wynik;
where "roboczogodziny" is the second table
My calculation element works only for one table and i don't know how to get values from second table based on filter applyed?
Sorry for my english...