tpl)) $app->uses('tpl');
if(!is_object($app->tform)) $app->uses('tform');
$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();
}
if(count($_POST) > 1) {
$this->dataRecord = $_POST;
$this->onSubmit();
} else {
$this->onShow();
}
}
/**
* Function called on page submit
*/
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 = $app->functions->intval($_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")."
";
}
}
// Calling the action functions
if($this->id > 0) {
$app->tform->action == 'EDIT';
$this->onUpdate();
} else {
$app->tform->action == 'NEW';
$this->onInsert();
}
}
/**
* Function called on data update
*/
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);
// 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 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", "".$app->tform->errorMessage."");
$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);
$app->plugin->raiseEvent($_SESSION['s']['module']['name'].':'.$app->tform->formDef['name'].':'.'on_check_delete', $this);
$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'));
$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 "
Email wurde versand.
";
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('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 .= '
';
}
if($app->tform->formDef['template_mailsend'] != '') {
$navibar .= "tform->formDef['action'].'?id='.$this->id."&send_form_by_mail=1','send','width=370,height=240')\">![\"Als](\"../themes/iprg/icons/mail.png\")
";
}
$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();
}
}
}
}
?>