Create a revision archive for field values - Revision history

Oblygre: Put in a check for date type so empty dates will be saved

2009-12-11T09:55:15Z

Put in a check for date type so empty dates will be saved

← Older revision		Revision as of 09:55, 11 December 2009
Line 52:		Line 52:
	$attrib=$this->getAttribute($revision_field);		$attrib=$this->getAttribute($revision_field);
	if (is_object($attrib)) { //Check that attribute exists		if (is_object($attrib)) { //Check that attribute exists
	if(!stripos(get_class($attrib),'~~manytoonerelation~~')) //~~onetomanyrelation~~ must be handled different		if(stripos(get_class($attrib),'date')) {//date must be handled different
	$~~save_revision_fields~~[$revision_field]=$attrib->display(array($revision_field=>$record[$revision_field]));		$value=$attrib->display(array($revision_field=>$record[$revision_field]),"view");
	~~else~~ {		$value_old=$attrib->display(array($revision_field=>$record['atkorgrec'][$revision_field]),"view");
			if ($value_old<>$value) {
			$save_revision_fields[$revision_field]=$value;
			}
			}
			elseif(stripos(get_class($attrib),'manytoonerelation')) {//onetomanyrelation must be handled different
	$value=$attrib->display(array($revision_field=>$record[$revision_field]),"view");		$value=$attrib->display(array($revision_field=>$record[$revision_field]),"view");
	$value_old=$attrib->display(array($revision_field=>$record['atkorgrec'][$revision_field]),"view");		$value_old=$attrib->display(array($revision_field=>$record['atkorgrec'][$revision_field]),"view");
	if ($value_old<>$value and array_merge($record['atkorgrec'][$revision_field],$record[$revision_field])<>$record['atkorgrec'][$revision_field]) {		if ($value_old<>$value and array_merge($record['atkorgrec'][$revision_field],$record[$revision_field])<>$record['atkorgrec'][$revision_field]) {
	$save_revision_fields[$revision_field]=$value; //If ~~equal~~ descriptor and ~~equal~~ PK's save		$save_revision_fields[$revision_field]=$value; //If different descriptor and different PK's save
	}		}
	}		}
			else {
			$save_revision_fields[$revision_field]=$attrib->display(array($revision_field=>$record[$revision_field]));
			}
	}		}
	}		}
Line 67:		Line 75:
	$this->updaterevision($record['atkprimkey'],$save_revision_fields);		$this->updaterevision($record['atkprimkey'],$save_revision_fields);
	}		}

	function updaterevision($rev_atkprimkey,$save_revision_fields) {		function updaterevision($rev_atkprimkey,$save_revision_fields) {
	global $g_user;		global $g_user;

Oblygre: Added a workaround for manytoonerelations so they are saved correct

2009-12-11T09:15:52Z

Added a workaround for manytoonerelations so they are saved correct

← Older revision		Revision as of 09:15, 11 December 2009
Line 29:		Line 29:
	$this->addFlag(NF_TRACK_CHANGES);		$this->addFlag(NF_TRACK_CHANGES);
	}		}

	function postUpdate($record)		function postUpdate($record)
	{		{
Line 36:		Line 37:
	return true;		return true;
	}		}

	function postAdd($record)		function postAdd($record)
	{		{
Line 43:		Line 45:
	return true;		return true;
	}		}
	function checkrevision($record)
	{		function checkrevision($record) {
	$save_revision_fields=array();		$save_revision_fields=array();
	foreach($this->m_revision_fields as $revision_field)		foreach($this->m_revision_fields as $revision_field) {
	if ($record[$revision_field]<>$record['atkorgrec'][$revision_field])		if ($record[$revision_field]<>$record['atkorgrec'][$revision_field]) {
	$save_revision_fields[$revision_field]=$record[$revision_field];		$attrib=$this->getAttribute($revision_field);
			if (is_object($attrib)) { //Check that attribute exists
			if(!stripos(get_class($attrib),'manytoonerelation')) //onetomanyrelation must be handled different
			$save_revision_fields[$revision_field]=$attrib->display(array($revision_field=>$record[$revision_field]));
			else {
			$value=$attrib->display(array($revision_field=>$record[$revision_field]),"view");
			$value_old=$attrib->display(array($revision_field=>$record['atkorgrec'][$revision_field]),"view");
			if ($value_old<>$value and array_merge($record['atkorgrec'][$revision_field],$record[$revision_field])<>$record['atkorgrec'][$revision_field]) {
			$save_revision_fields[$revision_field]=$value; //If equal descriptor and equal PK's save
			}
			}
			}
			}
			}
	if (count($save_revision_fields)>0)		if (count($save_revision_fields)>0)
	$this->updaterevision($record['atkprimkey'],$save_revision_fields);		$this->updaterevision($record['atkprimkey'],$save_revision_fields);
	~~$return;~~		}
	}
	function updaterevision($rev_atkprimkey,$save_revision_fields)		function updaterevision($rev_atkprimkey,$save_revision_fields) {
	{		global $g_user;
	$revnode=&atkGetNode("revision.revision");		$revnode=&atkGetNode("revision.revision");
	~~global $g_user;~~		$update_datetime=array('year'=>date('Y'),
	$update_datetime=array('year'=>date('Y'),
	'month'=>date('m'),		'month'=>date('m'),
	'day'=>date('d'),		'day'=>date('d'),
Line 63:		Line 77:
	'minutes'=>date('i'),		'minutes'=>date('i'),
	'seconds'=>date('s'));		'seconds'=>date('s'));
	$rev_atkprimkey=str_replace("'","",$rev_atkprimkey); ~~//due to problems with ' in urls~~		$rev_atkprimkey=str_replace("'",'',$rev_atkprimkey);
	foreach($save_revision_fields as $field=>$value) {		foreach($save_revision_fields as $field=>$value) {
	~~$attrib=$this->getAttribute($field);~~		$rec['rev_atkprimkey']=$rev_atkprimkey;
	~~$value=$attrib->display(array($field=>$value));~~		$rec['rev_table']=$this->m_table;
	$rec['rev_atkprimkey']=$rev_atkprimkey;		$rec['rev_field']=$field;
	$rec['rev_table']=$this->m_table;		$rec['rev_username']=$g_user["full_name"];
	$rec['rev_field']=$field;		$rec['rev_datetime']= $update_datetime;
	$rec['rev_username']=$g_user["full_name"];		$rec['rev_value']=$value;
	$rec['rev_datetime']= $update_datetime;		$revnode->addDb($rec);
	$rec['rev_value']=$value;		unset($rec);
	$revnode->addDb($rec);
	unset($rec);
	}
	}		}
	}		}
	</syntaxhighlight>		</syntaxhighlight>

	The revision node:		The revision node:

Oblygre at 13:04, 12 November 2009

2009-11-12T13:04:58Z

← Older revision		Revision as of 13:04, 12 November 2009
Line 2:		Line 2:

	Describes how to create a revision system so every change in selected fields in a node can be tracked.		Describes how to create a revision system so every change in selected fields in a node can be tracked.



	First create a table:		First create a table:

Oblygre at 13:04, 12 November 2009

2009-11-12T13:04:48Z

← Older revision		Revision as of 13:04, 12 November 2009
Line 2:		Line 2:

	Describes how to create a revision system so every change in selected fields in a node can be tracked.		Describes how to create a revision system so every change in selected fields in a node can be tracked.



	First create a table:		First create a table:

Oblygre: Removed a wrong } from the nodecode

2009-10-29T08:20:50Z

Removed a wrong } from the nodecode

← Older revision		Revision as of 08:20, 29 October 2009
Line 100:		Line 100:
	function rev_value_display($record,$mode) // Override the display function so the preformatted data is shown as saved in the database.		function rev_value_display($record,$mode) // Override the display function so the preformatted data is shown as saved in the database.
	{		{
	return $record['rev_value'];}		return $record['rev_value'];
	}		}
	}		}

Oblygre at 18:43, 28 October 2009

2009-10-28T18:43:44Z

← Older revision		Revision as of 18:43, 28 October 2009
Line 97:		Line 97:
	$this->setOrder("rev_table,rev_field,rev_datetime");		$this->setOrder("rev_table,rev_field,rev_datetime");
	$this->setTable("revision");		$this->setTable("revision");
			}
			function rev_value_display($record,$mode) // Override the display function so the preformatted data is shown as saved in the database.
			{
			return $record['rev_value'];}
	}		}
	}		}

bahtiar at 08:41, 10 April 2009

2009-04-10T08:41:40Z

← Older revision		Revision as of 08:41, 10 April 2009
Line 20:		Line 20:
	$this->m_revision_fields(array("field1","field"));		$this->m_revision_fields(array("field1","field"));
	Then every fieldchange in these fields will be saved to the database.		Then every fieldchange in these fields will be saved to the database.
	<~~code~~>		<syntaxhighlight lang="php">
	class watkNode extends atkNode {		class watkNode extends atkNode {
	var $m_revision_fields=array(); //Add fields from your node here to track changes		var $m_revision_fields=array(); //Add fields from your node here to track changes
Line 78:		Line 78:
	}		}
	}		}
	</~~code~~>		</syntaxhighlight>

	The revision node:		The revision node:

	<~~code~~>		<syntaxhighlight lang="php">
	useattrib("atkattribute");		useattrib("atkattribute");
	useattrib("atkdatetimeattribute");		useattrib("atkdatetimeattribute");
Line 99:		Line 99:
	}		}
	}		}
	</~~code~~>		</syntaxhighlight>

	What's missing here is a generic way of showing the different revisions.		What's missing here is a generic way of showing the different revisions.

Oblygre at 08:54, 19 February 2009

2009-02-19T08:54:29Z

← Older revision		Revision as of 08:54, 19 February 2009
Line 65:		Line 65:
	$rev_atkprimkey=str_replace("'","",$rev_atkprimkey); //due to problems with ' in urls		$rev_atkprimkey=str_replace("'","",$rev_atkprimkey); //due to problems with ' in urls
	foreach($save_revision_fields as $field=>$value) {		foreach($save_revision_fields as $field=>$value) {
	$rec['rev_atkprimkey']=$rev_atkprimkey;		$attrib=$this->getAttribute($field);
			$value=$attrib->display(array($field=>$value));
			$rec['rev_atkprimkey']=$rev_atkprimkey;
	$rec['rev_table']=$this->m_table;		$rec['rev_table']=$this->m_table;
	$rec['rev_field']=$field;		$rec['rev_field']=$field;

Oblygre at 21:31, 30 January 2009

2009-01-30T21:31:19Z

← Older revision		Revision as of 21:31, 30 January 2009
Line 16:		Line 16:
	</code>		</code>

	Then this baseclass instead of your usual atkNode.		Then use this baseclass instead of your usual atkNode.
	Add fields from your node to		Add fields from your node to
	$this->$m_revision_fields(array("field1","field"));		$this->m_revision_fields(array("field1","field"));
	Then every fieldchange in these fields ~~would~~ be saved to the database.		Then every fieldchange in these fields will be saved to the database.
	<code>		<code>
	class watkNode extends atkNode {		class watkNode extends atkNode {

Oblygre at 21:13, 30 January 2009

2009-01-30T21:13:14Z

← Older revision		Revision as of 21:13, 30 January 2009
Line 63:		Line 63:
	'minutes'=>date('i'),		'minutes'=>date('i'),
	'seconds'=>date('s'));		'seconds'=>date('s'));
	$rev_atkprimkey=str_replace("'",'',$rev_atkprimkey); //due to problems with ' in urls		$rev_atkprimkey=str_replace("'","",$rev_atkprimkey); //due to problems with ' in urls
	foreach($save_revision_fields as $field=>$value) {		foreach($save_revision_fields as $field=>$value) {
	$rec['rev_atkprimkey']=$rev_atkprimkey;		$rec['rev_atkprimkey']=$rev_atkprimkey;