How to validate one element?s rows sum?

[jmdc]

Hello,

I would like to know if it?s possible to have a php validation in the sum of one element.

So, imagine i have one element Yes/NO, wich values are "1" or "0".
And i have 4 rows:
Row 1:0
Row 2:1
Row 3:0
Row 4:0

If user edit row 2 to No wich is "zero", my validation should say that?s not possible because the row?s sum of this element should always be > 0.

Could you help me?

Thanks you.

 

[jmdc]

Any idea, please?

Thank you!.

 

[troester]

You can add a php validation calculating the sum directly from the DB table.

 

[jmdc]

Do you have that code, please ?

Thank you in advance.

 

[troester]

http://fabrikar.com/forums/index.php?wiki/common-php-tasks/#select
So something like ...select('sum(your-element)')...

 

[jmdc]

I am writing this code, but it doesn?t work...what am i missing??

app = JFactory::getApplication();
$result = mysql_query('SELECT SUM(esc_familiasdet___DebitarFacturas_raw) AS value_sum FROM esc_familiasdet');
$row = mysql_fetch_assoc($result); $sum = $row['value_sum'];
if($sum == '0'){
return true;
}
else{
return false;
}

 

[jmdc]

I forgot something...i just want to validate this form for this row?s user who is submitting the form, and not all the data?s rows...

Could you help me?

Thanks.

 

[jmdc]

What should i have to put in "Condition" and in "PHP"???

Thank you.

 

[jmdc]

Could you help me, please?

Thank you.

 

[troester]

If you want to sum only user's records you have to add a WHERE condition.

Did you read the WIKI for how to select?

There are also WIKI entries for plugins
http://fabrikar.com/forums/index.php?wiki/php-validation/

 

[jmdc]

I have already read these wikis, but how can i sum these records like the sum button? What code to use and where do i have to put it? In "condition" or "php"?
thank you

 

[troester]

• Condition - A PHP expression which if returns false, means that the validation is not run.
• PHP -PHP code to run.
  • If it returns 'true' then the validation is successful,
  • if it returns false then the validation fails.
  • The element's submitted value is found in the variable $data.

 

[jmdc]

My problem is that i don?t know what code to put into Condition and PHP ? Could you help me,please?

Thank you.

 

[jmdc]

What code i have to put in php for a calc element if i want to sum all rows from one element A? If you help me, i can after that a validation like "greatorlessthan" in the other element B.

Thank you.

 

[cheesegrits]

We can't write custom code for people in Community support.

-- hugh

 

[jmdc]

Ok. Thank you.