Portions created by the Initial Developer are Copyright (C) 2016 - 2020 the Initial Developer. All Rights Reserved. Contributor(s): Mark J Crane */ //includes require_once "root.php"; require_once "resources/require.php"; require_once "resources/check_auth.php"; //check permissions if (permission_exists('database_transaction_add') || permission_exists('database_transaction_edit')) { //access granted } else { echo "access denied"; exit; } //add multi-lingual support $language = new text; $text = $language->get(); //set the variables if (is_uuid($_GET["id"])) { $database_transaction_uuid = $_GET["id"]; $search = $_GET['search']; $page = $_GET['page']; } //pre-populate the form if (count($_GET) > 0 && is_uuid($_GET["id"]) && $_POST["persistformvar"] != "true") { $sql = "select "; $sql .= "t.database_transaction_uuid, d.domain_name, u.username, t.user_uuid, t.app_name, t.app_uuid, "; $sql .= "t.transaction_code, t.transaction_address, t.transaction_type, t.transaction_date, "; $sql .= "t.transaction_old, t.transaction_new, t.transaction_result "; $sql .= "from v_database_transactions as t, v_domains as d, v_users as u "; $sql .= "where t.domain_uuid = :domain_uuid "; $sql .= "and t.database_transaction_uuid = :database_transaction_uuid "; $sql .= "and t.user_uuid = u.user_uuid "; $sql .= "and t.domain_uuid = d.domain_uuid "; $parameters['domain_uuid'] = $domain_uuid; $parameters['database_transaction_uuid'] = $database_transaction_uuid; $database = new database; $row = $database->select($sql, $parameters, 'row'); if (is_array($row) && @sizeof($row) != 0) { $user_uuid = $row["user_uuid"]; $app_name = $row["app_name"]; $app_uuid = $row["app_uuid"]; $domain_name = $row["domain_name"]; $username = $row["username"]; $transaction_code = $row["transaction_code"]; $transaction_address = $row["transaction_address"]; $transaction_type = $row["transaction_type"]; $transaction_date = $row["transaction_date"]; $transaction_old = $row["transaction_old"]; $transaction_new = $row["transaction_new"]; $transaction_result = $row["transaction_result"]; } unset($sql, $parameters, $row); } //undo the transaction if ($_GET['action'] == 'undo' && ($transaction_type == 'delete' || $transaction_type == 'update')) { //get the array $array = json_decode($transaction_old, true); //save to the data $database = new database; $database->app_name = $app_name; $database->app_uuid = $app_uuid; $database->save($array); $message = $database->message; //redirect the user $_SESSION["message"] = $text['message-update']; header("Location: database_transactions.php?".($search != '' ? "&search=".urlencode($search) : null).($page != '' ? "&page=".urlencode($page) : null)); } //get the type if not provided if (strlen($transaction_type) == 0) { if ($transaction_old == null || $transaction_old == "null") { $transaction_type = 'add'; } else { $transaction_type = 'update'; } } //include the header $document['title'] = $text['title-database_transaction']; require_once "resources/header.php"; //show the content echo "
\n"; echo "
".$text['title-database_transaction']."
\n"; echo "
\n"; echo button::create(['type'=>'button','label'=>$text['button-back'],'icon'=>$_SESSION['theme']['button_icon_back'],'id'=>'btn_back','link'=>'database_transactions.php?'.($search != '' ? "&search=".urlencode($search) : null).(is_numeric($page) ? "&page=".urlencode($page) : null)]); if ($transaction_type == 'delete' || $transaction_type == 'update') { echo button::create(['type'=>'button','label'=>$text['button-undo'],'icon'=>'undo-alt','id'=>'btn_save','style'=>'margin-left: 15px;','link'=>'database_transaction_edit.php?id='.urlencode($database_transaction_uuid).'&action=undo'.($search != '' ? "&search=".urlencode($search) : null).(is_numeric($page) ? "&page=".urlencode($page) : null)]); } echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
\n"; echo " ".$text['label-app_name']."\n"; echo " \n"; echo " ".escape($app_name)."\n"; echo "
\n"; echo " ".$text['label-user_uuid']."\n"; echo " \n"; echo " ".escape($username)."\n"; echo "
\n"; echo "		\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
\n"; echo " ".$text['label-transaction_code']."\n"; echo " \n"; echo " ".escape($transaction_code)."\n"; echo "
\n"; echo " ".$text['label-transaction_address']."\n"; echo " \n"; echo " ".escape($transaction_address)."\n"; echo "
\n"; echo "		\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
\n"; echo " ".$text['label-transaction_type']."\n"; echo " \n"; echo " ".escape($transaction_type)."\n"; echo "
\n"; echo " ".$text['label-domain']."\n"; echo " \n"; echo " ".escape($domain_name); echo "
\n"; echo "
\n"; if ($_REQUEST["debug"] == "true") { echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo " ".$text['label-transaction_old']."\n"; echo "\n"; echo " \n"; echo "
\n"; echo " ".$text['label-transaction_new']."\n"; echo "\n"; echo " \n"; echo "
\n"; echo " ".$text['label-transaction_result']."\n"; echo "\n"; echo " \n"; echo "
"; } //define the array _difference function //this adds old and new values to the array function array_difference($array1, $array2) { $array = array(); if (is_array($array1)) { foreach ($array1 as $key => $value) { if (is_array($array2[$key])) { $array[$key] = array_difference($array1[$key], $array2[$key]); } else { $array[$key]['old'] = $value; } } } if (is_array($array2)) { foreach ($array2 as $key => $value) { if (is_array($value)) { $array[$key] = array_difference($array1[$key], $array2[$key]); } else { $array[$key]['new'] = $value; } } } return $array; } //show the content from the difference array as a list function show_difference($array) { //loop through the array foreach ($array as $key => $value) { if (is_array($value) && !isset($value['old']) && !isset($value['new'])) { if (!is_numeric($key)) { //get the table name $_SESSION['name'] = $key; } else { //get the row id $_SESSION['row'] = $key; } $array = show_difference($value); } else { //set the variables $old = $value['old']; $new = $value['new']; if (is_null($old)) { $old = ''; } if (is_null($new)) { $new = ''; } //determine if the value has changed if (strval($old) == strval($new) && isset($old)) { $color = "#000000"; } else { $color = "#ff0000"; } //set the table header if ($_SESSION['previous_name'] !== $_SESSION['name'] || $_SESSION['previous_row'] !== $_SESSION['row']) { echo str_replace("name","".$_SESSION['name']."",$_SESSION['table_header']); //echo $_SESSION['table_header']; } $_SESSION['previous_name'] = $_SESSION['name']; $_SESSION['previous_row'] = $_SESSION['row']; //show the results echo "\n"; echo " ".escape($key)."\n"; echo " ".escape($old)."\n"; echo " ".escape($new).""; echo "\n"; //echo "\n"; } unset($key,$old,$new,$value); } } //decode the json to arrays $before = json_decode($transaction_old, true); $after = json_decode($transaction_new, true); //unset the sessions unset($_SESSION['previous_name']); unset($_SESSION['previous_row']); //show the add if ($transaction_type == "add") { //multiple dimensional array into a 2 dimensional array if (is_array($after)) { $x = 0; foreach ($after as $key => $value) { $id = 0; foreach ($value as $row) { $sub_id = 0; foreach ($row as $sub_key => $val) { if (is_array($val)) { foreach ($val as $sub_row) { foreach ($sub_row as $k => $v) { $array[$x]['schema'] = $sub_key; $array[$x]['row'] = $sub_id; $array[$x]['name'] = $k; $array[$x]['value'] = htmlentities($v); $x++; } $sub_id++; } } else { $array[$x]['schema'] = $key; $array[$x]['row'] = $id; $array[$x]['name'] = $sub_key; $array[$x]['value'] = htmlentities($val); $x++; } } $id++; } } } echo "
\n"; echo "\n"; if (is_array($array)) { foreach ($array as $row) { if ($row['schema'] !== $previous_schema || $row['row'] !== $previous_row) { echo "\n"; echo "\n"; echo " \n"; echo " \n"; echo "\n"; } echo "\n"; echo " \n"; echo " \n"; echo "\n"; $previous_schema = $row['schema']; $previous_row = $row['row']; } echo "
 
".escape($row['schema'])."value
".escape($row['name'])."".escape($row['value'])."
\n"; } /* if (is_array($after)) { //create the table header $array = array_difference(null, $after, 1); $table_header = " \n"; $table_header .= "\n"; $table_header .= " name\n"; $table_header .= "  \n"; $table_header .= " new\n"; $table_header .= "\n"; $_SESSION['table_header'] = $table_header; //show the difference echo "\n"; show_difference($array); echo "
\n"; } */ } //show the update if ($transaction_type == "update") { if (count($before) > 0 && count($after) > 0) { //create the table header $array = array_difference($before, $after, 1); $table_header = " \n"; $table_header .= "\n"; $table_header .= " name\n"; $table_header .= " old\n"; $table_header .= " new\n"; $table_header .= "\n"; $_SESSION['table_header'] = $table_header; //show the difference echo "
\n"; echo "\n"; show_difference($array); echo "
\n"; } } //show the delete if ($transaction_type == "delete") { echo "

\n"; echo "\n"; if (is_array($before)) { foreach ($before as $table_name => $rows) { echo " \n"; echo " \n"; echo " \n"; foreach ($rows as $row) { foreach ($row as $key => $value) { echo " \n"; echo " \n"; echo " \n"; } echo " \n"; echo " \n"; echo " \n"; } } } } echo "
".escape($table_name)." 
".escape($key)."".escape($value)."


\n"; //add a few lines at the end echo "

\n"; //include the footer require_once "resources/footer.php"; ?>