Calculated Field example - Revision history

Saitta at 20:42, 25 August 2006

2006-08-25T20:42:09Z

← Older revision		Revision as of 20:42, 25 August 2006
Line 1:		Line 1:
	[[Category:ATK]]		[[Category:ATK Examples]]

	{{Examples\|basic\|[[Fabio Saitta]] <webmaster@saitta.it>}}		{{Examples\|basic\|[[Fabio Saitta]] <webmaster@saitta.it>}}

bahtiar: SpecialNodes moved to Calculated Field example

2006-08-25T06:04:20Z

SpecialNodes moved to Calculated Field example

← Older revision	Revision as of 06:04, 25 August 2006
(No difference)

Saitta at 21:45, 24 August 2006

2006-08-24T21:45:38Z

← Older revision		Revision as of 21:45, 24 August 2006
Line 1:		Line 1:
	[[Category:ATK]]		[[Category:ATK]]

	{{~~Howto~~\|basic\|[[Fabio Saitta]] <webmaster@saitta.it>}}		{{Examples\|basic\|[[Fabio Saitta]] <webmaster@saitta.it>}}

	Custom Calculated Field Sample		Custom Calculated Field Sample

Saitta at 21:43, 24 August 2006

2006-08-24T21:43:29Z

← Older revision		Revision as of 21:43, 24 August 2006
Line 1:		Line 1:
	[[Category:ATK]]		[[Category:ATK]]

	{{Howto\|basic\|[[Fabio Saitta]] <~~fabio~~@saitta.it>}}		{{Howto\|basic\|[[Fabio Saitta]] <webmaster@saitta.it>}}

	Custom Calculated Field Sample		Custom Calculated Field Sample

Saitta at 21:37, 24 August 2006

2006-08-24T21:37:57Z

← Older revision		Revision as of 21:37, 24 August 2006
Line 1:		Line 1:
	[[Category:ATK]]		[[Category:ATK]]

			{{Howto\|basic\|[[Fabio Saitta]] <fabio@saitta.it>}}

	Custom Calculated Field Sample		Custom Calculated Field Sample

Saitta at 08:15, 23 February 2006

2006-02-23T08:15:51Z

← Older revision		Revision as of 08:15, 23 February 2006
Line 3:		Line 3:
	Custom Calculated Field Sample		Custom Calculated Field Sample

	~~{code}~~		<pre>
	class fsMovAttribute extends atkAttribute		class fsMovAttribute extends atkAttribute
	{		{
Line 26:		Line 26:
	}		}
	}		}
	{/~~code}~~		</pre>

	You can define you Calculated field inside function __load__ the query is only for reference you can it as you need.		You can define you Calculated field inside function __load__ the query is only for reference you can it as you need.

	~~{code}~~		<pre>
	include_once (moduleDir("..Your Module here..")."class.YourClassHere.inc");		include_once (moduleDir("..Your Module here..")."class.YourClassHere.inc");

	$this->add(new __fsMovAttribute__("Rimanenza", AF_HIDE_ADD \| AF_READONLY));		$this->add(new __fsMovAttribute__("Rimanenza", AF_HIDE_ADD \| AF_READONLY));
	{/~~code}~~		</pre>

	Here is how to use a calculated field		Here is how to use a calculated field

Saitta at 08:10, 23 February 2006

2006-02-23T08:10:40Z

← Older revision		Revision as of 08:10, 23 February 2006
Line 1:		Line 1:
	^		[[Category:ATK]]

	Custom Calculated Field Sample		Custom Calculated Field Sample

	~~~~#FF0000:~~class fsMovAttribute extends atkAttribute~~		{code}
			class fsMovAttribute extends atkAttribute
	{		{
	function hasStore($mode) { Return True; }		function hasStore($mode) { Return True; }
Line 24:		Line 26:
	}		}
	}		}
	^		{/code}

	You can define you Calculated field inside function __load__ the query is only for reference you can it as you need.		You can define you Calculated field inside function __load__ the query is only for reference you can it as you need.

	^		{code}
	include_once (moduleDir("..Your Module here..")."class.YourClassHere.inc");		include_once (moduleDir("..Your Module here..")."class.YourClassHere.inc");

	$this->add(new __fsMovAttribute__("Rimanenza", AF_HIDE_ADD \| AF_READONLY));		$this->add(new __fsMovAttribute__("Rimanenza", AF_HIDE_ADD \| AF_READONLY));
	^		{/code}

	Here is how to use a calculated field		Here is how to use a calculated field

Saitta at 07:57, 23 February 2006

2006-02-23T07:57:51Z

New page

^
Custom Calculated Field Sample

~~#FF0000:class fsMovAttribute extends atkAttribute~~
{
function hasStore($mode) { Return True; }

function store($g_db, $record, $mode) { Return True; }

function load(&$db, $record)
{
$query = "select sum(importo) as totale from all_incassi where pagamento = ".$record["id"];
$raw = $db->getrows($query);
/*record found*/
if (count($raw)==1)
{
$tot=$raw[0]["totale"];
if ($record["Importo"]>$tot && $record["pagato"]==1)
$db->query("UPDATE all_movimenti SET pagato=0 WHERE id=".$record["id"]);
}
else
$tot=0;
return $record["Importo"]-$tot;
}
}
^

You can define you Calculated field inside function __load__ the query is only for reference you can it as you need.

^
include_once (moduleDir("..Your Module here..")."class.YourClassHere.inc");

$this->add(new __fsMovAttribute__("Rimanenza", AF_HIDE_ADD | AF_READONLY));
^

Here is how to use a calculated field