new theme

redray

2008-10-25 0ef490b4ce268b51e7b63127fedff7c8a0c39ecc

 interface/lib/classes/tform_actions.inc.php

@@ -41,6 +41,7 @@
        var $activeTab;

        var $dataRecord;

        var $plugins = array();

      var $oldDataRecord; // This array is only filled during updates and when db_history is enabled.



        function onLoad() {

                global $app, $conf, $tform_def_file;

@@ -55,7 +56,19 @@
                $app->tform->loadFormDef($tform_def_file);

            

            // Importing ID

                $this->id = intval($_REQUEST["id"]);

                $this->id = (isset($_REQUEST["id"]))?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();

            }



                if(count($_POST) > 1) {

                        $this->dataRecord = $_POST;

@@ -86,15 +99,19 @@


        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(!empty($sql)) {

                                $app->db->query($sql);

                            if($app->db->errorMessage != '') die($app->db->errorMessage);

                        }

						
                  if($app->tform->formDef['db_history'] == 'yes') {

                     $this->oldDataRecord = $app->tform->getDataRecord($this->id);

                  }

						
                  // Save record in database

                  $this->onUpdateSave($sql);

                  

                  // loading plugins

                  $next_tab = $app->tform->getCurrentTab();

@@ -106,25 +123,57 @@
                        }



                        $this->onAfterUpdate();

						
                  // 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"];

                                if($list_name != '' && $_SESSION["s"]["list"][$list_name]["parent_id"] != $this->id && $_SESSION["s"]["list"][$list_name]["parent_name"] != $app->tform->formDef["name"]) {

                           $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);

                        } else {

                                                   header("Location: ".$app->tform->formDef['list_default']);

                        }

                        exit;

                    } else {

                     // When a returnto variable is set

                     } 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;

                        // 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())) {

            $app->db->query($sql);

            if($app->db->errorMessage != '') die($app->db->errorMessage);

         }

      }

		


        /**

        * Function called on data insert

@@ -132,13 +181,14 @@


        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 == '') {

                        $app->db->query($sql);

                        if($app->db->errorMessage != '') die($app->db->errorMessage);

                        $this->id = $app->db->insertID();

						
                  $this->id = $this->onInsertSave($sql);

                  

                  // loading plugins

                  $next_tab = $app->tform->getCurrentTab();

@@ -150,15 +200,30 @@
                        }



                        $this->onAfterInsert();

						
                  // 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"]) {

                                                        $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"];

                         // 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);

                        } else {

                     exit;

                        } elseif ($_SESSION["s"]["form"]["return_to_url"] != '') {

                     $_SESSION["s"]["form"]["return_to_url"] = '';

                     session_write_close();

                     header("Location: ".$_SESSION["s"]["form"]["return_to_url"]);

                     exit;

                  } else {

                                header("Location: ".$app->tform->formDef['list_default']);

                        }

                        exit;

@@ -169,14 +234,33 @@
                        $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 onAfterUpdate() {

                        global $app, $conf;

                }

        function onBeforeUpdate() {

            global $app, $conf;

        }



                function onAfterInsert() {

                        global $app, $conf;

                }

        function onBeforeInsert() {

            global $app, $conf;

        }

		
      function onAfterUpdate() {

            global $app, $conf;

        }



        function onAfterInsert() {

            global $app, $conf;

        }





        /**

@@ -212,30 +296,23 @@
                if($this->id > 0) {



                        // checking permissions

                        if($app->tform->formDef['auth'] == 'yes') {

                        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'));

                        }



                        $record_old = $app->db->queryOneRecord("SELECT * FROM ".$liste["table"]." WHERE ".$liste["table_idx"]." = ".$this->id);

                        //$this->dataRecord = $app->db->queryOneRecord("SELECT * FROM ".$liste["table"]." WHERE ".$liste["table_idx"]." = ".$this->id);

                  $this->dataRecord = $app->tform->getDataRecord($this->id);

						
                  $this->onBeforeDelete();



                        // Saving record to datalog when db_history enabled

                        if($form["db_history"] == 'yes') {

                                $diffrec = array();



                                foreach($record_old as $key => $val) {

                                        // Record has changed

                                        $diffrec[$key] = array('old' => $val,

                                                                                           'new' => '');

                                }



                                $diffstr = $app->db->quote(serialize($diffrec));

                                $username = $app->db->quote($_SESSION["s"]["user"]["username"]);

                                $dbidx = $app->tform->formDef['db_table_idx'].":".$this->id;

                                $sql = "INSERT INTO sys_datalog (dbtable,dbidx,action,tstamp,user,data) VALUES ('".$app->tform->formDef['db_table']."','$dbidx','d','".time()."','$username','$diffstr')";

                                $app->db->query($sql);

                        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 ".$liste["table"]." WHERE ".$liste["table_idx"]." = ".$this->id);

                        $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();

@@ -244,13 +321,15 @@
                  

                        // Call plugin

                        foreach($this->plugins as $plugin) {

                                $plugin->onInsert();

                                $plugin->onDelete();

                        }

						
                  $this->onAfterDelete();

                }



                //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"]) {

                      //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();

@@ -261,6 +340,121 @@
                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('u');

            }

            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('u');

               }

               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 (!ereg('^[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+' . '@' . '([-!#$%&\'*+\\/0-9=?A-Z^_`a-z{|}~]+\.)+' . '[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+$', $sender)) {

                $sender = 'noreply@iprguard.de';

              }

				
            if (ereg('^[-!#$%&\'*+\\./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;

         }

			
			


         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('u');

            }

            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

@@ -284,8 +478,20 @@
                // 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);

            }

				
				
            // loading plugins

            //$next_tab = $app->tform->getNextTab();

                $this->loadPlugins($this->active_tab);



                // Calling the Plugin onShow Events and set the data in the

@@ -325,19 +531,20 @@


                // bestehenden Datensatz anzeigen

                if($app->tform->errorMessage == '') {

                        if($app->tform->formDef['auth'] == 'no') {

                                $sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id;

                        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('u');

                        } else {

                                $sql = "SELECT * FROM ".$app->tform->formDef['db_table']." WHERE ".$app->tform->formDef['db_table_idx']." = ".$this->id." AND ".$app->tform->getAuthSQL('u');

                           $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($_POST,$this->active_tab);

                  $record = $app->tform->encode($this->dataRecord,$this->active_tab);

                }



                $this->dataRecord = $record;



            // Userdaten umwandeln

               // Userdaten umwandeln

                $record = $app->tform->getHTML($record, $this->active_tab,'EDIT');

                $record['id'] = $this->id;



@@ -353,13 +560,15 @@
      

      function loadPlugins($next_tab) {

         global $app;

         if(is_array($app->tform->formDef["tabs"][$next_tab]["plugins"])) {

         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();

                  }

             }