From 7fe908c50c8dbc5cc05f571dbe11d66141caacd4 Mon Sep 17 00:00:00 2001
From: Marius Cramer <m.cramer@pixcept.de>
Date: Thu, 14 Nov 2013 09:01:22 -0500
Subject: [PATCH] Cleaning up code to match coding guidelines

---
 interface/lib/classes/tform_actions.inc.php | 1048 +++++++++++++++++++++++++++++----------------------------
 1 files changed, 528 insertions(+), 520 deletions(-)

diff --git a/interface/lib/classes/tform_actions.inc.php b/interface/lib/classes/tform_actions.inc.php
index 4db3157..336d2fb 100644
--- a/interface/lib/classes/tform_actions.inc.php
+++ b/interface/lib/classes/tform_actions.inc.php
@@ -30,570 +30,578 @@
 
 class tform_actions {
 
-        public $id;
-        public $activeTab;
-        public $dataRecord;
-        public $plugins = array();
-		public $oldDataRecord; // This array is only filled during updates and when db_history is enabled.
+	public $id;
+	public $activeTab;
+	public $dataRecord;
+	public $plugins = array();
+	public $oldDataRecord; // This array is only filled during updates and when db_history is enabled.
 
-        function onLoad() {
-                global $app, $conf, $tform_def_file;
+	function onLoad() {
+		global $app, $conf, $tform_def_file;
 
-                // Loading template classes and initialize template
-                if(!is_object($app->tpl)) $app->uses('tpl');
-                if(!is_object($app->tform)) $app->uses('tform');
+		// Loading template classes and initialize template
+		if(!is_object($app->tpl)) $app->uses('tpl');
+		if(!is_object($app->tform)) $app->uses('tform');
 
-                $app->tpl->newTemplate("tabbed_form.tpl.htm");
+		$app->tpl->newTemplate("tabbed_form.tpl.htm");
 
-                // Load table definition from file
-                $app->tform->loadFormDef($tform_def_file);
-				
-				// Importing ID
-                $this->id = (isset($_REQUEST["id"]))?$app->functions->intval($_REQUEST["id"]):0;
-				
-				// show print version of the form
-				if(isset($_GET["print_form"]) && $_GET["print_form"] == 1) {
-					die('Function disabled.');
-					$this->onPrintForm();
-				}
-				
-				// send this form by email
-				if(isset($_GET["send_form_by_mail"]) && $_GET["send_form_by_mail"] == 1) {
-					die('Function disabled.');
-					$this->onMailSendForm();
-				}
+		// Load table definition from file
+		$app->tform->loadFormDef($tform_def_file);
 
-                if(count($_POST) > 1) {
-                        $this->dataRecord = $_POST;
-                        $this->onSubmit();
-                } else {
-                        $this->onShow();
-                }
-        }
+		// Importing ID
+		$this->id = (isset($_REQUEST["id"]))?$app->functions->intval($_REQUEST["id"]):0;
 
-        /**
-        * Function called on page submit
-        */
+		// show print version of the form
+		if(isset($_GET["print_form"]) && $_GET["print_form"] == 1) {
+			die('Function disabled.');
+			$this->onPrintForm();
+		}
 
-        function onSubmit() {
-                global $app, $conf;
-                
-                // check if the client is locked - he may not change anything, then.
-				if(!$app->auth->is_admin()) {
-					$client_group_id = $_SESSION["s"]["user"]["default_group"];
-					$client = $app->db->queryOneRecord("SELECT client.locked FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = ".$app->functions->intval($client_group_id));
-					if(is_array($client) && $client['locked'] == 'y') {
-						$app->tform->errorMessage .= $app->lng("client_you_are_locked")."<br />";
-					}
-				}
-                
-                // Calling the action functions
-                if($this->id > 0) {
-					$app->tform->action == 'EDIT';
-					$this->onUpdate();
-                } else {
-					$app->tform->action == 'NEW';
-					$this->onInsert();
-                }
-        }
+		// send this form by email
+		if(isset($_GET["send_form_by_mail"]) && $_GET["send_form_by_mail"] == 1) {
+			die('Function disabled.');
+			$this->onMailSendForm();
+		}
 
-        /**
-        * Function called on data update
-        */
+		if(count($_POST) > 1) {
+			$this->dataRecord = $_POST;
+			$this->onSubmit();
+		} else {
+			$this->onShow();
+		}
+	}
 
-        function onUpdate() {
-                global $app, $conf;
-				
-				$this->onBeforeUpdate();
-				
-                $ext_where = '';
-                $sql = $app->tform->getSQL($this->dataRecord,$app->tform->getCurrentTab(),'UPDATE',$this->id,$ext_where);
-                if($app->tform->errorMessage == '') {
-						
-						if($app->tform->formDef['db_history'] == 'yes') {
-							$this->oldDataRecord = $app->tform->getDataRecord($this->id);
-						}
-						
-						// Save record in database
-						$this->onUpdateSave($sql);
-						$app->plugin->raiseEvent($_SESSION['s']['module']['name'].':'.$app->tform->formDef['name'].':'.'on_update_save',array('page_form'=>$this, 'sql'=>$sql));
-                        
-						// loading plugins
-						$next_tab = $app->tform->getCurrentTab();
-                		$this->loadPlugins($next_tab);
+	/**
+	 * Function called on page submit
+	 */
 
-                        // Call plugin
-                        foreach($this->plugins as $plugin) {
-                                $plugin->onUpdate();
-                        }
-						
-						$this->onAfterUpdate();
-						$app->plugin->raiseEvent($_SESSION['s']['module']['name'].':'.$app->tform->formDef['name'].':'.'on_after_update',$this);
-						
-						// Write data history (sys_datalog)
-						if($app->tform->formDef['db_history'] == 'yes') {
-							$new_data_record = $app->tform->getDataRecord($this->id);
-							$app->tform->datalogSave('UPDATE',$this->id,$this->oldDataRecord,$new_data_record);
-							unset($new_data_record);
-							unset($old_data_record);
-						}
 
-                        if($_REQUEST["next_tab"] == '') {
-                           $list_name = $_SESSION["s"]["form"]["return_to"];
-						   // When a list is embedded inside of a form
-						   
-                           //if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_id"] != $this->id && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {
-						   if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {
-                                $redirect = "Location: ".$_SESSION["s"]["list"][$list_name]["parent_script"]."?id=".$_SESSION["s"]["list"][$list_name]["parent_id"]."&next_tab=".$_SESSION["s"]["list"][$list_name]["parent_tab"];
-                                $_SESSION["s"]["form"]["return_to"] = '';
-                                session_write_close();
-                                header($redirect);
-							// When a returnto variable is set
-							} elseif (isset($_SESSION["s"]["form"]["return_to_url"]) && $_SESSION["s"]["form"]["return_to_url"] != '') {
-								$redirect = $_SESSION["s"]["form"]["return_to_url"];
-								$_SESSION["s"]["form"]["return_to_url"] = '';
-								session_write_close();
-								header("Location: ".$redirect);
-								exit;
-								// Use the default list of the form
-                        	} else {
-                            	header("Location: ".$app->tform->formDef['list_default']);
-                        	}
-                        	exit;
-                    	} else {
-                                $this->onShow();
-                        }
-                } else {
-                        $this->onError();
-                }
-        }
-		
-		/*
-		 Save record in database
-		*/
-		
-		function onUpdateSave($sql) {
-			global $app;
-			if(!empty($sql) && !$app->tform->isReadonlyTab($app->tform->getCurrentTab(),$this->id)) {
-				$app->db->query($sql);
-				if($app->db->errorMessage != '') die($app->db->errorMessage);
+	function onSubmit() {
+		global $app, $conf;
+
+		// check if the client is locked - he may not change anything, then.
+		if(!$app->auth->is_admin()) {
+			$client_group_id = $_SESSION["s"]["user"]["default_group"];
+			$client = $app->db->queryOneRecord("SELECT client.locked FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = ".$app->functions->intval($client_group_id));
+			if(is_array($client) && $client['locked'] == 'y') {
+				$app->tform->errorMessage .= $app->lng("client_you_are_locked")."<br />";
 			}
 		}
-		
 
-        /**
-        * Function called on data insert
-        */
-
-        function onInsert() {
-                global $app, $conf;
-				
-				$this->onBeforeInsert();
-
-                $ext_where = '';
-                $sql = $app->tform->getSQL($this->dataRecord,$app->tform->getCurrentTab(),'INSERT',$this->id,$ext_where);
-                if($app->tform->errorMessage == '') {
-						
-						$this->id = $this->onInsertSave($sql);
-						$app->plugin->raiseEvent($_SESSION['s']['module']['name'].':'.$app->tform->formDef['name'].':'.'on_insert_save',array('page_form'=>$this, 'sql'=>$sql));
-                        
-						// loading plugins
-						$next_tab = $app->tform->getCurrentTab();
-                		$this->loadPlugins($next_tab);
-						
-                        // Call plugin
-                        foreach($this->plugins as $plugin) {
-                                $plugin->onInsert();
-                        }
-
-                        $this->onAfterInsert();
-						$app->plugin->raiseEvent($_SESSION['s']['module']['name'].':'.$app->tform->formDef['name'].':'.'on_after_insert',$this);
-
-						// Write data history (sys_datalog)
-						if($app->tform->formDef['db_history'] == 'yes') {
-							$new_data_record = $app->tform->getDataRecord($this->id);
-							$app->tform->datalogSave('INSERT',$this->id,array(),$new_data_record);
-							unset($new_data_record);
-						}
-						
-
-                     if($_REQUEST["next_tab"] == '') {
-                         $list_name = $_SESSION["s"]["form"]["return_to"];
-                         // if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_id"] != $this->id && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {
-						 if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {
-                            $redirect = "Location: ".$_SESSION["s"]["list"][$list_name]["parent_script"]."?id=".$_SESSION["s"]["list"][$list_name]["parent_id"]."&next_tab=".$_SESSION["s"]["list"][$list_name]["parent_tab"];
-                            $_SESSION["s"]["form"]["return_to"] = '';
-                            session_write_close();
-                            header($redirect);
-							exit;
-                        } elseif ($_SESSION["s"]["form"]["return_to_url"] != '') {
-							$redirect = $_SESSION["s"]["form"]["return_to_url"];
-							$_SESSION["s"]["form"]["return_to_url"] = '';
-							session_write_close();
-							header("Location: ".$redirect);
-							exit;
-						} else {
-                                header("Location: ".$app->tform->formDef['list_default']);
-                        }
-                        exit;
-                    } else {
-                            $this->onShow();
-                        }
-                } else {
-                        $this->onError();
-                }
-        }
-		
-		/*
-		 Save record in database
-		*/
-		
-		function onInsertSave($sql) {
-			global $app, $conf;
-			$app->db->query($sql);
-            if($app->db->errorMessage != '') die($app->db->errorMessage);
-            return $app->db->insertID();
+		// Calling the action functions
+		if($this->id > 0) {
+			$app->tform->action == 'EDIT';
+			$this->onUpdate();
+		} else {
+			$app->tform->action == 'NEW';
+			$this->onInsert();
 		}
-
-        function onBeforeUpdate() {
-            global $app, $conf;
-        }
-
-        function onBeforeInsert() {
-            global $app, $conf;
-        }
-		
-		function onAfterUpdate() {
-            global $app, $conf;
-        }
-
-        function onAfterInsert() {
-            global $app, $conf;
-        }
+	}
 
 
-        /**
-        * Function called on data insert or update error
-        */
+	/**
+	 * Function called on data update
+	 */
+	function onUpdate() {
+		global $app, $conf;
 
-        function onError() {
-                global $app, $conf;
+		$this->onBeforeUpdate();
 
-                $app->tpl->setVar("error","<li>".$app->tform->errorMessage."</li>");
-                $app->tpl->setVar($this->dataRecord);
-                $this->onShow();
-        }
+		$ext_where = '';
+		$sql = $app->tform->getSQL($this->dataRecord, $app->tform->getCurrentTab(), 'UPDATE', $this->id, $ext_where);
+		if($app->tform->errorMessage == '') {
 
-        /**
-        * Function called on data delete
-        */
+			if($app->tform->formDef['db_history'] == 'yes') {
+				$this->oldDataRecord = $app->tform->getDataRecord($this->id);
+			}
 
-        function onDelete() {
-                global $app, $conf,$list_def_file,$tform_def_file;
+			// Save record in database
+			$this->onUpdateSave($sql);
+			$app->plugin->raiseEvent($_SESSION['s']['module']['name'].':'.$app->tform->formDef['name'].':'.'on_update_save', array('page_form'=>$this, 'sql'=>$sql));
 
-                include_once($list_def_file);
+			// loading plugins
+			$next_tab = $app->tform->getCurrentTab();
+			$this->loadPlugins($next_tab);
 
-                // Loading tform framework
-                if(!is_object($app->tform)) $app->uses('tform');
+			// Call plugin
+			foreach($this->plugins as $plugin) {
+				$plugin->onUpdate();
+			}
 
-                // Load table definition from file
-                $app->tform->loadFormDef($tform_def_file);
+			$this->onAfterUpdate();
+			$app->plugin->raiseEvent($_SESSION['s']['module']['name'].':'.$app->tform->formDef['name'].':'.'on_after_update', $this);
 
-                // importing ID
-                $this->id = $app->functions->intval($_REQUEST["id"]);
+			// Write data history (sys_datalog)
+			if($app->tform->formDef['db_history'] == 'yes') {
+				$new_data_record = $app->tform->getDataRecord($this->id);
+				$app->tform->datalogSave('UPDATE', $this->id, $this->oldDataRecord, $new_data_record);
+				unset($new_data_record);
+				unset($old_data_record);
+			}
 
-                if($this->id > 0) {
+			if($_REQUEST["next_tab"] == '') {
+				$list_name = $_SESSION["s"]["form"]["return_to"];
+				// When a list is embedded inside of a form
 
-                        // checking permissions
-                        if($app->tform->formDef['auth'] == 'yes' && $_SESSION["s"]["user"]["typ"] != 'admin') {
-                                if($app->tform->checkPerm($this->id,'d') == false) $app->error($app->lng('error_no_delete_permission'));
-                        }
-
-                        //$this->dataRecord = $app->db->queryOneRecord("SELECT * FROM ".$liste["table"]." WHERE ".$liste["table_idx"]." = ".$this->id);
-						$this->dataRecord = $app->tform->getDataRecord($this->id);
-						
-						$this->onBeforeDelete();
-						$app->plugin->raiseEvent($_SESSION['s']['module']['name'].':'.$app->tform->formDef['name'].':'.'on_before_delete',$this);
-						
-                        // Saving record to datalog when db_history enabled
-                        if($app->tform->formDef["db_history"] == 'yes') {
-							//$old_data_record = $app->tform->getDataRecord($this->id);
-							$app->tform->datalogSave('DELETE',$this->id,$this->dataRecord,array());
-                        }
-
-                        $app->db->query("DELETE FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." LIMIT 1");
-						
-						
-						// loading plugins
-						$next_tab = $app->tform->getCurrentTab();
-                		$this->loadPlugins($next_tab);
-						
-                	
-                        // Call plugin
-                        foreach($this->plugins as $plugin) {
-                                $plugin->onDelete();
-                        }
-						
-						$this->onAfterDelete();
-						$app->plugin->raiseEvent($_SESSION['s']['module']['name'].':'.$app->tform->formDef['name'].':'.'on_after_delete',$this);
-                }
-
-                		//header("Location: ".$liste["file"]."?PHPSESSID=".$_SESSION["s"]["id"]);
-                 $list_name = $_SESSION["s"]["form"]["return_to"];
-                 if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_id"] != $this->id && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {
-                        $redirect = "Location: ".$_SESSION["s"]["list"][$list_name]["parent_script"]."?id=".$_SESSION["s"]["list"][$list_name]["parent_id"]."&next_tab=".$_SESSION["s"]["list"][$list_name]["parent_tab"];
-                        $_SESSION["s"]["form"]["return_to"] = '';
-                        session_write_close();
-                        header($redirect);
-                } else {
-                    header("Location: ".$liste["file"]);
-                }
-                exit;
-
-        }
-		
-		function onBeforeDelete() {
-            global $app, $conf;
-        }
-		
-		function onAfterDelete() {
-            global $app, $conf;
-        }
-		
-		/**
-        * Function to print the form content
-        */
-		
-		function onPrintForm() {
-			global $app, $conf;
-			
-			if($app->tform->formDef['template_print'] == '') die('No print template available.');
-			
-			$app->tpl->newTemplate("print.tpl.htm");
-			$app->tpl->setInclude("content_tpl",$app->tform->formDef['template_print']);
-
-			if($app->tform->formDef['auth'] == 'no') {
-            	$sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id;
-            } else {
-            	$sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." AND ".$app->tform->getAuthSQL('r');
-            }
-            if(!$record = $app->db->queryOneRecord($sql)) $app->error($app->lng('error_no_view_permission'));
-			
-			$record["datum"] = date("d.m.Y");
-			
-			$app->tpl->setVar($app->tform->wordbook);
-
-			$app->tpl->setVar($record);
-			$app->tpl_defaults();
-			$app->tpl->pparse();
-			exit;
-			
-		}
-		
-		/**
-        * Function to print the form content
-        */
-		
-		function onMailSendForm() {
-			global $app, $conf;
-			
-			if($app->tform->formDef['template_mailsend'] == '') die('No print template available.');
-			
-			if($_POST["email"] == '' && $_POST["sender"] == '') {
-				// Zeige Formular zum versenden an.
-				$app->tpl->newTemplate("form.tpl.htm");
-				$app->tpl->setInclude("content_tpl",$app->tform->formDef['template_mailsend']);
-				$app->tpl->setVar('show_form',1);
-				$app->tpl->setVar("form_action",$app->tform->formDef['action'].'?send_form_by_mail=1');
-				$app->tpl->setVar("id",$this->id);
-				$app->tpl_defaults();
-				$app->tpl->pparse();
+				//if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_id"] != $this->id && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {
+				if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {
+					$redirect = "Location: ".$_SESSION["s"]["list"][$list_name]["parent_script"]."?id=".$_SESSION["s"]["list"][$list_name]["parent_id"]."&next_tab=".$_SESSION["s"]["list"][$list_name]["parent_tab"];
+					$_SESSION["s"]["form"]["return_to"] = '';
+					session_write_close();
+					header($redirect);
+					// When a returnto variable is set
+				} elseif (isset($_SESSION["s"]["form"]["return_to_url"]) && $_SESSION["s"]["form"]["return_to_url"] != '') {
+					$redirect = $_SESSION["s"]["form"]["return_to_url"];
+					$_SESSION["s"]["form"]["return_to_url"] = '';
+					session_write_close();
+					header("Location: ".$redirect);
+					exit;
+					// Use the default list of the form
+				} else {
+					header("Location: ".$app->tform->formDef['list_default']);
+				}
 				exit;
 			} else {
-				$app->tpl->newTemplate("mail.tpl.htm");
-				$app->tpl->setInclude("content_tpl",$app->tform->formDef['template_mailsend']);
-				$app->tpl->setVar('show_mail',1);
-				if($app->tform->formDef['auth'] == 'no') {
-            		$sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id;
-            	} else {
-            		$sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." AND ".$app->tform->getAuthSQL('r');
-            	}
-            	if(!$record = $app->db->queryOneRecord($sql)) $app->error($app->lng('error_no_view_permission'));
-			
-				$record["datum"] = date("d.m.Y");
-				$record["mailmessage"] = $_POST["message"];
-			
-				$app->tpl->setVar($app->tform->wordbook);
-
-				$app->tpl->setVar($record);
-				$app->tpl_defaults();
-				
-				$email_message = $app->tpl->grab();
-				$email = $_POST["email"];
-				$sender = $_POST["sender"];
-				
-				$headers  = "MIME-Version: 1.0\n";
-				$headers .= "Content-type: text/html; charset=iso-8859-1\n";
-				$headers .= "From: $sender\n";
-				
-				if (!preg_match('/^[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+' . '@' . '([-!#$%&\'*+\\/0-9=?A-Z^_`a-z{|}~]+\.)+' . '[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+$/', $sender)) {
-    				$sender = 'noreply@iprguard.de';
-  				}
-				
-				if (preg_match('/^[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+' . '@' . '([-!#$%&\'*+\\/0-9=?A-Z^_`a-z{|}~]+\.)+' . '[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+$/', $email)) {
-    				mail($email, 'Domainrecherche Statement '.$record["domain"], $email_message, $headers);
-  				}
-				echo "<p>&nbsp;</p><p>Email wurde versand.</p>";
-				exit;
+				$this->onShow();
 			}
-			
-			
+		} else {
+			$this->onError();
+		}
+	}
 
+	/*
+		 Save record in database
+		*/
+
+	function onUpdateSave($sql) {
+		global $app;
+		if(!empty($sql) && !$app->tform->isReadonlyTab($app->tform->getCurrentTab(), $this->id)) {
+			$app->db->query($sql);
+			if($app->db->errorMessage != '') die($app->db->errorMessage);
+		}
+	}
+
+
+
+
+
+	/**
+	 * Function called on data insert
+	 */
+	function onInsert() {
+		global $app, $conf;
+
+		$this->onBeforeInsert();
+
+		$ext_where = '';
+		$sql = $app->tform->getSQL($this->dataRecord, $app->tform->getCurrentTab(), 'INSERT', $this->id, $ext_where);
+		if($app->tform->errorMessage == '') {
+
+			$this->id = $this->onInsertSave($sql);
+			$app->plugin->raiseEvent($_SESSION['s']['module']['name'].':'.$app->tform->formDef['name'].':'.'on_insert_save', array('page_form'=>$this, 'sql'=>$sql));
+
+			// loading plugins
+			$next_tab = $app->tform->getCurrentTab();
+			$this->loadPlugins($next_tab);
+
+			// Call plugin
+			foreach($this->plugins as $plugin) {
+				$plugin->onInsert();
+			}
+
+			$this->onAfterInsert();
+			$app->plugin->raiseEvent($_SESSION['s']['module']['name'].':'.$app->tform->formDef['name'].':'.'on_after_insert', $this);
+
+			// Write data history (sys_datalog)
+			if($app->tform->formDef['db_history'] == 'yes') {
+				$new_data_record = $app->tform->getDataRecord($this->id);
+				$app->tform->datalogSave('INSERT', $this->id, array(), $new_data_record);
+				unset($new_data_record);
+			}
+
+
+			if($_REQUEST["next_tab"] == '') {
+				$list_name = $_SESSION["s"]["form"]["return_to"];
+				// if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_id"] != $this->id && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {
+				if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {
+					$redirect = "Location: ".$_SESSION["s"]["list"][$list_name]["parent_script"]."?id=".$_SESSION["s"]["list"][$list_name]["parent_id"]."&next_tab=".$_SESSION["s"]["list"][$list_name]["parent_tab"];
+					$_SESSION["s"]["form"]["return_to"] = '';
+					session_write_close();
+					header($redirect);
+					exit;
+				} elseif ($_SESSION["s"]["form"]["return_to_url"] != '') {
+					$redirect = $_SESSION["s"]["form"]["return_to_url"];
+					$_SESSION["s"]["form"]["return_to_url"] = '';
+					session_write_close();
+					header("Location: ".$redirect);
+					exit;
+				} else {
+					header("Location: ".$app->tform->formDef['list_default']);
+				}
+				exit;
+			} else {
+				$this->onShow();
+			}
+		} else {
+			$this->onError();
+		}
+	}
+
+	/*
+		 Save record in database
+		*/
+
+	function onInsertSave($sql) {
+		global $app, $conf;
+		$app->db->query($sql);
+		if($app->db->errorMessage != '') die($app->db->errorMessage);
+		return $app->db->insertID();
+	}
+
+	function onBeforeUpdate() {
+		global $app, $conf;
+	}
+
+	function onBeforeInsert() {
+		global $app, $conf;
+	}
+
+	function onAfterUpdate() {
+		global $app, $conf;
+	}
+
+	function onAfterInsert() {
+		global $app, $conf;
+	}
+
+
+	/**
+	 * Function called on data insert or update error
+	 */
+	function onError() {
+		global $app, $conf;
+
+		$app->tpl->setVar("error", "<li>".$app->tform->errorMessage."</li>");
+		$app->tpl->setVar($this->dataRecord);
+		$this->onShow();
+	}
+
+
+	/**
+	 * Function called on data delete
+	 */
+	function onDelete() {
+		global $app, $conf, $list_def_file, $tform_def_file;
+
+		include_once $list_def_file;
+
+		// Loading tform framework
+		if(!is_object($app->tform)) $app->uses('tform');
+
+		// Load table definition from file
+		$app->tform->loadFormDef($tform_def_file);
+
+		// importing ID
+		$this->id = $app->functions->intval($_REQUEST["id"]);
+
+		if($this->id > 0) {
+
+			// checking permissions
+			if($app->tform->formDef['auth'] == 'yes' && $_SESSION["s"]["user"]["typ"] != 'admin') {
+				if($app->tform->checkPerm($this->id, 'd') == false) $app->error($app->lng('error_no_delete_permission'));
+			}
+
+			//$this->dataRecord = $app->db->queryOneRecord("SELECT * FROM ".$liste["table"]." WHERE ".$liste["table_idx"]." = ".$this->id);
+			$this->dataRecord = $app->tform->getDataRecord($this->id);
+
+			$this->onBeforeDelete();
+			$app->plugin->raiseEvent($_SESSION['s']['module']['name'].':'.$app->tform->formDef['name'].':'.'on_before_delete', $this);
+
+			// Saving record to datalog when db_history enabled
+			if($app->tform->formDef["db_history"] == 'yes') {
+				//$old_data_record = $app->tform->getDataRecord($this->id);
+				$app->tform->datalogSave('DELETE', $this->id, $this->dataRecord, array());
+			}
+
+			$app->db->query("DELETE FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." LIMIT 1");
+
+
+			// loading plugins
+			$next_tab = $app->tform->getCurrentTab();
+			$this->loadPlugins($next_tab);
+
+
+			// Call plugin
+			foreach($this->plugins as $plugin) {
+				$plugin->onDelete();
+			}
+
+			$this->onAfterDelete();
+			$app->plugin->raiseEvent($_SESSION['s']['module']['name'].':'.$app->tform->formDef['name'].':'.'on_after_delete', $this);
+		}
+
+		//header("Location: ".$liste["file"]."?PHPSESSID=".$_SESSION["s"]["id"]);
+		$list_name = $_SESSION["s"]["form"]["return_to"];
+		if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_id"] != $this->id && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {
+			$redirect = "Location: ".$_SESSION["s"]["list"][$list_name]["parent_script"]."?id=".$_SESSION["s"]["list"][$list_name]["parent_id"]."&next_tab=".$_SESSION["s"]["list"][$list_name]["parent_tab"];
+			$_SESSION["s"]["form"]["return_to"] = '';
+			session_write_close();
+			header($redirect);
+		} else {
+			header("Location: ".$liste["file"]);
+		}
+		exit;
+
+	}
+
+	function onBeforeDelete() {
+		global $app, $conf;
+	}
+
+	function onAfterDelete() {
+		global $app, $conf;
+	}
+
+
+
+
+
+	/**
+	 * Function to print the form content
+	 */
+	function onPrintForm() {
+		global $app, $conf;
+
+		if($app->tform->formDef['template_print'] == '') die('No print template available.');
+
+		$app->tpl->newTemplate("print.tpl.htm");
+		$app->tpl->setInclude("content_tpl", $app->tform->formDef['template_print']);
+
+		if($app->tform->formDef['auth'] == 'no') {
+			$sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id;
+		} else {
+			$sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." AND ".$app->tform->getAuthSQL('r');
+		}
+		if(!$record = $app->db->queryOneRecord($sql)) $app->error($app->lng('error_no_view_permission'));
+
+		$record["datum"] = date("d.m.Y");
+
+		$app->tpl->setVar($app->tform->wordbook);
+
+		$app->tpl->setVar($record);
+		$app->tpl_defaults();
+		$app->tpl->pparse();
+		exit;
+
+	}
+
+
+
+
+
+	/**
+	 * Function to print the form content
+	 */
+	function onMailSendForm() {
+		global $app, $conf;
+
+		if($app->tform->formDef['template_mailsend'] == '') die('No print template available.');
+
+		if($_POST["email"] == '' && $_POST["sender"] == '') {
+			// Zeige Formular zum versenden an.
+			$app->tpl->newTemplate("form.tpl.htm");
+			$app->tpl->setInclude("content_tpl", $app->tform->formDef['template_mailsend']);
+			$app->tpl->setVar('show_form', 1);
+			$app->tpl->setVar("form_action", $app->tform->formDef['action'].'?send_form_by_mail=1');
+			$app->tpl->setVar("id", $this->id);
+			$app->tpl_defaults();
+			$app->tpl->pparse();
+			exit;
+		} else {
+			$app->tpl->newTemplate("mail.tpl.htm");
+			$app->tpl->setInclude("content_tpl", $app->tform->formDef['template_mailsend']);
+			$app->tpl->setVar('show_mail', 1);
 			if($app->tform->formDef['auth'] == 'no') {
-            	$sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id;
-            } else {
-            	$sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." AND ".$app->tform->getAuthSQL('r');
-            }
-            if(!$record = $app->db->queryOneRecord($sql)) $app->error($app->lng('error_no_view_permission'));
-			
+				$sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id;
+			} else {
+				$sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." AND ".$app->tform->getAuthSQL('r');
+			}
+			if(!$record = $app->db->queryOneRecord($sql)) $app->error($app->lng('error_no_view_permission'));
+
 			$record["datum"] = date("d.m.Y");
-			
+			$record["mailmessage"] = $_POST["message"];
+
 			$app->tpl->setVar($app->tform->wordbook);
 
 			$app->tpl->setVar($record);
 			$app->tpl_defaults();
-			$app->tpl->pparse();
+
+			$email_message = $app->tpl->grab();
+			$email = $_POST["email"];
+			$sender = $_POST["sender"];
+
+			$headers  = "MIME-Version: 1.0\n";
+			$headers .= "Content-type: text/html; charset=iso-8859-1\n";
+			$headers .= "From: $sender\n";
+
+			if (!preg_match('/^[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+' . '@' . '([-!#$%&\'*+\\/0-9=?A-Z^_`a-z{|}~]+\.)+' . '[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+$/', $sender)) {
+				$sender = 'noreply@iprguard.de';
+			}
+
+			if (preg_match('/^[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+' . '@' . '([-!#$%&\'*+\\/0-9=?A-Z^_`a-z{|}~]+\.)+' . '[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+$/', $email)) {
+				mail($email, 'Domainrecherche Statement '.$record["domain"], $email_message, $headers);
+			}
+			echo "<p>&nbsp;</p><p>Email wurde versand.</p>";
 			exit;
-			
 		}
 
-        /**
-        * Function called on page show
-        */
 
-        function onShow() {
-                global $app, $conf;
 
-                // Which tab do we render
-                $this->active_tab = $app->tform->getNextTab();
-
-                if($this->id > 0) {
-                        $this->onShowEdit();
-                } else {
-                        $this->onShowNew();
-                }
-
-                // make Form and Tabs
-                $app->tform->showForm();
-
-                // Setting default values
-                $app->tpl_defaults();
-				
-				// Show the navigation bar of the form
-				if(isset($app->tform->formDef['navibar']) && $app->tform->formDef['navibar'] == 'yes') {
-					$navibar = '';
-					if($app->tform->formDef['template_print'] != '') {
-						$navibar .= '<a href="'.$app->tform->formDef['action'].'?id='.$this->id.'&print_form=1" target="_blank"><img src="../themes/iprg/icons/printer.png" border="0" alt="Drucken" /></a> &nbsp;';
-					}
-					if($app->tform->formDef['template_mailsend'] != '') {
-						$navibar .= "<a href=\"#\" onclick=\"window.open('".$app->tform->formDef['action'].'?id='.$this->id."&send_form_by_mail=1','send','width=370,height=240')\"><img src=\"../themes/iprg/icons/mail.png\" border=\"0\" alt=\"Als E-Mail versenden\" /></a>";
-					}
-					$app->tpl->setVar('form_navibar',$navibar);
-				}
-				
-                if(isset($_SESSION['show_info_msg'])) {
-                    $app->tpl->setVar('show_info_msg', $_SESSION['show_info_msg']);
-                    unset($_SESSION['show_info_msg']);
-                }
-                if(isset($_SESSION['show_error_msg'])) {
-                    $app->tpl->setVar('show_error_msg', $_SESSION['show_error_msg']);
-                    unset($_SESSION['show_error_msg']);
-                }
-				
-				// loading plugins
-                $this->loadPlugins($this->active_tab);
-
-                // Calling the Plugin onShow Events and set the data in the
-                // plugins placeholder in the template
-                foreach($this->plugins as $plugin_name => $plugin) {
-                        $app->tpl->setVar($plugin_name,$plugin->onShow());
-                }
-
-                // Parse the templates and send output to the browser
-                $this->onShowEnd();
-
-        }
-
-        /**
-        * Function called on new record
-        */
-
-        function onShowNew() {
-                global $app, $conf;
-
-                if($app->tform->errorMessage == '') {
-                        $record = array();
-                        $record = $app->tform->getHTML($record, $app->tform->formDef['tab_default'],'NEW');
-                } else {
-                        $record = $app->tform->getHTML($app->tform->encode($_POST,$this->active_tab),$this->active_tab,'EDIT');
-                }
-
-                $app->tpl->setVar($record);
-        }
-
-        /**
-        * Function called on edit record
-        */
-
-        function onShowEdit() {
-                global $app, $conf;
-
-                // bestehenden Datensatz anzeigen
-                if($app->tform->errorMessage == '') {
-                        if($app->tform->formDef['auth'] == 'yes' && $_SESSION["s"]["user"]["typ"] != 'admin') {
-                        	$sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." AND ".$app->tform->getAuthSQL('r');
-                        } else {
-                        	$sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id;
-                        }
-                        if(!$record = $app->db->queryOneRecord($sql)) $app->error($app->lng('error_no_view_permission'));
-                } else {
-                        // $record = $app->tform->encode($_POST,$this->active_tab);
-						$record = $app->tform->encode($this->dataRecord,$this->active_tab,false);
-                }
-
-                $this->dataRecord = $record;
-
-            	// Userdaten umwandeln
-                $record = $app->tform->getHTML($record, $this->active_tab,'EDIT');
-                $record['id'] = $this->id;
-
-                $app->tpl->setVar($record);
-        }
-
-        function onShowEnd() {
-                global $app, $conf;
-
-                // Template parsen
-                $app->tpl->pparse();
-        }
-		
-		function loadPlugins($next_tab) {
-			global $app;
-			if(@is_array($app->tform->formDef["tabs"][$next_tab]["plugins"])) {
-                 $app->load('plugin_base');
-                 foreach($app->tform->formDef["tabs"][$next_tab]["plugins"] as $plugin_name => $plugin_settings) {
-                      $plugin_class = $plugin_settings["class"];
-                      $app->load($plugin_class);
-                      $this->plugins[$plugin_name] = new $plugin_class;
-                      $this->plugins[$plugin_name]->setOptions($plugin_name,$plugin_settings['options']);
-					  // Make the data of the form easily accessible for the plugib
-					  $this->plugins[$plugin_name]->form = $this;
-                      $this->plugins[$plugin_name]->onLoad();
-                  }
-             }
+		if($app->tform->formDef['auth'] == 'no') {
+			$sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id;
+		} else {
+			$sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." AND ".$app->tform->getAuthSQL('r');
 		}
+		if(!$record = $app->db->queryOneRecord($sql)) $app->error($app->lng('error_no_view_permission'));
+
+		$record["datum"] = date("d.m.Y");
+
+		$app->tpl->setVar($app->tform->wordbook);
+
+		$app->tpl->setVar($record);
+		$app->tpl_defaults();
+		$app->tpl->pparse();
+		exit;
+
+	}
+
+
+	/**
+	 * Function called on page show
+	 */
+	function onShow() {
+		global $app, $conf;
+
+		// Which tab do we render
+		$this->active_tab = $app->tform->getNextTab();
+
+		if($this->id > 0) {
+			$this->onShowEdit();
+		} else {
+			$this->onShowNew();
+		}
+
+		// make Form and Tabs
+		$app->tform->showForm();
+
+		// Setting default values
+		$app->tpl_defaults();
+
+		// Show the navigation bar of the form
+		if(isset($app->tform->formDef['navibar']) && $app->tform->formDef['navibar'] == 'yes') {
+			$navibar = '';
+			if($app->tform->formDef['template_print'] != '') {
+				$navibar .= '<a href="'.$app->tform->formDef['action'].'?id='.$this->id.'&print_form=1" target="_blank"><img src="../themes/iprg/icons/printer.png" border="0" alt="Drucken" /></a> &nbsp;';
+			}
+			if($app->tform->formDef['template_mailsend'] != '') {
+				$navibar .= "<a href=\"#\" onclick=\"window.open('".$app->tform->formDef['action'].'?id='.$this->id."&send_form_by_mail=1','send','width=370,height=240')\"><img src=\"../themes/iprg/icons/mail.png\" border=\"0\" alt=\"Als E-Mail versenden\" /></a>";
+			}
+			$app->tpl->setVar('form_navibar', $navibar);
+		}
+
+		if(isset($_SESSION['show_info_msg'])) {
+			$app->tpl->setVar('show_info_msg', $_SESSION['show_info_msg']);
+			unset($_SESSION['show_info_msg']);
+		}
+		if(isset($_SESSION['show_error_msg'])) {
+			$app->tpl->setVar('show_error_msg', $_SESSION['show_error_msg']);
+			unset($_SESSION['show_error_msg']);
+		}
+
+		// loading plugins
+		$this->loadPlugins($this->active_tab);
+
+		// Calling the Plugin onShow Events and set the data in the
+		// plugins placeholder in the template
+		foreach($this->plugins as $plugin_name => $plugin) {
+			$app->tpl->setVar($plugin_name, $plugin->onShow());
+		}
+
+		// Parse the templates and send output to the browser
+		$this->onShowEnd();
+
+	}
+
+
+	/**
+	 * Function called on new record
+	 */
+	function onShowNew() {
+		global $app, $conf;
+
+		if($app->tform->errorMessage == '') {
+			$record = array();
+			$record = $app->tform->getHTML($record, $app->tform->formDef['tab_default'], 'NEW');
+		} else {
+			$record = $app->tform->getHTML($app->tform->encode($_POST, $this->active_tab), $this->active_tab, 'EDIT');
+		}
+
+		$app->tpl->setVar($record);
+	}
+
+
+	/**
+	 * Function called on edit record
+	 */
+	function onShowEdit() {
+		global $app, $conf;
+
+		// bestehenden Datensatz anzeigen
+		if($app->tform->errorMessage == '') {
+			if($app->tform->formDef['auth'] == 'yes' && $_SESSION["s"]["user"]["typ"] != 'admin') {
+				$sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." AND ".$app->tform->getAuthSQL('r');
+			} else {
+				$sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id;
+			}
+			if(!$record = $app->db->queryOneRecord($sql)) $app->error($app->lng('error_no_view_permission'));
+		} else {
+			// $record = $app->tform->encode($_POST,$this->active_tab);
+			$record = $app->tform->encode($this->dataRecord, $this->active_tab, false);
+		}
+
+		$this->dataRecord = $record;
+
+		// Userdaten umwandeln
+		$record = $app->tform->getHTML($record, $this->active_tab, 'EDIT');
+		$record['id'] = $this->id;
+
+		$app->tpl->setVar($record);
+	}
+
+	function onShowEnd() {
+		global $app, $conf;
+
+		// Template parsen
+		$app->tpl->pparse();
+	}
+
+	function loadPlugins($next_tab) {
+		global $app;
+		if(@is_array($app->tform->formDef["tabs"][$next_tab]["plugins"])) {
+			$app->load('plugin_base');
+			foreach($app->tform->formDef["tabs"][$next_tab]["plugins"] as $plugin_name => $plugin_settings) {
+				$plugin_class = $plugin_settings["class"];
+				$app->load($plugin_class);
+				$this->plugins[$plugin_name] = new $plugin_class;
+				$this->plugins[$plugin_name]->setOptions($plugin_name, $plugin_settings['options']);
+				// Make the data of the form easily accessible for the plugib
+				$this->plugins[$plugin_name]->form = $this;
+				$this->plugins[$plugin_name]->onLoad();
+			}
+		}
+	}
 
 
 }
 
-?>
\ No newline at end of file
+?>

--
Gitblit v1.9.1