| | |
| | | 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; |
| | |
| | | $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($_GET["print_form"] == 1) { |
| | | if(isset($_GET["print_form"]) && $_GET["print_form"] == 1) { |
| | | die('Function disabled.'); |
| | | $this->onPrintForm(); |
| | | } |
| | | |
| | | // send this form by email |
| | | if($_GET["send_form_by_mail"] == 1) { |
| | | if(isset($_GET["send_form_by_mail"]) && $_GET["send_form_by_mail"] == 1) { |
| | | die('Function disabled.'); |
| | | $this->onMailSendForm(); |
| | | } |
| | | |
| | |
| | | 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(); |
| | |
| | | } |
| | | |
| | | $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"]; |
| | |
| | | $_SESSION["s"]["form"]["return_to"] = ''; |
| | | session_write_close(); |
| | | header($redirect); |
| | | // 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 { |
| | | // 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->db->query($sql); |
| | | if($app->db->errorMessage != '') die($app->db->errorMessage); |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * Function called on data insert |
| | |
| | | $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(); |
| | |
| | | } |
| | | |
| | | $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"] == '') { |
| | |
| | | $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; |
| | |
| | | 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(); |
| | |
| | | foreach($this->plugins as $plugin) { |
| | | $plugin->onDelete(); |
| | | } |
| | | |
| | | $this->onAfterDelete(); |
| | | } |
| | | |
| | | //header("Location: ".$liste["file"]."?PHPSESSID=".$_SESSION["s"]["id"]); |
| | |
| | | } |
| | | exit; |
| | | |
| | | } |
| | | |
| | | function onBeforeDelete() { |
| | | global $app, $conf; |
| | | } |
| | | |
| | | function onAfterDelete() { |
| | | global $app, $conf; |
| | | } |
| | | |
| | | /** |
| | |
| | | $app->tpl_defaults(); |
| | | |
| | | // Show the navigation bar of the form |
| | | if($app->tform->formDef['navibar'] == 'yes') { |
| | | 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> '; |
| | |
| | | |
| | | 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"]; |