Basic HTML reports - Revision history

Rwolverine: /* getMyReport function */

2008-06-10T14:04:31Z

getMyReport function

← Older revision		Revision as of 14:04, 10 June 2008
Line 42:		Line 42:
	== getMyReport function ==		== getMyReport function ==
	<syntaxhighlight lang="php">		<syntaxhighlight lang="php">
	function ~~getproductiontallyreport~~()		function getMyReport()
	{		{
	// Get a reference to the sessionmanager		// Get a reference to the sessionmanager

Rwolverine: /* getMyReport function */

2008-06-10T14:03:49Z

getMyReport function

← Older revision		Revision as of 14:03, 10 June 2008
Line 69:		Line 69:
	// access section to get your data out and then just format		// access section to get your data out and then just format
	// standard html to output with		// standard html to output with
	}
	// Render a box around the generated output		// Render a box around the generated output
	$boxedoutput = $ui->renderBox(array("title"=>$this->actionTitle('ProductionTallySheet'), "content"=>$output));		$boxedoutput = $ui->renderBox(array("title"=>$this->actionTitle('ProductionTallySheet'), "content"=>$output));

bahtiar: /* action_report code */

2008-02-10T16:37:21Z

action_report code

← Older revision		Revision as of 16:37, 10 February 2008
Line 32:		Line 32:
	// Add the given content to the page		// Add the given content to the page
	$page = &$this->getPage();		$page = &$this->getPage();
	$page->addContent($this->renderActionPage("~~admin~~", $content));		$page->addContent($this->renderActionPage("report", $content));
	}		}
	</syntaxhighlight>		</syntaxhighlight>

bahtiar: /* Conclusion */

2008-02-10T16:37:07Z

Conclusion

← Older revision		Revision as of 16:37, 10 February 2008
Line 162:		Line 162:
	= Conclusion =		= Conclusion =
	There are many things that can be expanded upon here but this is the basic skeleton method borrowed from Achievo examples.		There are many things that can be expanded upon here but this is the basic skeleton method borrowed from Achievo examples.

			You may also want to have a look at [[atkBaseReport]]. It's a predefined class containing some of the constructs mentioned above.

bahtiar: /* Code tied together */ no duplication, that makes it harder to edit

2008-02-10T16:36:03Z

Code tied together: no duplication, that makes it harder to edit

← Older revision		Revision as of 16:36, 10 February 2008
Line 162:		Line 162:
	= Conclusion =		= Conclusion =
	There are many things that can be expanded upon here but this is the basic skeleton method borrowed from Achievo examples.		There are many things that can be expanded upon here but this is the basic skeleton method borrowed from Achievo examples.

	~~== Code tied together ==~~
	~~Here's the code all together:~~
	~~<syntaxhighlight lang="php">~~
	~~class myReport extends atkNode~~
	{
	~~function myReport ()~~
	{
	~~$this->atkNode("myReport");~~
	}


	~~function action_report()~~
	{
	~~// Here is the meat of the report and where everything happens~~
	~~$content = $this->getMyReport();~~

	~~// Add the given content to the page~~
	~~$page = &$this->getPage();~~
	~~$page->addContent($this->renderActionPage("admin", $content));~~
	}

	~~function getproductiontallyreport()~~
	{
	~~// Get a reference to the sessionmanager~~
	~~global $g_sessionManager;~~

	~~$this->addStyle("style.css");~~

	~~// Try to get a reference to the User Interface object and raise an error if it fails~~
	~~$ui = &$this->getUi();~~

	~~// Add a newline (vertical spacing)~~
	~~$output.= '<br/>';~~
	~~$go = $g_sessionManager->pageVar("go");~~

	~~//use this to show the filter screen first, and the report second. $go get's set as a hidden filed in the getFilterBar function.~~
	~~if ($go != 1)~~
	{
	~~// Start composing the output by adding the filterbar as topmost item~~
	~~$output = $this->getFilterBar();~~
	~~$output.= '<br/>';~~

	~~} else {~~
	~~//Reporting code goes here, use techniques learned in the db access section to get your data out and then just format standard html to output with~~
	}
	~~// Render a box around the generated output~~
	~~$boxedoutput = $ui->renderBox(array("title"=>$this->actionTitle('ProductionTallySheet'), "content"=>$output));~~

	~~// Return the generated boxed output~~
	~~return $boxedoutput;~~
	}

	~~function getfilterbar()~~
	{
	~~//get data to filter based on constraints for the report.~~
	~~$record = $this->getFilterRecord();~~

	~~//get the filter attributes~~
	~~$attrs = &$this->getFilterAttrs();~~

	~~$output = '<form action="dispatch.php" method="get">';~~
	~~$output.= session_form();~~
	~~$output.= '<input type="hidden" name="go" value="1">'; //trigger to prevent loading the first time~~
	~~$output.= atktext("Date","production").' '.$attrs["date"]->edit($record);~~
	~~$output.= '<br>';~~
	~~$output.= atktext("name").": ".$attrs["name"]->edit($record)." ";~~
	~~$output.= '<br>';~~
	~~$output.= atktext("shift").": ".$attrs["shift"]->edit($record)." ";~~

	~~$output.= ' <input type="submit" value="'.atktext("refresh").'">';~~
	~~$output.= '</form>';~~
	~~return $output;~~
	}

	~~function &getFilterAttrs()~~
	{
	~~userelation("atkmanytoonerelation");~~
	~~useattrib("atkradioattribute");~~
	~~$attrs["name"] = &new atkManyToOneRelation("name", "access.users");~~
	~~//$attrs["name"]->setNoneLabel("Do not filter");~~
	~~$attrs["shift"] = &new atkRadioAttribute("shift", array("1 ST","2 ND","3 RD"), array("1 ST","2 ND","3 RD"));~~
	~~$attrs["date"] = &new atkDateAttribute("date");~~
	~~return $attrs;~~
	}

	~~function getFilterRecord()~~
	{
	~~static $s_record = NULL;~~
	~~global $g_sessionManager;~~

	~~if ($s_record==NULL)~~
	{
	~~$s_record = array();~~
	~~$s_record["name"] = $g_sessionManager->pageVar("name");~~
	~~$s_record["shift"] = $g_sessionManager->pageVar("shift");~~
	~~$s_record["date"] = $g_sessionManager->pageVar("date");~~

	~~$attrs = &$this->getFilterAttrs();~~
	~~foreach (array_keys($attrs) as $attribname)~~
	{
	~~$p_attrib = &$attrs[$attribname];~~
	~~$s_record[$attribname] = &$p_attrib->fetchValue($s_record);~~
	}

	~~$go = $g_sessionManager->pageVar("go");~~
	~~if ($go != 1)~~
	{
	~~//initial loading.~~
	~~//set name to current logged in person~~
	~~$user = getUser();~~
	~~$s_record["name"] = array("id"=>$user["id"]);~~
	~~//We'll put the to to todays date~~
	~~$s_record["date"] = date("Ymd");~~
	}
	}
	~~return $s_record;~~
	}
	}
	~~</syntaxhighlight>~~

bahtiar: /* getFilterAttrs */

2008-02-10T16:35:18Z

getFilterAttrs

← Older revision		Revision as of 16:35, 10 February 2008
Line 147:		Line 147:
	Get the attribute info for the fields you're going to use to sort/filter on so they render normaly on the screen.		Get the attribute info for the fields you're going to use to sort/filter on so they render normaly on the screen.
	<syntaxhighlight lang="php">		<syntaxhighlight lang="php">
	function &getFilterAttrs()		function &getFilterAttrs()
	{		{
	userelation("atkmanytoonerelation");		userelation("atkmanytoonerelation");
	useattrib("atkradioattribute");		useattrib("atkradioattribute");
	$attrs["name"] = &new atkManyToOneRelation("name", "access.users");		$attrs["name"] = &new atkManyToOneRelation("name", "access.users");
	//$attrs["name"]->setNoneLabel("Do not filter");		//$attrs["name"]->setNoneLabel("Do not filter");
	$attrs["shift"] = &new atkRadioAttribute("shift", array("1 ST","2 ND","3 RD"), array("1 ST","2 ND","3 RD"));		$attrs["shift"] = &new atkRadioAttribute("shift", array("1 ST","2 ND","3 RD"), array("1 ST","2 ND","3 RD"));
	$attrs["date"] = &new atkDateAttribute("date");		$attrs["date"] = &new atkDateAttribute("date");
	return $attrs;
	}		return $attrs;
			}
	</syntaxhighlight>		</syntaxhighlight>

bahtiar: /* getFilterRecord */

2008-02-10T16:34:22Z

getFilterRecord

← Older revision		Revision as of 16:34, 10 February 2008
Line 108:		Line 108:
	Grab the data to be filtered/sorted on		Grab the data to be filtered/sorted on
	<syntaxhighlight lang="php">		<syntaxhighlight lang="php">
	function getFilterRecord()		function getFilterRecord()
	{		{
	static $s_record = NULL;		static $s_record = NULL;
	~~global~~ $~~g_sessionManager~~;
			$sessionManager = atkGetSessionManager();

	if ($s_record==NULL)		if ($s_record==NULL)
	{		{
	$s_record = array();		$s_record = array();
	$s_record["name"] = $~~g_sessionManager~~->pageVar("name");		$s_record["name"] = $sessionManager->pageVar("name");
	$s_record["shift"] = $~~g_sessionManager~~->pageVar("shift");		$s_record["shift"] = $sessionManager->pageVar("shift");
	$s_record["date"] = $g_sessionManager->pageVar("date");		$s_record["date"] = $g_sessionManager->pageVar("date");

	$attrs = &$this->getFilterAttrs();		$attrs = &$this->getFilterAttrs();
	foreach (array_keys($attrs) as $attribname)		foreach (array_keys($attrs) as $attribname)
	{		{
	$p_attrib = &$attrs[$attribname];		$p_attrib = &$attrs[$attribname];
	$s_record[$attribname] = &$p_attrib->fetchValue($s_record);		$s_record[$attribname] = &$p_attrib->fetchValue($s_record);
	}		}

	$go = $~~g_sessionManager~~->pageVar("go");		$go = $sessionManager->pageVar("go");
	if ($go != 1)		if ($go != 1)
	{		{
	//initial loading.		// initial loading.
	//set name to current logged in person		//set name to current logged in person
	$user = getUser();		$user = getUser();
	$s_record["name"] = array("id"=>$user["id"]);		$s_record["name"] = array("id"=>$user["id"]);
	//We'll put the to to todays date
	$s_record["date"] = date("Ymd");		// We'll put the to to todays date
	}		$s_record["date"] = date("Ymd");
	}		}
	return $s_record;		}
	}		return $s_record;
			}
	</syntaxhighlight>		</syntaxhighlight>

bahtiar: /* getFilterBar function */

2008-02-10T16:31:43Z

getFilterBar function

← Older revision		Revision as of 16:31, 10 February 2008
Line 82:		Line 82:
	In this function you can build the filter form.		In this function you can build the filter form.
	<syntaxhighlight lang="php">		<syntaxhighlight lang="php">
	function getfilterbar()		function getfilterbar()
	{		{
	//get data to filter based on constraints for the report.		// get data to filter based on constraints for the report.
	$record = $this->getFilterRecord();		$record = $this->getFilterRecord();

	//get the filter attributes		//get the filter attributes
	$attrs = &$this->getFilterAttrs();		$attrs = &$this->getFilterAttrs();

	$output = '<form action="dispatch.php" method="get">';		$output = '<form action="dispatch.php" method="get">';
	$output.= ~~session_form~~();		$output.= atkSessionManager::formState();
	$output.= '<input type="hidden" name="go" value="1">'; //trigger to prevent loading the first time		$output.= '<input type="hidden" name="go" value="1">'; //trigger to prevent loading the first time
	$output.= atktext("Date","production").' '.$attrs["date"]->edit($record);		$output.= atktext("Date","production").' '.$attrs["date"]->edit($record);
	$output.= '<br>';		$output.= '<br>';
	$output.= atktext("name").": ".$attrs["name"]->edit($record)." ";		$output.= atktext("name").": ".$attrs["name"]->edit($record)." ";
	$output.= '<br>';		$output.= '<br>';
	$output.= atktext("shift").": ".$attrs["shift"]->edit($record)." ";		$output.= atktext("shift").": ".$attrs["shift"]->edit($record)." ";

	$output.= ' <input type="submit" value="'.atktext("refresh").'">';		$output.= ' <input type="submit" value="'.atktext("refresh").'">';
	$output.= '</form>';		$output.= '</form>';
	return $output;		return $output;
	}		}
	</syntaxhighlight>		</syntaxhighlight>

bahtiar: /* getMyReport function */

2008-02-10T16:29:29Z

getMyReport function

← Older revision		Revision as of 16:29, 10 February 2008
Line 42:		Line 42:
	== getMyReport function ==		== getMyReport function ==
	<syntaxhighlight lang="php">		<syntaxhighlight lang="php">
	function getproductiontallyreport()		function getproductiontallyreport()
	{		{
	// Get a reference to the sessionmanager		// Get a reference to the sessionmanager
	global $~~g_sessionManager~~;		global $sessionManager = &atkGetSessionManager();

	$this->addStyle("style.css");		$this->addStyle("style.css");

	// Try to get a reference to the User Interface object and raise an error if it fails		// Try to get a reference to the User Interface object and raise an error if it fails
	$ui = &$this->getUi();		$ui = &$this->getUi();

	// Add a newline (vertical spacing)		// Add a newline (vertical spacing)
	$output.= '<br/>';		$output.= '<br/>';
	$go = $~~g_sessionManager~~->pageVar("go");		$go = $sessionManager->pageVar("go");

	//use this to show the filter screen first, and the report second. $go ~~get's~~ set as a hidden ~~filed~~ in the getFilterBar function.		//use this to show the filter screen first, and the report second.
	if ($go != 1)		// $go gets set as a hidden field in the getFilterBar function.
	{		if ($go != 1)
	// Start composing the output by adding the filterbar as topmost item		{
	$output = $this->getFilterBar();		// Start composing the output by adding the filterbar as topmost item
	$output.= '<br/>';		$output = $this->getFilterBar();
			$output.= '<br/>';
	} else {		}
	//Reporting code goes here, use techniques learned in the db access section to get your data out and then just format standard html to output with		else
			{
			// Reporting code goes here, use techniques learned in the db
			// access section to get your data out and then just format
			// standard html to output with
	}		}
	// Render a box around the generated output		// Render a box around the generated output
	$boxedoutput = $ui->renderBox(array("title"=>$this->actionTitle('ProductionTallySheet'), "content"=>$output));		$boxedoutput = $ui->renderBox(array("title"=>$this->actionTitle('ProductionTallySheet'), "content"=>$output));

	// Return the generated boxed output		// Return the generated boxed output
	return $boxedoutput;		return $boxedoutput;
	}		}
			}
	</syntaxhighlight>		</syntaxhighlight>

Rwolverine: /* Main report code */

2008-02-08T18:54:28Z

Main report code

← Older revision		Revision as of 18:54, 8 February 2008
Line 37:		Line 37:
	Here we use a function to manage everything called getMyReport();		Here we use a function to manage everything called getMyReport();

	= Main ~~report~~ code =		= Main Report code =
	~~All of~~ the ~~action~~ and the ~~rest of the stuff stems from~~ here:		As stated above this is where the the report is generated and presented, also the sorting/filtering choices are presented/configured here as well.

	== getMyReport function ==		== getMyReport function ==